The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills)

4.5 avg rating
( 30 ratings by Goodreads )
 
9780735698352: The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills)

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.

Top Search Results from the AbeBooks Marketplace

1.

Russo, Marco; Ferrari, Alberto
ISBN 10: 073569835X ISBN 13: 9780735698352
New Quantity Available: 5
Seller
GreatBookPrices
(Columbia, MD, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # 22117186-n

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 30.82
Convert Currency

Add to Basket

Shipping: US$ 2.64
Within U.S.A.
Destination, Rates & Speeds

2.

Alberto Ferrari, Marco Russo
Published by Microsoft Press,U.S., United States (2015)
ISBN 10: 073569835X ISBN 13: 9780735698352
New Paperback Quantity Available: 10
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description Microsoft Press,U.S., United States, 2015. Paperback. Book Condition: New. Language: English . Brand New Book. 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. Bookseller Inventory # AAU9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.47
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Alberto Ferrari, Marco Russo
Published by Pearson Education 2015-10-13, Redmond (2015)
ISBN 10: 073569835X ISBN 13: 9780735698352
New paperback Quantity Available: > 20
Seller
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description Pearson Education 2015-10-13, Redmond, 2015. paperback. Book Condition: New. Bookseller Inventory # 9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 29.74
Convert Currency

Add to Basket

Shipping: US$ 3.86
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Alberto Ferrari, Marco Russo
Published by Microsoft Press,U.S., United States (2015)
ISBN 10: 073569835X ISBN 13: 9780735698352
New Paperback Quantity Available: 10
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Microsoft Press,U.S., United States, 2015. Paperback. Book Condition: New. Language: English . Brand New Book. 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. Bookseller Inventory # AAU9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.43
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Ferrari, Alberto, Russo, Marco
Published by Microsoft Press
ISBN 10: 073569835X ISBN 13: 9780735698352
New Softcover Quantity Available: > 20
Seller
Kennys Bookstore
(Olney, MD, U.S.A.)
Rating
[?]

Book Description Microsoft Press. Book Condition: New. Num Pages: 592 pages. BIC Classification: UMT; UNSJ. Category: (P) Professional & Vocational. Dimension: 231 x 189 x 33. Weight in Grams: 976. . 2015. 1st Edition. Paperback. . . . . Books ship from the US and Ireland. Bookseller Inventory # V9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.48
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

6.

Ferrari, Alberto, Russo, Marco
Published by Microsoft Press (2015)
ISBN 10: 073569835X ISBN 13: 9780735698352
New Softcover First Edition Quantity Available: > 20
Rating
[?]

Book Description Microsoft Press, 2015. Book Condition: New. Num Pages: 592 pages. BIC Classification: UMT; UNSJ. Category: (P) Professional & Vocational. Dimension: 231 x 189 x 33. Weight in Grams: 976. . 2015. 1st Edition. Paperback. . . . . . Bookseller Inventory # V9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.64
Convert Currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, Rates & Speeds

7.

Alberto Ferrari;Marco Russo
Published by Microsoft Press (1783)
ISBN 10: 073569835X ISBN 13: 9780735698352
New Softcover Quantity Available: 20
Seller
Rating
[?]

Book Description Microsoft Press, 1783. Book Condition: New. Bookseller Inventory # EH9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.92
Convert Currency

Add to Basket

Shipping: US$ 3.52
From Germany to U.S.A.
Destination, Rates & Speeds

8.

Alberto Ferrari, Marco Russo
Published by Microsoft Press 2015-10-05 (2015)
ISBN 10: 073569835X ISBN 13: 9780735698352
New Quantity Available: 5
Seller
Chiron Media
(Wallingford, United Kingdom)
Rating
[?]

Book Description Microsoft Press 2015-10-05, 2015. Book Condition: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Bookseller Inventory # NU-GRD-05221561

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.99
Convert Currency

Add to Basket

Shipping: US$ 3.85
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Ferrari, Alberto
ISBN 10: 073569835X ISBN 13: 9780735698352
New Quantity Available: 1
Seller
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2015. PAP. Book Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9780735698352

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 35.77
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

10.

Ferrari, Alberto^Russo, Marco
Published by Prentice Hall
ISBN 10: 073569835X ISBN 13: 9780735698352
New Quantity Available: > 20
Seller
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 073569835X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 38.49
Convert Currency

Add to Basket

Shipping: US$ 3.50
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book