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.

Course Price
Early Bird Price
12 Jul 2016
$595+GST if paid by Jun 28
30 Aug 2016
$595+GST if paid by Aug 16
27 Sep 2016
$595+GST if paid by Sep 6
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
Discovering and Preparing Data with Power Query and Power BI Desktop
- 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
Creating and Enhancing Data Models using Power Pivot and Power BI Desktop
- 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
Creating and Querying Dashboards with the Power BI Site and Power Q&A
- Working with the Site
- Creating Datasets, Reports, and Dashboards
- Interacting with Data Using Power Q&A
- Using Power BI Desktop and Apps
- Accessing On-Premises Data via Gateways
- 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 2016 by SQL Down Under | Terms Of Use | Privacy Statement | Client login