Dynamics AX 2012 Blueprints: Using PowerBI to Analyze Dynamics AX Data

by Murray Fife

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.

48 pages, Paperback

First published November 24, 2013

About the author

Murray Fife is a Technical Solution Professional at Microsoft and Author of over 25 books on Microsoft Dynamics AX including the Bare Bones Configuration Guide Series which contains over 15 books that show novice users host to set up Dynamics AX using visual walkthroughs. These guides start off with the Financial modules of Dynamics AX and then progress through the Operational, Distribution, and then the more specialized modules like production, service management, and project accounting. You can find all of his books on Amazon (www.amazon.com/author/murrayfife) and also even more on the independent BSP (www.blindsquirrelpublishing.com) site.

Murray is also the curator of the Dynamics AX Companions (www.dynamicsaxcompanions.com) site which he built from the ground up as a resource for all of the Dynamics AX community where you can find walkthroughs and blueprints that he created since first being introduced to the Dynamics AX product.

Throughout his 25+ years of experience in the software industry he has worked in many different roles during his career, including as a developer, an implementation consultant, a trainer and a demo guy within the partner channel which gives him a great understanding of the requirements for both customers and partners perspective.