Preparing your data

Import, cleanse and transform your data using Power Query, Microsoft’s Excel-like data import tool. Power Query supports connections to a large number of data sources and a large collection of transformations to clean and shape the data just the way you need it.

Modelling your data

Create relationships, the ability to create relationships between tables is one the key differences between Excel and Power BI enabling you to interact with data in new and exciting ways. Introduction to DAX, a powerful calculation language used by Power BI unleashing a wealth of reporting options.

Visualising your data

Power BI’s rich set of built-in visuals supported by a growing set of custom visuals allowing users to create stunning interactive visuals that help drive deeper insights into their data.

Publishing your report

Not only does the Power BI service allow you to share your report with your peers but also includes an amazing set of machine learning tools such as Q&A and quick insights that allow you to interact with your data in ways that you could not have imagined

Data modelling

A good data model is crucial to support more advanced reporting scenarios. You will learn to create a model using a star schema as well as how to implement advanced relationships using Bidirectional relationships to support Many-to-Many scenarios as well as inactive relationships.

DAX

Dax is the language used in Power BI, SSAS tabular and Power Pivot and a good understanding is essential to creating valid and performant queries. You will learn how to write queries to solve a variety of business scenarios. Some of the advanced functionality that you will learn about include aggregation and filter functions, Evaluation context and context transition using the CALCULATE and CALCULATETABLE functions as well as time intelligence.