Case Study | Corporate Data Warehouse

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.