Hide form
MENU Close

Management Reporting and Financial Planning in O2 boasting a price
Microsoft Awards Finalist

100+

users from top and middle management levels using managerial reporting

10+

Advanced Users Using Microsoft Power BI Visualization and Analysis

24+

months return on investment in IT infrastructure optimization throughout the project

"with a project dealing with business planning and managerial reporting we struggled for many years. A comprehensive solution from Solatherey to our overall concept Ideally set and quite quickly happened in our company standard. It also increased towards our strict safety requirements. The quality of the solution is underlined by the fact that it has been awarded the prestigious Microsoft Awards 2017 finalist. "

Jan Martinec
Manager, BICC Financial Reporting


Solutions for the largest integrated telecommunications provider on the Czech market provides management reporting and financial planning, including consolidation of subsidiaries. It unites financial and non-financial data from sources, such as data warehouse, enterprise system and SQL Server, with transformed data are subsequently presented in the form of dynamic reports and dashboards in Power BI and Targetty Excel Add-in. The advantage of the solution is also the management of user rights at the level of elementary data in the database and the associated security benefits in reporting.

The solution together with managerial report covers the area of ​​financial planning, using the unique SSAS property (Microsoft SQL Server Analysis Services ) When data from Excel forms writes directly to the database. It also allows planning within defined scenarios (annual budget, re-budget, 12-month moving Forecast, strategic plan), in defined detail and in a defined organizational structure according to cost centers. Plans can be prepared for all financial statements (P & AMP; L, B / S & AMP; C / F), non-financial indicators (#FTE, Customers, # phones, etc.) and calculated indicators (average returns to the customer). The scheduled values ​​can be subsequently compared with the facts through all defined dimensions.

An analysis of available solutions for managerial reporting and financial planning was performed before the solution is implemented. In the initial phase O2 considered the implementation of alternative technologies such as Oracle Essbase / Hyperion. At the same time, at this stage O2, the current operation of the existing MicroStrategy Bi Platforms together with a new solution, which would also allow the financial planning process. After evaluating all variants and impacts on the overall O2 logic, the resulting decision to implement the entire solution over the Microsoft BI platform in order to use existing infrastructure. An important role in deciding also had a positive user experience with Microsoft Reporting Services 2012 in operational reporting. When deciding play an important role also a simple process of authentication of users via Active Directory in Microsoft BI platform and consolidation of managerial and operative reporting into one environment. Last but not least, operational and license terms have also affected the decision.

Solution enabled O2 to automate and overall optimize comprehensive reporting and planning processes. Significant benefits brought mainly in the area of ​​execution of change requirements for structure and detail in reports, reflecting organizational changes within the company, elimination of "Excelmart's maintenance" as sources for reporting, managed access to financial data across company, standardization of reports and, last but not least, then I a significant acceleration of the process of preparing managerial reports and dashboards.

Support for the development of "data-driven" culture by creating a multidimensional environment for working with financial and non-financial data across the company, including attractive data visualization at managerial reporting level.

Automation of reporting and planning processes, including standardization reporting methodology through defined dimensions and hierarchy and achieving significantly more efficient changes in reports and schedule scenarios.

Introduction of a controlled process of data security in the form of setting rights at the analytical database level.

We will help you simplify business

Trades and small businesses

Invoice easily,
Customize accounts or settle
problem with eet.

Medium-sized companies

Save time, capacities and simplify
processes thanks to enterprise
and personnel systems.

Large companies

FREE from worry that
Information technology
flawlessly solves for you.