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.

bismart-data-analysis-2

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