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
人気のある作家
J KING (12) JJ TAM (12) yang hu (11) Al Sweigart (8) Mojang AB (8) desti publishhings (7) Hidenori Kusaka (6) John Bach (6) JP TAM (6) Andrea Vedaldi (5) Halonjash Publications (5) Hiro Ainana (5) Horst Bischof (5) Intelligent Feather Publications (5) Jan-Michael Frahm (5) Michael W. Lucas (5) Andrew Park (4) Benjamin Smith (4) Engr. Michael David (4) Harvey Deitel (4)最適なファイルサイズ
10531 KB 1079 KB 1116 KB 1233 KB 2661 KB 370 KB 484 KB 536 KB 649 KB 738 KB 790 KB 10049 KB 1006 KB 10137 KB 1016 KB 102097 KB 1029 KB 10325 KB 1032 KB 1035 KB