
SQL complete cheat sheet
Every clause analysts use, from SELECT to window functions, with real results from a practice database. Tested on MySQL 8.
Weekday and weekend classes available
Book a free 20-minute session with a mentor
No payment on this website: confirm your schedule and payment options with our team
Free resources
Cheat sheets, interview questions, checklists, articles, a monthly live class, tools that help you choose what to learn, and trusted official guides for Excel, SQL, Python, Power BI, Tableau, data science and AI.
Resource library
Choose a resource and enter your name and email: you can download it straight away, and we email you the link too. SQL and Python examples were run while each PDF was built. Search, or filter by topic.

Every clause analysts use, from SELECT to window functions, with real results from a practice database. Tested on MySQL 8.

Every join type with real results, anti- and semi-joins, and why joined totals double. 8 exercises with answers. Tested on MySQL 8.

Scalar, IN, EXISTS and correlated subqueries, CTE chains and recursive CTEs, with 8 exercises and answers. Tested on MySQL 8.

Ranking, top N per group, running totals, moving averages, LAG/LEAD and frames, with real results and 8 exercises. Tested on MySQL 8.

Beginner to advanced, each with a worked answer and the wrong answer most people give. Every query tested on MySQL 8.

30 graded exercises from SELECT to window functions on one shop database, with tested answers and real results.

A complete sales-performance project: brief, data checks, seven analysis queries with real results, findings and the GitHub write-up.

XLOOKUP, SUMIFS, FILTER, UNIQUE, LET, text and date formulas, and five habits that make a workbook easy to check.

Build, group, filter and present PivotTables step by step, with check totals from the practice workbook so you know you are right.

Automate repeated cleaning in Excel: types, splitting, unpivot, merge, append and combining a folder of files, refreshed in one click.

XLOOKUP and INDEX-MATCH explained argument by argument: exact, approximate, two-way and multi-condition lookups, and fixing #N/A.

35 Excel interview questions with clear answers and formulas: lookups, SUMIFS, PivotTables, Power Query, dashboards and Excel tests.

Build a one-page sales dashboard in Excel: KPIs, trend, breakdowns and slicers that refresh in one click, plus the portfolio write-up.

The whole Power BI workflow: Power Query, star schema, date table, core DAX, visuals, publishing, refresh and security.

The DAX analysts use at work, grouped by job, with a working measure for each: CALCULATE, time intelligence, ranking and more.

The M language behind Power Query: syntax, the 40 functions analysts use most, custom columns, error handling, parameters and folding.

Facts, dimensions, grain and star schema; relationships, filter direction and the date table; six common modelling problems fixed.

35 Power BI interview questions: Power Query, star schema, DAX, visuals, performance, RLS and scenario questions, with clear answers.

From the practice workbook to a published two-page Power BI report: requirements, star schema, tested measures, design and write-up.

Tableau on a few pages: dimensions vs measures, filters and order of operations, core calculations, LODs, chart recipes and publishing.

Row-level vs aggregate logic, dates, strings, FIXED/INCLUDE/EXCLUDE LODs and table calculations, with 8 exercises and answers.

Design Tableau dashboards that read in five seconds: purpose, layout, chart choice, colour, actions, accessibility and performance.

30 Tableau interview questions: dimensions vs measures, LODs, table calcs, filter order, dashboards, performance and scenarios.

A complete Tableau Public project on customer analytics: lifetime value, cohorts, Pareto, two dashboards with actions and the write-up.

Core Python for analysts: types, strings, lists, dictionaries, comprehensions, functions, files, dates and errors. All code run.

Load, clean, reshape, summarise and export business data, with merges that cannot silently multiply rows. Run on pandas 3.0.

A seven-step pandas cleaning workflow on a messy file: types, text, dates, duplicates, missing values, outliers and validation.

Arrays, dtypes, indexing, boolean masks, broadcasting, axis aggregation, random numbers and NaNs. 6 exercises, all code run.

30 Python, pandas and NumPy interview questions for data roles, with clear answers and code run to prove each one.

A complete churn-prediction project with scikit-learn: framing, baseline, pipeline, metrics, a cost-based threshold and the write-up.

Use AI across the analytics workflow, how to brief an assistant, five checks before an AI number reaches a report, and data privacy.

General, spreadsheet, BI and coding AI assistants compared for analytics work (as of November 2026), plus a scoring sheet for your own trial.

How retrieval-augmented generation works: chunking, embeddings, search, prompting, a runnable retrieval demo, evaluation and security.

25 prompts for SQL, Python, Excel, DAX and reporting, each with the check that tells you whether the answer is right.

From neural-network basics to transformers: the maths you need, CNNs, sequence models, transformers, PyTorch and a project per stage.

From using AI assistants well to building LLM apps: prompting, APIs, structured outputs, tools, RAG, agents, evaluation and safety.

A six-stage path from Python and statistics to deployed models, with typical time per stage and a portfolio project for each.

The usual analyst interview rounds, a four-week preparation plan, frameworks for case and behavioural answers, and follow-up.

Skills to build and run AI applications: software engineering, LLM APIs, RAG, agents, evaluation, deployment and security.

Six stages from Excel to a portfolio, with typical time per stage, a project for each, and how to read your local job market.

From analyst skills to a first data science role: what the job involves, six stages with timeframes, portfolio projects and interviews.

What each project write-up should include, how to organise GitHub, and how to present your work.

