Data Analysis Fundamentals
Collect, clean, analyze and visualize data with SQL, Python & Excel
What you'll be able to do
- Clean, transform, and explore real datasets
- Query data with SQL
- Analyze and visualize data with Python (pandas, matplotlib)
- Communicate findings as clear, decision-ready insights
Before you start
- Comfort with spreadsheets
- Basic arithmetic and logic
- No prior coding required
Phase 1 · Spreadsheets & SQL
Excel / Sheets for Analysts
Formulas, pivot tables, lookups, and clean charts. The fastest path to first insights.
- Microsoft: Excel video training (free)videofree
- Kaggle: intro datasetslinkfree
- Build a pivot table report
- VLOOKUP/XLOOKUP across sheets
- Dashboard with conditional formatting
SQL for Data Analysis
SELECT to window functions: querying, joining, and aggregating real datasets.
- Mode: SQL Tutorial (free)coursefree
- SQLBolt (interactive, free)coursefree
- Kaggle: Intro to SQLcoursefree
- Multi-table JOINs with filtering
- GROUP BY + HAVING aggregations
- Window functions (rank, running total)
Phase 2 · Python for Analysis
Pandas & Data Cleaning
Loading messy data, handling nulls, types, dedup, and reshaping with Pandas.
- Kaggle: Pandas Course (free)coursefree
- Kaggle: Data Cleaning Course (free)coursefree
- Python Data Science Handbook (free)docfree
- Clean a real messy CSV
- groupby + pivot + merge
- Handle missing data 3 ways
Visualization & Statistics
Descriptive stats, distributions, correlation, and clear charts that tell the truth.
- Kaggle: Data Visualization (free)coursefree
- Khan Academy: Statistics & Probabilitycoursefree
- Storytelling with Data (book)bookpaid
- Build an EDA notebook
- Explain a distribution + outliers
- Pick the right chart for a question
Phase 3 · Reporting & Capstone
Dashboards with a BI Tool
Turn analysis into shareable dashboards with Power BI or Tableau Public.
- Microsoft: Power BI learning (free)coursefree
- Tableau Public: free training videosvideofree
- Connect a data source
- Build an interactive dashboard
- Publish + share it
Capstone: End-to-End Analysis
Pick a question, source the data, clean it, analyze, and present findings to a non-technical audience.
- data.gov open datasetslinkfree
- Our World in Datalinkfree
- Frame a clear analytical question
- Document your data pipeline
- Present 3 insights + a recommendation
Frequently asked
Is the Data Analysis Fundamentals roadmap free?+
Yes. The entire Data Analysis Fundamentals roadmap and every curated resource is free to follow on Commit. You can track your progress, keep a daily streak, and earn a shareable certificate at no cost — there is no paywall.
How long does the Data Analysis Fundamentals roadmap take to complete?+
About 110 hours of focused study across 6 courses and 3 stages. At roughly one hour a day that is about 4 months; you can move faster by studying more each day.
Do I get a certificate for finishing the Data Analysis Fundamentals roadmap?+
Yes. When you complete the roadmap on Commit you receive a verifiable certificate of completion that you can add to LinkedIn and your public Commit profile as proof of what you finished.
Related roadmaps
Make it stick
Copy this roadmap into Commit and turn it into a tracked program with a streak graph, study logging, and a shareable certificate when you finish. Free forever.
Start Data Analysis Fundamentals free