Russo, Marco, 1969-

The definitive guide to DAX : business intelligence with Microsoft Excel, SQL Server analysis services and Power BI / Marco Russo and Alberto Ferrari. - xxvi, 557 pages : illustrations ; 23 cm

Includes index.

What is DAX? -- Introducing DAX -- Using basic table functions -- Understanding evaluation contexts -- Understanding Calculate and Calculatetable -- DAX examples -- Time intelligence calculations -- Statistical functions -- Advanced table functions -- Advanced evaluation context -- Handling hierarchies -- Advanced relationships -- The VertiPaq engine -- Optimizing data models -- Analyzing DAX query plans -- Optimizing DAX.

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.--


IN ENGLISH

9780735698352 (pbk.) 073569835X (pbk.)

2014955069

GBB545016 bnb


Microsoft Excel (Computer file)


DAX (Computer programming language)
SQL (Computer program language)
Business intelligence--Computer programs.

QA76.73.S67 / R88 2015

005.756