Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$14
per month per user
Procore
Score 8.7 out of 10
N/A
Procore is a project management software designed specifically for the construction industry. Procore is cloud-based and allows unlimited users per instance, so that construction team members and stakeholders can all access project information and documents.
N/A
Pricing
Microsoft BI (MSBI)
Procore
Editions & Modules
Power BI Pro
$14
per month per user
Power BI Premium
$24
per month per user
Custom Bundle
Custom Quote
annually
Offerings
Pricing Offerings
Microsoft BI (MSBI)
Procore
Free Trial
No
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
Procore charges an upfront annual fee by product and based upon Annual Construction Volume (ACV) - the aggregate dollar value of the construction work across the customer's projects. Procore contracts include access for unlimited users, customer support, unlimited data storage, and product enhancements, at no additional cost.
Multi-year pools: Contract volume is set for the entire multi-year term and can be consumed at any time during that period to help smooth out variability in consumption.
Volume opt-in: Up-front contractual pricing is put in place for additional volume that might need to be added mid-term, to increase predictability of costs.
Renewal rate protection: Up-front setting of rates is locked now, so businesses can budget accordingly for future renewals and improve cost predictability in future years.
Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.
It works great for project management and putting all job-specific documents in one place. We are able to share drawings, submittals, and forms with our customers and subcontractors in a safe and reliable platform. However, getting reporting data is somewhat lacking, so if your business needs advanced options, you might try and find a better product.
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
We will undoubtedly renew Procore as it has proven itself to be a means to better track and improve upon our efficiency and communications between job sites and their project managers as well as all other departments. Procore has made an incredible impact on how we, as a company, do our job on all levels; it is one of our most powerful and effective resources.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
90% of Procore is very intuitive and any user can pick it up and go. There are a few elements, more so on the Financials side that need some prior knowledge of systems in order to understand how and why it functions as it does. Once this is understood, it flows effortlessly
If you are working in an area with little to no signal, Procore will still allow you to get in the system and use it fully and will then update once you are at a place with a strong enough signal. Whether it be with wifi or LTE cell phone reception.
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.
General Support for Project Management and Financials is consistent. The ERP support is never consistent and I do end up at times in a black hole. I have to continually reach out to get the issue resolved or get an update. The ERP support needs more of Procore's attention
Procore's Implementation Team does a great job of ensuring users are confident in using the system. They run through a process of training sessions based on the tools you have purchased, and lay ou ta plan to help the power users configure the tool to suit the company's needs. They provide useful resources for certifications, support and ongoing training as well.
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Procore's certification program and focused how-to training videos allowed for easy training that did not feel overwhelming. The way the certification programs were broken up into small parts made it seem much less daunting to complete. The training feels focused and does not overload users with too much information all at once.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
Iron out your cost code list in your accounting software before you link with Procore. Once the link is established that list is more or less permanent. Review the permission matrix carefully. It controls so much. You want to ensure the information provided to your users adequate but you also want to protect your sensitive data. Procore Financials are organized in a total contract value style. Any markup or Profit will need to be sent somewhere on your budget. This may be significantly different than the Cost budgeting that many contractors do
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
Procore has a clearer user interface and a wider variety of tools than any program I've used. Procore also lives up to their name in terms of helpful and fast customer service. There is always a Procore rep. that is available to contact, making any problems just a mini hurdle.
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
