The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - Available 24/7

Send us your message.


Analyzing Data With Power BI (M20778)

Key points about this course

Duration: 3 Days*

Exam: Analysing and Visualising Data with Microsoft Power BI

Accredited: Yes

Dates & Prices Enquire

Available delivery methods for this course

Classroom Icon


Onsite Icon


Online Icon


Virtual Icon

Live Virtual

Course Information

Analyzing Data with Power BI (M20778) Overview

This is a three-day Microsoft Power BI training course, allowing delegates to grasp a broad understanding of data analysis using Power BI. This is a collection of business analytics tools, which permits a series of data-based tasks to be completed, including desktop modelling and visualization, and data transformation. Delegates will learn how to complete these actions, whilst also learning broadly about the Power BI service, and the Power BI mobile app.


The Knowledge Academy is a proud Microsoft Silver Partner, and so is a fully accredited training provider of Microsoft training. 

Analyzing Data with Power BI (M20778) Outline

Module 1: Introduction to Self-Service BI Solutions

  • Introduction to business intelligence

  • Introduction to data analysis

  • Introduction to data visualization

  • Overview of self-service BI

  • Considerations for self-service BI

  • Microsoft tools for self-service BI

Lab: Exploring an Enterprise BI solution

  • Viewing reports

  • Creating a Power BI report

  • Creating a Power BI dashboard


Module 2: Introducing Power BI

  • Power BI

  • The Power BI service

Lab: Creating a Power BI dashboard

  • Connecting to Power BI data

  • Create a Power BI dashboard


Module 3: Power BI

  • Using Excel as a data source for Power BI

  • The Power BI data model

  • Using databases as a data source for Power BI

  • The Power BI service

Lab: Importing data into Power BI

  • Importing Excel files into Power BI

  • Viewing reports from Excel files


Module 4: Shaping and Combining Data

  • Power BI desktop queries

  • Shaping data

  • Combining data

Lab: Shaping and combining data

  • Shape power BI data

  • Combine Power BI data


Module 5: Modelling data

  • Relationships

  • DAX queries

  • Calculations and measures

Lab: Modelling Data

  • Create relationships

  • Calculations


Module 6: Interactive Data Visualizations

  • Creating Power BI reports

  • Managing a Power BI solution

Lab: Creating a Power BI report

  • Connecting to Power BI data

  • Building Power BI reports

  • Creating a Power BI dashboard


Module 7: Direct Connectivity

  • Cloud data

  • Connecting to analysis services

Lab: Direct Connectivity

  • Direct connectivity from Power BI desktop

  • Direct connectivity from the Power BI service


Module 8: Developer API

  • The developer API

  • Custom visuals

Lab: Using the developer API

  • Using custom visuals


Module 9: Power BI mobile app

  • The Power BI mobile app

  • Using the Power BI mobile app

  • Power BI embedded

Who should attend?

This course is widely attended by SQL Server report creators who wish to expand their knowledge in the field, and/or would like to use alternate means of presenting data. 



In order to enrol on this Analyzing Data with Power BI course, delegates should have the following previous experience and knowledge:

  • A level of understanding of data warehouse schema topology (including snowflake and star schematics)

  • Understanding of relational databases and reporting

  • Some experience of basic programming concepts (e.g. branching and looping)

  • A familiarity of key business priorities like profitability, revenue, and financial accounting (although this is not vital)

  • Awareness of Microsoft Office Applications, in particular Excel

Please arrive at the venue at 8:45am.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 3 days in duration
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts

Analyzing Data with Power BI (M20778) Exam

The exam that corresponds with this course is the Analyzing and Visualizing Data with Microsoft Power BI (beta) (70-778) exam. This exam tests the skills of consuming and transforming data using Power BI desktop, modelling and visualizing data, and configuring and dashboards in the Power BI service.

Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course

Duration: 3 Days*

Exam: Analysing and Visualising Data with Microsoft Power BI

Accredited: Yes

Why choose TKA logo

Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted Icon

Trusted & Approved

Microsoft Silver Learning Partner

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon


Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell


Super spring sales now on!