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 presentation we will show you how you can use all of the Power BI tools to analyze your Dynamics AX data.
The topics that are described within this series are:
- 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
PowerBI marries a number of useful analytics tools together to help you analyze your data, and to be able to analyze your data geographically is one of the cooler features.
After you have mastered the basics of the PowerBI suite though you can start using some of the other features such as:
- Creating multiple layers within PowerMap to merge data
- Using PowerQuery to access information from web sites and XML feeds
- Create labels and information panels in your PowerMaps
- Create tours that animate your maps through storyboards
There is so much that you can do with PowerBI, try it out.