What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

Get an understanding of data modeling techniques using Power BI with this up-to-date guide

Learn how to define the relationships between data sets to extract valuable insights

Explore best practices for data preparation and modeling and build optimal data models to solve a wide variety of real-world business challenges

Description

This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create full-fledged data models using Power BI confidently. In this new, fully updated edition, you'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models to gain deep and detailed insights about your organization. As you advance through the chapters, the book will demonstrate how to prepare efficient data models in the Power Query Editor and use simpler DAX code with new data modeling features. You'll explore how to use the various data modeling and navigation techniques and perform custom calculations using the modeling features with the help of real-world examples. Finally, you'll learn how to use some new and advanced modeling features to enhance your data models to carry out a wide variety of complex tasks. Additionally, you'll learn valuable best practices and explore common data modeling complications and the solutions to supercharge the process of creating a data model in Power BI and build better-performing data models. By the end of this Power BI book, you'll have gained the skills you need to structure data coming from multiple sources in different ways to create optimized data models that support high-performing reports and data analytics.

Who is this book for?

This MS Power BI book is for BI users, data analysts, and analysis developers who want to become well-versed with data modeling techniques to make the most of Power BI. Basic working knowledge of Power BI and the Star Schema functionality are required to help you to understand the concepts covered in this book.

What you will learn

Implement virtual tables and time intelligence functionalities in DAX to build a powerful model

Identify Dimension and Fact tables and implement them in Power Query Editor

Deal with advanced data preparation scenarios while building Star Schema

Discover different hierarchies and their common pitfalls

Understand complex data models and how to decrease the level of model complexity with different approaches

Learn advanced data modeling techniques such as calculation groups, aggregations, incremental refresh, RLS/OLS, and more

Get well-versed with datamarts and dataflows in PowerBI

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

Mastering Microsoft Power BI – Second Edition

NZ$73.99

NZ$71.99

Expert Data Modeling with Power BI, Second Edition

NZ$87.99

Total NZ$ 233.97

Brian Julius, Power BI Expert and Instructor Jun 02, 2023

If you want to build top-quality, high-performing Power BI reports, the make-or-break aspect will be whether you get your data model right.Ever since the first edition of MS MVP Soheil Bakhshi's book came out two years ago, it has been at the top of my list of recommended data modeling books:My only quibble with this book is the title, which might lead you to believe that that it is primarily for expert/advanced users. While the book skillfully addresses advanced topics, it is also the only book I've seen on this topic suitable for beginning Power BI users as well. At over 650 pages, this is an extensive resource that you can grow with as your Power BI knowledge expands over time.Soheil starts with an outstanding introduction to data modeling in Power BI - explaining in clear, concise language with multiple illustrations why the data model is so fundamental to Power BI, and addressing key concepts, such as star schema and denormalization.One of my favorite things about this book is the excellent balance of theory and practice. Soheil does a great job explaining the broader "whys" of data modeling best practices, but also shows you in step-by-step detail the "hows" of implementing these approaches in your own reports - covering the necessary DAX, Power Query and Power BI techniques with excellent clarity.As good as the first edition was, this new second edition is substantially improved, since it addresses in detail the advances in Power BI related to data modeling implemented over the last two years, including:🔸 Composite Models🔸 Enabling Direct Query for live connections🔸 Field Parameters🔸 Datamarts🔸 EVALUATEANDLOG for debugging🔸 The new family of DAX WINDOW functionsWhatever your current level of skill with data modeling is, I believe you will find much to learn from in this book.

Amazon Verified review

George Squillace Nov 19, 2023

I found the first edition of “Expert Data Modeling with Power BI” so valuable I had to buy the second edition when it became available. Even as an experienced Power BI developer I would often bring the book with me to lunch and enjoy reading, highlighting and underlining in it.There were several things I liked about the first edition. First, I liked the fact that the book was written by a consultant that had worked in a variety of situations, and, brought his real-world expertise that he gained to the pages. Second, I liked how thorough the book was, that it covered all aspects of data modeling (data acquisition, data prep, star schema, and advanced data modeling techniques) and was a useful resource for the beginner who could grow into the book, but useful for the experienced dev also.I even found the “Introduction” chapter valuable, but having a good amount of experience when I bought the first edition it was the “Advanced Modeling” techniques that I was most interested in.The second edition, as expected, adds more content, reflecting the many additions to the Power BI product since the first edition. I like the smaller font and the graphic design updates although I liked the first edition graphic design also. The screenshots look better in the second edition and it appears that some screenshots were replaced with actual diagrams to make the content clearer, which I like.I do have a few suggestions for a future revision. In the “Data from Various Sources” section I would love to see one or more examples connecting via an API, perhaps one simple example, and one more complex example. Something else I would find valuable, which the author invariably has run into, is a case study looking at a tangled data model design (bidirectional cross filtering, many to many relationships,…), and then a proposed redesign.In summary, I’m glad I have the second edition of the book and will have to find a willing recipient of my first edition copy that won’t mind my crazy highlighting and underlining.

Amazon Verified review

P. Laws May 05, 2023

This book has a massive breadth of knowledge, it's well structured and clearly explained.It focusses on the most important part of the design and build process which is a well built data model and efficicent data transformations.It takes you through from broad concepts right through to technical implementation.The chapters are well written with objectives set out at the beginning, well written instructions and clear screenshots and a wrap up summary at the end and caters for beginners and advanced users.

Amazon Verified review

AmazonFanZach Dec 04, 2023

Brian Julias recommended this book, and even though I've been using the product for years, I still found really good content within. I recommend for architects and anyone who's building semantic models with Power BI.

Amazon Verified review

Morph360Tech Apr 17, 2023

The book gives you all the expertise you need to have an effectively streamlined way of working and any skills you need when you work with data and perform reporting. This does an incredible job at detailing not only all the step by step screen shots involved in data modelling but also the concepts and how they can be implemented in the real world. The imagery offers an immersive insight into concepts, which makes it easier to understand techniques and visualise how things work with clarity. I will recommend this Power BI book for anyone who wants to use the tool more confidently and gain value from it. This will equip you with data modelling skills, it also makes for an engaging read to push your understanding of PowerBI forward.

Amazon Verified review

Expert Data Modeling with Power BI, Second Edition: Enrich and optimize your data models to get the best out of Power BI for reporting and business needs , Second Edition

What do you get with eBook?