Data Training Courses

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

Generative AI For Data Analysis Course

Who should attend

This course if for people in data analysis or business intelligence roles.

Course Length

This is a full day course.

Learning Objectives

Attendees will learn how to use generative AI tools to help them analyse data, to help with Excel challenges, and to write or understand SQL, Python or DAX.

Pre-requisites

Completion of the Introduction to Generative AI course.

Course Content

The course explains how AI tools are very useful for solving Excel problems, analysing data, and coding. There are several exercises to use AI tools to help analyse a dataset. There are sections on:

• Use Gen AI (directly) to help analyse data
• work better with Excel and solve Excel challenges
• write good clear understandable SQL scripts
• to write Python (the de-facto open-source language for data science and AI)
• to help use write code in DAX (the data modelling language of Power BI)

Course Style

The course has has both tutorials and group exercises. In tutorials, attendees follow the instructor step by step or prompt-by-prompt. In the group exercises, attendees work in groups of about 4 - 5 people in breakout rooms for about 25-30 minutes. Once back in the main room, a spokesperson for each group summarises their conclusions to the class.