A Business Intelligence Solution for a Project Management Unit in a Construction Company

Challenge

Our customer’s approach to managing projects was no longer keeping up with an accelerating pace of work. The data used to be captured in various spreadsheets, which were barely efficient enough to make use of. Struggling through a bazillion rows stuffed with data is not so great of a plan to get powerful insight. The more difficult deciphering the data was becoming the stronger our customer was striving for a new, unconventional strategy that would help to automate generating multiple reports and transmit them to user-friendly, intuitive dashboards.

Solution

*instinctools has developed a business intelligence system, allowing project managers within our customer’s company to painlessly analyze automatically generated and categorized information, and switch from a project’s quick overview to tracking all the necessary details. To make data visualizations and custom metrics as helpful as they could possibly be, it was crucial to start data integration from different systems to single online storage. Power BI technology seemed to be a perfect fit in this case since it can integrate data from a variety of sources and deliver it straight to users in the form of reports and dashboards.

Results

The implemented BI system enables project managers to make data-driven decisions about contracting and workforce levels and helps to keep projects on time and on budget. Without the necessity to manually enter data into spreadsheets, the company saves up to 40 hours of work per report. The time gained thanks to the newly acquired system can now be spent on more challenging tasks. Having a clear view of the data in their projects at hand, project managers can easily spot new opportunities for optimization and increase the number of winning bids.