Analysing and presenting data for decisions
How to ask the right question, clean and analyse data in Excel, and present results with clear charts that lead to decisions.
What you will learn
- Turn a business question into an analysable one
- Clean data and summarise it with pivot tables
- Choose the right chart and write a clear conclusion
Section 1 · 13 min
From business question to data
AreenNarrated by Areen · move between slides freely.
Data analysis doesn't start with numbers but with a question. Managers don't want "an analysis"; they want a decision: where to open the branch? which campaign to repeat? why did satisfaction fall?
The analysis cycle
- QuestionWhich decision is needed, and which question helps make it?
- DataWhat data is available? Is it sufficient and reliable?
- CleaningFix errors, duplicates and missing values.
- AnalysisSummarise, compare and find patterns.
- Presentation and decisionA clear message that leads to action.
⚖️ From a vague question to an analysable one
✗ Weak✓ Stronger
"How are sales doing?"
"Which branch and product saw the biggest drop in sales last quarter compared with the same quarter last year?"
"Are students satisfied?"
"What share of students are satisfied with advising, by faculty and study year, in this semester's survey?"
✍️ Reflect and write
Write an analysable question in your field that available data could answer.
Sign in to save your answers.
🔒 2 more sections in this course
Sign in or create a free account to continue the course, save your progress and answers, and earn the certificate once credited.
A platform tool for this course: Career match
To get credit: prepare this before the session or training
Before the session:
- Pick a small dataset (survey results, expenses, open data), clean it and summarise it with a pivot table
- Make one chart and write a two-sentence conclusion
Discussion:
- How can charts mislead readers?