Welcome to my Data Analysis Roadmap!
This repo is a structured plan to master Data Analysis, from fundamentals to advanced tools, including SQL, Python, R, Power BI, and Statistics.
- Core Understanding
- Types of Data Analytics
- Data Lifecycle
- Data Quality Concepts
- Business Language
- Analytical Thinking
- KPI & business metrics
- Excel Advanced Formulas & Pivot Tables
- Power Query & Dashboarding
- Insight Writing
- π₯ Project 1 β Sales Performance
- Database fundamentals
- Advanced SQL: JOINs, Subqueries, Window Functions
- Data quality in SQL
- Business Scenarios Analysis
- π₯ Project 2 β E-commerce Analysis
- Data Modeling & Star Schema
- DAX Functions & Time Intelligence
- Executive Dashboards & Storytelling
- Governance Concepts
- π₯ Project 3 β Company Dashboard
- Python Basics & Functions
- Pandas: Data Cleaning, Filtering, Aggregations
- Visualization & Reporting (matplotlib / seaborn)
- Python as Analyst
- π₯ Project 4 β Real Dataset Analysis
- Core Statistical Concepts
- Sampling & Bias
- Correlation & Causation
- A/B Testing & Forecasting
- π₯ Project 5 β Marketing Analysis
Mohamed Darwish β Data Analyst & Aspiring Data Engineer
- πΉ SQL | Python | R | Power BI
- πΉ Turning data into insights
- πΉ Always learning & improving
- Gmail: mdarwiish009@gmail.com
- LinkedIn: Mohamed Darwish
This roadmap is a personal learning plan, feel free to use it as a reference or modify it according to your learning path.