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

The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
分享
扫描下方二维码分享到微信
打开微信,点击右上角”+“,
使用”扫一扫“即可将网页分享到朋友圈。
出版社: Microsoft Press
2019-07
ISBN: 9781509306978
装帧: 其他
页数: 768页
1人买过
  • 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.
    Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel
    ·         Master core DAX concepts, including calculated columns, measures, and calculation groups
    ·         Work efficiently with basic and advanced table functions
    ·         Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions
    ·         Perform time-based calculations
    ·         Use calculation groups and calculation items
    ·         Use syntax of variables (VAR) to write more readable, maintainable code
    ·         Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters
    ·         Master advanced optimization techniques, and improve performance in aggregations
    ·         Optimize data models to achieve better compression
    ·         Measure DAX query performance with DAX Studio and learn how to optimize your DAX Contents at a Glance
    Foreword xvii
    Introduction to the second edition xx
    Introduction to the fi rst edition xxi
    CHAPTER 1 What is DAX? 1
    CHAPTER 2 Introducing DAX 17
    CHAPTER 3 Using basic table functions 57
    CHAPTER 4 Understanding evaluation contexts 79
    CHAPTER 5 Understanding CALCULATE and CALCULATETABLE 115
    CHAPTER 6 Variables 175
    CHAPTER 7 Working with iterators and with CALCULATE 187
    CHAPTER 8 Time intelligence calculations 217
    CHAPTER 9 Calculation groups 279
    CHAPTER 10 Working with the fi lter context 313
    CHAPTER 11 Handling hierarchies 345
    CHAPTER 12 Working with tables 363
    CHAPTER 13 Authoring queries 395
    CHAPTER 14 Advanced DAX concepts 437
    CHAPTER 15 Advanced relationships 471
    CHAPTER 16 Advanced calculations in DAX 519
    CHAPTER 17 The DAX engines 545
    CHAPTER 18 Optimizing VertiPaq 579
    CHAPTER 19 Analyzing DAX query plans 609
    CHAPTER 20 Optimizing DAX 657
    Index 711
  • 内容简介:
    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.
    Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel
    ·         Master core DAX concepts, including calculated columns, measures, and calculation groups
    ·         Work efficiently with basic and advanced table functions
    ·         Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions
    ·         Perform time-based calculations
    ·         Use calculation groups and calculation items
    ·         Use syntax of variables (VAR) to write more readable, maintainable code
    ·         Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters
    ·         Master advanced optimization techniques, and improve performance in aggregations
    ·         Optimize data models to achieve better compression
    ·         Measure DAX query performance with DAX Studio and learn how to optimize your DAX
  • 目录:
    Contents at a Glance
    Foreword xvii
    Introduction to the second edition xx
    Introduction to the fi rst edition xxi
    CHAPTER 1 What is DAX? 1
    CHAPTER 2 Introducing DAX 17
    CHAPTER 3 Using basic table functions 57
    CHAPTER 4 Understanding evaluation contexts 79
    CHAPTER 5 Understanding CALCULATE and CALCULATETABLE 115
    CHAPTER 6 Variables 175
    CHAPTER 7 Working with iterators and with CALCULATE 187
    CHAPTER 8 Time intelligence calculations 217
    CHAPTER 9 Calculation groups 279
    CHAPTER 10 Working with the fi lter context 313
    CHAPTER 11 Handling hierarchies 345
    CHAPTER 12 Working with tables 363
    CHAPTER 13 Authoring queries 395
    CHAPTER 14 Advanced DAX concepts 437
    CHAPTER 15 Advanced relationships 471
    CHAPTER 16 Advanced calculations in DAX 519
    CHAPTER 17 The DAX engines 545
    CHAPTER 18 Optimizing VertiPaq 579
    CHAPTER 19 Analyzing DAX query plans 609
    CHAPTER 20 Optimizing DAX 657
    Index 711
查看详情
相关图书 / 更多
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Black Book of Buried Secrets
Riordan;Rick
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Technique of parents innovation and independent parents cultivation in sugarcane cross breeding
吴才文
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Hongqiao Story: A Record of Whole-process People’s Democracy Practices in Local Communities
上海市长宁区虹桥街道全过程人民民主基层实践基地 作者;中译语通信息科技(上海)有限公司 译;上海人大全过程人民民主研习实践基地
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Ecological Relations of the Vegetation on the Sand Dunes of Lake Michigan(密歇
Henry Chandler Cowle
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The 14th Five-Year Plan for Vocational Skills Training
中华人民共和国人力资源和社会保障部
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Laws of the People\'s Republic of China (2020)
全国人大常委会法制工作委员会
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Ugly Duckling 丑小鸭 (精装本)—小学英语戏剧绘本
[澳]詹姆斯 · 宾 (澳)吉莉安 · 法拉蒂
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Computer and the Brain 计算机与人脑
John von Neumann约翰·冯
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Last Firehawk 2 :The Crystal Caverns:火鹰传奇
Katrina Charman
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Real Thief
William Steig
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Wizard of Oz 绿野仙踪(精装本)(小学英语戏剧绘本)
[澳]詹姆斯·宾 (澳)吉莉安·法拉蒂
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
The Pied Piper of Hamelin 花衣魔笛手(精装本)(小学英语戏剧绘本)
[澳]詹姆斯·宾 (澳)吉莉安·法拉蒂
您可能感兴趣 / 更多
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
家长的思维模式:儿童成长型思维模式的培养策略
Mary;Cay;Ricci
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
印度洋明珠:毛里求斯商贸要略
Marie Lourdes Lam Hung(玛丽·卢尔德·林·洪)
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
自然象征——宇宙论的探索(汉译人类学名著丛书)
Mary Douglas
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
欧盟个人数据保护制度——《一般数据保护条例》
Mariusz Krzysztofek
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
巴西小史
Maria del Priore
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
世界啤酒地图:150种啤酒大赏
Mark Dredge
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
法理学和政治学中的自然法(自然法名著译丛)
Mark C. Murphy
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
数学天书中的证明(第六版)
Martin Aigner;Günte
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
机器学习Python版(英文版)
Mark E. Fenner
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
关于《马丁·菲耶罗》
Margarita Guerrero 著;赵振江 译;豪尔赫·路易斯·博尔赫斯;玛加丽塔·格雷罗(Jorge Luis Borges
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
日耳曼中世纪文学
María Esther Vázquez 著;崔燕 译;豪尔赫·路易斯·博尔赫斯 玛丽亚·埃丝特·巴斯克斯(Jorge Luis Borges
The Definitive Guide to DAX:Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
幕后
Mary Ellen Mark