08-28-2017 19:54 PM - last edited 08-29-2017 13:17 PM
If you're tired of the same old, out-of-the-box, project management reports, then you're going to love this dynamic report that puts the power in your own hand. By using DAX, we've developed dynamic measures that are implemented in these scatterplots. That means that you get to choose the x-axis, y-axis, and bubble size of the scatterplots from a list of metrics. Let me explain this report, piece by piece.
The bar charts at the top provide a high-level view into your project portfolio (broken down by region in this example). You can use this to provide context to your subsequent analysis and help you make decisions on which metrics you want to visualize in the scatterplots. The main feature of this report, however, is the scatterplots.
Use the dropdown lists to select the metrics you want to analyze. The scatterplots update based on your selection. By having two scatterplots, you're able to perform various comparisons. Maybe you want one scatterplot to visualize cost related metrics and the other to visualize work related metrics. Or maybe you want them to have the same metrics, but you want to slice them by different regions. This allows for a more complex analysis that you don't typically get from other reporting services.
Lastly, we have the tables.
The tables provide a more granular look at your data and are populated with the x, y, and bubble size values you selected for the scatterplots. Additional supporting fields are also included in the tables. If you want, you can then export these tables to a CSV file to perform additional analysis and/or share with others in your organization.
This report was developed by ShareAdvance. We provide data analytics services to companies utilizing Microsoft Project Online and Project Server. With our Project Intelligence database, we're able to snapshot your project data, allowing for more advanced analytics - trends, historical comparisons, predictive. Please visit our site through the link above for more details.