Skip to content

This repository contains a Power BI dashboard designed to provide comprehensive insights into sales performance across various regions, segments, and products. The dashboard utilizes a variety of visualizations, including bar charts, line charts, maps, and tables, to effectively communicate key metrics and trends.

Notifications You must be signed in to change notification settings

Tapas-Gope/Global-SuperStore-Sales

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Global SuperStore Sales 🌍 🛒 📶

Dashboard Preview:

Screenshot 2024-09-16 044615

Introduction

The Global SuperStore Sales Dashboard provides valuable insights into the sales performance of Global SuperStore across different regions, segments, and product categories. It covers sales data from 2012 to 2015 and tracks critical business metrics such as total sales, quantity sold, profitability, and return orders. The dashboard helps the business identify top-performing products, customers, and regions, while also highlighting loss-generating products and return trends.

Key Metrics and Visuals

The dashboard features several essential metrics, which are visualized through charts and cards to offer a clear view of the business’s performance:

Total Sales

  • $12.64M (Sum of Sales)
  • Reflects the total revenue generated during the reporting period.

Quantity Sold

  • 178.31K units
  • Indicates the total number of units sold across all segments and regions.

Average Delivery Days

  • 4 Days
  • Tracks the average delivery time for orders, which can impact customer satisfaction and logistics efficiency.

Return Orders

  • 1,079 return orders
  • Highlights the number of return orders, offering insight into potential quality or service issues.

Sales by Region

  • The dashboard shows the geographical breakdown of sales, highlighting the performance of different regions. Screenshot 2024-09-16 045409

Sales Breakdown by Segment and Region

Sales by Segment

  • Consumer: $6.51M (51.48%)
  • Corporate: $3.82M (30.23%)
  • Home Office: $2.31M (18.28%)
  • The Consumer segment contributes the largest share of total sales, followed by Corporate and Home Office segments. Screenshot 2024-09-16 045734

Sales by Region

  • Asia Pacific: $4.04M (31.98%)
  • Europe: $3.29M (26%)
  • Other key markets include North America and Africa, providing insights into geographical performance. Screenshot 2024-09-16 045839

Product Performance

Top 6 Profitable Products

  • Canon imageCLASS 2200 Advanced Copier: $25K in profit
  • Cisco Smart Switch: $17K in profit
  • Motorola Smartphone: $17K in profit
  • These products contribute significantly to overall profitability, showcasing high-demand, high-margin items. Screenshot 2024-09-16 050050

Top 6 Loss Products

  • Bevis Compact Table: -$8.9K in losses
  • Bevis Round Chair: -$4.6K in losses
  • Cubify CubeX 3D Printer: -$4.4K in losses
  • These products represent the highest losses, signaling the need for potential discontinuation or reassessment of pricing and marketing strategies. Screenshot 2024-09-16 050138

Customer Analysis

Top 10 Customers by Profit

  • Tamara Chand: $8.7K in profit
  • Raymond Buch: $8.5K in profit
  • Sanjit Chand: $8.2K in profit
  • These high-value customers play a critical role in driving profitability for Global SuperStore. Screenshot 2024-09-16 050542

Conclusion and Actionable Insights

The Global SuperStore Sales Dashboard provides a clear view of the company’s sales and profitability across different segments, regions, and products. By leveraging these insights, Global SuperStore can make informed decisions to improve its overall performance.

Key Takeaways:

Segment Focus:

  • The Consumer segment is the top revenue generator, followed by Corporate and Home Office.
  • Future sales strategies should focus on further engaging the Consumer market.

Product Strategy:

  • Promoting high-performing products like the Canon imageCLASS 2200 Advanced Copier and addressing loss-making products like the Bevis Compact Table can optimize profitability.

Customer Retention:

  • High-value customers like Tamara Chand and Raymond Buch are critical to driving profits.
  • Implementing targeted marketing strategies for these customers can boost customer loyalty and sales.

Regional Focus:

  • Regions such as Asia Pacific and Europe account for a large portion of sales.
  • Expanding marketing efforts in these areas can help sustain growth.

By continuously monitoring and refining its business strategies, Global SuperStore can further enhance sales, improve customer satisfaction, and reduce operational inefficiencies.

About

This repository contains a Power BI dashboard designed to provide comprehensive insights into sales performance across various regions, segments, and products. The dashboard utilizes a variety of visualizations, including bar charts, line charts, maps, and tables, to effectively communicate key metrics and trends.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published