Getting Started with Power BI

Audience:End User / Power User, Business Executive
Duration:2.00 day(s)

Price: £975.00
Accommodation: £220 (UK Midlands only)

About this course

Getting Started with Power BI is 2-day online training course designed for students who are just getting started with Power BI and who need to get up to speed on building and deploying custom solutions using the Power BI Service and Power BI Desktop. Students will work through hands-on lab exercises to gain and reinforce skills for using a project-based approach for building custom BI solutions using Power BI Desktop.

Meet your trainer

Choose a date

Delivery Date Delivery Type Delivery Location  
October 24, 2018OnlineEMEA UK Time (9:30 start)
Book now
November 29, 2018OnlineEMEA UK Time (9:30 start)
Book now

All Combined Knowledge courses can be delivered privately online or at a site of your choice.
Contact us to arrange private delivery of a course or to find out more.

Book a private delivery of this course

There are currently no dates scheduled for this course, but all of our courses can be delivered privately at a site of your choice.

Our private on-site / online training can provide your business with the following benefits:

  • Substantial savings on travel and expense costs
  • Group learning – ensuring a consistent transfer of knowledge
  • Open discussions focused on specific business requirements
  • Ability to ‘cherry pick’ modules and tailor course content to your specific needs.
  • Multiple delivery and set-up methods

Contact us to arrange private delivery of a course or to find out more.

Course Syllabus

Getting Started with Power BI is 2-day online training course designed for students who are just getting started with Power BI and who need to get up to speed on building and deploying custom solutions using the Power BI Service and Power BI Desktop. Students will work through hands-on lab exercises to gain and reinforce skills for using a project-based approach for building custom BI solutions using Power BI Desktop.
Students will learn what can be accomplished with the Power BI service using just a browser as well as which types of project work must be completed using Power BI Desktop. Students will learn how to use the query features in Power BI Desktop to import and transform data as it loads into a project’s data model. The course also teaches students how to use the data modeling features of Power BI Desktop and to become proficient writing DAX expression to create calculated columns and measures. Students will learn how to design interactive reports as well as how to publish reports to the Power BI service and to SharePoint Online.

Along the way, students will learn how to import data from a variety of sources including Azure SQL databases, One Drive for Business, SharePoint Online and Dynamics 365. The course also teaches students the various techniques that can be used to integrate Excel workbooks into the Power BI environment.

Student Prerequisites

Students will require their own computer running either Windows 10, Windows 8.1 or Windows 7.

Course Modules

  • Introducing the Power BI Platform
  • Getting Started with Power BI Desktop
  • Mastering the Query Features of Power BI Desktop
  • Designing a Data Model with Power BI Desktop
  • Designing Interactive Reports in Power BI Desktop
  • Designing and Deploying Dashboards
  • Integrating Excel Workbooks into Power BI
  • Publishing Content using Apps and App Workspaces

Outline

Module 1: Introducing the Power BI Platform

This module introduces the fundamental concepts and terms associated with the Power BI platform. Students will learn how to create a trial tenant in Office 365 to serve as a multiuser development environment for designing and testing custom Power BI solutions. Students will learn to navigate around in the Power BI service using a browser and to create a simple solution which includes a dataset, a report and a dashboard. The module teaches students about Power BI licensing and the differences between standard Power BI subscriptions and a Power BI Pro subscriptions. The module concludes by discussing how to keep current with the Power BI cloud cadence and the monthly updates that Microsoft consistently applies to the Power BI platform.

Topics Covered

  • Understanding the Power BI Platform
  • Creating a Trial Office 365 Tenant for Development
  • Creating Datasets, Reports and Dashboards
  • Understanding Power BI Licensing
  • Staying in Sync with Monthly Updates

Module 2: Getting Started with Power BI Desktop

This module introduces students to Power BI Desktop and provides a high-level overview of managing the lifecycle of a Power BI Desktop project. Students will learn how the contents of a Power BI Desktop project are saved and published using the PBIX project file format. The module demonstrates how to import data from an external source into a Power BI Desktop project to create a dataset. Students will also learn how to get started with data modeling by creating simple calculated columns and measures. Students will also get hands-on experience using the report designer in Power BI Desktop and publishing a PBIX project file to the Power BI service to make a Power BI Desktop report accessible through the browser.

Topics Covered

  • Getting Started with Power BI Desktop
  • Creating Queries in Power BI Desktop
  • Modeling Data in Power BI Desktop
  • Designing Reports in Power BI Desktop
  • Publishing Power BI Desktop Projects

 

Module 3: Mastering the Query Features of Power BI Desktop

This module provides an in-depth examination of designing and running queries in a Power BI Desktop project. Students will learn to import data from a variety of external datasources including text files, Excel workbooks, web pages, Azure SQL databases, SharePoint Online and Dynamics 365. The module demonstrates how to design queries to clean up and transform data during the import process and students will learn the why and the how of designing queries in a Power BI Desktop project to generate a star schema. Along the way, students will learn advanced query design techniques to merge columns from multiple datasources and to append rows from multiple sources tables into a single output table.

Topics Covered

  • Deciding What To Measure
  • Working with the Query Editor Window
  • Managing Queries, Datasources and Credentials
  • Designing Queries in a Project to Generate a Star Schema
  • Creating a Query to Merge Columns from Multiple Datasources
  • Creating a Single Table by Appending Rows from Multiple Datasources
  •  

Module 4: Designing a Data Model with Power BI Desktop

