Saturday, October 21, 2017
Using PowerBI To Analyze Dynamics AX Data
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
Get Your Own Copy Of The Book

If you are more of a would like to get your own copy of the book then don't worry - we have made it available for you through Blind Squirrel Publishing.  All you have to do is follow the link below:


Buy Now


If you want a copy of the book from Amazon then just click on this link http://www.amazon.com/dp/1494276267/

Become an eBook Subscriber and get All the Books at Once

If you want access to all of the books that we have published (and will publish in the future then you may want to become an eBook Subscriber.  This will allow you to download the latest version of the book directly from the Dynamics AX Companions site as a PDF file, which may also contain additional content that is not available in the published version because this will be the source file for the next and updated editions.  This is a one time only fee of $249.00 which is a steal if you ask us.

 

If you want to become an eBook Subscriber then just go to your Account Profile and add an eBook Subscription to your account.  It's super easy to do.

 

If you are a eBook Subscriber, then just click on the book link to get the file.



 


If you don't want to commit to getting a copy of all the books that are available, then you can just purchase the individual book by adding the Using PowerBI To Analyze Dynamics AX Data subscription to your account profile for $4.99.

Sign Up For The Premium Subscription To Access More of The Content
There is a lot more content that is available through the Dynamics AX Companions site, but in order to keep the lights on (or the Azure hosting fees paid) they can only be accessed if you show your support to the website through a subscription.  The Premium subscription will also give you access to all the PDF versions from the Tips & Tricks archive, giving you a sneak preview into the next Tips & Tricks book before it's even published.  I’m hoping that people will appreciate that this is just $9.95 a month and keep on subscribing and not just pillage the files and then cancel the monthly subscription because then you will miss out on all the new content that is continually made available.

 

To add a Premium subscriptions to your account just follow these instructions:

  1. Register on the site by clicking on the register link in the header of the website.
  2. Access your user profile by clicking on your name in the top right of the form, (or by clicking here) and click on the My Account button below your profile image.
  3. Select the Manage Services tab and click on the Subscribe button for the subscription that you want to add.
Contact Info

EMAIL: info@dynamicsaxcompanions.com

TWITTER: @daxcompanions