When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Microsoft Power BI Performance Best Practices

Grow your skills with Coursera Plus for $239/year (usually $399). Save now.

Microsoft Power BI Performance Best Practices

Instructor: Packt - Course Instructors

Included with

Learn more

15 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

15 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Set realistic performance targets and proactively address performance challenges
Understand how architectural choices impact performance optimization
Develop efficient Power BI reports and streamline data transformations

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 15 modules in this course

In today’s fast-paced business environment, optimizing Power BI performance is essential to building scalable and efficient solutions. This course teaches data professionals practical techniques to enhance the speed and efficiency of Power BI reports, empowering them to meet demanding performance requirements.

By diving deep into key topics such as data modeling, DAX, and performance management, this course will help learners overcome the common challenges of slow reports and poor data transformations. Learners will acquire actionable insights, equipping them to deliver high-speed, optimized Power BI solutions in their organizations. What sets this course apart is its blend of theory and real-world applications. Through a combination of technical explanations and illustrative examples, learners will get hands-on experience with the tools and practices required to improve Power BI performance, ensuring they can apply what they learn to actual business scenarios. This course is designed for data analysts, BI developers, and professionals who already have basic familiarity with Power BI. It is perfect for anyone looking to elevate their Power BI solutions and optimize performance, regardless of industry. Based on the book, Microsoft Power BI Performance Best Practices, by Thomas LeBlanc and Bhavik Merchant.

In this section, we define performance targets for Power BI solutions, analyze factors affecting report and data performance, and explore strategies for consistent management.

What's included

2 videos1 reading1 assignment

In this section, we examine Power BI architecture, focusing on data storage modes, gateway deployment, and log analysis to optimize performance and scalability for efficient data delivery.

What's included

1 video7 readings1 assignment

1 video Total 1 minute

Exploring Power BI Architecture and Configuration - Overview Video 1 minute

7 readings Total 80 minutes

Introduction 10 minutes
Import Mode 10 minutes
DirectQuery Mode 10 minutes
Direct Lake Mode 10 minutes
Deploying Power BI Gateways 10 minutes
Configuring Gateway Performance Logging 10 minutes
Scaling up Gateways 20 minutes

1 assignment Total 10 minutes

Power BI System Design and Optimization 10 minutes

In this section, we explore Power BI performance tools to analyze and optimize report efficiency, focusing on metrics and diagnostics for improved user experience.

What's included

1 video4 readings1 assignment

1 video Total 1 minute

Learning the Tools for Performance Tuning - Overview Video 1 minute

4 readings Total 50 minutes

Learning the Tools for Performance Tuning 20 minutes
Learning About the Performance Analyzer 10 minutes
Exporting and Analyzing Performance Data 10 minutes
Using the Optimize Ribbon 10 minutes

1 assignment Total 10 minutes

Mastering Tools for Optimizing Power BI Performance 10 minutes

In this section, we explore collecting and analyzing Power BI performance data using metrics, logs, and Azure monitoring tools to identify bottlenecks and optimize report efficiency.

What's included

1 video5 readings1 assignment

1 video Total 1 minute

Analyzing Logs and Metrics - Overview Video 1 minute

5 readings Total 50 minutes

Introduction 10 minutes
Making a Copy of the Usage Metrics Report to Edit 10 minutes
Viewing Granular Performance Data 10 minutes
Activity Logs and Unified Audit Logs 10 minutes
Azure Metrics for AAS 10 minutes

1 assignment Total 10 minutes

Analyzing Logs and Metrics in Power BI and Azure 10 minutes

In this section, we explore DirectQuery and DirectLake optimizations, focusing on reducing data source load and leveraging cloud capabilities for scalable performance in Power BI models.

What's included

1 video2 readings1 assignment

In this section, we explore third-party utilities like Power BI Helper, Tabular Editor, and DAX Studio to analyze and optimize Power BI model performance and query efficiency.

What's included

1 video4 readings1 assignment

In this section, we explore structured performance monitoring, root cause analysis, and repeatable improvement processes for Power BI to ensure sustainable BI solution efficiency.

