E-commerce Sales Analysis Dashboard Using Power BI 🚀

I am excited to share with you some fascinating sales analysis insights that I have generated using Power BI. ⚡ Among the features of the report, the slicer section stands out as my favorite. The dashboard is highly dynamic, enabling the end-user to make informed business decisions much more efficiently.

⭐ About This Project

This dashboard provides a quick understanding to managers and stakeholders about the company's performance in key areas:

Key Features:

• Key Performance Indicators (KPIs):

  • Total Sales: $12.64M
  • Total Profit: $1.47M
  • Total Quantity Sold: 178K
  • Shipping Cost: $1.35M
  • Total Customers: 795

• Breakdown of Sales:

  • Sales by Segment: Consumer (51.48%), Corporate (30.25%), Home Office (18.27%)
  • Sales by Category and Market
  • Sales by Top 10 Countries: United States (29.01%), China (8.85%), Germany (7.94%), etc.
  • Sales by Top 5 States: New York, California, etc.
  • Sales by Top 5 Cities: New York City, Los Angeles, Seattle, etc.
  • Sales by Ship Mode: Standard, Second Class, First Class, Same Day
  • Sales & Profit by Year

• Visualizations:

  • Donut Charts: To show proportions in categories and markets
  • Pie Charts: For regional sales breakdown
  • Bar Charts: Highlighting top customers and products
  • Line Charts: Trends over years

• Top Products and Customers:

  • Top 3 Profiting Products: Canon imageCLASS 2200, Cisco Smart Phone, Motorola Smart Phone
  • Top 3 Profiting Sub-Categories: Bookcases, Copiers, Phones
  • Sales by Top 5 Customers

Usage

The dashboard is designed to be user-friendly and highly interactive, making it easy for end-users to:

• Filter data based on various criteria such as date range, product category, and customer segment.
• Drill down into specific areas of interest to gain deeper insights.
• Visualize data through various charts and graphs to identify trends and patterns.

Benefits

By using this dashboard, stakeholders can:

• Quickly assess the overall health of the business.
• Identify high-performing products and customer segments.
• Make data-driven decisions to optimize sales strategies and improve profitability.
• Monitor key metrics to ensure operational efficiency.

How to Use

1. Clone this repository:

   git clone https://github.com/yourusername/E-commerce-Sales-Analysis-Dashboard.git

2. Open the Power BI file: Open the .pbix file in Power BI Desktop.

3. Connect to your data source: Ensure your data source is properly connected and updated.

4. Explore the dashboard: Use the slicers, filters, and visualizations to analyze the data.

Technologies Used

• Power BI: For data visualization and dashboard creation.
• SQL: For data querying and transformation.
• Excel: For data preparation and initial analysis.