Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Power BI Performance Best Practices

You're reading from   Microsoft Power BI Performance Best Practices Learn practical techniques for building high-speed Power BI solutions

Arrow left icon
Product type Paperback
Published in Aug 2024
Publisher Packt
ISBN-13 9781835082256
Length 346 pages
Edition 2nd Edition
Languages
Tools
Arrow right icon
Authors (2):
Arrow left icon
Thomas LeBlanc Thomas LeBlanc
Author Profile Icon Thomas LeBlanc
Thomas LeBlanc
Bhavik Merchant Bhavik Merchant
Author Profile Icon Bhavik Merchant
Bhavik Merchant
Arrow right icon
View More author details
Toc

Table of Contents (23) Chapters Close

Preface 1. Part 1: Architecture, Bottlenecks, and Performance Targets
2. Chapter 1: Setting Targets and Identifying Problem Areas FREE CHAPTER 3. Chapter 2: Exploring Power BI Architecture and Configuration 4. Chapter 3: Learning the Tools for Performance Tuning 5. Part 2: Performance Analysis, Improvement, and Management
6. Chapter 4: Analyzing Logs and Metrics 7. Chapter 5: Optimization for Storage Modes 8. Chapter 6: Third-Party Utilities 9. Chapter 7: Performance Governance Framework 10. Part 3: Fetching, Transforming, and Visualizing Data
11. Chapter 8: Loading, Transforming, and Refreshing Data 12. Chapter 9: Report and Dashboard Design 13. Part 4: Data Models, Calculations, and Large Semantic Models
14. Chapter 10: Dimensional Modeling and Row Level Security 15. Chapter 11: Improving DAX 16. Chapter 12: High Scale Patterns 17. Part 5: Optimizing Capacities in Power BI Enterprises
18. Chapter 13: Working with Capacities 19. Chapter 14: Performance Needs for Fabric Artifacts 20. Chapter 15: Embedding in Web Apps 21. Index 22. Other Books You May Enjoy

Knowledge sharing and awareness

In the previous section, we talked about the importance of being pro-active about performance management. Since there are many areas to cover, some being quite technical, we need to have the right level of complexity and relevance for the audience. We will introduce these groups in general and then summarize with role-specific advice.

Helping self-service users

One of Power BI’s greatest strengths is its approachability and ease of use for non-technical users or analysts who are not professional BI developers. The drawback of this is that lack of knowledge can lead to poorly optimized solutions. We recommend using the guidance in later chapters to create the following:

  • Report design guide: This will incorporate style, theme, and design choices to avoid. These can even be supplied as a Power BI template file.
  • Data modeling and loading guide: This will have common guidance, such as the basics of dimensional modeling, relationship...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image