Data & Analytics.

Challenge: The client had multiple data sources dispersed across legacy systems, spreadsheets, and non-integrated databases, which made it difficult to consolidate strategic information, generate reliable management reports, and gain visibility into sales indicators, channels, inventory, and operational performance. There was a need to structure a Business Intelligence model that would enable data-driven decision-making.

What was done:

• Structuring of the Business Intelligence environment. 

• Migration and consolidation of data from different sources (MS Excel spreadsheets, MS Access databases, and corporate systems) into an Oracle Data Warehouse. 

• Development of conceptual, logical, and physical database models, including normalization and data dictionary. 

• Development of ETL processes and technical documentation for handover. 

• Creation of management dashboards in Qlik Sense, including sales indicators, targets, travel agency channels, inventory, no-show rates, cancellations, and moving average analyses. 

• Migration of existing dashboards from Power BI to Qlik Sense and configuration of access profiles. 

Result obtained:

• Implementation of a single, structured data repository, reducing information inconsistencies and redundancies. 

• Delivery of an initial set of executive and operational dashboards, providing a consolidated view of sales, channel performance, and inventory control. 

• Significant increase in agility for generating management reports and analyzing strategic indicators. 

• Improved governance and traceability of information, enabling faster and more business-driven decision-making.