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

Économisez sur les compétences qui vous font briller avec 40 % de réduction sur 3 mois de Coursera Plus. Économisez maintenant

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues.

Microsoft Power BI Performance Best Practices

Instructeur : Packt - Course Instructors

Inclus avec

15 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Intermédiaire

Expérience recommandée

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

15 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Intermédiaire

Expérience recommandée

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

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

Compétences que vous acquerrez

Catégorie : Performance Measurement
Catégorie : Performance Metric
Catégorie : Performance Management
Catégorie : Data Architecture
Catégorie : Performance Tuning
Catégorie : Data Modeling
Catégorie : Scalability
Catégorie : Model Optimization
Catégorie : Data Transformation
Catégorie : Dashboard Creation
Catégorie : Data Analysis Expressions (DAX)
Catégorie : Business Intelligence
Catégorie : Data Storage
Catégorie : Performance Improvement
Catégorie : Performance Analysis

Outils que vous découvrirez

Catégorie : Power Platform Architecture & Technical Design
Catégorie : Microsoft Azure
Catégorie : Power BI
Catégorie : Dashboard
Catégorie : Microsoft SQL Servers

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

mars 2026

Évaluations

15 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Il y a 15 modules dans ce cours

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.

Inclus

2 vidéos1 lecture1 devoir

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.

Inclus

1 vidéo7 lectures1 devoir

1 vidéoTotal 1 minute

Exploring Power BI Architecture and Configuration - Overview Video1 minute

7 lecturesTotal 80 minutes

Introduction10 minutes
Import Mode10 minutes
DirectQuery Mode10 minutes
Direct Lake Mode10 minutes
Deploying Power BI Gateways10 minutes
Configuring Gateway Performance Logging10 minutes
Scaling up Gateways20 minutes

1 devoirTotal 10 minutes

Power BI System Design and Optimization10 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.

Inclus

1 vidéo4 lectures1 devoir

1 vidéoTotal 1 minute

Learning the Tools for Performance Tuning - Overview Video1 minute

4 lecturesTotal 50 minutes

Learning the Tools for Performance Tuning20 minutes
Learning About the Performance Analyzer10 minutes
Exporting and Analyzing Performance Data10 minutes
Using the Optimize Ribbon10 minutes

1 devoirTotal 10 minutes

Mastering Tools for Optimizing Power BI Performance10 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.

Inclus

1 vidéo5 lectures1 devoir

1 vidéoTotal 1 minute

Analyzing Logs and Metrics - Overview Video1 minute

5 lecturesTotal 50 minutes

Introduction10 minutes
Making a Copy of the Usage Metrics Report to Edit10 minutes
Viewing Granular Performance Data10 minutes
Activity Logs and Unified Audit Logs10 minutes
Azure Metrics for AAS10 minutes

1 devoirTotal 10 minutes

Analyzing Logs and Metrics in Power BI and Azure10 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.

Inclus

1 vidéo2 lectures1 devoir

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.

Inclus

1 vidéo4 lectures1 devoir

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

Inclus

1 vidéo4 lectures1 devoir

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

Inclus

1 vidéo5 lectures1 devoir

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

Inclus

1 vidéo3 lectures1 devoir

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.

Inclus

1 vidéo6 lectures1 devoir

1 vidéoTotal 1 minute

Dimensional Modeling and Row Level Security - Overview Video1 minute

6 lecturesTotal 60 minutes

Introduction10 minutes
Building a Single Source of Truth10 minutes
Adjusting Date and Time Settings10 minutes
Considering Many-to-Many Relationships and Bi-Directional Filtering10 minutes
Avoiding Pitfalls with Row-Level Security10 minutes
Guidance That Applies to Dynamic RLS10 minutes

1 devoirTotal 10 minutes

Data Modeling and Security Fundamentals10 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.

Inclus

1 vidéo3 lectures1 devoir

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.

Inclus

1 vidéo6 lectures1 devoir

1 vidéoTotal 1 minute

High Scale Patterns - Overview Video1 minute

6 lecturesTotal 60 minutes

Introduction10 minutes
Leveraging AAS for Data and User Scale10 minutes
Using Partitions in the Fact Table10 minutes
Scaling with Aggregations and Composite Models10 minutes
Leveraging Aggregations10 minutes
Improving Performance with Synapse and Fabric10 minutes

1 devoirTotal 10 minutes

High-Scale Data Patterns and Optimization10 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.

Inclus

1 vidéo6 lectures1 devoir

1 vidéoTotal 1 minute

Working with Capacities - Overview Video1 minute

6 lecturesTotal 60 minutes

Introduction10 minutes
How Capacities Manage Resources10 minutes
Premium Capacity Overage10 minutes
Determining the Initial Capacity Size10 minutes
Alert Notifications10 minutes
Utilization Overage10 minutes

1 devoirTotal 10 minutes

Power BI Capacity Management Fundamentals10 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.

Inclus

1 vidéo2 lectures1 devoir

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

Inclus

1 vidéo2 lectures1 devoir

Instructeur

Packt - Course Instructors

Packt

1 857 Cours514 430 apprenants

Offert par

Packt

En savoir plus sur Software Development

Statut : Essai gratuit
Microsoft
Advanced DAX and Performance Optimization
Cours
Statut : Essai gratuit
Whizlabs
Power BI: Data Modeling and Data Analysis
Cours
Statut : Essai gratuit
EDUCBA
Analyze Sales Performance Using Microsoft Power BI
Cours
Statut : Essai gratuit
Edureka
Power BI Essentials: Data Transformation & Modeling with DAX
Cours

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Étudiant(e) depuis 2018

’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’

Jennifer J.

Étudiant(e) depuis 2020

’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’

Larry W.

Étudiant(e) depuis 2021

’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’

Chaitanya A.

’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’

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

Plus de questions

Visitez le Centre d'Aide pour les Étudiants

Aide financière disponible,

Microsoft Power BI Performance Best Practices

Ce cours n'est pas disponible en Français (France)

Microsoft Power BI Performance Best Practices

Ce que vous apprendrez

Compétences que vous acquerrez

Outils que vous découvrirez

Détails à connaître

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

Il y a 15 modules dans ce cours

Setting Targets and Identifying Problem Areas

Inclus

Exploring Power BI Architecture and Configuration

Inclus

Learning the Tools for Performance Tuning

Inclus

Analyzing Logs and Metrics

Inclus

Optimization for Storage Modes

Inclus

Third-Party Utilities

Inclus

Performance Governance Framework

Inclus

Loading, Transforming, and Refreshing Data

Inclus

Report and Dashboard Design

Inclus

Dimensional Modeling and Row Level Security

Inclus

Improving DAX

Inclus

High Scale Patterns

Inclus

Working with Capacities

Inclus

Performance Needs for Fabric Artifacts

Inclus

Embedding in Web Apps

Inclus

Instructeur

Offert par

En savoir plus sur Software Development

Advanced DAX and Performance Optimization

Power BI: Data Modeling and Data Analysis

Analyze Sales Performance Using Microsoft Power BI

Power BI Essentials: Data Transformation & Modeling with DAX

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Save on skills that make you shine with 40% off 3 months of Coursera Plus

Faites progresser votre entreprise et responsabilisez vos équipes

Foire Aux 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?

Plus de questions