Sales Performance & Trend Analysis| For Home Appliances and Electronics Co.
The Original Data Has Been Changed Due to Confidentiality
E£0.00
🚀New Project | Sales Performance & Trend Analysis| For Home Appliances and Electronics Co.
I'm excited to share my latest end-to-end Sales Analysis project built using
Excel, Power Query, Power Pivot, DAX, and Power BI.
🔹 Project Overview:
This project covers the complete analytics workflow starting from raw data, cleaning and modeling, all the way to building fully interactive Live dashboards.
📊 Dashboard Structure
Data cleaning and transformation using Power Query
Rebuilt the Star Schema inside Power BI with Fact & Dimension tables
Created a dedicated Measures table using DAX to calculate key KPIs
Designed 3 interactive dashboards covering:
(Sales Overview - Sales Performance - Trend Analysis)
Publish The Report Live On Power Bi Service
📊 Key KPIs
Total Sales: $68.24M - Total Cost: $28.94M
Total Profit: $39.29M - Total Quantity: 297.29K
Total Orders: 18.87K - Average Order Value (AOV): 3.62K
Year Over Year Growth (YoY): 39.74%
🛠 What We Recommend to Investigate Deeply
✔ 2024 Sales is Lower Than Last Year(2023)
✔ May 2025 Sales is Lower Than Usual(2023 -2024)
✔ Sep 2022 Sales Was A big Outlier Against Other Years
✔ Jun Sales are The Lowest All Over Time
✔ In 2025 Sales The Big Jump & Scale Was in Q4
✔ The Last YoY Growth Changed From -9.45% To 10.81% Net Growth
✨ Check out the project here: https://app.powerbi.com/links/0Bb0oWBlxc?ctid=07907f53-111c-4bea-bd79-2835aa8384dd&pbi_source=linkShare
I’d really appreciate any feedback or suggestions 🙌