XafsaCiise/Somali-Data-Analyst-Bootcamp
Record type:
software
Creator:
Xaf
Host:
Roadmapkan waxan ugu tala galay qof walba oo raba inuu barto (data analysis) falanqaynta xogta.
# 📊 Data Analyst Roadmap (Somali Edition)
Welcome to this structured roadmap designed to take you from **zero to job-ready Data Analyst** using practical projects and real datasets.
This repository is built for learners who prefer:
- Hands-on practice
- Real-world datasets
- Step-by-step progression
- Clear skill levels
---
# 🎯 Learning Path Overview
You will learn in 4 stages:
1. 📘 Excel (Data Cleaning + Analysis)
2. 🗄️ SQL (Data Extraction + Queries)
3. 📊 Data Visualization (Dashboards + Insights)
4. 🐍 Python (Automation + Advanced Analysis)
---
# 📘 Phase 1: Excel for Data Analysis (START HERE)
## 🎯 Goal
Learn how to clean, organize, and analyze raw data using Excel like a real analyst.
---
## 📁 Dataset
- `regional_sales_performance.csv`
- `customer_reference.csv`
---
## 🧠 Skills You Will Learn
### 1. Data Cleaning
- TRIM (remove extra spaces)
- PROPER (fix capitalization)
- VALUE (convert text to numbers)
- DATEVALUE (fix date formats)
- Find & Fix missing values
---
### 2. Basic Analysis
- SUM (total sales)
- AVERAGE (average price)
- COUNT / COUNTA (data size)
- MAX / MIN (best & worst values)
---
### 3. Logical Thinking
- IF (classify data)
- IFS (multi-condition logic)
- ISBLANK (detect missing values)
- IFERROR (handle errors)
---
### 4. Lookup Skills
- XLOOKUP (connect tables)
- MATCH (find positions)
---
### 5. Advanced Analysis
- SUMIFS (conditional totals)
- COUNTIFS (conditional counting)
- SUMPRODUCT (advanced calculations)
---
# 🧪 Excel Practice Tasks
## 🧹 Task 1: Clean the Data
- Remove spaces from Product_Code
- Standardize product names
- Fix date formats
- Convert Unit_Price into numbers
---
## 📊 Task 2: Sales Analysis
- Total sales per Sales Rep
- Total revenue per product
- Count returned orders
- Identify top-selling product
---
## 🔗 Task 3: Join Data
- Use XLOOKUP to bring:
- Customer_Name
- Region
---
## 📈 Task 4: Insights
- Which Sales Rep performed best?
- Which product sells most?
- Which region has highest s …