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

Free resources for analysts and AI learners.

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

45 free guides, cheat sheets and practice files.

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.

PDF · Cheat sheet11 pages

SQL complete cheat sheet

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

PDF · Guide13 pages

SQL joins reference guide

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

PDF · Guide12 pages

SQL subqueries and CTEs guide

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

PDF · Guide12 pages

SQL window functions guide

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

PDF · Interview Q&A14 pages

50 SQL interview questions and answers

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

PDF · Workbook16 pages

SQL practice exercises

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

PDF · Project guide8 pages

SQL real-world project guide

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

PDF · Cheat sheet5 pages

Excel formula cheat sheet

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

PDF · Guide5 pages

Excel PivotTables guide

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

PDF · Guide5 pages

Power Query guide for Excel

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

PDF · Guide7 pages

XLOOKUP and INDEX-MATCH guide

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

PDF · Interview Q&A7 pages

Excel interview questions and answers

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

PDF · Project guide4 pages

Excel dashboard project guide

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

PDF · Cheat sheet5 pages

Power BI complete cheat sheet

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

PDF · Reference7 pages

DAX formula reference

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

PDF · Reference6 pages

Power Query (M) reference guide

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

PDF · Guide4 pages

Power BI data modelling guide

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

PDF · Interview Q&A6 pages

Power BI interview questions and answers

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

PDF · Project guide4 pages

Power BI dashboard project guide

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

PDF · Cheat sheet5 pages

Tableau complete cheat sheet

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

PDF · Guide6 pages

Tableau calculated fields guide

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

PDF · Guide4 pages

Tableau dashboard design guide

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

PDF · Interview Q&A5 pages

Tableau interview questions and answers

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

PDF · Project guide4 pages

Tableau real-world project guide

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

PDF · Cheat sheet7 pages

Python for data analysis cheat sheet

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

PDF · Cheat sheet5 pages

pandas cheat sheet

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

PDF · Guide8 pages

Data cleaning guide with pandas

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

PDF · Guide8 pages

NumPy reference guide

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

PDF · Interview Q&A9 pages

Python interview questions for data roles

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

PDF · Project guide6 pages

Data science project guide: customer churn

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

PDF · Guide4 pages

AI for data analysts guide

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

PDF · Guide4 pages

AI tools comparison guide for analysts

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

PDF · Guide5 pages

RAG and AI application concepts guide

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

PDF · Prompt library6 pages

Generative AI prompt library for analysts

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

PDF · Roadmap4 pages

Deep learning roadmap

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

PDF · Roadmap4 pages

Generative AI and LLM roadmap

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

PDF · Roadmap4 pages

Machine learning roadmap

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

PDF · Guide4 pages

Data analyst interview preparation guide

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

PDF · Roadmap4 pages

AI engineer career roadmap

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

PDF · Roadmap4 pages

Data analyst career roadmap

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

PDF · Roadmap4 pages

Data scientist career roadmap

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

PDF · Checklist3 pages

Portfolio and GitHub checklist

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

PDF · Checklist3 pages

Resume and LinkedIn checklist

CV structure, bullet points that show results, a pre-send check, and the LinkedIn profile section by section.

SQL script8 KB

SQL practice database

The shop database used in every Novo SQL guide: 12 customers, 49 orders, products, employees and monthly sales. Run it in MySQL 8.

Excel workbook29 KB

Excel and BI practice workbook

400 order lines (January to June 2026) as an Excel Table, plus regional targets. Used in the Excel, Power BI and Tableau guides.

Article

SQL window functions for analysts: running totals and month-on-month change

Running totals, month-on-month change with LAG, and the difference between GROUP BY and OVER, with a dataset and tested MySQL 8 queries.

Article

How to check SQL an AI assistant writes for you

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.

Article

What to put in a data analyst portfolio, and what to leave out

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.

Tool

Program Finder

A few short questions, a recommended path, honest time advice and the price in your currency.

Tool

From data to AI roadmap

Eight levels from data foundations to AI agents, and where to learn each.

Live class

Free monthly live class

One hour solving a real analytics problem live, then questions. Tell us which day and time suits you and we will invite you.

Tool

Verify a certificate

Check that a Novo AI Academy certificate of completion is genuine, using its ID.

Learn from trusted sources

Official guides and courses, by topic.

Documentation, courses and tools from the companies and projects behind each technology, the same material we point our own learners to.

Excel

SQL & MySQL

Python for data analytics

Power BI

Tableau

Data science & machine learning

Generative AI & AI-assisted analytics

Projects, portfolio & career

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

Stay Ahead in Data and AI

Get new learning resources, practical guides, project ideas, and AI insights delivered to your inbox.

  • New free PDFs and Insights articles
  • We confirm by email before adding you
  • Unsubscribe in one click, any time

Your AI career path

Your path from data to AI.

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.

FoundationsAnalytics & BIAI & MLAutomation
Level 4

AI-Powered Analytics

Claude, ChatGPT and Copilot across Excel, SQL, Python and BI, with verification.

Where you learn it

  • AI-Powered Data Analyst
  • AI for Data Analysts

Find your starting level

Free PDF

Free resource

Tell us where to send it. You can download it as soon as you press the button, and we email you the link as well.

We use your details to send this resource and to see which resources help people. We never sell them. Privacy policy.

Talk to a mentorFind my program

Your cookie choices

Choose which optional cookies we may use. Essential storage is always on because the site needs it.

EssentialAlways on

Your theme and currency, this choice, and spam protection on forms.

Analytics

Google Analytics, to count visits and see which pages and links help people. Also lets us note which link brought you here and send it with a request you make.

Advertising

Meta (Facebook, Instagram) and Google Ads, to measure whether our ads lead to enquiries.

Cookie policy · Privacy policy ·