This module examines the data modeling features in Power BI Desktop project and teaches students how to extend a data model with table relationships, calculated columns, measures and dimensional hierarchies. The module discusses working with the DAX expression language and reviews guidelines for writing maintainable DAX expressions. Students will learn how to import a lookup table from a secondary data source and how to integrate the lookup table into a data model to assist with data categorization. The module also demonstrates how to configure the metadata for geolocation fields within a data model so they can be used to visually map aggregated data values to geographical locations such as countries, states, cities and zipcodes.

Topics Covered

  • Modeling Data in Power BI Desktop
  • Understanding Table Relationships
  • Writing DAX Expressions
  • Understanding Calculated Columns versus Measures
  • Creating Dimensional Hierarchies
  • Adding Geographic Fields to a Data Model

 

Module 5: Designing Interactive Reports in Power BI Desktop

This module demonstrates how to use the report design features of Power BI Desktop to create reports using the standard set of Power BI visuals. Students will learn to design reports with effective interactive behavior by adding slicers, visual highlighting and drill actions. The module introduces students to the Power BI Custom Visuals Gallery and explains how to import custom visuals into a Power BI Desktop project. The module teaches students how to use Phone Layout view to create mobile reports as well as how to publish Power BI reports to the Power BI service. Students will learn how to use the Publish to SharePoint feature and the Publish to Web feature in Power BI to deploy reports to SharePoint Online sites and to public websites on the Internet with anonymous access.

 

Topics Covered

  • Designing Interactive Reports
  • Importing Custom Visuals
  • Designing Mobile Reports using Phone Layout View
  • Publishing a PBIX Project File to the Power BI Service
  • Publishing Reports in SharePoint with the Power BI Web Part
  • Publishing Reports using the Publish to Web Feature

Module 6: Designing and Deploying Dashboards

The module examines the role that dashboards play in Power BI and teaches students about the strengths and weakness of dashboards in comparison to Power BI reports. Students will learn about best practices in dashboard design and how to create an effective drilldown scheme from a dashboard into its underlying reports. Students will also learn about Natural Language Q&A and how to pin Q&A query results to create a dashboard tile. The module teaches students how to use Phone Layout view customize the mobile layout of a dashboard and examines using dashboard sharing as a simple mechanism to make dashboards and reports accessible to other users. The module concludes by examining how to configure a dashboard with data alerts to send notifications when a measure behind a dashboard tile reaches a predefined threshold.

Topics Covered

  • Understanding the Differences between Dashboards and Reports
  • Creating and Configuring Dashboards
  • Executing Queries with Natural Language Q&A
  • Designing Dashboards for Mobile Devices
  • Sharing Dashboards with Other Office 365 Users
  • Configuring Data Alerts on Dashboard Tiles

Module 7: Integrating Excel Workbooks into Power BI

This module discusses the three primary techniques that can be used to integrate Excel workbooks into the Power BI environment.  points that exist between the Excel Desktop application, Excel Online and the Power BI platform. First, students will learn how to connect to Excel workbooks from a Power BI workspace. Next, students will learn how to import an Excel workbook into Power BI to create a new Power BI dataset from the data inside the workbook. Finally, the module teaches students how to migrate a data model from inside an Excel workbook into a new Power BI Desktop project. Along the way, students will learn about several other features to assist with Excel to Power BI integration such as the Power BI Publisher Add-in for Excel and the Analyze in Excel feature.

Topics Covered

  • Data Modeling in Excel versus Power BI Desktop
  • Connecting to an Excel Workbook from Power BI
  • Migrating an Excel Data Model into Power BI Desktop
  • Using the Power BI Publishing for Excel Add-in
  • Connecting from Excel to a Power BI Dataset

 

Module 8: Publishing Content using Apps and App Workspaces

The module examines the best practice of building a custom solution in an app workspace and then using the app model to distribute the custom solution on a wide-scale basis. This module walks through the steps of publishing an app workspace and making it accessible to other users as an installable app. Students will learn the various ways one can install a Power BI app. The module demonstrates how to upgrade reports and dashboards after an app has been installed using staged updates. The module explains the essential concepts involved with Power BI Premium and dedicated capacities and demonstrates how to configure an app workspace to run within a dedicated capacity. Along the way, this module will provide students with the decoder ring necessary to understand the capacity-based licensing model and strategies for distributing content to users with the Power BI free license.

Topics Covered

  • Understanding the Role of App Workspaces
  • Publishing App Workspaces and Installing Apps
  • Updating Apps and Managing App Lifecycle
  • Understanding Power BI Premium and Dedicated Capacities
  • Configuring App Workspaces to Run in a Dedicated Capacity
  • Distributing Content to Users with the Power BI Free License

 

Not sure which Power BI training course is right for you?

Here's a quick visual guide to help, click on a course to see more

Courses related to Getting Started with Power BI

For users with 6 - 12 months' experience with Power BI, this Certification Bootcamp is an advanced 3-day training class designed to prepare students to pass Microsoft certification exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All the essential Power BI concepts and techniques discussed in lectures are reinforced with hands-on lab exercises in which students will move through the actual steps required to build reporting and dashboard solutions and then to distribute those solutions to a wide audience using app workspaces and the Power Bi app model.

View course

Power BI Developer Certification Bootcamp is an intensive 4-day instructor-led training course with hands-on labs designed to get professional software developers up to speed on developing custom software solutions for Power BI. This course assumes that students already have experience with Power BI Desktop and the Power BI Service and are looking for ways to move beyond what’s possible with just Power BI Desktop alone.

View course

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.

View course