Introduction to PowerPivot -- Using the unique features of PowerPivot -- Introducing DAX -- Understanding data models -- Publishing to SharePoint -- Loading data -- Understanding evaluation contexts -- Understanding CALCULATE -- Using hierarchies -- Using Power View -- Shaping the reports -- Performing date calculations in DAX -- Using advanced DAX -- Using DAX as a query language -- Automating operations using VBA -- Comparing Excel and SQL Server Analysis Services.
|