Expert Data Modeling with Power BI - Second Edition

The media could not be loaded. Book content is very good very useful,Book binding is perfectDelevery is on time,

Anyone looking to improve their data modelling abilities with Power BI should check out "Expert Data Modelling with Power Bi." The book offers a thorough manual for improving data models for improved reporting and business requirements. It is filled with useful examples and is appropriate for readers of every skill level, from beginners to specialists, in my opinion. However, I advise that you have at least a month of comfortable Power Bi working experience before buying this book.The book introduces users to new features, choices, and DAX functions while also covering subjects including security, sophisticated data modelling techniques, and data preparation. For data analysts who frequently use Power BI, it is a useful resource because it is well-structured and simple to understand.

I am yet to complete the entire book.So far I felt the contents are explained in simple English and with clear screenshot of the tools.This makes the book easy to understand for a fresher who has less hands on experience on the tools.This books also provides Github links where sample dataset is uploaded which is used in the book itself, so that reader can simultaneously work along with the chapters covered as they progress.Once I complete this book, will update my final review.

I must say this is an outstanding book for anyone looking to optimize their data models in Power BI. The author's expertise in data modeling shines through every chapter, providing practical techniques and best practices.The in-depth coverage of advanced topics like partitioning, aggregations, and composite models and the wide range of topics, including data modeling principles, relationship management, DAX calculations, and performance optimization really piqued my interest. Therefore, it's a must-have resource for anyone looking to maximize the potential of Power BI's data modeling capabilities. Highly recommended!

"Expert Data Modelling with Power Bi" is an incredible read.if you are someone looking for complete guide on Power BI or an Analysis Services model and do not know where to start, then I would say this book is a god starting point on the journey to mastering Power BI. All the concepts are introduced in a detailed manner with practical use cases.You’ll learn DAX expressions in depth to write robust code. It will lead you step-by-step through the process of developing an effective data modelling for power bi reporting.It covers modern best practices for building efficient data models, performance tuning approaches, Microsoft’s DAX language for business intelligence and analytics. Highly recommended for anyone working in data field and trying to learn data visualization and data modelling using Power BI.

I haven’t read much books related to Power BI but when I started reading this book, I felt more interesting and deep dive into data modeling. Excellent book for Power BI data professionals and also architects. Much recommended book.

Excellent powebi book but not for beginners and solely for more advanced or medium developers!! Kudos to Soheil for this masterpiece

"Expert Data Modelling with Power Bi" is an outstanding resource for anyone seeking to enhance their data modeling skills with Power BI. The book provides a comprehensive guide to optimizing data models for better reporting and business needs. I find It suitable for readers at every level, from beginners to experts, and is packed with practical examples. However I recommend that before goign for this book you have atleast a month of comfortable working experience with Power Bi.The book covers topics such as data preparation, advanced data modeling techniques, and security, as well as introducing readers to new options, features, and DAX functions. It's well-structured and easy to follow, making it an invaluable tool for data analysts who use Power BI regularly.I personally liked the data preparation section of the book. It covers how to connect various data sources and implement star schema in sufficient details. Advanced topics like RLS and DataFlows in sufficient detail.Overall, "Expert Data Modelling with Power Bi" is a must-read for anyone seeking to take their data modeling skills to the next level.

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.

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.

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

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!

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.