Industry: Retail · Services: Data Analytics, Power BI
The need
Comparing a company’s growth only with its own past can be misleading. The real question was: while the market is growing, are we growing faster or slower than the market?
The solution
We combined the retail sales indices of the Turkish Statistical Institute (TÜİK), the company’s own revenue data and competitor price data in a single Power BI data model. This made it possible to compare internal performance with industry trends on the same timeline.
- Regular loading of TÜİK retail index data into the model
- Period-based matching with company revenue data
- Growth and price positioning comparisons against the market
- Summary and detail report pages for management
The result
Management can track company performance against the market average in the same report, and growth and pricing decisions can be evaluated in the context of the industry.
Technologies: Power BI, Power Query, DAX, SQL Server