The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Original price was: $59.99.$30.22Current price is: $30.22.
Price: [price_with_discount]
(as of [price_update_date] – Details)
[ad_1]
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX’s remarkable capabilities? This no-compromise “deep dive” is exactly what you need.
Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel
· Master core DAX concepts, including calculated columns, measures, and calculation groups
· Work efficiently with basic and advanced table functions
· Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions
· Perform time-based calculations
· Use calculation groups and calculation items
· Use syntax of variables (VAR) to write more readable, maintainable code
· Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters
· Master advanced optimization techniques, and improve performance in aggregations
· Optimize data models to achieve better compression
· Measure DAX query performance with DAX Studio and learn how to optimize your DAX
Publisher : Microsoft Press; 2nd edition (July 2, 2019)
Language : English
Paperback : 768 pages
ISBN-10 : 1509306978
ISBN-13 : 978-1509306978
Item Weight : 2.77 pounds
Dimensions : 7.38 x 1.52 x 9.1 inches
[ad_2]
13 reviews for The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Add a review
Related Products
Ammar S. –
Excellent Book
This book is really helpful in breaking down the complexity of each function into clear explanations & examples. Thank you so much for the authors. I’m really happy with my purchase
Robert Wolf –
Amazing Book
I have been reading this book for 5 months. I am not finished. I spend a half hour every day. Marco Russo and Alberto Ferrari are teachers and very good ones. There is so much effort put into this book it feels like they actually care about you and your DAX journey. I have gotten so much out of this book. Though I can’t say that I truly understand it. Yet I see that my DAX has improved quite a bit. With many mysteries still remaining. I am just an average person trying to be a bit above average and I thank the authors for helping me in my quest. I highly recommend this book. Though if I were starting off from scratch I would read Matt Allington’s book Supercharge Power BI and possibly Power Pivot and Power BI by Rob Collie and Avichal Singh though that book is a bit older. In summation: my lack of understanding is my issue, the book itself is extremely comprehensive and well written. So I will continue on my DAX journey and hopefully will continue to improve as I make my way through the final 3rd of the book.
Horacio –
Review
Excellent
Amazon Customer –
Damaged binding
Great book content-wise, but I bought it new and the binding is damaged, corners are bent, and some pages are creased. Should have just purchased a used copy.
Anonymous –
The most holy text of the DAX religion…
Reading this book makes me realize how little I know about the things I thought I knew. I’ve been writing DAX for years, having started with PowerPivot (no spaces in the name, that’s how old) for Excel 2010, and in my job I still find new, interesting problems to solve. This book is an amazing reference for anyone interested in pushing the calculation envelope in DAX and their models. I’ve built models spanning billions of records with the expert guidance this book provides.I would almost consider this a holy book of the DAX religion. If you ever wanted someone to explain why god created CALCULATE() and how we should observe it daily in our lives, this is the book, and the Italians preach adeptly. I’m a big believer, and you will be too.
Sarah Elrays –
Excellent Resource!
I love this book! The authors know their audience. It’s written in such a way that the reader feels as though they’re being taught by instructors. They give helpful learning tips along the way and know when a certain topic is especially difficult. For example, at the end of a certain arduous chapter, the conclusion starts, “In this final section of a long and difficult chapter…”Upon completion, it is easy to go back and use as a guide for specific topics as they arise.
Excelente material, su contenido muy valioso –
Contenido
Lo utilizo como medio de aprendizaje y actualización
S. Bellomo –
Now I really know what’s happening under the hood
This was a really important book for my understanding of Dax formulas. I watched a lot of videos online, and forums can often give you formulas that will solve your problem but I never fully understood what was happening.I feel very confident now after reading this book. I can visualize what is happening with my model and it has made writing Dax much easier. I’m not saying that I’m an expert or that it’s easy now, but I know how it works and the functions that are available to me. If you really want to know what’s happening, this is the book for you.
José Vanderlei M dos Santos –
Este livro me serve de referência e de um bom guia na assimilação da linguagem aplicada.
Cliente Amazon –
El libro es realmente extraordinario. Aunque lemamentablemente no hay versión em castellano, me decidà a comprarlo por las recomendaciones. El inglés es muy claro y se lee muy bien. Las explicaciones son precisas y fáciles de entender a pesar de la complejidad del lenguaje. Muy buena inversión.
Cliente Amazon –
Top
Ram –
Definitely much needed guide to swim through dax.
Client d’Amazon –
Une vraie somme de savoir. Comme le disent les auteurs, il faudra le lire plusieurs fois (et je n’ai pas fini lecture No 1)C’est néanmoins didactique : le livre avance pas à pas (et c’est vrai parfois à grands pas). A mon avis indispensable si on veut comprendre (voire maîtriser) DAX