Guides
Practical articles on every skill this program covers. Free to read, written to actually help.
How to use AI as your analytics copilot safely and effectively
Learn how beginners can use AI as a tutor, idea partner and debugger for data analysis, while keeping your own judgment firmly in charge.
Read the guide →How to use AI tools to practice and improve your SQL safely
Learn how to draft, debug and understand SQL with AI tools while still checking results yourself so you truly build real skills.
Read the guide →Analytical thinking process: from problem to clear insights
Learn a simple analytical thinking process from framing your problem to extracting data, analyzing results and communicating clear, useful insights.
Read the guide →Core tools data analysts use: spreadsheets, SQL, visuals, AI
Learn the core tools data analysts actually use daily: spreadsheets, SQL, visualization tools and AI helpers, plus how to start with each.
Read the guide →Correlation vs causation in data: how to avoid wrong conclusions
Learn how to tell simple co-movement in data from real cause and effect so your analyses guide better business decisions.
Read the guide →Descriptive summary thinking with counts, sums and averages
Learn how to use counts, sums and averages to quickly describe data, spot patterns and answer everyday questions with confidence.
Read the guide →Distribution aware reasoning: why averages often mislead you
Learn how to look beyond simple averages, read full data distributions and avoid everyday decision mistakes at work and in life.
Read the guide →How to turn vague ideas into clear data questions
Learn a simple method to turn fuzzy business ideas into sharp, answerable data questions that actually guide your analysis and next steps.
Read the guide →Pivot table analysis: how to summarize large data fast
Learn how to build simple pivot tables to summarise big spreadsheets, spot patterns in seconds and answer basic business questions with confidence.
Read the guide →Role of a data analyst in turning raw data into decisions
Learn what data analysts actually do day to day, how they work with data, and how their findings guide better business decisions.
Read the guide →SELECT, filter and sort in SQL for clear beginner queries
Learn how to use SELECT, WHERE and ORDER BY in SQL to pick columns, filter rows and sort results so your data answers real questions.
Read the guide →Spreadsheet data cleaning with filters, sorting and formulas
Learn simple spreadsheet steps to spot errors, clean messy columns and fix basic data quality issues before serious analysis.
Read the guide →Spreadsheet fundamentals for beginners: cells, ranges, formulas
Learn the essential spreadsheet skills for data analysis: cells, ranges, sorting and simple formulas you can apply to your own data today.
Read the guide →SQL basics for data analysts: what it is and how it fits in
Understand what SQL is, how it talks to databases and where it fits into a real data analysis workflow, even if you only used spreadsheets before.
Read the guide →Tabular data thinking: how to structure data for analysis
Learn to think of your information as clean tables with rows and columns so you can sort, filter and analyze it with confidence.
Read the guide →Tidy data structuring explained: simple rules and examples
Learn how to turn messy spreadsheets into tidy data tables so each analysis is faster, less error prone and easier to automate.
Read the guide →Turn reading into real progress
A short quiz builds your personal learning path for How to Become a Data Analyst. Lessons adapt to you from day one.
Start the quiz