Sales Performance & Trend Analysis| For Home Appliances and Electronics Co.
The Original Data Has Been Changed Due to Confidentiality
$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 ๐