📌 Project Purpose A complete Power BI project focused on analyzing retail order performance. This project walks through customer order tracking, delivery status, category-wise distribution, and state-level performance — providing actionable insights for retail business optimization.
- Power BI Desktop
- Power Query (M)
- DAX (Data Analysis Expressions)
- Excel / CSV (Raw Data Source)
- Custom Visual Formatting
- Format: .xlsx / .csv
- Rows: ~294K Orders
- Columns: 7–8
- Fields include: Order_ID, Customer Name, State, Product Category, Product Brand, Product, Order Status
- Source: Simulated Retail Dataset
The retail company wants to better understand order fulfillment patterns, delivery efficiency, and product category performance to enhance customer experience and operational decision-making.
- Create an interactive, filter-driven dashboard
- Track key KPIs: Delivered, Shipped, Processing, Pending
- Understand product category contributions and state-wise distribution
- Provide actionable insights for supply chain & sales teams
- KPI Cards: Total Orders, Delivered, Shipped, Processing, Pending
- Line Chart: Orders trend by Month
- Donut Chart: Product Category Orders distribution
- Map Visual: Orders by State
- Table Visual: Order details (ID, Name, Category, Status)
- Clear visibility into order fulfillment efficiency (43% delivered vs 16% pending)
- 📈 Electronics (23.6%) & Grocery (22.1%) lead in sales share
- Helps identify regions with higher/lower order activity
- Improves inventory planning & supply chain efficiency
- Provides insights into customer demand trends across months
🔍 Full Dashboard Preview The dashboard showcases a dark-themed retail visualization with KPI cards, charts, and state-level mapping to deliver a professional analytical view.
🖼️Here is the link: View Full Dashboard Image
- Fully formatted KPI cards with icons & color coding
- DAX measures for calculating percentages & KPIs
- Power Query transformations for data cleaning
- Customized layout with modern dark theme
