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

Send us your message.

X

Analyzing And Visualizing Data With Microsoft Power BI M20778 - Australia

Key points about this course


Duration: 3 Days*

Exam: Analysing and Visualising Data with Microsoft Power BI

Accredited: Yes

Support: 24/7

Dates & Prices Enquire
  • Grasp a broad understanding of data analysis using Power BI.
  • Learn how to create a Power BI report and Power BI dashboard.
  • Learn to use excel and databases as a data source for Power BI.

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

In-house

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. 

 

Prerequisites

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

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.

Key points about this course


Duration: 3 Days*

Exam: Analysing and Visualising Data with Microsoft Power BI

Accredited: Yes

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
+61 1-800-150644

Analyzing And Visualizing Data With Microsoft Power BI M20778 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
Adelaide
Mon 9th Dec 2019
Places available
$5995
Mon 16th Dec 2019
Places available
$5995
Perth
Mon 16th Dec 2019
Places available
$5995
Sydney
Mon 6th Jan 2020
Places available
$4895
Brisbane
Mon 6th Jan 2020
Places available
$5495
Perth
Mon 6th Jan 2020
Places available
$5495
Adelaide
Mon 6th Jan 2020
Places available
$5495
Melbourne
Mon 6th Jan 2020
Places available
$4895
Canberra
Mon 6th Jan 2020
Places available
$4895
Mon 13th Jan 2020
Places available
$4495
Mon 10th Feb 2020
Places available
$4495
Mon 9th Mar 2020
Places available
$4495
Mon 20th Apr 2020
Places available
$4495
Mon 4th May 2020
Places available
$4495
Perth
Mon 11th May 2020
Places available
$5495
Adelaide
Mon 11th May 2020
Places available
$5495
Melbourne
Mon 11th May 2020
Places available
$4895
Canberra
Mon 11th May 2020
Places available
$4895
Sydney
Mon 11th May 2020
Places available
$4895
Brisbane
Mon 11th May 2020
Places available
$5495
Mon 8th Jun 2020
Places available
$4495
Melbourne
Mon 6th Jul 2020
Places available
$4895
Canberra
Mon 6th Jul 2020
Places available
$4895
Sydney
Mon 6th Jul 2020
Places available
$4895
Brisbane
Mon 6th Jul 2020
Places available
$5495
Perth
Mon 6th Jul 2020
Places available
$5495
Adelaide
Mon 6th Jul 2020
Places available
$5495
Mon 20th Jul 2020
Places available
$4495
Mon 31st Aug 2020
Places available
$4495
Canberra
Mon 7th Sep 2020
Places available
$4895
Brisbane
Mon 7th Sep 2020
Places available
$5495
Sydney
Mon 7th Sep 2020
Places available
$4895
Perth
Mon 7th Sep 2020
Places available
$5495
Adelaide
Mon 7th Sep 2020
Places available
$5495
Melbourne
Mon 7th Sep 2020
Places available
$4895
Mon 21st Sep 2020
Places available
$4495
Mon 19th Oct 2020
Places available
$4495
Brisbane
Mon 9th Nov 2020
Places available
$5495
Sydney
Mon 9th Nov 2020
Places available
$4895
Perth
Mon 9th Nov 2020
Places available
$5495
Adelaide
Mon 9th Nov 2020
Places available
$5495
Melbourne
Mon 9th Nov 2020
Places available
$4895
Canberra
Mon 9th Nov 2020
Places available
$4895
Mon 16th Nov 2020
Places available
$4495
Mon 7th Dec 2020
Places available
$4495

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

Support: 24/7


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

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

hsbc-logo
mercedes-logo