TY - BOOK AU - Russo,Marco AU - Ferrari,Alberto TI - The definitive guide to DAX: business intelligence with Microsoft Excel, SQL Server analysis services and Power BI SN - 9780735698352 (pbk.) AV - QA76.73.S67 R88 2015 U1 - 005.756 23 PY - 2015///] CY - Redmond, Washington PB - Microsoft Press KW - Microsoft Excel (Computer file) KW - DAX (Computer programming language) KW - SQL (Computer program language) KW - Business intelligence KW - Computer programs N1 - 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 N2 - 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.-- ER -