CV structure, bullet points that show results, a pre-send check, and the LinkedIn profile section by section.
The shop database used in every Novo SQL guide: 12 customers, 49 orders, products, employees and monthly sales. Run it in MySQL 8.
400 order lines (January to June 2026) as an Excel Table, plus regional targets. Used in the Excel, Power BI and Tableau guides.
Running totals, month-on-month change with LAG, and the difference between GROUP BY and OVER, with a dataset and tested MySQL 8 queries.
AI-written SQL often runs and is still wrong. A worked example of a double-counting join, and a five-step routine to check any AI-written query.
How many projects you need, what each project write-up should show, how to organise GitHub, and what to leave out of a data analyst portfolio.
A few short questions, a recommended path, honest time advice and the price in your currency.
Eight levels from data foundations to AI agents, and where to learn each.
One hour solving a real analytics problem live, then questions. Tell us which day and time suits you and we will invite you.
Check that a Novo AI Academy certificate of completion is genuine, using its ID.
Nothing matches that search. Try another word, or ask us for a resource.
Learn from trusted sources
Documentation, courses and tools from the companies and projects behind each technology, the same material we point our own learners to.
Microsoft Support · external site
Syntax, arguments and worked examples for XLOOKUP, the modern way to look up values in a table, including approximate and nested lookups.
Open on Microsoft Support: XLOOKUP function (opens external site in a new tab) ↗Microsoft Support · external site
What PivotTables and PivotCharts are, and how they summarise, analyse and visualise worksheet data.
Open on Microsoft Support: Overview of PivotTables and PivotCharts (opens external site in a new tab) ↗MySQL Reference Manual · external site
Connect with the mysql client, create a database and tables, and run your first queries, from MySQL’s own manual.
Open on MySQL Reference Manual: MySQL 8.4 Tutorial (opens external site in a new tab) ↗MySQL Reference Manual · external site
How the OVER and WINDOW clauses work, with the functions used for rankings, running totals and frame specifications.
Open on MySQL Reference Manual: Window functions in MySQL (opens external site in a new tab) ↗Kaggle Learn · external site
Short hands-on lessons on writing SQL queries, run in the browser against Google BigQuery datasets.
Open on Kaggle Learn: Intro to SQL (opens external site in a new tab) ↗Python documentation · external site
python.org’s introduction to the language: data structures, functions, modules and the standard library. Easiest if you have written a little code before.
Open on Python documentation: The Python Tutorial (opens external site in a new tab) ↗pandas documentation · external site
A quick tour of Series and DataFrames: selecting data, handling missing values, grouping, reshaping and reading and writing files.
Open on pandas documentation: 10 minutes to pandas (opens external site in a new tab) ↗Kaggle Learn · external site
Short hands-on challenges to practise data manipulation with pandas.
Open on Kaggle Learn: Pandas (opens external site in a new tab) ↗Microsoft Learn · external site
Four modules: the analytics process, building with Power BI, end-to-end analytics in Microsoft Fabric, and Copilot in Power BI.
Open on Microsoft Learn: Get started with Microsoft data analytics (opens external site in a new tab) ↗Microsoft Learn · external site
Syntax, parameters and examples for more than 250 DAX functions, grouped by category such as filter and time intelligence.
Open on Microsoft Learn: DAX function reference (opens external site in a new tab) ↗Tableau · external site
Tableau’s own free videos for getting up to speed with building views, dashboards and calculations.
Open on Tableau: Free training videos (opens external site in a new tab) ↗Tableau · external site
A free platform to publish data visualisations online, a practical place to show your dashboards to employers.
Open on Tableau: Tableau Public (opens external site in a new tab) ↗scikit-learn documentation · external site
The core workflow: fitting estimators, pipelines, cross-validation and automatic hyperparameter search.
Open on scikit-learn documentation: scikit-learn: Getting Started (opens external site in a new tab) ↗Google for Developers · external site
A fast-paced, practical introduction to machine learning with videos, interactive exercises and hands-on practice.
Open on Google for Developers: Machine Learning Crash Course (opens external site in a new tab) ↗Claude Platform Docs · external site
When prompt engineering is the right fix, with links to prompting best practices and interactive tutorials.
Open on Claude Platform Docs: Prompt engineering overview (opens external site in a new tab) ↗Anthropic · external site
Anthropic’s learning hub for working and building with Claude, including AI Fluency, with certificates on completion.
Open on Anthropic: Claude Academy (opens external site in a new tab) ↗Novo AI Academy
The kind of business projects our learners build: the problem, the data, the deliverables and the recommendation.
View the projects: Example portfolio projects →GitHub Docs · external site
Create the special repository that puts a README on your GitHub profile, so visitors see your projects first.
Open on GitHub Docs: Managing your profile README (opens external site in a new tab) ↗Kaggle · external site
No-cost, hands-on micro-courses in Python, pandas, SQL, data visualisation and machine learning, useful for practice between classes.
Open on Kaggle: Kaggle Learn (opens external site in a new tab) ↗These links go to official documentation and learning sites. Novo AI Academy is not affiliated with these providers, and each provider sets its own access terms. Links were checked on 25 October 2026.
Newsletter
Get new learning resources, practical guides, project ideas, and AI insights delivered to your inbox.
Your AI career path
Eight levels, each building on the one before. Most people start at level 1 or 2; experienced analysts often start at 4. Select a level to see what it covers and where you learn it.
Claude, ChatGPT and Copilot across Excel, SQL, Python and BI, with verification.
Where you learn it