EDA AND ETL...
TOOLS: Microsoft Excel: Power Query, Power Pivot, Pivot Table
Welcome to Auto Drive Motors
Your mission is to analyze our 2020 sales performance and provide actionable insights.
Objectives:
1. Sales Performance:
- Analyze 2020 sales trends, seasonality, and peak periods.
2. Customer Demographics:
- Understand customer age, gender, location, etc.
3. Geographical Analysis:
- Compare sales across branches and identify regional trends.
4. Product Analysis:
- Identify top-selling models and customer preferences.
Data set gotten from ‪@LearnwithEtuk‬