Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data
Data Analysis Requirements Exercise
The purpose of this exercise is to understand the nature and type of data used by attendees so that we can tailor the course to be most relevant to them.
Please:
- describe the data that you use on a regular basis
- explain what uses and purposes does the data have
- list the tools do you use to analyse the data (and mention if there any tools you might like to use in the future)
- suggest how could this data be improved
Example Analysis - Course Attendee List
For example, the trainer receives the attendee list before a course. Here is a fictional example.
This is how it could be described. This data lists the attendees on an upcoming course. It is received just before the course. The first few rows look like this.
| Name |
Job Title |
Organisation |
Function |
| Alex Harper |
Data Scientist |
Novalytics Ltd |
Predictive Modelling |
| Maya Lin |
Software Engineer |
Quantum Arc Technologies |
Backend Development |
| Daniel Cho |
Research Analyst |
Helix Insights |
Market Research |
Data Description
- This is tabular data with a row for each attendee. There are about 20 rows.
- The columns are: name, job title, organisation, and function.
- The rows are in no particular order.
- The data is complete (no missing value)
- It is in PDF format.
Uses and Purposes
- Understand the background of the attendees so the trainer can tailor the course content.
- Create a list of attendees in order of first name, so that trainer can register attendees
I use Excel to sort and filter the data. Since the data is in PDF format, I must firstly use the PowerQuery component of Excel to import the data.
Suggested Improvements
- Split the (full) name column into two columns: first name and last name.
- Provide more details in the function column: replace OTHER values with more useful values.
- Collect data and add a new column : attendee requests for the course.
- The PDF format is not easily to analyse, e.g., we cannot filter, sort PDF data. Provide as an Excel file