Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.



Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Course information

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

Show moredowndown

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

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. 

Show moredowndown

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.

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.


Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.


State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible


Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience


Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.


Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.


Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.


Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.


Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Frequently asked questions


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
The price for Analyzing and Visualizing Data with Microsoft Power BI M20778 certification in Australia starts from AUD1195
The Knowledge Academy is the Leading global training provider in the world for Analyzing and Visualizing Data with Microsoft Power BI M20778.

Why choose us


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 & Approved

Microsoft Silver Learning Partner


Many delivery methods

Flexible delivery methods are available depending on your learning style.


High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
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

santander logo
bmw Logo
Google Logo
Shell Logo

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

Diane Gray, Shell

Looking for more information on Microsoft SQL Server Training?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on +61 1-800-150644 and speak to our training experts, we should be able to help you with your requirements.