BTerrell Group Blog

Sage 300 ERP: Operational Data Analysis Using PowerPivot - Wrap-Up

Posted by Tony Zhang on Thu, Dec 05, 2013

This is my final blog wrapping up our series on Sage 300 ERP operational data analysis using PowerPivot. Follow this link to interact with the workbook. Please note, you need Excel 2013 Professional Plus and will need to enable the Power View add-in for the interaction with the “Sales Dashboard”, as shown in the first screenshot below.

As you work with the slicer, please note that some of the slicers are linked to more than one report, as shown in the second screenshot below.

Below, are the worksheets included in the workbook and the links to the blogs about them. Follow this link for a static view.   

  1. Inventory Control
  2. ABC Item Sales
  3. ABC Item Valuation
  4. SO
  5. Aged SO
  6. Sales History
  7. Sales Analysis
  8. PO Action
  9. Aged PO
  10. Purchase History
  11. Purchase Analysis
  12. Item Forecast


Screenshot 1:

Sage 300 ERP Power Pivot
Screenshot 2:

Sage 300 ERP Power Pivot

I hope you've enjoyed this series of blogs, and that they've helped you with using PowerPivot to analyze, manipulate and report on Sage 300 ERP data.

In the next blog, I will talk about payroll analysis using PowerPivot.

Tags: Sage 300 ERP, PowerPivot