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

Managing a Power BI Environment

3 days
UPBIM
3 days

Upcoming Sessions

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Location:

Book now

Interested in a private company training? Request it here.

Configuring Workspaces

Workspaces are places where users collaborate to create datasets, reports, dashboards, data flows,... In this module students will learn about securing and managing workspaces in an enterprise Power BI environment. Topics like how to automate the creation of workspaces, link workspaces to an Azure Data Lake Gen2 storage account, assigning capacity,... will be covered in this chapter.

  • Creating workspaces
  • Set a Workspace OneDrive
  • Shared versus dedicated capacity
  • Workspace connectivity with the XMLA endpoint
  • Configuring Azure Data Lake Gen 2 integration
  • Automating Workspace creation using PowerShell
  • Creating and working with Service principals
  • Power BI Governance
  • LAB: Configuring workspaces

Managing Datasets

Datasets are at the cornerstone of Power BI reporting. This module covers the versioning of datasets using free and open-source tools and how datasets can also be developed using Visual Studio with Analysis Services projects for stricter versioning and source control.

  • Working with datasets in the Power BI Service
  • Versioning using the open-source ALM Toolkit
  • Versioning and ALM using Visual Studio with Analysis Services projects
  • Working with shared datasets
  • Dataset Lineage
  • Certifying and promoting datasets
  • Automating Dataset deployment using PowerShell
  • LAB: Deploying and versioning datasets

Deploying content using Deployment Pipelines

When Power BI reports and dashboards become essential company resources, you don't want to deploy new or updated workspace content directly in production. This module describes how use deployment pipeline to deploy workspace content between development, acceptance and production workspaces.

  • The need for different workspaces
  • Using Deployment Pipelines
  • LAB: Working with Deployment Pipelines

Configuring workspace security

This module discusses the different workspace security roles and the consequences of these roles when sharing dashboards and reports with other users.

  • Configuring Workspace security
  • Security when sharing Dashboards and Reports
  • Securing data at rest
  • Securing data in transit
  • LAB: Securing workspaces

Refreshing datasets

Most datasets in the Power BI service contain a copy of the data from the source systems. This means that you must schedule data refreshes so that reports show the latest data. This module covers the installation and configuration of Data Gateways in Power BI. When you are dealing with large volumes of data, doing a full refresh is not feasible anymore. Incrementally refreshing and partitioning your data are a solution the this problem.

  • Data Gateways
  • Standard versus Personal mode
  • Import versus DirectQuery versus live connections
  • Configuring Data Refresh Credentials
  • Gateway clusters
  • Monitoring Gateways and data refresh
  • Configuring incremental refresh
  • Incremental refreshes and partitioning
  • Dataset refresh using the XMLA endpoint
  • LAB: Configuring data refreshes

Working with Dataflows

Dataflows bring Power Query to the cloud, allowing for reuse of data preparation logic in multiple datasets or in other Azure technologies. In this module, we will discuss the concept and usage of dataflows and the Common Data Model. You will not only learn how dataflows are created and leveraged in Power BI, but also how they can be used in other Microsoft Azure technologies like Azure Synapse and Databricks using Spark and the Common Data Model connector.

  • What are Dataflows?
  • Dataflows, Entities and the Common Data Model (CDM)
  • Dataflows and Azure Data Lake Gen 2 storage
  • Creating Dataflows
  • Working with linked and computed Entities
  • Scheduling refreshes for Dataflows
  • Using Dataflows in Power BI Desktop
  • Consuming and creating dataflows using Azure Synapse, Azure Databricks and Azure ML
  • Dataflow licensing
  • LAB: Working with Dataflows

Administering a Power BI Tenant

To enforce company policies, tenant settings need to be properly configured. Which custom visuals can be used? Can reports and report data be shared with external users,... In this module you will get an overview of the different Power BI tenant settings you can configure.

  • Configuring tenant settings
  • Sharing settings
  • Custom visuals settings
  • Managing custom data sources
  • LAB: Configuring a Power BI Tenant

Monitoring Power BI

Monitoring the Power BI environment is crucial to spot performance issues, to estimate capacity. Auditing is also important from a security point of view.

  • Monitor Power BI via reports
  • Monitoring workspace usage
  • Customizing workspace usage reporting
  • Power BI Premium Capacity Metrics and Alerts
  • Integrated Unified Office 365 Audit Logging
  • LAB: Monitoring Power BI

Power BI is a suite of business analytics tools to analyze data and share insights. This training shows you how to setup and manage Power BI in a enterprise business environment. It focusses on the challenges that might appear when a large group of people need to develop and access the Power BI infrastructure: How to do versioning? How to check data lineage? How to control the tenant settings? How to setup security? ...

BI and IT professionals responsible for an enterprise deployment and management of Power BI solutions in the cloud. Participants are expected to have some experience with Power BI Desktop.

© 2021 U2U All rights reserved.