📊 Ecommerce Sales Dashboard

This Power BI dashboard provides a comprehensive overview of ecommerce sales performance using dynamic and interactive visuals.

📁 Dataset

The dashboard uses two CSV files:

• Orders.csv: Contains order-level information such as State, Payment Mode, Quantity, Amount, Profit, etc.
• Details.csv: Contains details about product categories, sub-categories, and customer names.

📈 Dashboard Features

• KPIs: Total Sales Amount, Total Profit, Quantity Sold, Average Order Value (AOV)
• State-wise Sales: Horizontal bar chart showing regional performance
• Monthly Profit Trend: Column chart with monthly breakdown
• Top Customers: Visual representation of top-performing customers by sales
• Category Distribution: Pie chart showing category-wise sales quantities
• Sub-Category Profit Analysis: Bar chart of profit per sub-category
• Payment Modes Used: Pie chart showing distribution across payment methods

🛠 Tools & Skills Used

• Power BI Desktop
• Power Query
• DAX (Data Analysis Expressions)
• Data Modeling & Relationships
• Data Cleaning & Transformation

💡 Learnings

• Building relationships between multiple datasets

• Applying advanced filters and slicers

• Calculating KPIs using DAX

• Designing clean and visually appealing reports

  

📬 Feedback

Feel free to open issues or suggest improvements. Feedback is always appreciated!