The Microsoft Power BI Advanced Design and Modelling course will take your staff from a basic knowledge and ability in Power BI to a more in depth knowledge around data modelling and visualisation in Power BI. This course will also act as an excellent foundation for anyone interested in data modelling in other tools such as Microsoft SSAS. The course will cover: Building a Data Model, Using Query Editor, Mash Ups and Multiple Data Sources, Data Types and Categories, Advanced Time Intelligence in DAX, Visualising Geographical Data, Refreshing Data and Gateway, Security and Best Practices. This is a perfect follow on from the Basic Design course.
Duration: 2 Days
Availability and Schedule: Please enquire

Course Topics:

Building a Data Model

This section sets the foundations. Data will be taken from a “normalised” database to build a data model to be used for reporting. Knowledge of SQL, whilst useful, is not essential as full support will be given.

Using Query Editor

The student will now enrich and enhance the data model built in section 1 using the query editor. This is a particularly critical feature if you ever need to work with “dirty” data sources, such as web sites or files that you have no control over.

Data Mashups and Multiple Data Sources

Once again, building on the model already created in this module we add data from internet sources, transforming it in the Query Editor and consolidating on the work done in section 2. Throughout these sections, students will be able to build visualisations to demonstrate the effects of the models changes being made.

Data Types and Categories

This is the first of two more technical sections: to ensure that the various visualisations and even DAX functions work correctly, it is important the data is set up with the correct types and categories – especially where these are not naturally detected from the underlying data source.

Advanced Time Intelligence in DAX

One of the most critical aspects of most BI solutions is the ability to carry out comparisons of data over time. Here we will look at Period to Date calculations and Period on Period comparisons. This section introduces the idea of context and learn how we can control it using the CALCULATE function.

Visualising Geographical Data

Geographical data is usually best presented in its natural environment – the map. Here we will look at Power BI’s advanced map visualisation to give clarity and insight into our geographical data.

Refreshing Data

Data gets old fast – and it’s no use if it’s out of date. It is critical that any data we work with in Power BI can be kept up to date. The student will learn how the Gateway works and how to set up and administer it.

Security and Administration

This section covers the setup of security and the general aspects of administering a Power BI solution. This is a chance to look at many of the practical issues involved in managing and sharing data in Power BI.