cicifly / data-analytics-projects Goto Github PK

Introduction

• Analyzed the Superstore dataset to uncover sales trends and patterns
• Dataset spans multiple years, regions, and categories

Executive Summary

• Total sales: $2,297,200.86
• Total transactions: 5,009
• Peak sales month: November
• Highest sales day: Tuesday
• Key customer segment: Consumer

Overview

• Top 10 states by sales: California, Texas, New York, ...
• Bottom 10 states by sales: North Dakota, West Virginia, ...

Trends and Patterns

• Sales trend: November highest, January lowest
• Customer segment ranking: Consumer peaks in November
• Average sales by day of week: Tuesday highest, Saturday lowest

Sales and Transactions Report by Location

• Top 10 states by sales: California, ...
• Transactions by day of week: Monday highest, Wednesday lowest

Advanced Sales Exploration and Analysis

• Decomposition tree: Standard Class ship mode dominates in 2015
• Key influencers: Average categories influencing sales

Conclusions

• Seasonal trend: November peak sales
• Consistent demand: Home Office segment
• Optimized sales strategies: Tuesdays and Mondays

Recommendations

• Targeted marketing campaigns for Consumer segment in November
• Consistent marketing efforts for Home Office segment
• Optimized sales strategies for Tuesdays and Mondays

#DataAnalysis#SalesData
#BusinessIntelligence#DataInsights#SuperstoreDatase#PowerBI#DataVisualization#SalesStrategy#BusinessGrowth#Analytics
#MarketingInsights #SalesPerformance#GeographicAnalysis#CustomerSegmentation