Project Purpose
The purpose of this project is to analyze sales, profitability, and operating costs across different store types, departments, and locations using Power BI dashboards. The project aims to identify business opportunities, improve financial performance, and support data-driven decision-making.
Financial Analysis
1. Overall Financial Performance
| KPI | Value |
|---|---|
| Total Sales | $4.05 Billion |
| Gross Margin | $2.22 Billion |
| Total Cost | $1.53 Billion |
| Total Sales YTD | $1.39 Billion |
The company generated approximately $4.05 billion in total sales, with a gross margin of $2.22 billion, indicating strong profitability. Total operating costs are $1.53 billion, resulting in a healthy margin between revenue and expenses
2. Sales by Store Type
The dashboard shows that CORE stores generate the majority of total sales across all departments.
Store Performance
| Store Type | Performance |
|---|---|
| CORE | Highest revenue contributor |
| DIGITAL | Moderate sales |
| LOCAL | Lowest sales |
This indicates that CORE stores remain the company’s primary revenue driver and should continue receiving strategic investment. DIGITAL stores have growth potential, while LOCAL stores may require performance improvement initiatives.
3. Department Performance
Among all departments:
- Clothing generates the highest sales.
- Electronics is the second-largest contributor.
- Garage, Kitchen, and Other departments contribute comparatively less.
This suggests customer demand is strongest for apparel and electronics, while lower-performing departments may benefit from promotional or assortment strategies.
5. Cost Analysis
| Cost Category | Amount |
|---|---|
| Total Cost | $1.53 Billion |
| Rent | $840.29 Million |
| Wage | $687.84 Million |
Rent represents the largest operating expense, accounting for roughly 55% of total operating costs, while wages account for about 45%. This indicates that facility-related expenses have a significant impact on profitability and may present opportunities for cost optimization.
5. Sales Target Performance
Overall:
- Total Sales = $4.048 Billion
- Sales exceeded target by $291.85 Million
- Overall performance = 7.21% above target
This indicates the business surpassed its overall sales target, demonstrating strong sales execution.
Highest Positive Performance
Some of the strongest-performing locations include:
- Connecticut (20.02% above target)
- Pennsylvania (18.40% above target)
- Iowa (16.25% above target)
- Colorado (14.94% above target)
- Mississippi (14.69% above target)
Underperforming Locations
Several locations fell short of their targets:
- New Mexico (−11.71%)
- Oklahoma (−4.70%)
- Nevada (−2.25%)
- North Carolina (−1.41%)
These regions may require further investigation into sales strategies, local market conditions, or operational challenges.
6. Sales Trend Analysis
The sales trend from 2020 to 2022 shows generally stable performance with periodic spikes in revenue, suggesting seasonal demand or promotional events. Toward the end of 2022, sales decline slightly after a peak, indicating potential seasonality or changing market conditions.
7. KPI Performance
The Sales KPI indicates:
- Current Sales KPI: 18.03M
- Target: 27.30M
- Performance: 33.93% below target
Although overall annual sales exceeded the broader target, this specific KPI is below its goal, suggesting that a selected period, region, or business segment is underperforming and warrants additional analysis.
Key Recommendations
- Continue investing in CORE stores, which generate the highest revenue.
- Expand successful practices from high-performing states such as Connecticut and Pennsylvania to lower-performing regions.
- Review pricing, promotions, and operations in underperforming states like New Mexico and Oklahoma.
- Reduce operating costs by evaluating rent expenses, as they represent the largest share of total costs.
- Strengthen DIGITAL store performance through targeted marketing and customer engagement.
- Increase focus on high-performing departments, particularly Clothing and Electronics, while developing strategies to improve lower-performing categories.
- Investigate why the Sales KPI is below target despite overall sales exceeding targets, as this may indicate issues within a specific business segment or reporting period.