A national energy board safety regulator needed to correlate financial and time sheet data with their project management system. As part of a their mandate as government regulator, they had to determine if the money they were spending on projects in various geographies was appropriate and if the time and resources used were recorded and matched correctly.
Despite having all of the information, it was sprawled across 3 different data sources. They wanted to know how the Microsoft Power BI data analysis tools could help them to visualize and understand their data in a more cohesive way to ensure compliance. They engaged Imaginet to provide an extensive analysis of their data.
Imaginet’s BI Architect worked for several days with their Project Manager and met with the various departments responsible for their 3 systems to improve data analysis and visualization using Power BI. Microsoft PowerPivot and Power View for SharePoint Server were used to interpret all of the data from SQL databases and Excel spreadsheets.
Imaginet presented a prototype to show data visualizations and provided an assessment for BI maturity capabilities. This was the first time the company was able to see their data correlated. During the demonstration of the prototype, managers wanted to immediately drill down through the visualizations and make operational change decisions based on the information in front of them.
Total Duration:2 weeks