Practical PowerPivot & DAX formulas for Excel 2010 [

Practical PowerPivot & DAX formulas for Excel 2010 [

"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 s...

Full description

Bibliographic Details
Main Author: Tennick, Art (Author)
Format: Book
Language:English
Published: New York : McGraw-Hill , c2011
Subjects:
Business intelligence > Computer programs
Business > Computer programs
Electronic spreadsheets
Online Access:McGraw Hill
Table of Contents:
  • 1. PowerPivot : quick start
  • 2. PowerPivot : overview
  • 3. PowerPivot : in-depth
  • 4. DAX : overview
  • 5. Pivot tables and Pivot charts : overview
  • 6. Fundamental functions : filter, logical, and miscellaneous functions
  • 7. Aggregate functions : statistical functions and SUM()/SUMX() functions
  • 8. Date & time functions 1/2 : basic functions
  • 9. Date & time functions 2/2 : Time intelligence functions
  • 10. Text functions
  • 11. Math & trig functions
  • 12. A few ideas : PowerPivot and DAX solutions

Similar Items