Microsoft Power BI Performance Best Practices
Learn practical techniques for building high-speed Power BI solutions
2nd Edition
Published on 23. August 2024
Book
Paperback/Softback
346 pages
978-1-83508-225-6 (ISBN)
Description
Maximize the effectiveness of your Power BI solutions through performance optimization and drive superior business outcomes
Key Features
Learn how to build performant data models and apply row-level security
Identify and fix performance issues in reports, DAX, and datasets using DAX Studio and VertiPaq Analyzer
Implement a formal process for performance management, from setting targets to monitoring and remediating issues
Purchase of the print or Kindle book includes a free PDF eBook
Book DescriptionIn a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging. Author Thomas LeBlanc, a seasoned Business Intelligence Architect with over 30 years of IT experience, draws on his extensive expertise to guide you in overcoming challenges related to slow performance, data modeling, query optimization, visualization design, deployment, administration, integration, compliance, and security.
This book covers topics ranging from architecture and data modeling to Power BI premium features, DAX formulas, and collaboration, helping you to gain a deep understanding of the Power BI architecture, design efficient data models, create efficient queries, and improve visualization performance. You'll also learn best practices to deploy and manage Power BI solutions, integrate with other tools and systems, ensure compliance and security, and collaborate with team members.
By the end of the book, you'll have developed your knowledge and skills to design, build, and maintain high-performing, scalable, and efficient Power BI solutions to drive unparalleled business success.What you will learn
Master setting realistic performance targets and proactively addressing performance challenges
Understand the impact of architectural choices and configurations on performance optimization
Develop streamlined Power BI reports and enhance data transformations for optimal efficiency
Explore best practices for data modeling, mastering DAX, and handling large datasets effectively
Gain insight into the intricate workings of Power BI Premium for enhanced performance
Harness the potential of Azure services for extreme scale data processing
Who this book is forIf you are a data analyst, BI developer, or a data professional who wants to maximize the performance of your Power BI solutions and understand how to build advanced analytics solutions, this book is for you. It assumes familiarity with the major components of Power BI and a beginner-level understanding of their purpose and use cases.
Key Features
Learn how to build performant data models and apply row-level security
Identify and fix performance issues in reports, DAX, and datasets using DAX Studio and VertiPaq Analyzer
Implement a formal process for performance management, from setting targets to monitoring and remediating issues
Purchase of the print or Kindle book includes a free PDF eBook
Book DescriptionIn a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging. Author Thomas LeBlanc, a seasoned Business Intelligence Architect with over 30 years of IT experience, draws on his extensive expertise to guide you in overcoming challenges related to slow performance, data modeling, query optimization, visualization design, deployment, administration, integration, compliance, and security.
This book covers topics ranging from architecture and data modeling to Power BI premium features, DAX formulas, and collaboration, helping you to gain a deep understanding of the Power BI architecture, design efficient data models, create efficient queries, and improve visualization performance. You'll also learn best practices to deploy and manage Power BI solutions, integrate with other tools and systems, ensure compliance and security, and collaborate with team members.
By the end of the book, you'll have developed your knowledge and skills to design, build, and maintain high-performing, scalable, and efficient Power BI solutions to drive unparalleled business success.What you will learn
Master setting realistic performance targets and proactively addressing performance challenges
Understand the impact of architectural choices and configurations on performance optimization
Develop streamlined Power BI reports and enhance data transformations for optimal efficiency
Explore best practices for data modeling, mastering DAX, and handling large datasets effectively
Gain insight into the intricate workings of Power BI Premium for enhanced performance
Harness the potential of Azure services for extreme scale data processing
Who this book is forIf you are a data analyst, BI developer, or a data professional who wants to maximize the performance of your Power BI solutions and understand how to build advanced analytics solutions, this book is for you. It assumes familiarity with the major components of Power BI and a beginner-level understanding of their purpose and use cases.
More details
Edition
2nd Revised edition
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Revised edition
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 19 mm
Weight
647 gr
ISBN-13
978-1-83508-225-6 (9781835082256)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Thomas Leblanc | Bhavik Merchant
Microsoft Power BI Performance Best Practices
Learn practical techniques for building high-speed Power BI solutions
E-Book
01/2025
2nd Edition
Packt Publishing
from
€26.99
Available for download
Persons
Thomas LeBlanc is a seasoned Business Intelligence Architect at Data on the Geaux, where he applies his extensive skillset in dimensional modeling, data visualization, and analytical modeling to deliver robust solutions. With a Bachelor of Science in Management Information Systems from Louisiana State University, Thomas has amassed over 30 years of experience in Information Technology, transitioning from roles as a software developer and database administrator to his current expertise in business intelligence and data warehouse architecture and management.
Throughout his career, Thomas has spearheaded numerous impactful projects, including consulting for various companies on Power BI implementation, serving as lead database administrator for a major home health care company, and overseeing the implementation of Power BI and Analysis Service for a large bank. He has also contributed his insights as an author to the Power BI MVP book.
Thomas is recognized as a Microsoft Data Platform MVP and is actively engaged in the tech community through his social media presence, notably as TheSmilinDBA on Twitter and ThePowerBIDude on Bluesky and Mastodon. With a passion for solving real-world business challenges with technology, Thomas continues to drive innovation in the field of business intelligence. Bhavik Merchant has nearly 18 years of deep experience in Business Intelligence. He is currently the Director of Product Analytics at Salesforce. Prior to that, he was at Microsoft, first as a Cloud Solution Architect and then as a Product Manager in the Power BI Engineering team. At Power BI, he led the customer-facing insights program, being responsible for the strategy and technical framework to deliver system-wide usage and performance insights to customers. Before Microsoft, Bhavik spent years managing high-caliber consulting teams delivering enterprise-scale BI projects. He has provided extensive technical and theoretical BI training over the years, including expert Power BI performance training he developed for top Microsoft Partners globally.
Throughout his career, Thomas has spearheaded numerous impactful projects, including consulting for various companies on Power BI implementation, serving as lead database administrator for a major home health care company, and overseeing the implementation of Power BI and Analysis Service for a large bank. He has also contributed his insights as an author to the Power BI MVP book.
Thomas is recognized as a Microsoft Data Platform MVP and is actively engaged in the tech community through his social media presence, notably as TheSmilinDBA on Twitter and ThePowerBIDude on Bluesky and Mastodon. With a passion for solving real-world business challenges with technology, Thomas continues to drive innovation in the field of business intelligence. Bhavik Merchant has nearly 18 years of deep experience in Business Intelligence. He is currently the Director of Product Analytics at Salesforce. Prior to that, he was at Microsoft, first as a Cloud Solution Architect and then as a Product Manager in the Power BI Engineering team. At Power BI, he led the customer-facing insights program, being responsible for the strategy and technical framework to deliver system-wide usage and performance insights to customers. Before Microsoft, Bhavik spent years managing high-caliber consulting teams delivering enterprise-scale BI projects. He has provided extensive technical and theoretical BI training over the years, including expert Power BI performance training he developed for top Microsoft Partners globally.
Content
Table of Contents
Setting Targets and Identifying Problem Areas
Exploring Power BI Architecture and Configuration
Learning the Tools for Performance Tuning
Analyzing Logs and Metrics
Optimization for Storage Modes
Third-Party Utilities
Performance Governance Framework
Loading, Transforming, and Refreshing Data
Report and Dashboard Design
Dimensional Modeling and Row-level Security
Improving DAX
High-Scale Patterns
Working with Capacities
Performance Needs for Fabric Artifacts
Embedding in Web Apps
Setting Targets and Identifying Problem Areas
Exploring Power BI Architecture and Configuration
Learning the Tools for Performance Tuning
Analyzing Logs and Metrics
Optimization for Storage Modes
Third-Party Utilities
Performance Governance Framework
Loading, Transforming, and Refreshing Data
Report and Dashboard Design
Dimensional Modeling and Row-level Security
Improving DAX
High-Scale Patterns
Working with Capacities
Performance Needs for Fabric Artifacts
Embedding in Web Apps