The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
- ISBN-10
- 0735698376
- ISBN-13
- 9780735698376
- Category
- Computers
- Pages
- 592
- Language
- English
- Published
- 2015-10-14
- Publisher
- Microsoft Press
- Authors
- Marco Russo, Alberto Ferrari
Description
This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading 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, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio
Get the book
Other editions
-
- 2019-07-02
- 1885 pages
- Ebook
- Microsoft Press
Similar books
-
Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
By Philip SeamarkWhat You’ll Learn Turbocharge your Power BI model by adding advanced DAX programming techniques Know when to use calculated measures versus calculated columns Generate new tables on the fly from existing data Optimize, monitor, and tune ...
-
DAX Patterns: Second Edition
By Marco Russo, Alberto FerrariThis book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.
-
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
By Miguel Escobar, Ken PulsThis book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.
-
Analyzing Data with Power BI and Power Pivot for Excel
By Marco Russo, Alberto FerrariBy reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the ...
-
Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular
By Philip Seamark, Thomas MartensThis book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft’s leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Server Analysis ...
-
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
By Gil RavivPower Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it.
-
DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence
By Greg DecklerBy the end of this book, you'll have the skills you need to use DAX's functionality and flexibility in business intelligence and data analytics.
-
The Definitive Guide to DAX: Business Intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
By Marco Russo, Alberto FerrariNow 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.
-
Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence
By Brett PowellDesign, create and manage robust Power BI solutions to gain meaningful business insights Key Features Master all the dashboarding and reporting features of Microsoft Power BI Combine data from multiple sources, create stunning ...
-
DAX Patterns: Second Edition
By Marco Russo, Alberto FerrariThis book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.