PowerPivot Alchemy: Patterns and Techniques for ExcelPowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis. |
Other editions - View all
Common terms and phrases
Bill Bill Jelen blank calc column calculated calendar table cell chapter chart choose conditional formatting create CSV files cube formula CUBERANKEDMEMBER CUBESET dashboard data set data table Date column DAX Formulas dialog Drag drop-down End Date example Excel pros Figure Fisher-Price Formulas for Power function header Here’s look lookup table macro match Microsoft Model Name month Moving Average Moving Sum multiple Note Pass TD PeriodID Periods table Power Map Power Pivot Power Query Power View field Products table Project Gemini Rank RANKX refresh report filters returns row context Rows drop zone Sales Measure sales per day Sales table same-store sales Sarah Problem scene seasonally adjusted SharePoint simple single slicer sort Statosphere steps technique text box things Tile ToolTips TopN Total Sales trick Unpivot View field list Webdings week Wingdings workbook worksheet write zip codes zoom