Using PowerPivot to Analyze Your Dynamics AX Data

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.

Here are all of the blog posts that are included in this series:

Bonus Book Content

  • Creating a PowerPivot Gallery within SharePoint
  • Saving PowerPivot Data Models to the PowerPivot Gallery
  • Creating PowerView Dashboards from the PowerPivot Gallery Data Sources
  • Changing the View Mode for the PowerPivot Gallery
  • Setting PowerPivot Data Model Refresh Rates
  • Exporting PowerView Dashboards to PowerPoint

PowerPivot is a great tool that gives you a lot more capabilities that the normal Pivot function lacks, and in this worked example we have shown how it also extends out to SharePoint giving you a number of new publishing and visualization options.

Once you have mastered all of the basics of PowerPivot, you may want to dive into some other features like:

  • The creation of more complex calculations using the DAX Queries
  • The creation of KPI’s based off the calculations
  • Reporting hierarchies

Then you will want to start investigating the other tools that are included in the PowerBI suite (which PowerPivot is just one of). The other tools are:

  • PowerView
  • PowerMap
  • PowerQuery

Have fun PowerBI-ing.

1 comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: