Skip to content
Edition NigeriaGlobal
Country: Kuwait

You are in the Kuwait edition. Type your country to switch.

Set up your profile

You are learning in the Kuwait edition, with examples in dinars and from Kuwait.

AI for data analysis: spreadsheets and BI · Lesson 1 of 9

The analysis workflow with AI

Good analysis follows six steps: question, data, cleaning, analysis, checking and communication. This lesson shows where an AI assistant helps at each step, how to describe a data set precisely without sharing it, and how to run a first exploratory pass.

Intermediate12 min read5 steps

This lesson is complete in writing. A video for it is on its way.

What you will learn

  • By the end you can name the six steps of an analysis and say what each one produces.
  • You can say where an AI assistant helps at each step and where your own judgement has to lead.
  • You can describe a data set to an assistant precisely, using a data dictionary, without sharing the data itself.
  • You can run a short exploratory pass on a new data set and turn what you find into questions.

Key terms in this lesson

Pivot table
A spreadsheet tool that summarises a long table by groups, such as totals by year and sector.
SQL
Structured Query Language: the standard language for asking a relational database to select, filter, combine and summarise rows of data.
Personal data
Any information that identifies you or could be linked to you, such as your name, account numbers, address, ID number or voice.
Data dictionary
A document that lists each field in a data set with its meaning, its type and the values it is allowed to hold, so everyone reads the data the same way.
Exploratory data analysis
A first look at a data set to understand its shape, quality and patterns, such as gaps, odd values and spread, before any formal analysis begins.
Missing value
A blank in a dataset where a figure should be. It is not the same as zero.
Large language model
An AI model trained on huge amounts of text to understand and generate language.
AI hallucination
A confident answer from an AI tool that is false or made up, such as an invented figure or a source that does not exist.

Step 1 of 5

Six steps from question to answer

Opening this step…

Step 2 of 5

Start with a sharp question

This step opens when you finish the one above.

Step 3 of 5

Describe the data without sharing it

This step opens when you finish the one above.

Step 4 of 5

Explore before you analyse

This step opens when you finish the one above.

Step 5 of 5

Where an assistant helps and where you lead

This step opens when you finish the one above.

Key takeaways

The key takeaways open when you finish every step.

Lesson quiz

5 questions. You need 85% to pass.

The quiz opens when you finish every step.

Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.

Up next

English