Repository files navigation
The Sales Dashboard (Excel + Power BI) project focuses on analyzing sales performance using raw Excel data and transforming it into interactive dashboards using Power BI. This project helps stakeholders understand: • Monthly and yearly trends • Top-performing products and regions • Customer and category-wise insights ________________________________________ • Convert raw Excel sales data into meaningful insights • Build interactive dashboards using Power BI • Use DAX measures for calculations • Enable decision-making using visual analytics ________________________________________ • Microsoft Excel – Data source & cleaning • Power BI Desktop – Data modeling & visualization • DAX (Data Analysis Expressions) – Measures & KPIs ________________________________________ Performed before loading into Power BI: • Converted numeric columns • Standardized region & category names ________________________________________ 🔗 Data Modeling (Power BI) • Created calculated columns & measures ________________________________________ Total Sales = SUM(Sales[Sales]) Total Profit = SUM(Sales[Profit]) Profit Margin % = DIVIDE([Total Profit], [Total Sales], 0) Total Quantity = SUM(Sales[Quantity]) ________________________________________ • Identified top-performing regions • Found most profitable categories • Detected seasonal sales patterns • Highlighted low-margin products
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
You can’t perform that action at this time.
