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.

Optimizing Data Models and Performance in Microsoft Fabric

Ends today! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Optimizing Data Models and Performance in Microsoft Fabric

This course is part of Architecting Power BI Solutions in Microsoft Fabric Specialization

Instructor: Packt - Course Instructors

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

4 hours to complete

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

4 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Optimize Power BI and Fabric data models for performance, storage, and scalability
Implement semantic model refresh and security strategies in Microsoft Fabric
Deploy robust, efficient BI solutions aligned with organizational performance goals

Skills you'll gain

Tools you'll learn

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

Build your subject-matter expertise

This course is part of the Architecting Power BI Solutions in Microsoft Fabric Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

This course teaches advanced strategies for optimizing data models and improving performance in Power BI and Microsoft Fabric. Learners will gain the skills needed to build efficient, secure, and scalable BI solutions in complex data environments.

Participants will explore Microsoft Fabric’s architecture, semantic model refresh strategies, storage modes, and intermediate data stores. By mastering these concepts, learners can enhance solution efficiency, streamline report distribution, and improve overall BI performance. What makes this course unique is its combination of theoretical knowledge with hands-on optimization techniques. Real-world scenarios demonstrate how to secure semantic models, tune performance, and deploy robust BI solutions effectively. This course is designed for BI developers, data engineers, and IT professionals seeking to elevate their skills in Power BI and Microsoft Fabric. A working knowledge of Power BI and basic data modeling is recommended. This course is part two of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. If you haven't already explored part 1, then learners are encouraged to complete that course before starting this one.

This module introduces the architecture and core components of Microsoft Fabric, highlighting its integration with Power BI and data storage solutions like Lakehouse and Data Warehouse. Learners will explore how semantic models are automatically generated and how to build them using Direct Lake connectivity. By the end, you'll understand how Fabric supports modern data analytics workflows.

What's included

1 video6 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

6 readingsTotal 30 minutes

Introduction7 minutes
Reviewing the Fabric Architecture5 minutes
Exploring Lakehouse and Data Warehouse4 minutes
Data Warehouse Overview3 minutes
Default Semantic Model5 minutes
Building a Semantic Model in Direct Lake Mode6 minutes

1 assignmentTotal 12 minutes

Microsoft Fabric Data Architecture and Performance12 minutes

This module explores various methods for refreshing semantic models in Power BI, including full and incremental refresh strategies. Learners will gain hands-on experience using XMLA endpoints and decision trees to select the most efficient refresh approach for different scenarios. Practical guidance is provided for managing large datasets and optimizing refresh operations.

What's included

1 video5 readings1 assignment

This module guides learners through essential techniques for optimizing Power BI semantic models, including best practices for column and relationship design. Learners will explore powerful tools like VertiPaq Analyzer, Tabular Editor, and Performance Analyzer to diagnose and enhance report performance. Practical strategies for connector selection, streaming operations, and DAX optimization are also covered to ensure efficient and responsive Power BI solutions.

What's included

1 video8 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

8 readingsTotal 61 minutes

Introduction8 minutes
Semantic Model Optimization Best Practices11 minutes
Semantic Model Optimization Using VertiPaq Analyzer5 minutes
Using Tabular Editor Best Practice Analyzer to Optimize Semantic Models7 minutes
Performing Streaming Operations First8 minutes
Picking the Right Connector12 minutes
Using Performance Analyzer for Optimization3 minutes
DAX Optimization7 minutes

1 assignmentTotal 16 minutes

Mastering Performance Enhancements in Power BI16 minutes

This module explores essential strategies for securing semantic models in Power BI, focusing on user access control and data residency considerations. Learners will gain practical knowledge on configuring security settings and understanding how data storage locations impact compliance and governance.

What's included

1 video2 readings1 assignment

This module guides learners through the process of deploying Power BI solutions, including the use of deployment pipelines and Git integration for streamlined change management. Participants will explore best practices for report development, environment management, and leveraging Azure DevOps for version control. By the end, learners will be equipped to efficiently publish and manage Power BI artifacts in organizational settings.

What's included

1 video6 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

6 readingsTotal 27 minutes

Introduction5 minutes
Understanding Deployment Pipelines4 minutes
Deployment Process Using Deployment Pipelines5 minutes
Report Development4 minutes
How to Configure Git Integration4 minutes
Understanding the Advantages of Git Integration5 minutes

1 assignmentTotal 16 minutes

Power BI Deployment Fundamentals16 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Packt - Course Instructors

Packt

1,893 Courses524,225 learners

Offered by

Packt

Explore more from Data Analysis

Microsoft
Advanced Analytics & AI Optimization with Microsoft Fabric
Course
Whizlabs
Microsoft Fabric: Monitor and Optimize an Analytics Solution
Course
Packt
Microsoft Fabric: Fundamentals and Power BI Workflow
Course
Packt
Architecting Power BI Solutions in Microsoft Fabric
Specialization

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

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.