ASHKA STORE ANALYSIS
Embedded Files
INTRODUCTION
In this project, I conducted a comprehensive sales performance analysis for Ashka Store, a retail business operating across 19 states. The primary goal was to uncover key sales patterns, identify high and low-performing regions, assess product performance, and provide data-driven recommendations for business growth.
This analysis was developed using Power BI, leveraging dynamic visuals, filters, and DAX measures to offer actionable insights for stakeholders.
OBJECTIVES:
Track overall business performance across states.
Identify top and least performing product categories and regions.
Analyze trends in customer purchases and payment behavior.
Provide insights to guide marketing and sales strategies.
EXECUTIVE OVERVIEW
KPIs:
Total Customers: 336
Total Orders: 1,500
Total Sales: ₦438K
Total Quantity Sold: 5,615 units
Profit: ₦37K
States Covered: 19
KEY INSIGHT:
Top Performing States by Sales: Maharashtra (102K), Madhya Pradesh (87K)
Least Performing States: Sikkim, Tamil Nadu, Goa
Most Ordered Product Category: Clothing (63.27%)
DASHBOARD HIGHLIGHTS
INSIGHTS
Top Profitable Subcategories:
Printers (₦8.6K), Bookcases (₦6.5K), Saree (₦4.1K)
Sales Trend by Month:
Highest quantity sold in March (751 units)
Noticeable drop in July
Payment Method Preferences:
UPI (45.5%), Debit Card (22.1%), Credit Card (10.87%)
Trend & Recommendations
Sales dropped significantly from June to July, particularly in Electronics and Clothing.
COD (Cash on Delivery) recorded the highest negative shift in July, indicating a potential issue with fulfillment or customer trust.
DASHBOARD HIGHLIGHTS
RECOMMENDATIONS
Revive Electronics & Clothing Sales:
The sharp drop in quantity sold between June and July was tied to reduced purchases in electronics and clothing. Strategic campaigns including discounts, product bundles, or promotional offers should be focused on these categories.Monitor COD Transactions:
COD contributed to the largest drop in quantity during the period under review. It’s recommended to review customer experience around COD orders, including delivery times, return rates, or failed deliveries.Capitalize on High-Performing States:
States like Maharashtra and Madhya Pradesh consistently drive high sales. Consider expanding distribution or exclusive offers in these regions to boost brand loyalty.Plan Around Seasonal Demand:
March saw the highest volume of purchases. This could indicate seasonal or festival-driven behavior. Align inventory and campaigns ahead of these peak months.
TOOLS & SKILLS APPLIED
Power BI Desktop
DAX for calculated fields
Data modeling and transformation
Slicers and drill-through filters
Interactive dashboard design
Visual storytelling through line, bar, donut, and waterfall charts
CONCLUSION
This project offered deep insights into Ashka Store’s operational performance across regions and products. The interactive dashboard not only enabled the identification of high and low-performing segments but also helped frame strategic business decisions to boost overall growth.
Page updated
Google Sites
Report abuse