MISUO Sales Analysis — From Raw Data to Business Decisions.

I developed an interactive Excel dashboard to analyze and visualize MISUO's performance. The dashboard provides business insights into revenue, Delivery status, and customer behavior with interactive filters and KPIs.

The process included:

Cleaning the data with Power Query (handling nulls, removing duplicates, spelling errors).

Creating Pivot Tables to summarize and analyze sales data.

Designing a professional dashboard to highlight the most important insights.

Key Insights & Features:

KPIs: Total Sales (979K), Total Orders(118), Total Customers(76).

Trend Analysis: Sales over time to identify seasonal patterns.

Product & Sub-Product breakdown for better product insights.

Ship Mode performance analysis:On-Time Delivery Rate was only 36%(needs improvement).

Top Cities by sales.

Top Platform: Most sales came from Homzmart.

Tools & Skills: Excel, Power Query, Data Cleaning, Data, Data Visualization.

This project enhanced my skills in data storytelling, dashboard design, and translating raw data into actionable insights.