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
Original price was: $59.99.$47.99Current price is: $47.99.
Price: [price_with_discount]
(as of [price_update_date] – Details)
[ad_1]
Take your Power BI reports to the next level by learning various data modeling techniques and leveraging the latest features of Power BI effectively
Purchase of the print or Kindle book includes a free eBook in PDF format.
Key Features:
Get an understanding of data modeling techniques using Power BI with this up-to-date guideLearn how to define the relationships between data sets to extract valuable insightsExplore best practices for data preparation and modeling and build optimal data models to solve a wide variety of real-world business challenges
Book 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.
What You Will Learn:
Implement virtual tables and time intelligence functionalities in DAX to build a powerful modelIdentify Dimension and Fact tables and implement them in Power Query EditorDeal with advanced data preparation scenarios while building Star SchemaDiscover different hierarchies and their common pitfallsUnderstand complex data models and how to decrease the level of model complexity with different approachesLearn advanced data modeling techniques such as calculation groups, aggregations, incremental refresh, RLS/OLS, and moreGet well-versed with datamarts and dataflows in PowerBI
Who this book is 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.
Publisher : Packt Publishing; 2nd ed. edition (April 28, 2023)
Language : English
Paperback : 698 pages
ISBN-10 : 1803246243
ISBN-13 : 978-1803246246
Item Weight : 2.64 pounds
Dimensions : 9.25 x 7.52 x 1.4 inches
[ad_2]
11 reviews for 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
Add a review
Related Products
Learn Power BI – Second Edition: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence
Practical Splunk Search Processing Language: A Guide for Mastering SPL Commands for Maximum Efficiency and Outcome
Microsoft Power BI Dashboards Step by Step
George Squillace –
A worthwhile purchase!
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.
Brian Julius, Power BI Expert and Instructor –
The best book on Data Modeling for Power BI users is now updated and improved…
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.
ALY –
Expert Data Modeling with Power BI
This book is complex but I have joined the authors group and plan to see what I can learn from the experts.
AmazonFanZach –
Great Book on Power BI Data Modeling
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.
Armando Lacerda –
More about Power BI than data modeling
I recommend this book for the hands on exercises and thoughtful full tips on getting the data working fast for you on the Power BI platform. It is not for beginner, though.The reading is good. The topic is one I use and consider myself an SME on.The book feels a bit diffused and sometimes out of order, which makes the reading confusing for most people, in my opinion. Give it some paciense and you will learn a ton.
AE –
Hidden Gems
I have been using Power BI for close to three years on a daily basis and still found several hidden gems in this book. Highly recommend!
Kais –
This book is a real game-changer for anyone working with Power BI and in the field of data analysis, As, it focuses on data modeling and best practices, breaking down complex concepts into easily understandable elements. Soheil’s passion and expertise shine through on every page, making this an invaluable resource for mastering data modeling. The real-world examples and advice shared are pure gold from designing effective models to mastering DAX. This book covers it all, and Iâm keen to put it in action.
Sarabjit –
 Book content is very good very useful,Book binding is perfectDelevery is on time,
enrique –
No veo que sea un libro que sirva para iniciarse en power bi como dice el libro. Si sabes de la materia puede ayudar a ordenar y aclarar ideas. Además explica el porqué de las cosas. En definitiva, para usuarios medios
Peter van den Bos –
In my profession as a business intelligence consultant, I mainly focus on performance improvements in Power BI. In 80-90% of cases, performance problems stem from a ‘wrongly’ set up data model. Unfortunately, adjusting a data model later is a big job and often takes a lot of time. So it’s better to get it right at the start. This will save you a lot of time, costs and user annoyance.The book is written for data analysts, business analysts and BI professionals with basic knowledge of Power BI and issues around data modeling. Still, the book gives a concise summary of how data modeling should be set up. For in-depth knowledge, other valuable books have been written, such as Ralph Kimball’s ‘Data Warehouse Toolkit’. Also, the book fleetingly covers only the essentials for data modeling in terms of DAX (data analysis expressions). For in-depth coverage, I can recommend the book ‘Definitive Guide to DAX’ by the gurus in this field: Alberto Ferrari and Marco Russo.It is quite an art to describe only the basics and necessities of two complex techniques, namely data modeling and DAX. The reader is taken step by step through the process of getting from the source data to the final data model. The author covers how the data is loaded, right up to actually shaping the data into a table, be it a fact or dimension table in Power Query. The book covers many interesting concepts in the areas of RLS, many-to-many calculations groups and SCD.The book provides great insights, informs you on how best to set up a data model and offers examples of best practices to ponder. It is valuable not only for the novice developer, but also for the experienced developer. Highly recommended!
nikot.23 –
This should be labeled as essential reading for powerbi professionals. It goes through all stages of report development with examples and detailed analysis. You can easily go through the book to find some references on specific topics.That said, the “expert” part of the title might be a little bit misleading, as there are no specific insights for real life scenarios of advanced complex cases.