Call Us: +32 2 466 00 16
Email: info@u2u.be
Follow Us:

Analyzing your data with Power BI for BI Professionals

5days
Training code
UBIPB
Book this course

Introduction to Power BI

Power BI is a product that covers many things: Power BI in Excel, Power BI Desktop, the Power BI online service, ... . In this introduction we set the scene for the rest of the training, introducing the different aspects of the Power BI product.

  • The need for Business Intelligence
  • Self-Service BI versus Enterprise BI
  • Power BI basics
  • Overview of Power BI Desktop
  • Introducing the Power BI Service

Creating Queries using Power BI Desktop

In this chapter you will learn how to create queries in Power BI Desktop to extract data from source systems like SQL Server, Oracle, Excel files, CSV files,... Applying transformations that can filter, sort and clean the extracted data will also be covered.

  • Overview of supported Data Sources
  • Importing data, Direct Query and Live Connections
  • Loading data from CSV and Excel files
  • Loading data from relational databases
  • Combining data from multiple files
  • Applying basic transformations
  • Query Folding

Writing Advanced Queries in Power BI Desktop

Often your data sources contain data that requires extra processing. You will learn about the more advanced transformations that Power BI has to offer like the Pivot, Unpivot, Columns By Examples,... transformations. Combining data from multiple queries into one query will also be covered in this chapter. In the second part you will learn about query parameters, get an overview of the M query language, learn how to write query functions and manage data source definitions.

  • Advanced Transformations
  • Appending and Merging Queries
  • Working with Query Parameters
  • M Language Syntax
  • M Query Basics
  • Defining and using Query Functions

Building a Data Model

  • Why do we need a Data Model?
  • Authoring data models in Power BI Desktop
  • Data model storage
  • Vertipaq Analyzer

Relationships

  • 1:n relationships
  • n:m relationships
  • Filter direction
  • Role-playing dimensions
  • One way versus both way filters

Storage modes

  • Import data
  • DirectQuery
  • Live connection
  • Aggregation tables

Data Analysis Expressions (DAX)

  • DAX introduction
  • Calculated columns
  • Measures
  • Tables
  • CALCULATE

Designing Reports in Power BI Desktop

After the model has been fine-tuned we can use this to create our reports. Power BI allows you to create very impressive reports, and in this module you will explore many visualizations, as well as the interaction between these visualizations.

  • Overview of the Report Canvas
  • Adding textboxes, shapes and images
  • Using built-in visualizations
  • Add style and branding through themes
  • Printing a Power BI Report
  • Creating Power BI Templates

Enhancing Reports in Power BI Desktop

Sometimes a static report just isn't enough. In this module you'll learn how to make interactive reports which are easy to use for any type of end user. Take your reports to the next level.

  • Working with Slicers and Filters
  • Working with Drillthrough report pages
  • Creating custom Tooltips
  • Working with Bookmarks
  • Visual hierarchies and drill-down behavior
  • Grouping and Binning
  • What If Parameters
  • Using Custom Visuals
  • Create reports that are optimized for phones
  • Miscellaneous features

Introduction to Power BI Service

If you want to share models and reports with you co-workers, the Power BI service allows you to upload these to the cloud and manage and share them with others. In this module you will learn about the general features of the Power BI service, the next modules dive into the details.

  • What is the Power BI Service?
  • Power BI Service pricing and features
  • Overview of the Power BI Service UI
  • Creating and using App Workspaces

Creating Datasets and Reports in Power BI Service

For some types of reporting you do not want to go through the hassle of creating a dataset in Power BI Desktop. That's why for a limited set of data sources we can start using them directly from the Power BI service without the need to first create an offline model. In this module you'll learn how to create these models directly in the Power BI Service.

  • Creating Datasets in the Power BI Service
  • Using Quick Insights
  • Creating Reports in Power BI Service
  • Printing Reports
  • Export to PowerPoint
  • Embedding Power BI Reports in SharePoint Online

Creating Dashboards and Analyzing Data with Power BI Service

Dashboards allow you to combine visuals from different reports into one page for quick access. This module teaches you to build and customize these dashboards in the Power BI Service.

  • Creating Dashboards
  • Printing Dashboards
  • Configuring Dashboards for Mobile Devices
  • Working with Power BI Q&A
  • Analyze in Excel

Sharing Content in the Power BI Service

Power BI has different mechanisms to share content with other users: Sometimes you want to share in order to develop something together, or you want others to customize something, or maybe you want others to have read-only permissions on the shared object. In this module you'll learn how to accomplish this with the different sharing options in the Power BI Service.

  • Sharing Reports and Dashboards with internal and external users
  • Sharing content using App Workspaces
  • Creating Power BI Apps
  • Consuming Power BI Apps
  • Using Publish to Web with Reports
  • Creating Report Subscriptions

Working with Data Gateways

Data models that are uploaded to the Power BI Service need to have their data refreshed from time to time. This module shows the different options to configure the data refresh, for cloud data as well as data which runs on-premises.

  • The need for a Data Gateway
  • Installing and configuring a Data Gateway
  • Creating Data Sources on a Data Gateway
  • Scheduling Dataset refreshes
  • Logging in the Data Gateway
  • Configuring incremental data refreshes in Power BI Premium
  • Working with Direct Query and Live Connections

Working with Dataflows

  • Create Dataflows to extract and clean data in the cloud
  • Dataflows, Entities and the Common Data Model
  • Creating Dataflows
  • Configuring incremental Refreshes
  • Working with Linked Entities
  • Configuring Computed Entities
  • Connect to Power BI Dataflows in Power BI Desktop

Securing a Data Model

  • Enhancing a Data Model with Row Level Security
  • Configuring Row Level Security
  • Implementing Dynamic Security

Power BI is a suite of business analytics tools to analyze data and share insights. Power BI Desktop transforms your company's data into rich visuals for you to monitor your business and get answers quickly with rich dashboards available on every device.

This course will teach you all aspects of creating Power BI Data Models and Reports and publishing and maintaining them on the Power BI online service. The course will cover technical topics on DAX and the M query language.  It also explains how to configure the Data Gateway so that you can connect the Power BI online service to your on-premise data sources. We finish the training with the brand new Dataflows and and an overview on how to implement Row Level Security in Power BI.

This course is intended for technical people who have a background in Business Intelligence. U2U also offers a 3-day course Analyzing your data with Power BI for Business Users targeted at people without a technical background.

© 2019 U2U All rights reserved.