Power AI

Who is this course for? Anybody who want to take advantage of the predictive, machine learning and embedded AI capabilities on Power BI.

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 Power BI 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.

Below are some images from the lab exercises on the course.

Key Influencers AI-assisted visual in Power BI
A Key Influencers AI-assisted visual in Power BI suggests the key factors determining a binary outcome.
A box and whisker chart to indicate those variables that may have predictive power.
A Power BI Auto ML report
A step in the Power BI Auto ML process