Skip to content

This Repo contains all the resources for the SuperStore Sales Analysis Dashboard using Power BI

Notifications You must be signed in to change notification settings

HussainM899/SuperStore-Sales-Dashboard-----Power-Bi-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 

Repository files navigation

Super Store Sales Analysis Dashboard -- Power Bi

Project Objective

The objective of this project is to contribute to the success of the business by utilizing Data Analysis techniques, specifically focusing on Time Series Analysis, to provide valuable insights and accurate Sales Forecasting of 15 Days.

Key Insights

  1. Payment Insights: 43% prefer COD, 22% Cards, 35% Online - Tailoring payment options can enhance customer satisfaction.
  2. Regional Sales Snapshot: West leads with 33%, Central with 22%, East with 29%, South with 16% - Targeted marketing is key.
  3. Best-Selling Category: Office Supplies - Exploring similar products promises growth.
  4. Total Revenue: $1.6M - An achievement that motivates us to aim higher.
  5. Units Sold: 22,000 - Reflecting our growing impact in e-commerce.
  6. Total Profit: $175,000 - Confirming the effectiveness of our strategies.
  7. Quick Shipping: 4 days on average - Dedicated to exceptional service.
  8. Sales Trends: A dip in April, strong year-end - Areas for optimization.
  9. Shipping Preferences: Most prefer Standard Class - Guiding shipping strategies.
  10. Forecast: Next 15 days avg. sale $5,304 - Preparing for what lies ahead.

Project Learnings

The project provided valuable learnings in mastering Data Analysis techniques, especially Time Series Analysis, to drive business success with valuable insights and precise sales forecasts.

Recommendations

  • Tailor payment options to enhance customer satisfaction.
  • Implement targeted marketing strategies based on regional sales snapshots.
  • Explore similar products in the best-selling category to drive growth.
  • Aim for higher revenue and profit by optimizing sales trends.
  • Focus on exceptional service and shipping strategies to meet customer preferences.

Watch the Power BI Dashboard Video

About

This Repo contains all the resources for the SuperStore Sales Analysis Dashboard using Power BI

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published