Data Training Courses

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

Power BI AI features course

Who should attend

Anybody who want to take advantage of the predictive, machine learning and embedded AI capabilities on Power BI.

Course Length

1 day

Learning Objectives

Attendees will be able to use the machine learning and AI features of Power BI including the Key Influencers visual and AutoML.

Pre-requisites

Basic familiarity with Power BI Desktop, for example by attending the foundation course.

Course Content

Attendees first explore a dataset to see if it may be possible to build a predictive model. We then build a predictive model with AutoML,a tool in the Power BI Service that guides us through creating a machine learning (ML) model step-by-step.

We look at the “AI assisted” visuals in Power BI - the Key Influencers and Decomposition Tree visuals

We incorporate R and Python scripts into Power BI, as a step in the Query Editor to shape the data and to create a visual.

We take advantage of the Insights features for example, explain the increase, quick insights, find where distribution is different.

We invoke Cognitive Services, to do some text analysis - we do this from the Query Editor and also from dataflows

Finally we use the Q&A visual and configure Power BI to better understand natural language questions.

This is a practical hands-on course based on a set of lab exercises and case-studies.