20778 Analyzing Data with Power BI
CLASS DATE(s):
6/8/2020 - 6/10/2020
8/10/2020 - 8/12/2020

COURSE LENGTH: 3 Days

COURSE COST: $1495

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This three-day instructor-led course provides students with the knowledge and skills to analyze data with Power BI.

AUDIENCE AND PREREQUISITES

The primary audience for this course is BI professionals who need to analyze data utilizing Power BI. The secondary audiences for this course are technically proficient business users. In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications particularly Excel.

  

*Course Cost listed does not include the cost of courseware or exam. Course is subject to a minimum enrollment to run. Course may run virtually as a Virtual Instructor-Led (VILT) class if the minimum enrollment is not met. If the course is under the minimum enrollment the course may run as 4 day class (Bootcamp Style). For more information, please contact learn@vtec.org or call 207-775-0244.

COURSE TOPICS:


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 BI1
Microsoft Tools for Self-Service BI
Lab : Exploring an Enterprise BI Solution

Module 2: Introducing Power BI
Power BI
The Power BI Service
Lab : Creating a Power BI Dashboard

Module 3: Power BI Data
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

Module 4: Shaping and Combining Data
Power BI Desktop Queries
Shaping Data
Combining Data
Lab : Shaping and Combining Data

Module 5: Modeling Data
Relationships
DAX Queries
Calculations and Measures
Lab : Modeling Data

Module 6: Interactive Data Visualizations
Creating Power BI Reports
Managing a Power BI Solution
Lab : Creating a Power BI Report

Module 7: Direct Connectivity
Cloud data
Connecting to analysis services
Lab : Direct Connectivity

Module 8: The Developer API
The Developer API
Custom Visuals
Lab : Using the Developer API

Module 9: Power BI Mobile
Power BI Mobile Apps
Using the Power BI Mobile App
Power BI Embedded