📊 E-commerce Sales Dashboard | Power BI Project

🧠 Project Overview

In this project, I created an interactive E-commerce Sales Dashboard using Microsoft Power BI. The dashboard provides insightful visualizations of sales performance across various product categories, customer segments, regions, and time periods. It is designed to help businesses track KPIs, monitor revenue trends, and make data-driven decisions.

🎯 Objective

To analyze sales data and design a dynamic dashboard that enables stakeholders to:

• Monitor total sales, profit, and quantity sold.
• Filter data by region, category, sub-category, and order date.
• Compare profit margins across segments and time periods.
• Identify top-performing products and regions.

🛠️ Tools & Technologies

• Power BI for data modeling, visualization, and dashboard design.
• DAX (Data Analysis Expressions) for calculated metrics and dynamic insights.
• MS Excel / CSV as the primary data source for import.

📌 Key Features

• KPI Cards showing Total Sales, Total Profit, and Total Orders.
• Bar & Column Charts for Category and Sub-Category performance.
• Time-Series Line Charts to show trends over months and years.
• Map Visualization for region-wise performance.
• Slicers and Filters for interactivity and customized exploration.
• Pie Charts for customer segments and ship modes.

📷 Screenshots

E-commerce Dashboard Homepage

📁 Dataset

The dataset contains information about orders including:

• Order Date, Ship Date
• Sales, Quantity, Discount, Profit
• Category, Sub-Category
• Customer Segment and Region

📌 Note: The dataset used is similar to the Superstore dataset, which is publicly available and commonly used in data visualization projects.

📈 Insights Discovered

• Profitable Categories: Technology had the highest profit margins.
• Underperforming Segments: Office Supplies in the South region showed low profitability.
• Peak Seasons: November and December saw spikes in sales volume.
• Customer Segments: Corporate customers brought in the most revenue.

💡 Learnings

• Gained hands-on experience in Power BI visual design and data modeling.
• Learned how to use DAX to create dynamic metrics and time-intelligent visuals.
• Developed an understanding of how dashboards can drive business insights and decisions.

🔗 Project Links

• [🔗 View Power BI File (https://github.com/ToshanDahiya/Ecommerce-Dashboard-using-PowerBI-/blob/main/JOE%20Ecommerce%20sales%20dashboard.pbix)
• [🔗 GitHub Repository (https://github.com/ToshanDahiya/Ecommerce-Dashboard-using-PowerBI-/tree/main)
• [🔗 Dataset Source]
  [https://github.com/ToshanDahiya/Ecommerce-Dashboard-using-PowerBI-/blob/main/Details.csv]
  [https://github.com/ToshanDahiya/Ecommerce-Dashboard-using-PowerBI-/blob/main/Orders.csv]

🏁 Conclusion

This project is a solid demonstration of my data visualization skills and my ability to build insightful dashboards that help businesses make informed decisions. It reflects my growing expertise in Business Intelligence and my dedication to turning raw data into strategic knowledge.

---

Feel free to contact me for collaborations, feedback, or freelance dashboard design projects!

📩 Toshan Dahiya
💼 Data Analyst | Power BI Developer
📧 toshanrakeshdahiya@gmail.com
🔗 LinkedIn | GitHub