Training Courses

search courses

20778: Analysing Data with Power BI

Guaranteed to Run Scheduled Fully Booked
Location
Christchurch
Auckland
Wellington
Hamilton
Oct 2019
24
Nov 2019
18
7
18 27
Dec 2019
2
2
Jan 2020
20
Feb 2020
13
5
Mar 2020
19
16
18
Apr 2020
29
May 2020
25
Jun 2020
15
10
Jul 2020
20
22
Aug 2020
24
Sep 2020
21
2
Oct 2020
27
14
Nov 2020
23
25
Dec 2020
21
Voucher
Voucher: 3-day voucher
Code: 20778
Length: 2 Days
Certifications
MCSA: BI Reporting
Overview

Our most popular Power BI class! Gain a good understanding of data analysis with Power BI.

Delivery format(s)
On-Site
On-Site
On-Demand
On-Demand
Classroom
Classroom
Anywhere
Anywhere
OBJECTIVES
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

This class is also available as On-Demand - 3-month subscription.

PREREQUISITES

Before attending this course, students must have:

  • A need to analyse data.
  • An understanding of relational databases.
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications - particularly Excel.
  • An understanding of Excel PivotTables and vlookups.
WHAT YOU’LL LEARN

After completing this course, students will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.
COURSE OUTLINE

Module 1: Introduction to Self-Service BI Solutions
Introduces business intelligence (BI) and how to self-serve with BI.
Lessons

  • 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

Module 2: Introducing Power BI
This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.
Lessons

  • Power BI
  • The Power BI service

Module 3: Power BI
At the end of this module students will be able to explain the rationale and advantages of using Power BI.
Lessons

  • 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

Module 4: Shaping and Combining Data
With Power BI desktop you can shape and combine data with powerful, buil-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.
Lessons

  • Power BI desktop queries
  • Shaping data
  • Combining data

Module 5: Modelling data
This module describes how to shape and enhance data.
Lessons

  • Relationships
  • DAX queries
  • Calculations and measures

Module 6: Interactive Data Visualizations
This module describes how to create and manage interactive data visualizations.
Lessons

  • Creating Power BI reports
  • Managing a Power BI solution

Module 7: Direct Connectivity
This module describes various connectivity options using Power BI.
Lessons

  • Cloud data
  • Connecting to analysis services

Module 8: Developer API
This module describes the developer API within Power BI.
Lessons

  • The developer API
  • Custom visuals

Module 9: Power BI mobile app
This module describes the Power BI mobile app.
Lessons

  • Using the Power BI mobile app
  • Power BI embedded

This class helps prepare the student for Exam 70-778 which forms part of the MCSA: BI Reporting certification.

Enquiry Form