Multinational Movie Theater Company
Multinational Movie Theater Company
Corporate Data Warehouse
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
RESULTATS
- 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
