Call us at 1-800-413-0939
Hands On Technology Transfer, Inc.

Analyzing Data with Power BI

Attend face-to-face, remote-live or via Microsoft Official Courses On-Demand (MOC On-Demand)

Travel Packages Discount Programs
Top

Analyzing Data with Power BI (20778)

Duration: 3 Days

Live Course Delivery Price: $1795

MOC On-Demand Price: $895

Discounts: We offer multiple discount options. Click here for more info.

Delivery Options: Attend face-to-face in the classroom, remote-live or via MOC On-Demand.

Students Will Learn

  • Performing Power BI desktop data transformation
  • Describing Power BI desktop modelling
  • Creating a Power BI desktop visualization
  • Implementing the Power BI service
  • Describing how to connect to Excel data
  • Describing how to collaborate with Power BI data
  • Connecting directly to data stores
  • Describing the Power BI developer API
  • Describing the Power BI mobile app

Course Description

This is a Microsoft Official Course (MOC) and includes Microsoft courseware and hands-on labs. This course gives students a solid understanding of data analysis with Power BI. Topics include creating visualizations; connecting to Excel files; creating a Power BI dashboard; developing reports using the Power BI desktop App; using DAX syntax; accessing data in Azure SQL Data Warehouses; using the Power BI Mobile App and the Developer API.

Course Prerequisites

Before attending this course, students must have:

  • Excellent knowledge of relational databases and reporting
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming constructs (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

About MOC On-Demand

This course is also available via on-demand. Microsoft Official Courses On-Demand (MOC On-Demand) uses a combination of streaming video, text, lab exercises and assessment checks throughout the course. MOC On-Demand courses are available for 90 days and recommend the following system requirements:

  • Browser: Current version of Internet Explorer, Microsoft Edge, Google Chrome or Firefox
  • Internet: Broadband Internet connection of over 4Mbps
  • Screen Resolution: 1280 x 1024 or higher

Course Overview

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

Labs

  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard

After completing this module, students will be able to:

  • Describe the trends in BI
  • Describe the process of data analysis in Power BI.
  • Use the key visualizations in Power BI
  • Describe the rationale for self-service BI
  • Describe considerations for self-service BI
  • Understand how you can use Microsoft products to implement a BI solution

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
Labs
  • Connecting to Power BI data
  • Create a Power BI dashboard

After completing this module, students will be able to:

  • Develop reports using the Power BI Desktop app
  • Use report items to create dashboards on the Power BI portal.
  • Understand the components of the Power BI service including licensing and tenant management

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
Labs
  • Importing Excel files into Power BI
  • Viewing reports from Excel files

After completing this module, students will be able to:

  • Describe the data model and know how to optimize data within the model.
  • Connect to Excel files and import data
  • Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector
  • Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups

Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, built-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
Labs
  • Shape Power BI data
  • Combine Power BI data

After completing this module, students will be able to:

  • Perform a range of query editing skills in Power BI
  • Shape data, using formatting and transformations.
  • Combine data together from tables in your dataset

Module 5: Modeling Data

This module describes how to shape and enhance data.

Lessons

  • Relationships
  • DAX queries
  • Calculations and measures
Labs
  • Create relationships
  • Calculations

After completing this module, students will be able to:

  • Describe relationships between data tables.
  • Understand the DAX syntax, and use DAX functions to enhance your dataset
  • Create calculated columns, calculated tables 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
Labs
  • Connecting to Power BI data
  • Building Power BI reports
  • Creating a Power BI dashboard

After completing this module, students will be able to:

  • Use Power Bi desktop to create interactive data visualizations
  • Manage a power BI solution

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons

  • Cloud data
  • Connecting to analysis services
Labs
  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service

After completing this module, students will be able to:

  • Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop
  • Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimensional mode

Module 8: The Developer API

This module describes the developer API within Power BI.

Lessons

  • The developer API
  • Custom visuals
Labs
  • Using custom visuals

After completing this module, students will be able to:

  • Describe the developer API.
  • Use the developer API to create custom visuals

Module 9: Power BI Mobile App

This module describes the Power BI mobile app.

Lessons

  • Power BI mobile apps
  • Using the Power BI mobile app
  • Power BI embedded

After completing this module, students will be able to:

  • Describe the Power BI mobile app
  • Download and use the Power BI mobile app.
  • Describe Power BI embedded and when you would want to use it

Course Schedule

Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.