Practical PowerPivot & DAX formulas for Excel 2010 / Art Tennick.
Material type: TextPublication details: New York : McGraw-Hill, c2011.Description: xxvi, 438 p. : ill. ; 23 cmISBN:- 9780071746854 (pbk.)
- 005.54 22
- HF5548.4.M523 T46 2011
Item type | Current library | Collection | Call number | Status | Date due | Barcode |
---|---|---|---|---|---|---|
Books | Tan Tao University General Stacks | Non-fiction | 005.54 (Browse shelf(Opens below)) | Not For Loan | AS-2014-0069 |
Includes index.
Machine generated contents note: Part I: PowerPivot Fundamentals -- Chapter 1 PowerPivot: Quick Start -- Chapter 2 PowerPivot: Overview -- Chapter 3 PowerPivot: In-depth -- Chapter 4 DAX: Overview -- Chapter 5 Pivot Tables and Pivot Charts: Overview -- Part II: DAX -- Chapter 6 Fundamental Functions: Filter, Logical, and Miscellaneous Functions -- Chapter 7 Aggregate Functions: Statistical Functions and SUM()/SUMX() Functions -- Chapter 8 Date & Time Functions 1/2: Basic Functions -- Chapter 9 Date & Time Functions 2/2: Time Intelligence Functions -- Chapter 10 Text Functions -- Chapter 11 Math & Trig Functions -- Part III: PowerPivot and DAX Applied -- Chapter 12 A Few Ideas: PowerPivot and DAX Solutions -- Part IV: Appendices -- Appendix A SQL Queries for PowerPivot -- Appendix B MDX Queries for PowerPivot -- Appendix C DMX Queries for PowerPivot.
"Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from a veteran database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excelʼ 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendices covering SQL, MDX, and DMX query design are included in this hands-on guide"--
There are no comments on this title.