Sales & Returns Analysis Dashboard | Power BI

Developed an end-to-end Business Intelligence solution using Power BI to analyze retail sales and returns and transform raw data into actionable business insights.

The project covers the complete BI workflow, including data cleaning and transformation using Power Query, building a scalable Galaxy Schema data model, developing advanced DAX measures and calculation groups, and designing interactive dashboards for business performance analysis.

The solution includes Executive Overview, Product & Sales Analysis, Returns & Risk Analysis, and What-If Analysis pages.

The What-If Analysis enables users to simulate different business scenarios by adjusting variables such as return rate and scenario days, and evaluate their potential impact on Net Sales, Total Profit, Simulated Profit, and Projected Loss.

The analysis generated key insights into sales performance, product categories, average order value, and return patterns, helping support data-driven business decision-making.

My Role: Team Leader & BI Developer — responsible for organizing the project workflow, distributing tasks, coordinating team progress, and contributing to the development and analysis of the Power BI solution