Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data
This course teaches students how to explore, analyse data and to ask the right questions that lead to better insights. It starts with an an introduction to the data analysis capabilities of several popular software tools: Excel, Python, Power Query and Power BI. It also introduces the data analysis capabilities of generative AI assistants such as ChatGPT and Copilot. It describes tabular data and why we must get data into a tabular format before we can successfully analyse it. Finally, it covers techniques for cleaning and analysing data e.g., descriptive statistics, summarising , binning, grouping…
Here is the course outline.
Please follow the joining instructions well before the course.
In the lab exercises, we explore many datasets from the course datasets landing page. Keep this link handy.
Note that this course uses Excel, Python and Power BI Desktop in the hands-on lab exercises. The joining instructions provide details of how to install or set up these before teh course
Tabular and Tidy Data exercise
Descriptive Statistics and descriptive statistics exercise
Improving Data Quality: discussion and exercise
Predictive Analysis and predictive analysis exercise
Performance Analysis & Reporting
Attendee data analysis needs exercise
What is data? How do we analyse it?