Understanding product profitability requires more than simply analyzing revenue. High-selling products may generate limited margins once historical production costs, pricing behavior, and product mix are considered.
This analysis was developed to evaluate how different products, categories, and subcategories contribute to overall business profitability while accounting for historical manufacturing costs and transactional sales performance.
The dashboard combines financial, operational, and pricing dimensions to provide a multidimensional view of product performance.
The analysis focused on answering several business questions:
The analytical dataset was developed in SQL Server using transactional sales data combined with historical production cost records.
A major challenge involved correctly matching each sale with the closest valid historical production cost available at the time of the transaction.
This was solved using:
OUTER APPLY