XafsaCiise/Somali-Data-Analyst-Bootcamp

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 …