Reporting and dashboard route
For spreadsheet analysis, querying, dashboards and reusable business metrics.
Learn the concepts, practise the tools, refresh what you have forgotten and prepare for technical interviews across modern data and analytics work.
Search by tool, topic or interview term.
You do not need to complete the library in numerical order. The part numbers organise the collection; the paths below show useful combinations.
For spreadsheet analysis, querying, dashboards and reusable business metrics.
For coding, data preparation, statistical work and machine-learning foundations.
For structured data analysis, statistical testing and clear reporting.
Choose a subject and work from fundamentals toward practical analysis. Each guide also includes a refresher and interview section.
Learn Python fundamentals, pandas, statistics, machine learning and practical data workflows.
Open Python guide →Learn R, dplyr, ggplot2, statistics, modelling and reproducible reporting.
Open R guide →Learn SQL queries, joins, CTEs, window functions, stored procedures, indexes and interview topics.
Open SQL guide →Learn formulas, XLOOKUP, PivotTables, Power Query, Power Pivot and reporting workflows.
Open Excel guide →Learn Power Query, star-schema modelling, DAX measures, dashboards, RLS and publishing.
Open Power BI guide →Learn measures, filter context, CALCULATE, iterators, time intelligence and reusable DAX patterns.
Open DAX guide →Use these companion resources for practical tests, behavioural questions, definitions and last-minute interview revision.
Prepare for live technical tests, practical data questions and common behavioural interviews with clear answer structures and examples.
Open interview preparation →Quick, plain-English definitions for common Python, R, SQL, Excel, Power BI and DAX interview terms.
Open interview glossary →Begin with the foundations. Advanced material stays further down each guide.
Retype examples, change values and check the result yourself.
Search for a forgotten concept and return to the full guide when you need more context.
Revise terminology, practical tasks and behavioural questions before interviews.