Dashboard for Strategic Merger Analysis & Financial Insights

Designed an end-to-end Power BI solution for a proposed strategic merger between a global sports company and an air sports manufacturer. The project included comprehensive data transformation, custom date table creation, dynamic DAX measures, and multiple interactive dashboards.

Key project components:

Cleaned and transformed historical financial data (5 years) for reporting

Built a dynamic date table responsive to source data changes

Developed dashboards identifying key profitability trends, customer/product performance, and seasonal insights

Created KPIs including total sales, gross profit %, customer count, and units sold, with slicers by year/month

Visualized profit and margin trends across business segments to support strategic recommendations

Enabled intuitive navigation with a custom title page and bookmarks