SALES DATA ANALYSIS - POWER BI

Sales Insights Overview:

Overall Performance:

Total sales amount to $34.49 million across 19 products and 9 cities.

The average sales per transaction are $185.49, with a total quantity sold of 209,000 units.

Product-Specific Highlights:

AAA Batteries and AA Batteries lead in quantity sold, with 31,000 and 28,000 units, respectively.

The Macbook Pro Laptop dominates with the highest total sales at $8 million.

Temporal Sales Patterns:

December emerges as the highest sales month, recording $4.61 million.

Hour 19 stands out with the highest sales among all hours.

Geographical Performance:

San Francisco tops the sales charts among cities.

Austin concludes the sales cycle for cities.

Recommendations:

1. Product Strategy Optimization:
   • Given the high quantity sold for AAA Batteries and AA Batteries, focus on targeted promotions or bundle deals to further capitalize on their popularity. Similarly, consider introducing complementary products to enhance overall sales.
2. Strategic Promotions for Macbook Pro Laptop:
   • Capitalize on the success of the Macbook Pro Laptop by introducing exclusive promotions or bundles. This could further boost sales and attract a broader customer base.
3. Seasonal Campaigns:
   • Leverage the observed sales peak in December by planning and executing targeted seasonal campaigns. Tailor promotions, discounts, or limited-time offers to maximize revenue during this high-performing month.
4. Hourly Optimization:
   • Recognize the sales dominance of Hour 19 and align staffing and promotional activities accordingly. Allocate resources to ensure peak performance during this hour, enhancing overall efficiency and customer engagement.
5. Geographical Targeting:
   • Given San Francisco's top sales performance, intensify marketing efforts and promotional activities in this city. Tailor strategies to local preferences and demographics to maximize sales potential.
6. City-Specific Promotions:
   • In Austin, where the last sales are recorded, consider implementing targeted promotions or incentives to revive sales. Evaluate local factors influencing purchasing decisions and adapt strategies accordingly.