Extend the power of Excel—and discover an agile, cost-effective approach to business intelligence. Two business intelligence experts take you inside the PowerPivot add-in for Excel 2013. With a focus on real world scenarios, problem-solving, and data modeling, this guide shows you how to perform complex data analysis, and will help you deepen your skills as an Excel power-user.
Transform data into business intelligence solutions and on-the-job results

• Create reports with the Data Analysis Expressions (DAX) language
• Use data modeling to make your data easier to understand and manage
• Load data from different sources directly into PowerPivot
• Add hierarchies to your data model to enable faster browsing
• Get insights from your data in a visual way with Power View
• Share your results across your organization using Microsoft SharePoint

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

                        Index