About Microsoft Power BI

At the heart of Microsoft Power BI there are three core programs, Power BI Desktop, Power BI Services and Power BI Mobile, all of which are fast becoming forerunners in data analytics, and there's good reason for it. Previously, any serious data analyses was carried out by a company’s IT administrator, if you're lucky enough to have one. However, with Power BI, you are now empowered to perform those same analyses yourself.

The approach and concepts of these courses are introduced in a simple step-by-step manner, accompanied by corresponding easy to follow user guides. The techniques presented will allow you to produce in minutes, results that formerly would have taken an entire team weeks. Yes, it's that good!

Power BI Introduction

Power BI has a rich set of features for data shaping and cleansing, enabling the creation of sophisticated data sets and the output of comprehensive reports.

The four parts of the Power BI development cycle:

  • Data discovery: connect to various data sources
  • Data Transformation: shaping one or more tables connected by relationships
  • Data visualization: working with different types of table and chart visuals
  • Distribution of reports: share with others

We review the skills needed to consume data in Power BI Desktop, starting with the steps required to connect to various data sources, as well as ways to combine data from distinct data sources. Then we review integral data cleansing techniques using the Query Editor.

After reviewing the skills necessary to connect to data and transform data with the Power Query Editor, the process also known as data shaping, we cover data modelling skills. In Power BI, a data model is a collection of one or more tables connected by relationships.

Apart from the M language formulas which is part of data shaping, Power BI uses DAX, it's the native formula language within Power BI Desktop. Power BI possesses rich data modelling capabilities, which include creating relationships, measures (DAX) and calculated columns.

Next, we review the data visualization skills, working with diverse types of visualisations including charts and tables, managing interactions between visuals and configuring page layouts.

We then review the skills needed to work with another product in the Power BI family, Power BI Service. Publishing reports to Power BI Service, it's the online portal which refreshes changes we make to our datasets instantly and allows us to share reports with others.

Details and book

We offer four Power BI courses in an in-house or virtual classroom environment.

    Power BI Introduction. Details and book

    The 1-day course is a great way to get a balanced overview of the four main aspects of Power BI, in a short space of time; getting data, transforming data, creating visualisations, and publishing reports. It aims to have you using Power BI efficiently, in the shortest amount of time.

    Power BI Internediate. Details and book

    This 1-day course is designed to give you a balanced in-depth look at the four areas that make up Power BI Desktop: Report view, Data view, Model view, and the Query Editor. Enabling table transformation to produce reports.

    Power BI Introduction to Intermediate. Details and book

    The 2-day course is our most popular as it goes beyond the basics, allowing you to confidently start using the main aspects of Power BI straight away. It build on the 1-day course, going further into business scenarios, in greater complexity on the second day.

    Power BI DAX Measures. Details and book

    This 1-day course is specifically designed to help you understand the process of data modelling by writing DAX (Data Analysis Expressions). Altough it's pitched as an introduction, we would expect you to have some knowladge of Power BI.