/data-analysis-dashboard

This interactive dashboard provides deep insights into ecommerce sales performance across multiple states in India. Built with advanced data visualization techniques, it enables users to explore sales trends, customer behavior, product profitability, and payment preferences with ease.

📊 Garima Ecommerce Sales Dashboard

Welcome to the Garima Ecommerce Sales Dashboard project! This interactive dashboard provides deep insights into ecommerce sales performance across multiple states in India. Built with advanced data visualization techniques, it enables users to explore sales trends, customer behavior, product profitability, and payment preferences with ease.

Project Learnings

🚀 Project Overview

This dashboard was designed to analyze and visualize ecommerce sales data across various dimensions such as:

  • 📅 Quarterly performance
  • 🗺️ State-wise sales distribution
  • 💳 Payment mode preferences
  • 👥 Top customers and their contribution
  • 📦 Product category and sub-category performance
  • 📈 Monthly profit trends

📚 Key Learnings

Through this project, I gained hands-on experience in:

  • ✅ Creating interactive dashboards to track and analyze online data
  • ✅ Using complex parameters to drill down into worksheets with filters and slicers
  • ✅ Establishing data relationships, joins, and calculations to enable user-driven visualizations
  • ✅ Designing customized visualizations including:
    • Bar chart
    • Pie chart
    • Donut chart
    • Clustered bar chart
    • Scatter chart
    • Line chart
    • Area chart
    • Map
    • Slicers

📂 Dataset

The dashboard is powered by three core datasets:

  • Orders.csv: Contains order-level details including customer name, state, and city
  • Details.csv: Includes transaction-level data such as amount, profit, quantity, category, sub-category, and payment mode
  • dashboard.pdf: A visual summary of the dashboard with embedded charts and figures

🖼️ Dashboard Preview

Here are a few snapshots from the dashboard:

🔹 State-wise Sales Distribution

State Sales

🔹 Payment Mode Analysis ( Different payment mode in MP )

Payment Mode

🔹 Top Customers ( Top Customers of Delhi )

Top Customers

🔹 Product Profitability

Product Profit

🛠️ Tools & Technologies

  • Power BI & Microsoft Excel
  • Data Cleaning & Transformation
  • Interactive Visualizations
  • Parameter-driven Filtering

📌 How to Use

  1. Clone this repository
  2. Open the garima_ecommerce_dashboard file in your power BI tool
  3. Explore the filters, slicers, and charts to gain insights
  4. Use the datasets to customize or extend the dashboard

🙌 Acknowledgments

Special thanks to all mentors and peers who provided feedback and guidance throughout this project. This dashboard was built as part of my data analytics learning journey.

📬 Contact

For feedback, collaboration, or questions, feel free to reach out:

Garima
📧 [garimakashyap2121@gmail.com]
🌐 LinkedIn Profile