Microsoft Excel 2013 Building Data Models with PowerPivot

Series
Microsoft Press
Author
Alberto Ferrari / Marco Russo  
Publisher
Microsoft Press
Cover
Softcover
Edition
1
Language
English
Total pages
512
Pub.-date
March 2013
ISBN13
9780735676343
ISBN
0735676348


Product detail

Product Price CHF Available  
9780735676343
Microsoft Excel 2013 Building Data Models with PowerPivot
45.10 approx. 7-9 days

Table of Contents

  • Introduction
  • Chapter 1: Introduction to PowerPivot
  • Chapter 2: Using the unique features of PowerPivot
  • Chapter 3: Introducing DAX
  • Chapter 4: Understanding data models
  • Chapter 5: Publishing to SharePoint
  • Chapter 6: Loading data
  • Chapter 7: Understanding evaluation contexts
  • Chapter 8: Understanding CALCULATE
  • Chapter 9: Using hierarchies
  • Chapter 10: Using Power View
  • Chapter 11: Shaping the reports
  • Chapter 12: Performing date calculations in DAX
  • Chapter 13: Using advanced DAX
  • Chapter 14: Using DAX as a query language
  • Chapter 15: Automating operations using VBA
  • Chapter 16: Comparing Excel and SQL Server Analysis Services
  • About the Authors

Author

Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.