Data and AI Training

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:

1. describe the data that you use on a regular basis
2. explain what uses and purposes does the data have
3. list the tools do you use to analyse the data (and mention if there any tools you might like to use in the future)
4. suggest how could this data be improved

Example Analysis - Course Attendee List

For example, the trainer receives the attendee list. This is how it could be described. This data lists the attendees on an upcoming course. It is received just before the course.

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 attendee can register attendees

Data Analysis Tools Used

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