Free Data Analyst Roadmap: From Spreadsheets to Defensible Decisions
Quantum Institute of Analytics (QIA) — original free learning checklist
Reviewed 27 October 2026
Learning time is flexible. Software, API use and examinations may cost extra.

[ ] 1. Understand the work before choosing the tools
Data analysis begins with a decision, not a dashboard. An analyst turns an uncertain business question into a measurable investigation, checks the evidence, and explains what someone can reasonably do next. Consider a small distributor comparing deliveries across Karachi, Lahore, and Dubai. A useful investigation asks whether late deliveries increased within comparable service types, rather than simply ranking cities by total complaints. Your responsibility is to define the comparison, expose limitations, and avoid presenting correlation as proof of a cause.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 2. Plan around your time, equipment, and actual costs
Free learning is not the same as free software. Public documentation can be read without tuition, while a particular desktop application, sharing feature, or hosted service may require a license. Excel desktop is generally licensed; browser access and available capabilities depend on the account and current offering. LibreOffice Calc can support early spreadsheet practice, but menus and advanced features differ. Power BI Desktop is a Windows application, and publishing or collaborating can introduce separate licensing requirements. Check current official terms rather than assuming that installation makes every workflow free.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 3. Learn spreadsheet structure before complicated formulas
Begin in Excel or an available spreadsheet alternative with tables, sorting, filtering, cell references, number formats, and basic formulas. Distinguish a stored value from its display format: a number shown as a percentage is not automatically a correctly calculated rate. Practice SUM, COUNT, AVERAGE, IF, SUMIFS, COUNTIFS, and lookup functions available in your version. Learn absolute references before copying formulas across hundreds of rows. Keep raw imports on a separate sheet and document every correction instead of silently overwriting source values.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 4. Use pivots and descriptive statistics to ask better questions
Next learn pivot tables, grouped summaries, conditional formatting, and simple charts. Calculate counts alongside averages so that a tiny group does not look as reliable as a large one. Compare medians with means when a few expensive orders distort the picture. Learn percentage change, percentage points, weighted averages, and the difference between an overall rate and an average of subgroup rates. A return rate calculated from total returns divided by total orders is not necessarily the same as averaging branch return percentages.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 5. Learn SQL from row selection to reliable joins
Move to SQL when spreadsheet transformations become difficult to audit or repeat. Use a local PostgreSQL installation or another clearly documented practice environment. Learn SELECT, WHERE, ORDER BY, CASE, GROUP BY, HAVING, and aggregate functions before exploring advanced syntax. Understand NULL as missing or unknown rather than zero. Practice date filters with explicit boundaries, and learn why filtering a timestamp through the end of a named day can accidentally omit records if the boundary is interpreted as midnight.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 6. Add intermediate SQL and data quality checks
Learn common table expressions, subqueries, window functions, and conditional aggregation. Use ROW_NUMBER to identify possible duplicates, LAG to compare periods, and a running sum to study cumulative activity. Explain partitioning and ordering in ordinary language before relying on a window result. Avoid memorizing interview puzzles without understanding how their assumptions differ from actual transactional data. Practice inspecting query plans later, once correctness and table relationships are comfortable.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 7. Learn Python for repeatable analysis, not syntax collection
Install Python through a trusted distribution and use an isolated environment for each project. Begin with variables, lists, dictionaries, conditions, loops, functions, file paths, and exceptions. Then learn pandas for reading CSV files, inspecting types, selecting rows, merging tables, grouping values, and handling missing data. Use notebooks for exploration, but move reusable cleaning steps into functions or scripts. A notebook should run from a fresh session without depending on cells executed in a mysterious order.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 8. Develop analytical judgment and honest comparisons
Study sampling, distributions, variation, confidence intervals, and the distinction between association and causation. You do not need advanced mathematics to recognize that a survey of current app users may exclude people who abandoned the service. Learn how changing definitions can manufacture apparent improvement. A customer support team can appear faster simply by excluding difficult tickets, so record eligibility rules before comparing performance. When exploring many segments, acknowledge that some striking differences may occur by chance.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 9. Build a Power BI report with an explicit data model
Learn Power Query transformations, relationships, a date table, and a simple star schema before spending hours on colors. Separate transaction facts from descriptive dimensions such as product and customer. Check relationship direction and cardinality; accidental many-to-many relationships can make totals difficult to interpret. Start DAX with measures for sales, completed orders, and return rate. Understand filter context through small examples, and distinguish measures evaluated at query time from calculated columns stored in the model.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 10. Learn Tableau as a second visualization environment
Use Tableau to strengthen visual reasoning rather than recreating every Power BI feature immediately. Practice dimensions and measures, discrete versus continuous fields, calculated fields, filters, sorting, and dashboard actions. Learn when a bar chart communicates comparison better than a map and when a line chart needs consistent time intervals. Inspect axis choices carefully: truncated scales can exaggerate small changes, while crowded dual axes can suggest relationships that the underlying data does not support.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 11. Build two portfolio cases with different business decisions
A strong portfolio needs a chain of reasoning, not a collection of unrelated charts. Make your first case an operations investigation using synthetic retail or logistics records. Include the stakeholder brief, data dictionary, cleaning log, SQL queries, dashboard, and recommendation memo. Show how you checked totals and explain one mistake you corrected. Make the second case a public-data analysis, perhaps comparing published education indicators or studying weather patterns, with source dates and geographic definitions clearly recorded.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 12. Handle privacy, security, and accessibility as core skills
Never assume removing names anonymizes a dataset. Phone numbers, precise addresses, device identifiers, and unusual combinations of attributes can identify people. Use synthetic records when practicing customer analysis, and aggregate sensitive geographic information when exact locations are unnecessary. Obtain permission before using organizational data, follow the applicable policy, and retain only what the task requires. Do not paste real customer tables into public AI assistants, online converters, or community support forums while asking for debugging help.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 13. Avoid the habits that slow down real learning
Common traps include switching tools whenever an exercise becomes difficult, copying dashboards without understanding the metrics, and treating every missing value as something to replace with zero. Another mistake is cleaning away unusual records before checking whether they represent genuine business events. Keep a decision log that records the reason for each exclusion or transformation. When a number seems surprising, inspect a handful of underlying records before inventing an explanation.
Checkpoint: build a small example, explain its limitations, and record evidence.

