Training
Power BI Core Skills
Power BI is the latest tooling for self-service analysis and reporting from Microsoft. This course is designed to show you how to enable end-users to perform much of their own analysis and reporting by using Excel, Power Query, Power Pivot, Power Map, Power Q&A and Power BI with just the right amount of depth, within a single day.

The course is most suitable for users that need to learn to work with the Microsoft Power BI platform or for existing IT professionals that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. Both high level and detailed click by click instructions are provided for all practical lab work.

During the course, you'll learn about how to acquire data using Power Query, how to construct an analytic data model using Power Pivot, how to analyse the data using Power View, Power Map, and Excel charts and pivot tables. You'll also see details of how to share your work with other by using Power BI and Sharepoint.

Our courses are based on the latest available versions of Power BI. The focus of the course and of the labs is on acquiring and shaping data, and on creating reports from the data. A demonstration of the capabilities that are provided by using Power BI online is also provided.

City
Dates
Course Price
Early Bird Price
Melbourne
11 Nov 2014
$700+GST
$595+GST if paid by Oct 28
Sydney
10 Feb 2015
$700+GST
$595+GST if paid by Jan 27
Brisbane
14 Apr 2015
$700+GST
$595+GST if paid by Mar 31
Perth
19 May 2015
$700+GST
$595+GST if paid by May 5
Canberra
18 Aug 2015
$700+GST
$595+GST if paid by Aug 4
Day
Code
Module
1
PB201
Visualizing Data with Excel, Power View, and Power Map
- Introduction to Power BI
- Creating Pivot Tables and Charts in Excel
- Interactively Visualising Data using Power View
- Interactively Visualising Data using Power Map
- LAB: Visualizing Data with Excel and Power View
1
PB202
Discovering and Preparing Data with Power Query
- Acquiring Data using Power Query
- Preparing Data using Power Query
- Managing Queries and Data Sources in Power Query
- LAB: Discovering and Preparing Data with Power Query
1
PB203
Creating and Enhancing Data Models using Power Pivot
- Creating a Power Pivot Data Model
- Adding Measures and Calculations to Power Pivot Data Models using DAX
- Enhancing a Power Pivot Data Model with Hierarchies, KPIs and Properties
- LAB: Creating Data Models using Power Pivot
1
PB204
Sharing Insights with Power BI Sites and Power Q&A
- Understanding Power BI and Power BI Sites
- Sharing Workbooks using Power BI
- Interacting with Data Using Power Q&A
- Accessing On-Premises Data using the Data Management Gateway
- LAB: Enhancing Power Pivot Data Models
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2014 by SQL Down Under | Terms Of Use | Privacy Statement | Client login