This blog is a continuation on the Sage 300 ERP business intelligence journey using PowerPivot. I will focus on the project analysis in this blog.
If you use Sage 300 ERP Project and Job Costing module, then you might like a report like this:
The report replicates the Sage 300 ERP Contract Summary report, with additional information like PM Cost Left to Spend while providing the flexibility and performance improvements brought by using Excel PowerPivot. For example, this report allows you to select projects that are not consecutive by holding the CTRL key and click the projects you like from the “Project” slicer circled above, which is impossible when using the standard report as show below:
I highlighted the numbers in the Excel report above and the Crystal report below to show they are the same.
The next report is meant to analyze the project cost. Notice that both original cost and current cost estimates are presented together with the actual cost – a more comprehensive analysis comparing with the “Detailed Costs” as show in the following screenshots, where only one of them is presented in the report.
Again, I highlighted the numbers in the Excel report above and the Crystal report below to show they are the same.
The last example is the standard “Transaction History” report and the PowerPivot version of it. Again, the point here is the flexibility and the performance gain from using PowerPivot.
I hope this blog is helpful as you continue to understand PowerPivot’s position and the level of professional services we provide here at BTerrell Group. Feel free to view the report in static form here to grasp the look and feel. Please “Scroll to the first sheet” to see those three reports.
Other Related Blog Posts
- Sales analysis overview
- AP aging reports
- Cash flow forecast
- Inventory control
- Dynamic ABC analysis
- OE aged orders
- Sales history reporting
- Purchase history and KPIs
- Inventory forecasting
- Operational data analysis using PowerPivot (wrap-up)
- Financial dashboards