Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level
Original price was: $48.99.$39.19Current price is: $39.19.
Price: [price_with_discount]
(as of [price_update_date] – Details)
[ad_1]
Discover the true power of DAX and build advanced DAX solutions for practical business scenarios
Key Features:
Solve complex business problems within Microsoft BI tools including Power BI, SQL Server, and ExcelDevelop a conceptual understanding of critical business data modeling principlesLearn the subtleties of Power BI data visualizations, evaluation context, context transition, and filtering
Book Description:
This book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools.
Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you’ll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations.
You’ll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You’ll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time.
What You Will Learn:
Understand data modeling concepts and structures before you start working with DAXGrasp how relationships in Power BI models are different from those in RDBMSesSecure aggregation levels, attributes, and hierarchies using PATH functions and row-level securityGet to grips with the crucial concept of contextApply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZEExplore dynamically changing visualizations with helper tables and dynamic labels and axesWork with week-based calendars and understand standard time-intelligenceEvaluate investments intelligently with the XNPV and XIRR financial DAX functions
Who this book is for:
Extreme DAX is written for analysts with a working knowledge of DAX in Power BI or other Microsoft analytics tools. It will help you upgrade your knowledge and work with analytical models more effectively, so you’ll need practical experience with DAX before you can get started.
From the brand
Packt is a leading publisher of technical learning content with the ability to publish books on emerging tech faster than any other.
Our mission is to increase the shared value of deep tech knowledge by helping tech pros put software to work.
We help the most interesting minds and ground-breaking creators on the planet distill and share the working knowledge of their peers.
See Our Full Range
Power BI
PostgreSQL and Tableau
See Our Full Range
Publisher : Packt Publishing (January 20, 2022)
Language : English
Paperback : 470 pages
ISBN-10 : 1801078513
ISBN-13 : 978-1801078511
Item Weight : 1.78 pounds
Dimensions : 9.25 x 7.52 x 0.95 inches
[ad_2]
9 reviews for Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level
Add a review
Related Products
Brian –
Excellent resource even for those of us with 5 plus years of Power BI experience
Books, rather than videos, have long been my preference for learning.Of the several DAX books I possess, Extreme DAX and DAX Patterns are the two I reference most.Extreme DAX is exceptionally well written. This is crucial when the Authors detail the topic which confounds most of us who first learned DAX: row and filter context. They expand on this topic to include query context.Before delving into ‘context’, they detail Power BI best practices including model design, calculated columns, and measures using the CALCULATE() function.Over the past several months since purchasing this book, I’ve adopted many of their best practices recommendations. Doing so has increased my level of confidence when taking on new Power BI work assignments especially those which do not align, design-wise, with my prior experience.
AE –
Challenging book
“Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level” by Michiel Rozema and Henk Vlootman is a valuable resource for anyone looking to deepen their understanding of Data Analysis Expressions (DAX) in Power BI. The authors do an excellent job of breaking down complex concepts into digestible sections, making the powerful features of DAX accessible even to those new to Power BI. The book is well-structured, guiding readers through a variety of practical business scenarios that can be tackled with Microsoft BI tools, including Power BI, SQL Server, and Excel.One of the key strengths of this book is its hands-on approach, with numerous examples and exercises that encourage active learning. Rozema and Vlootman’s expertise shines through as they explore advanced solutions for real-world data challenges, without sacrificing clarity. Whether you are a business professional seeking to leverage data more effectively, or a data analyst looking to enhance your technical toolkit, “Extreme DAX” offers a comprehensive guide that promises to elevate your analytical capabilities to a new level.
michael mitchell –
Extreme DAX for SSAS, Power BI, & Power Pivot Usera
I loved the book covered everything I use on a daily basis as a Power BI Developer/ SSAS Tabular Model user. Extreme DAX gives the user a brief overview of all the places the Users can use DAX, and then it dives into some important DAX principles like columnar data storage, context transition, data modeling, and filter direction. I a brief overview of fact and dimension tables and relational database theory before delving into the DAX language.The author also taught the basics of DAX. I am enjoyed reading about the theory even though I watched over 100 videos of learning DAX like how to create calculated columns with row context and measures with filtered context, and DAX Queries utilization in tools like Power BI Report Server. I also like the sections on ALL & Keepfilter and Remove filter. The most important chapter was Table Functions & Iterators because most of the tables in DAX Queries in our models utilize both of them. The book also covered Row Level Security and other advanced DAX properties, however, most of my daily learning for my job consisted of the first half of the book. While the second half of the book, I only utilize the advanced elements 20% of the time in my daily work. I would add this book if you are learning DAX or using it daily on your job. I didn’t like the book didn’t offer a video to compliment this awesome material.
Hotcha –
Rozema, Michiel
At first, I thought, WTH? BUT, AS I continued to read. the book made less and less sense, then suddenly it all clicked together! I felt sorry for Dax as it appeared that he lived in an unstable home, and he started to hallucinated both night and day with seeing monsters. His school principal he thought was an Ogre!! With his missing dad he was frantic to find him and he went through some weird changes. I can’t say that I want to continued Dax’s story as I do not think that my heart can take it.
Darwin Marrero –
Great for New and Experienced Users
Extreme DAX would have been nice to have years ago when I was first learning DAX and Power BI. Itdoes a fine job of refreshing the user of best practices and designs in the early chapters before diving into advanced topics. I would highly recommend it to new and experienced Power BI Users. I can definitely say the topics in this book are relevant and are used in my current day-to-day work environment as a Power BI Analyst. Everything from designing the perfect data model, setting up dynamic RLS security, utilizing the proper filter context, and performing calculation based on time intelligence formulas. Though, I don’t necessarily agree it’s best practice to create a calendar table in Power BI, it can be good to know if you have no other option.By far, the business case section is the most valuable component to this book. The finance formulas and the convention in which they were utilized were very informative. I definitely learned a couple of new tricks from this section.All in all, Extreme DAX is easy to understand and a great book to reference.
Mark –
Putting Power BI and DAX into perspective
Extreme DAX is the perspective of two well experienced and respected Power BI experts who have been consulting in the field for a long time. The book focuses on best practices for Power BI modeling and how the power of DAX can best be utilized. As such, the book is ideally for those who have some experience with Power BI and DAX.I like how the authors start out discussing where and how Power BI and DAX fits into modern business intelligence solutions. In my own experience in the field, I have in some cases used too much DAX and other cases not enough. This is where I found the first few chapters to be very useful in helping me understand how to strike a good balance while maintain best practices.Before touching on any DAX coding, Henk and Michiel tackle the topic of effective model design and some of the typical challenges that tend to come up in Power BI data modeling. I found it to be very refreshing that they decided to deal with such an important part of building effective reports in Power BI.
Kais –
Extreme DAX, reveals the full potential of the DAX language’s features, and it’s an exhilarating journey. I’m looking forward to the second edition, which will certainly bring additional tools, such as ðð¶ð²ð¹ð±ð ð½ð®ð¿ð®ðºð²ðð²ð¿ð, that promise to extend the Scope of DAX even further. This is an absolute essential resource for BI Developers && BI Analysts, enabling the use of advanced DAX techniques to perform in-depth data analysis.
Márcio Monteiro –
Excelente livro, para quem está estudando sobre Power esse livro e muito top..
Amazon Customer –
The section on Row Level Security paid for the whole book.