Case Study | Corporate Data Warehouse
Multinational Movie Theater Company
Implementation of a Business Intelligence environment in Microsoft SQL 2016 and analytical tools in Microsoft Power BI Report Server and Reporting Services.
GOAL
To respond to the information needs, not only of the central services but also of all the group’s cinemas, integrating all the information in a single environment and offering a simple and agile consultation tool.
ESTRATEGY
- Integration via SSIS including a data normalization process.
- Creation of the data warehouse and the operations and finances data mart.
- Preparation of a tabular data model for reporting.
- Implementation of Reporting Services for static reports and Power BI for dynamic analysis.
RESULTS
- Single data repository.
- Higher quality data.
- Democratized information.
- Autonomy of users for ad-hoc reporting.
- Near real-time reports.
Operations and finance dashboards
22 million spectators
40 cinemas > 500 screens
Other Case Studies
Discover what we can do for your business