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
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
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.