During this full-day training session, you will learn Power BI from the ground up. Starting with a little bit of theory before diving into several practical demonstrations covering the full spectrum of the report creation lifecycle.

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

Using the knowledge you learn in this session, you will return to work with a great understanding of what Power BI is and the type of problems it can help you solve.

Some exposure to Excel and SQL will be helpful but is not a requirement. This session is aimed at people who know very little about Power BI or BI in general.
Laptop Required:Yes

Presented by Michael Johnson at SQLBits XVIII