Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) - Softcover
Synopsis
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
"synopsis" may belong to another edition of this title.
About the Author
Marco Russo and Alberto Ferrari cofounded sqlbi.com, where they regularly publish articles about Microsoft PowerPivot, DAX, Power BI, and SQL Server Analysis Services. They also speak regularly at major international conferences, such as TechEd, Ignite, PASS Summit, and SQLBits. Both consult and mentor on business intelligence (BI) and Microsoft BI technologies, having worked with them since 1999. Their books include Microsoft Excel 2013 Building Data Models with PowerPivot, Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning.
"About this title" may belong to another edition of this title.
Search results for Definitive Guide to DAX, The: Business intelligence...
Seller Image
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
Seller: Zoom Books East, Glendale Heights, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: acceptable. Book is in acceptable condition and shows signs of wear. Book may also include underlining highlighting. The book can also include "From the library of" labels. May not contain miscellaneous items toys, dvds, etc. . We offer 100% money back guarantee and 24 7 customer service. Seller Inventory # ZEV.073569835X.A
Stock Image
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00097417317
Stock Image
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00098652828
Stock Image
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
Seller: Evergreen Goodwill, Seattle, WA, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Good. Seller Inventory # mon0000260007
Stock Image
The Definitive Guide to Dax: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power Bi
Seller: ThriftBooks-Reno, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G073569835XI4N00
Stock Image
The Definitive Guide to Dax: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power Bi
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G073569835XI4N00
Stock Image
The Definitive Guide to Dax: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power Bi
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G073569835XI4N00
Stock Image
The Definitive Guide to Dax: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power Bi
Seller: ThriftBooks-Phoenix, Phoenix, AZ, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G073569835XI4N00
Seller Image
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
Seller: Goodwill of Colorado, COLORADO SPRINGS, CO, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. All pages and cover are intact. Dust jacket included if applicable, though it may be missing on hardcover editions. Spine and cover may show minor signs of wear including scuff marks, curls or bends to corners as well as cosmetic blemishes including stickers. Pages may contain limited notes or highlighting. "From the library of" labels may be present. Shrink wrap, dust covers, or boxed set packaging may be missing. Bundled media e.g., CDs, DVDs, access codes may not be included. Seller Inventory # 466ROY001N7N
Stock Image
The Definitive Guide to DAX : Business Intelligence for SQL Server Analysis Services and Excel
Seller: Better World Books: West, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Used book that is in clean, average condition without any missing pages. Seller Inventory # 12940965-6