Country: Germany
You are in the Germany edition. Type your country to switch.
Nigeria
Europe
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Germany edition, with examples in euros and from Germany.
Your learning profile
Intermediate path · Free course
AI for data analysis: spreadsheets and BI
Using AI assistants to analyse data well: cleaning data, writing and checking spreadsheet formulas, summarising with pivot tables, natural-language questions and SQL, charts and BI dashboards, statistical sanity checks, data storytelling, privacy and reproducibility.
- Intermediate level
- 9 lessons
- 2 hours of study
- 1 final test
- $5 certificate (about €4.56)
- Germany edition
Education, not advice: this course explains how products and rules work. It does not recommend any product, trade or provider.
What you will learn
- By the end you can name the six steps of an analysis and say what each one produces.
- By the end you can recognise the four common kinds of mess: duplicates, inconsistent labels, wrong types and dates, and missing values.
- By the end you can describe a sheet's columns precisely enough for an assistant to return a formula that fits it.
- By the end you can design a summary by deciding its rows, columns, measure and period before building it.
- By the end you can explain what a natural language query and text-to-SQL are, and where each can go wrong.
- By the end you can choose a chart type from the question it has to answer.
- By the end you can compare a mean with a median to spot skew and outliers.
- By the end you can turn a finding into a message with a clear so-what for a named audience.
Skills you will practise
Syllabus
-
The analysis workflow with AIGood analysis follows six steps: question, data, cleaning, analysis, checking and communication. This lesson shows where an AI assistant helps at eac…
12 min · 5 steps
- Six steps from question to answer
- Start with a sharp question
- Describe the data without sharing it
- Explore before you analyse
- Where an assistant helps and where you lead
- Lesson quiz
-
Cleaning data with AI helpMessy data produces confident wrong answers. This lesson covers duplicates, inconsistent labels, types and dates and missing values, how to ask an as…
11 min · 5 steps
- Why cleaning comes first
- Duplicates: decide first, then remove
- Labels, types and dates
- Missing values: choose a treatment
- A worked cleaning with a log
- Lesson quiz
-
Spreadsheet formulas with AIAn assistant can draft lookups, conditional sums and counts, and text and date formulas in seconds, but only a precise description of your columns ge…
11 min · 5 steps
- The formulas analysts use most
- Describe the columns precisely
- A worked conditional sum, checked by hand
- Lookups, text and dates: the usual traps
- Explaining formulas you inherit
- Lesson quiz
-
Pivot tables and summariesPivot tables summarise data by category and period, and an assistant can help you design them. This lesson shows how to check every summary against a…
10 min · 5 steps
- Design the summary before you build it
- Control totals: the check that never goes out of date
- A worked pivot that reconciles
- Percentages of total
- Percentage change and percentage points
- Lesson quiz
-
Natural-language questions and SQLMany data tools now let you ask questions in plain words and turn them into SQL. This lesson shows how to describe tables precisely, read a generated…
11 min · 5 steps
- Asking data questions in plain words
- Describe the tables before you ask
- A join that double-counts
- Read the query clause by clause
- Check the result with counts and totals
- Lesson quiz
-
Charts and BI dashboardsA good chart answers one question honestly. This lesson covers choosing the right chart, honest axes, dashboards built around decisions and how to ch…
10 min · 5 steps
- Choose the chart from the question
- Honest axes and labels
- Dashboards that answer questions
- Check every chart an assistant suggests
- A review before you share
- Lesson quiz
-
Statistical sanity checksAI assistants can produce insights faster than anyone can check them. This lesson gives you the sanity checks to apply: mean against median, outliers…
10 min · 5 steps
- Mean against median
- Correlation is a question, not an answer
- Small samples, big percentages
- Simpson's paradox: when the total misleads
- Questions to ask of any AI insight
- Lesson quiz
-
Data storytellingA finding only matters if someone understands and acts on it. This lesson shows how to turn a result into a message with a clear so-what, write a one…
10 min · 5 steps
- From finding to message
- A worked example: Zuma Water
- The one-page insight summary
- Avoiding overclaiming
- Drafting the story with an assistant
- Lesson quiz
-
Privacy and reproducible analysisUsing an assistant on real data raises two questions: is it safe to share, and could someone repeat what you did? This lesson covers describing, aggr…
11 min · 6 steps
- Share the least data that does the job
- Aggregates and the small-group problem
- Synthetic data for building and testing
- Making the analysis repeatable
- The analysis log
- Bringing the course together
- Lesson quiz
Final test
A fresh set of questions drawn from every lesson of this course, timed, with the options in a new order every time. You need 85% to pass, and passing earns your certificate.