Multinational Movie Theater Company

Data warehouse corporatiu

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

Operations and finance dashboards

 22 million spectators

22 million spectators

40 cinemas > 500 screens

40 cinemas > 500 screens

Most Recent Projects