Archive

Pivot Tables

Using PowerBI to Analyze Dynamics AX Data

November 27, 2013
Dynamics AX, Pivot Tables, PowerBI, PowerMap, PowerPivot, PowerQuery, PowerView
2 Comments

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

Using PowerPivot to Analyze Your Dynamics AX Data

October 31, 2013
Dynamics AX, Pivot Tables, PowerBI, PowerPivot, PowerView
1 Comment

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

Adding Timeline Slicers to PowerPivot Dashboards

October 31, 2013
Dynamics AX, Pivot Tables, PowerBI
1 Comment

PowerPivot has a couple of extra features that you can take advantage of while you are building your dashboards for slicing and filtering your data. One is called a Timeline Slicer.

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