Havens Consulting

This three day course is designed for users who want to learn to enhance Power BI models for enterprise deployment, creating sharing strategies, and ensuring security. In this course, you will learn valuable tools and skills to create, configure, and manage enterprise-grade Power BI models and take your organization's data analytics to the next level.

We will also delve into important tools such as Tabular Editor and skills such as DevOps to ensure efficient management and maintenance of your models.

The training is relevant for data analysts, business intelligence professionals, IT professionals, and developers who work with Power BI. Participants should have a basic understanding of Power BI and data modeling concepts, including tables, relationships, and measures. Prior experience with Tabular Editor and DevOps is not required, but it may be helpful.

The modules covered in this course are as follows:

Enhancing the Model Design: In this module, you will learn how to create enterprise-grade design principles and recommended practices. It will look at configuring tables, columns, hierarchies, and measures.

Adding Enterprise-Grade Model Features: This module covers advanced features such as incremental refresh and very large datasets. We will add model level metadata, plus design for model reuse and use in Excel.

Deploying & Managing Content: This module focuses on the deployment of Power BI models and how to manage the content effectively. It covers version control, DevOps, and build and deployment pipelines. We’ll look at a range of tools such as Tabular Editor, Visual Studio, Azure DevOps, or GitHub. We’ll cover all terminology at a introductory level so you won’t get left behind.

Maintaining the Model Lifecycle: In this module, you will learn how to maintain and update your Power BI models effectively. You will learn publication options, how to configure datasets, refresh and monitor datasets, configure workspaces, and control workspace access.

Sharing Power BI Content: This module covers different sharing strategies for Power BI content. You will learn about sharing distributing content with Apps. You will also learn how to collaborate with workspaces and compare different sharing techniques.

Enforcing Permissions & Security: This module focuses on how to enforce permissions and security in your Power BI models. You will learn how to configure role-based access control (RBAC), implement RLS and OLS, and apply security labels. We’ll learn some common data leak pitfalls and how to avoid them.