Country: Mexico
You are in the Mexico edition. Type your country to switch.
Nigeria
The Americas
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Mexico edition, with examples in pesos and from Mexico.
Your learning profile
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.
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: Six steps from question to answer, not started
- Step 2: Start with a sharp question, not started
- Step 3: Describe the data without sharing it, not started
- Step 4: Explore before you analyse, not started
- Step 5: Where an assistant helps and where you lead, not started
About 10 min of reading
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.
Popular in Mexico: Financial markets law and regulation: foundationsFutures contracts and CFDs