What's included

1 video4 readings1 assignment

In this section, we explore efficient data loading, transformation, and refresh strategies in Power BI to optimize performance and reduce resource usage.

What's included

1 video5 readings1 assignment

In this section, we explore optimizing report layouts, interaction patterns, and dashboard design to enhance performance and user experience in Power BI.

What's included

1 video3 readings1 assignment

In this section, we explore efficient Power BI semantic model design, focusing on single-source truth, performance optimization, and RLS implementation for reliable data delivery.

What's included

1 video6 readings1 assignment

1 video Total 1 minute

Dimensional Modeling and Row Level Security - Overview Video 1 minute

6 readings Total 60 minutes

Introduction 10 minutes
Building a Single Source of Truth 10 minutes
Adjusting Date and Time Settings 10 minutes
Considering Many-to-Many Relationships and Bi-Directional Filtering 10 minutes
Avoiding Pitfalls with Row-Level Security 10 minutes
Guidance That Applies to Dynamic RLS 10 minutes

1 assignment Total 10 minutes

Data Modeling and Security Fundamentals 10 minutes

In this section, we examine DAX performance optimization by analyzing row and filter context, improving calculated columns, and applying efficient design patterns for better query efficiency in Power BI.

What's included

1 video3 readings1 assignment

In this section, we explore strategies for managing large data volumes using composite models, aggregations, and Azure technologies like AAS and Fabric for scalable architectures.

What's included

1 video6 readings1 assignment

1 video Total 1 minute

High Scale Patterns - Overview Video 1 minute

6 readings Total 60 minutes

Introduction 10 minutes
Leveraging AAS for Data and User Scale 10 minutes
Using Partitions in the Fact Table 10 minutes
Scaling with Aggregations and Composite Models 10 minutes
Leveraging Aggregations 10 minutes
Improving Performance with Synapse and Fabric 10 minutes

1 assignment Total 10 minutes

High-Scale Data Patterns and Optimization 10 minutes

In this section, we explore Power BI Premium and Fabric capacities, focusing on capacity planning, workload monitoring, and optimization strategies to ensure efficient resource use and performance in real-world deployments.

What's included

1 video6 readings1 assignment

1 video Total 1 minute

Working with Capacities - Overview Video 1 minute

6 readings Total 60 minutes

Introduction 10 minutes
How Capacities Manage Resources 10 minutes
Premium Capacity Overage 10 minutes
Determining the Initial Capacity Size 10 minutes
Alert Notifications 10 minutes
Utilization Overage 10 minutes

1 assignment Total 10 minutes

Power BI Capacity Management Fundamentals 10 minutes

In this section, we explore Fabric artifacts for data management, Direct Lake integration, and resource monitoring to enhance data warehouse efficiency and real-time analytics.

What's included

1 video2 readings1 assignment

In this section, we explore embedding Power BI content into web apps, focusing on optimizing performance and monitoring embedded reports using Fabric tools.

What's included

1 video2 readings1 assignment

Instructor

Packt - Course Instructors

Packt

1,608 Courses 446,194 learners

Offered by

Packt

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

Microsoft Power BI Performance Best Practices

Microsoft Power BI Performance Best Practices

What you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

There are 15 modules in this course

Setting Targets and Identifying Problem Areas

What's included

Exploring Power BI Architecture and Configuration

What's included

Learning the Tools for Performance Tuning

What's included

Analyzing Logs and Metrics

What's included

Optimization for Storage Modes

What's included

Third-Party Utilities

What's included

Performance Governance Framework

What's included

Loading, Transforming, and Refreshing Data

What's included

Report and Dashboard Design

What's included

Dimensional Modeling and Row Level Security

What's included

Improving DAX

What's included

High Scale Patterns

What's included

Working with Capacities

What's included

Performance Needs for Fabric Artifacts

What's included

Embedding in Web Apps

What's included

Instructor

Offered by

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

Can I preview a course before enrolling?

When will I have access to the lectures and assignments?

What will I get when I enroll?

More questions