This project analyzes the sales, marketing, and product performance of VTech, a global technology company.
Using Power BI as a complete analytics environment, I transformed raw transactional and marketing data into four interactive dashboards that reveal:
- Overall business health → Revenue, profit, deals closed, and targets met
- Customer & marketing performance → Campaign ROI, satisfaction, and conversion rates
- Product insights → Top performers, revenue vs. target, and profitability dynamics
- Transactional deep dive → Searchable report with drill-through capability
Each dashboard includes YoY comparisons (absolute, % change, and growth rate) across 2022, 2023, and partial 2024 (Jan–Aug).
🎯 What’s the big picture of sales & revenue performance?
KPIs:
- 2022: Revenue $601K, Profit $132K, Margin 22.0%
- 2023: Revenue $630K (+4.8% vs PY), Profit $136K (+3.1% vs PY), Margin 21.7% (-1.5% vs PY)
- 2024 (YTD Aug): Revenue $410K (-34.9% vs PY), Profit $86K (-37.2% vs PY), Margin 20.9% (-3.5% vs PY)
Key Visuals & Insights:
- Revenue Trend: Peaks in Jan 2022 ($55.9K), Apr 2023 ($65K), and Mar 2024 ($59.5K)
- Regional Split: Europe consistently leads; weakest regions shift (North America in 2022, South America in 2023, France in 2024)
- Sales Channel: Online dominates across all years (~66–68% of total revenue)
Key Takeaway:
Business grew steadily from 2022 to 2023, but the 2024 decline reflects incomplete data (up to August), not a collapse.
🎯 How effective are campaigns and customer engagement?
KPIs (YoY):
- Views: 45K → 46K (+1.2%) → 31K (-32.7% YTD 2024)
- Conversion Rate: 6.1% → 6.18% → 6.1%
- Satisfaction: 47.6% → 49.7% → 45.7%
Key Visuals & Insights:
- Top Campaigns: Winter Promo 2023 ($133K) & Spring Promo 2024 ($141K)
- Plans: Basic plan dominates (~75–78% of revenue)
- Lead Sources: Email consistently the top driver (>$140K annually)
- ROI: Strong campaigns peak at ~30%, weaker ones dip to ~21%
Key Takeaway:
Marketing delivers consistent ROI, but growth is slow. Heavy reliance on the basic plan and email campaigns is both a strength and risk.
🎯 Which products drive revenue & profitability?
Highlights:
- Revenue vs Target: 2022–23 mostly met/exceeded targets; 2024 weaker but incomplete
- Top 10 Products: Revenue concentrated in a small group of products
- Scatter Plot: Strong positive correlation between revenue and profit across products
Key Takeaway:
Performance is driven by a handful of products. Variability suggests seasonality and execution gaps.
🎯 How can we track performance at a granular level?
Features:
- Searchable drill-through table with Sales ID lookup
- Fields: Sales Date, Sales ID, Customer ID, Product, Country, Channel, Sales Rep, Revenue, Profit, Margin
Key Takeaway:
Enables granular audit, operational tracking, and transaction-level insights.
- 2022 → 2023: Modest but stable growth (+4.8% revenue)
- 2024 (Jan–Aug): Apparent decline (-34.9% YoY) is due to incomplete data
- Strengths: Online channel, email campaigns, and basic plan customers drive consistent growth
- Risks: Heavy revenue concentration in a few regions, campaigns, and products
- Stabilize underperforming regions (Canada, France)
- Diversify marketing channels beyond email
- Introduce premium plans for higher-margin growth
- Smooth seasonal dips with targeted promotions
- Investigate regional underperformance in France & Canada
- Reduce reliance on basic plan & email by expanding offerings
- Launch diversified campaigns with multi-channel strategies
- Implement seasonal promotions to boost weak quarters
- How to design multi-dashboard analysis systems in Power BI
- The importance of YoY comparisons for business context
- Campaign ROI analysis as a measure of marketing efficiency
- How data concentration risks impact long-term growth strategies
Technical Skills:
- Power BI (Advanced)
- DAX & Data Modeling
- Power Query (Data Cleaning & Transformation)
- Interactive Dashboard Design
- KPI & ROI Tracking
Soft Skills:
- Analytical Thinking
- Data Storytelling
- Critical Thinking
- Problem-Solving
- 📈 Identified regional performance gaps for targeted action
- 📊 Highlighted ROI strengths & risks in marketing strategy
- 💡 Exposed concentration risk in a handful of products and campaigns
- ⏱ Provided executive-ready insights to guide growth strategies
✅ This project demonstrates how Power BI dashboards, powered by DAX, data modeling, and interactive visuals, can provide end-to-end business insights into sales, marketing, and product performance.
A 4-in-1 Power BI dashboard analyzing sales, marketing, and product performance of VTech, with interactive ROI insights, product analysis, and drill-through reports.