Microsoft Excel Dashboard | Retail Sales Overview Analytics

I designed an interactive retail sales dashboard using Microsoft Excel to analyze and visualize key business performance metrics across products, customers, categories, and countries.

The dashboard provides business insights using KPIs such as total sales, total customers, average order value, sales growth percentage, average items per order, and average shipping time.

Dynamic filters including year, month, category, and country allow users to explore trends and compare performance across multiple business dimensions.

To present insights effectively, I used column, bar, donut, and line charts along with supporting analytical tables such as Top 10 Products by Sales and Top 10 Cities by Sales.

This project demonstrates skills in data cleaning, data modeling, Power Query transformation, Power Pivot analysis, and DAX-based KPI calculations.

Github: https://github.com/iamuzairmehmood/Projects-IBM-Data-Analyst-Professional-Certificate-2025/tree/main/MS%20Excel-Project-3-Retail-Sales-Dashboard

#DataAnalytics #ExcelDashboard #uzairmehmood_se

Видео Microsoft Excel Dashboard | Retail Sales Overview Analytics канала Uzair Mehmood