Destiny 📊

🔰 Data Analyst Roadmap 2026 ├── 🗃 Introduction to Data Analysis │ ├── Role overview & career paths │ ├── Key skills: SQL, Excel, storytelling │ └── Tools ecosystem (Colab, Tableau Public) ├── 📊 Excel Mastery (Formulas, Pivots) │ ├── VLOOKUP, INDEX-MATCH, XLOOKUP │ ├── PivotTables, slicers, Power Query │ ├── Charts & conditional formatting │ └── ETL basics in spreadsheets ├── 🔍 SQL for Analytics (Joins, Aggregates) │ ├── Advanced SELECT with WHERE, GROUP BY │ ├── JOINS (INNER, LEFT, window functions) │ └── Performance: indexes, EXPLAIN plans ├── 📈 Visualization Principles (Charts, Dashboards) │ ├── Chart types (bar, line, heatmaps) │ ├── Design rules (avoid chart junk) │ └── Color theory & accessibility ├── 🐍 Python Basics (Pandas, NumPy) │ ├── DataFrames: load, clean, merge │ ├── Grouping, pivoting, NumPy arrays │ └── Jupyter notebooks & stats intro ├── 🔢 Statistics Fundamentals (Averages, Tests) │ ├── Descriptive (mean, median, distributions) │ ├── Hypothesis testing (t-tests, chi-square) │ └── A/B testing & confidence intervals ├── 🛠 Tableau/Power BI Essentials │ ├── Tableau: calculated fields, LOD │ ├── Power BI: DAX, data modeling │ └── Interactive dashboards & storytelling ├── 🤖 AI Tools for Insights (Prompts, AutoML) │ ├── Prompt engineering for SQL/viz │ ├── Tableau Einstein, Power BI Copilot │ └── AutoML basics (no-code modeling) ├── ☁️ Cloud Platforms (BigQuery Basics) │ ├── BigQuery SQL & massive datasets │ ├── AWS QuickSight, Snowflake intro │ └── Free tier cost optimization ├── 📊 Data Storytelling Frameworks │ ├── Pyramid Principle for reports │ ├── KPI dashboards & executive summaries │ └── Narrative structure (context-insight-action) ├── 🔗 ETL Pipelines Intro (dbt, Airflow) │ ├── Data transformation with dbt │ ├── Orchestration (Airflow basics) │ └── No-code: Zapier automation ├── 💼 Portfolio & Interview Prep │ ├── 3-5 projects (sales, churn analysis) │ ├── Kaggle datasets & GitHub portfolio │ └── STAR method, mock interviews └── 🧪 Real-world Challenges (Kaggle, Cases) ├── E-commerce churn prediction ├── Marketing ROI analysis ├── Supply chain optimization └── LeetCode SQL, case studies Like for detailed explanation ❤️

Excel sounds easy until you actually start using it 😭🥺

I’ve finally set up my workspace!