[ ] 14. Assess readiness and choose the next iteration
Test yourself with a fresh dataset and a realistic request: identify why net revenue changed and propose what should be investigated next. Without following a tutorial, define net revenue, inspect quality, write SQL, create a reproducible transformation, and present a concise visual explanation. Ask a peer to challenge your denominators, join logic, missing values, and causal language. If you cannot explain a calculation without reading the code, return to that concept rather than adding another tool to your profile.
Checkpoint: build a small example, explain its limitations, and record evidence.

FREE RESOURCES
Excel learning reference: https://support.microsoft.com/en-us/excel
PostgreSQL documentation: https://www.postgresql.org/docs/current/
pandas getting started: https://pandas.pydata.org/docs/getting_started/index.html
Power BI learning hub: https://learn.microsoft.com/en-us/training/powerplatform/power-bi
Tableau getting started: https://help.tableau.com/current/pro/desktop/en-us/gettingstarted_overview.htm
SQLBolt interactive lessons: https://sqlbolt.com/
Tableau Public download and learning: https://public.tableau.com/
World Bank downloadable indicators: https://data.worldbank.org/country/pakistan
Microsoft Power BI sample datasets: https://learn.microsoft.com/en-us/power-bi/create-reports/sample-datasets

DIRECT VIDEO LESSONS
The Complete Data Analyst Roadmap: https://www.youtube.com/watch?v=YRJbhFLLPyE
Data Analyst Full Course in 11hrs | Data Analyst Roadmap in 2024: https://www.youtube.com/watch?v=WIhnvXGVwwk
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more): https://www.youtube.com/watch?v=PSNXoAs2FtQ
How I Would Learn to be a Data Analyst: https://www.youtube.com/watch?v=JFA7H1uJ8wU
Excel for Data Analytics - Full Course for Beginners: https://www.youtube.com/watch?v=pCJ15nGFgVg
SQL Tutorial - Full Database Course for Beginners: https://www.youtube.com/watch?v=HXV3zeQKqGY
Learn Python - Full Course for Beginners [Tutorial]: https://www.youtube.com/watch?v=rfscVS0vtbw
How to use Microsoft Power BI - Tutorial for Beginners: https://www.youtube.com/watch?v=TmhQCQr_DCA
Learn Tableau in Under 2 hours | Dashboards, Relationships, Visualizations + Mini Project: https://www.youtube.com/watch?v=j8FSP8XuFyk
Linear Regression, Clearly Explained!!!: https://www.youtube.com/watch?v=7ArmBVF2dCs
Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby): https://www.youtube.com/watch?v=vmEHCJofslg
Git and GitHub for Beginners - Crash Course: https://www.youtube.com/watch?v=RGOj5yH7evk