Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

Analysing Data Course

This course teaches students how to explore, analyse data and to ask the right questions that lead to better insights.

This is a course that teaches how to analyse data. The course uses Excel in the hands-on lab exercises. This is not an Excel course per-se. There are many other good tools to analyses data: for example, Python, SQL, Power BI, and R. This is for practical purposes. Nearly all attendees have at least basic familiarity with Excel but possible not with some of the other tools mentioned.

Excel also offers three separate and usefully distinct tools for data analysis. These are:

• the Excel formula language
• Power Query, that offers and user interface and cleaning and shaping data in a repeatable fashion
• Python, the de-facto language for data analysis, data science and AI. (This is available in Excel’s current channel although not all organisations have yet deployed this version so may not be available to all attendees)
• an embedded generative AI model, Copilot, which can help us with our data analysis. It can also help us to use Python - for example to build charts better and faster than using the standard charting options.

Here is the course outline.

Please follow the joining instructions well before the course.

In the lab exercises, we explore many datasets. The landing page with links to all these datasets is here. Keep this link handy.

Course Structure

What is data? How do we analyse it?

Tabular Data discussion

Tidy Data discussion

Tabular and Tidy Data exercise

Improving Data Quality: discussion and exercise

Survey Data

Optional Topics

Tools for data analysis

Descriptive Statistics and descriptive statistics exercise

Predictive Analysis and predictive analysis exercise

Performance Analysis & Reporting

Appendix

Data Quality Approaches

Post Course Resources