國立虎尾科技大學 |

Language: English

Back

The definitive guide to DAX : = busi...

Ferrari, Alberto, (1966-)

The definitive guide to DAX : = business intelligence with Microsoft Power BI, SQL server analysis services, and Excel /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	The definitive guide to DAX :/ Marco Russo and Alberto Ferrari.
Reminder of title:	business intelligence with Microsoft Power BI, SQL server analysis services, and Excel /
remainder title:	Business intelligence with Microsoft Power BI, SQL server analysis services, and Excel
Author:	Russo, Marco,
other author:	Ferrari, Alberto,
Published:	[New York, NY] :Pearson Education, Inc., : c2020.,
Description:	xxvi, 739 p. :ill. ; : 24 cm.;
Notes:	Includes index.
Subject:	Business intelligence - Computer programs. -
ISBN:	9781509306978 (pbk.) :

The definitive guide to DAX : = business intelligence with Microsoft Power BI, SQL server analysis services, and Excel /
Russo, Marco,1969-

The definitive guide to DAX :business intelligence with Microsoft Power BI, SQL server analysis services, and Excel /Business intelligence with Microsoft Power BI, SQL server analysis services, and ExcelMarco Russo and Alberto Ferrari. - 2nd ed. - [New York, NY] :Pearson Education, Inc.,c2020. - xxvi, 739 p. :ill. ;24 cm.

Includes index.

What is DAX? -- Introducting DAX -- Using basic table functions -- Understanding evaluation contexts -- Understanding Calculate and Calculatetable -- Variables -- Working with iterators and with Calculate -- Time intelligence calculations -- Calculation grops -- Workig with the filter context -- Handling hierachies -- Working with tables -- Authoring queries -- Advanced DAX concepts -- Advanced relationships -- Advanced calculations in DAX -- The DAX engines -- Optimizing VertiPaq -- Analyzing DAX query plans -- Optimizing DAX.

"Now 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. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need." --

ISBN: 9781509306978 (pbk.) :NT1684

LCCN: 2019930884Subjects--Uniform Titles:

SQL server.
Subjects--Topical Terms:

643520
Business intelligence
--Computer programs.

LC Class. No.: QA76.73.S67 / R88 2020

Dewey Class. No.: 005.74

The definitive guide to DAX : = business intelligence with Microsoft Power BI, SQL server analysis services, and Excel /
LDR:02313cam a2200277 a 4500 001 934973
005 20191029164249.0
008 191112s2020 nyua 001 0 eng d
010 $a 2019930884
020 $a 9781509306978 (pbk.) : $c NT1684
020 $a 1509306978 (pbk.)
035 $a (OCoLC)1112253036
035 $a on1112253036
040 $a PWC $b eng $c PWC $d JOZ $d JRZ $d VP@ $d OCLCF $d MHD $d NFU
041 0 # $a eng
050 # 4 $a QA76.73.S67 $b R88 2020
050 # 4 $a QA76.73.D24 $b R88 2020
082 0 4 $a 005.74 $2 23
100 1 $a Russo, Marco, $d 1969- $3 1218564
245 1 4 $a The definitive guide to DAX : $b business intelligence with Microsoft Power BI, SQL server analysis services, and Excel / $c Marco Russo and Alberto Ferrari.
246 3 0 $a Business intelligence with Microsoft Power BI, SQL server analysis services, and Excel
246 3 # $a Definitive guide to Digital Analysis Expressions
250 $a 2nd ed.
260 # $a [New York, NY] : $b Pearson Education, Inc., $c c2020.
300 $a xxvi, 739 p. : $b ill. ; $c 24 cm.
500 $a Includes index.
505 0 # $a What is DAX? -- Introducting DAX -- Using basic table functions -- Understanding evaluation contexts -- Understanding Calculate and Calculatetable -- Variables -- Working with iterators and with Calculate -- Time intelligence calculations -- Calculation grops -- Workig with the filter context -- Handling hierachies -- Working with tables -- Authoring queries -- Advanced DAX concepts -- Advanced relationships -- Advanced calculations in DAX -- The DAX engines -- Optimizing VertiPaq -- Analyzing DAX query plans -- Optimizing DAX.
520 # $a "Now 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. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need." -- $c Provided by publisher.
630 0 0 $a SQL server. $3 565415
630 0 0 $a Microsoft Excel (Computer file) $3 558412
630 0 0 $a Microsoft PowerPivot (Computer file) $3 1070177
650 # 0 $a Business intelligence $x Computer programs. $3 643520
650 # 0 $a Query languages (Computer science) $3 568019
700 1 # $a Ferrari, Alberto, $d 1966- $3 1218565