Archive

PowerPivot

One of the easiest ways to map your Dynamics AX data is through PowerView directly from within Excel. PowerView will automatically recognize geographic columns as mappable data elements, and will translate them to the map view.

NOTE: This is part of the Using PowerBI to Analyze Dynamics AX Data blueprint series where we show how to use PowerView, PowerPivot & Power Map to analyze and visualize your data more effectively. If you want to see all of the other posts in this series, click
here.

Read More

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.

Read More

Perhaps you have heard about the new tool in Excel called PowerPivot, but wonder how it can enhance your use of Excel.

In this series 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.

Read More

Within the PowerPivot Data Model editor, you can also filter the data that is returned to Excel through the filtering option.

NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.

Read More

When the Power Pivot Data Models are stored within a PowerPivot Gallery, you will want to have them periodically refresh to get the latest information. Rather than doing this manually, you can configure a default refresh rate and the gallery will do the rest for you.

NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.

Read More

If you want to show off, you can also change the style of the PowerView Gallery to Carrousel, Theatre, or List mode depending on where you are embedding the view.

NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.

Read More

The real benefit of hosting your PowerPivot workbooks within a PowerPivot Gallery is that people can then report off the data source as if it were a mini data warehouse using PowerView.

NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.

Read More