Why are the trainers not selling?
Harbour Sports is a made-up shop. The manager says: "We sold fewer trainers this month. Find out why."
You cannot just open a spreadsheet and look. First you must know what the manager really needs. Then you must find the data, check it and tidy it. Analysis is a set of steps, done in order.
By the end of this lesson
Note
I can put the stages of analysing data in the right order and say what each stage does.
Key words
| Word | What it means |
|---|---|
| Information requirement | what the reader needs to know, and why |
| Strategic data | data used to make big, long-term decisions |
| Operational data | data used to run the work each day |
| Data cleansing | finding and fixing errors in data |
| Duplicate | a record that appears more than once |
| Data manipulation | changing how data is arranged to answer a question |
The cells students fill in are left blank in this preview.
Starter: what you already know
Have a go
Starter: what you already know
4 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.
Two levels of data
Organisations use data at different levels. Operational data runs the work each day: today's sales, stock on the shelf, who is on shift. It changes all the time.
Strategic data helps the leaders plan the future: sales over three years, which towns buy most, whether to open a new shop. It is often a summary built from operational data.
Operational and strategic data
| Operational | Strategic | |
|---|---|---|
| Used by | Shop staff, team leaders | Managers, owners |
| Time span | Today or this week | Months or years |
| Example | Stock of trainers on the shelf | Trainer sales for each year |
| Question | Do we need to reorder today? | Should we stock more shoes next year? |
The cells students fill in are left blank in this preview.
Check
Have a go
Check
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.