Data modeling is one the most crucial parts of Power BI which is usually undermined, misunderstood or completely ignored by many developers. The consequence is having unnecessarily large models, complex DAX code, and underperforming reports. In some cases, poorly designed data models incur surplus cost to organisations. The reports are so slow that the organizations decide to get more process power by buying Power BI Premium or upgrading their existing Premium license to higher and more expensive tiers, while all those costs could be potentially avoided by having better designed data models. What makes Expert Data Modeling with Power BI different from other books on data modeling with Power BI? The main focus of other books is to teach readers how to write DAX or resolve complex scenarios with DAX in the data model layer itself. With this book, I’ve focused on explaining the importance of data preparation as well as writing better DAX expressions. I want to help readers mitigate the risks associated with writing complex DAX expressions and take care of the heavy lifting in the data preparation layer within the Power Query Editor. You’ll also discover many best practices in Power Query, data modeling and DAX that will be useful. I’d also recommend this book if you’ve been looking for something that covers all the new features of Power BI, which are missing in other books such as object-level security, calculation groups, and composite models. How has your background and experience helped you to write this book? I come from a programming background with extensive experience in database design and implementation. Throughout my career, I’ve worked with relational data models - and Power BI is no different. Power BI also follows relational data modeling. To be able to design and implement a well-performing report, you also need to have a well-designed data model with the Star Schema approach. Having a concrete background in designing and implementing relational databases with Star Schema helped me significantly in writing this book. What are your favorite parts in the book and why? Data Preparation in Power Query Editor: I love this chapter as it explains the importance of data preparation while having Star Schema and data modeling in mind. It is super important to get the data preparation right which leads to having a well-designed data model that is clear, less complex and makes it easier to deal with the required DAX expression.Advanced Data Modeling Techniques: This chapter provides invaluable techniques for more advanced users working on enterprise-grade projects by explaining aggregations, incremental data loading, parent-child hierarchies, and more. Without knowledge of the techniques explained in this chapter, you won’t be able to support large models in an enterprise.Extra Features for Data Modeling: This chapter is great because it explains new features in Power BI which are either revolutionary, such as composite models, or are helpful in decreasing development effort and taking the user experience to the next level such as calculation groups.
✔ Author(s): Soheil Bakhshi,Christian Wade
✔ Title: Expert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs
✔ Rating : 4.9 out of 5 base on (57 reviews)
✔ ISBN-10: 1800205694
✔ Language: English
✔ Format ebook: PDF, EPUB, Kindle, Audio, HTML and MOBI
✔ Device compatibles: Android, iOS, PC and Amazon Kindle
Readers' opinions about Expert Data Modeling with Power BI by Soheil Bakhshi
Naomi Bates
Experience the inspiring journey of an individual overcoming incredible odds in this powerful memoir. The author's candid and heartfelt writing brings their story to life. Each chapter reveals the resilience and strength of the human spirit. The narrative is both informative and deeply moving, offering valuable life lessons. It's a story that motivates and inspires, making it a must-read. Perfect for those seeking inspiration and personal growth.
Gipsy Herbert
Experience the thrill of a heist gone wrong in this fast-paced crime novel. The author's detailed plotting and dynamic characters create a compelling narrative. Each twist and turn in the story keeps you hooked from start to finish. The tension and suspense build with each chapter, making it a page-turner. It's an exhilarating read that captures the essence of high-stakes crime. Perfect for fans of heist stories and thrillers.
Leeann Little
Delve into a richly detailed fantasy world where magic and mystery abound. The author's imaginative world-building and captivating plot draw you in from the start. Each character's journey is thrilling and their development is relatable. The narrative is filled with enchanting elements that keep you hooked. It's a story that sparks the imagination and transports you to another realm. Perfect for fans of epic fantasy.
