Business Intelligence: If You Can Measure It, You Can Manage It

In Lantern Posts by Marc Krichman

Healthy profit margins don’t come easily to construction companies. Every project is different, so it’s hard to deliver consistent quality on time, within budget. The key is to avoid problems before they arise and implement best practices across the organization. And that takes information.

Enter business intelligence (BI). BI aggregates information from multiple sources and presents it in easy-to-grasp formats. Decision makers use that information to identify problems, single out best practices, and improve the performance of individuals and the organization.

The big problem with data? It’s Everywhere…

BI solves the problem of vital information being hidden from the people who need it. Three examples illustrate how:

  1. A large global program management company has so many departments managing vendors and subcontractors that senior managers couldn’t even identify major vendors! Contracts were spread over many systems, and aggregating data was so labor-intensive as to be impractical. The challenge was perfect for a business intelligence solution. A BI system gathers data from all of the company’s contract systems and presents it in an easy-to-read dashboard. The contract management team now has the information needed to make better, more timely decisions across the enterprise.
  2. An ENR top 400 general contractor’s senior project managers need to mentor trainees, but the senior managers don’t have time to retrieve project data such as profit, past-due receivables, and job-to-date costs from the financial system, and to gather documents such as RFIs, submittals, and action items from the project management system. Instead, a BI system automatically gathers the data and presents it in a purpose-built dashboard. Problem solved.
  3. A leading regional construction firm had people enter productivity and profitability data into multiple Excel spreadsheets. Despite consuming vast resources, the process failed to deliver adequate results. After implementing a BI system and dashboard, more and better information reached key people faster than ever. That, in turn, has led to an increase in staff productivity and job profitability.

BI insights improve company-wide performance.

BI’s greatest benefit is the way it enables company-wide performance improvements. For example, our company recently helped an organization identify a way to improve client satisfaction across the company.

We aggregated data that had been contained in a mix of Excel spreadsheets and web survey tools. Key outputs included:

  • The top 10 projects (most satisfied)
  • The bottom 10 projects (least satisfied)
  • The top 10 clients (most satisfied)
  • The bottom 10 clients (least satisfied)

The dashboard also compared performance by project type.

Data revealed most issues were caused by miscommunication. Managers compared projects and clients by categories to find the highest performers were all in operations and maintenance (O&M). Why? O&M projects had better communication guidelines.

The key to improving client satisfaction became obvious: Learn from O&M communications guidelines to improve guidelines across all categories. As a result, client satisfaction scores have risen, leading to more, better referrals and a greater rate of repeat business!

BI nips problems in the bud.

Another company has set up a system to predict potential claims by analyzing the number of RFIs by project phase. Managers can see, for instance, when the number of RFIs exceeds 20 percent of the average for like projects or contracts. Although it’s early, they anticipate reducing the number of claims by flagging problems sooner.

The same company also compares invoicing to the degree to which a project is complete. Doing so enabled the company to see that a particular contract was 171 percent invoiced but only 60 percent complete. This meant either there was a serious problem with invoicing or there were contract changes which hadn’t been input into the system. Either way, the potential problem was identified and identified quickly.

If you need help, call Lantern Data Systems

Lantern Data Systems is a business intelligence company specializing in AEC companies. Lantern combines data from project systems, business systems, and other resources into one intuitive platform, enabling organizations to avoid problems and improve performance.

Want to learn more about how Lantern helps AEC companies make better, data-driven decisions? Review some customer stories and contact us for a demo or discussion about your business!