This project delivers a decision-support platform designed to centralize and analyze price data coming from several actors in the Tunisian market, including Carrefour, Geant, Touring, and Traveltodo. A star-schema Data Warehouse was created to integrate heterogeneous sources through automated ETL workflows, standardize the information, and expose a single trusted analytical layer. Power BI dashboards were then built to compare prices, monitor product performance, identify market trends, and surface KPIs that support strategic decisions.
The goal was to transform raw price data from different sources into a reliable analytical system that allows fast comparison and market visibility. The solution was designed around a structured warehouse model so business users can query consolidated data without dealing with fragmented source systems.
Source data is extracted, cleansed, transformed, and loaded into the warehouse using SSIS packages. SQL Server stores the modeled dimensions and facts, while DAX measures in Power BI provide dynamic calculations for ranking, comparison, and performance tracking.
The final solution helps turn price data into actionable insights. It gives stakeholders a clear view of market positioning, product performance, and pricing trends, making it easier to support data-driven decisions in a competitive environment.