Career Development CenterAl-Quds University
Back
SP10 Specialised trainingBusiness and Economics · Science and Technology · Public Health · Dual Studies · Engineering ⏱ 40 min📚 3 sections

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
1

Section 1 · 13 min

From business question to data

Areen

Narrated 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
  1. QuestionWhich decision is needed, and which question helps make it?
  2. DataWhat data is available? Is it sufficient and reliable?
  3. CleaningFix errors, duplicates and missing values.
  4. AnalysisSummarise, compare and find patterns.
  5. 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?