CB.06.AX2012.1: Using PowerBI to Analyze Dynamics AX Data (Digital)

Configuration Blueprints Module 06 Everyone has used Pivot Tables within Excel at one point in time to create simple reports against Dynamics AX, and some of you may have also used Power Pivot to create more elaborate dashboards and charts. Recently Microsoft extended out the query and reporting capabilities within Excel with the Power BI suite. In addition to extending the Power Pivot capabilities, they also added three more tools called Power Query, Power View & Power Map, and that means that you have a whole new set of reporting options. In this blueprint we will show you how you can use all of the Power BI tools to analyze your Dynamics AX data. Topics Include: Mapping your data within Excel through PowerView Using PowerQuery to Clean up Your Data Using PowerMap to Build Even Better Map Visualizations Using different Visualizations within PowerMap Using PowerQuery to Merge Datasets Flattening Maps Adding Labels to the Maps Using PowerQuery to Integrate External Data   Paperback: 48 pages Publisher: CreateSpace Independent Publishing Platform (November 24, 2013) Language: English ISBN-10: 1494276267 ISBN-13: 978-1494276263 Product Dimensions: 7.5 x 0.1 x 9.2 inches Shipping Weight: 4.2 ounces