The Challenge
The time-consuming and manual process of building custom dashboards with Excel and CSV files led Stiles Construction to look for a way to simplify the process. The team was also searching for ways to ensure their dashboards were consistent, up-to-date, and reliable.
The Solution
Stiles Construction discovered Procore Analytics which allowed data from Procore to automatically flow into a powerful analytics tool, providing more up-to-date and relevant information. Additionally, the custom dashboards helped increase transparency and trust for project stakeholders.
“We were continuing to have issues using the manual process of downloading data from Procore and uploading to Power BI. We couldn’t rely on this process.”
Seth Cheever
Director of Operational Excellence
Streamlining Data Across Systems
Prior to Procore Analytics, Stiles Construction’s manual processes had led to inconsistencies in how information was exported and loaded into their dashboards. In fact, data exported from applications (such as Procore, Sage, and SharePoint) with these methods often resulted in essential information being outof- date or inaccurate. In order to help provide consistent data and to streamline their process, Director of Operational Excellence Seth Cheever at Stiles Construction, began to search for an alternative solution.
When researching analytics solutions, Seth reviewed a variety of platforms such as Tableau, Domo, and Qlik. However, as Stiles is a Microsoft shop, it became clear early on that the best decision for the organization was to implement Microsoft’s Power BI. In order to ensure data visualizations and custom metrics were as useful as possible, Seth wanted to be able to integrate data sources from all of their systems including Procore, Sage, Textura, and SharePoint. In his research, he found that Power BI functions as a hybrid solution that can integrate data from a variety of sources and feed it into a set of integrated reports and dashboards.
Since Stiles was already a user of Power BI and had dashboards in place, the company was perfectly set up to benefit from the Data Extract capabilities of Procore Analytics. This solution would give Stiles near real-time access to their Procore data, the flexibility to incorporate other data sources, and the freedom to build custom dashboards.
Implementation Made Quick and Seamless
In the process of becoming more data driven, Stiles rapidly discovered the necessity of building and deploying custom dashboards to support their growth. Procore Analytics hit the mark, by both allowing their Procore data to flow seamlessly into Power BI via automatically scheduled refreshes and equipping Stiles with ready-made dashboards. By helping the Stiles team become more accustomed to visualizing data, Procore Analytics made creating new custom dashboards to meet specific organizational needs easier than ever. Plus, the ability to see project insights from Procore, combined with data from their Sage accounting system, helped decision-makers at Stiles keep a closer eye on the company’s projects.
Trust Gained with Information Quality
After implementing Procore Analytics, Seth and the Stiles team are now confident that data pulled into their Power BI dashboards—and ultimately used in their decision-making process—are accurate, timely, and reliable.
As a result, more project stakeholders use information in the Power BI dashboards to make critical decisions and help keep projects on schedule, under budget, and limit their potential risk. With Procore Analytics, Stiles executives are now able to utilize dashboards to make critical decisions with ease and confidence.
To learn more about Procore Analytics visit procore.com/analytics or speak to your local representative at (866) 477-6267.