Search

Our Business Intelligence reporting class will give participants a base knowledge on the data sources and reporting tools available to build reports and dashboards on Microsoft’s Enterprise Project Management solution. Participants will extend their knowledge on building reports off the Project Online Reporting database using Excel with the add-ons PowerView and PowerPivot.  Excel Power View is an interactive data visualization and presentation tool that is ideal for ad-hoc reporting. Power View is a feature of Microsoft Excel 2016.

This Project Stats report summarizes project counts by sponsor and budget status by project size displayed visually using the graph functionality in Excel Power View.

Project Statistics

This Project Health Report uses the Key Performance Indicators available in an Excel Power View to display a visually pleasing health check report.

 

Project Health 

This Issue Report using the layout and formatting capabilities of Power View to improve the visual layout of the fields in the report.

Project Issue Report