CB.05.AX2012.1: Using PowerPivot to Analyze Dynamics AX Data (Digital)

Configuration Blueprints Module 05 Perhaps you have heard about the new tool in Excel 2010, PowerPivot, but wonder how it can enhance your use of Excel. In this configuration guide we will show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. Topics Covered Using Pivot Tables to Analyze Dynamics AX Data Using PowerPivot to create Dashboards Adding Timeline Slicers to PowerPivot Dashboards Creating Additional Calculated Columns Applying Filters to your Data Model Creating Joins between Multiple Datasets Using Functions to create Calculated Columns Creating URL and Picture Columns Creating a PowerPivot Gallery within SharePoint Saving PowerPivot Data Models to the PowerPivot Gallery Creating PowerView Dashboards from the PowerPivot Gallery Data Sources Changing the View Mode for the PowerPivot Gallery Setting PowerPivot Data Model Refresh Rates Exporting PowerView Dashboards to PowerPoint   Paperback: 60 pages Publisher: CreateSpace Independent Publishing Platform (November 24, 2013) Language: English ISBN-10: 1494272377 ISBN-13: 978-1494272371 Product Dimensions: 7.5 x 0.1 x 9.2 inches Shipping Weight: 4 ounces