This is a newly updated multi-media training kit focused on building cube formula reports and dashboards from Analysis Services Multidimensional cubes, Tabular models, or both. It complements the Excel training kit: PowerPivot Formula Reporting Made Easy.
Users of Excel 2010/2013 may be familiar with using Slicers to filter data in a PivotTable. But they can also significantly enhance the user experience with reports and dashboards built from Excel cube functions.
Analysis Services cubes commonly have user-defined hierarchies, such as a date hierarchy. Getting a table of data at the right level of detail can be tricky. Large PivotTables can be slow to set up and manipulate. Learn more on how best to complete this task.
Excel 2013 is now publicly available. If you have the Microsoft Office 2013 Professional Plus version and you enable the PowerPivot add-in you can open and modify PowerPivot models from Excel 2010.
Learn how to build your PivotTable and get the benefits of Excel's OLAP Tools
Some reports, such as financial reports, require a very specific layout that PivotTables don't allow. Find out how Excel Cube Functions make it easy to build these reports and stay live-linked to your database. Helps with dashboards too!
This trick can be more useful than Find as it identifies all cells that include the words/phrases at the same time. Great for auditing descriptions in a list of transactions.
PowerPivot for Excel does not support write-back to a data model and as Personal BI it is not intended for shared usage. But it still offers some planning capabilities. This multi-part section describes how.
Check out Cell Mate for a various wish-I'd-known-that-before video Excel tips, trickery, and shortcuts, many demonstrated with videos.
This is a real time-saver when copying a cell down hundreds of rows.