How a Managed IT Service Provider in Calgary Helped a Construction Company Unlock Better Reporting Without APIs
At Tursa Group, we’re often brought in when businesses hit a technology wall—when their systems work individually but don’t communicate with each other. As a managed service provider in Calgary, we specialize in solving exactly these kinds of challenges using automation, data integration, and smart use of existing tools.
This case study highlights how we helped a construction company modernize their reporting without replacing their core platform or relying on APIs.
The Challenge
One of our construction clients in Calgary was using Buildtopia as their construction management platform. While it handled day-to-day operations well, it had a major limitation:
- No APIs or native integrations
- No direct way to connect Buildtopia data to other systems
- The only export option was manual Excel reports
The client wanted custom dashboards to track multiple construction projects in one place. However, manually downloading reports and rebuilding dashboards each day was inefficient, especially for an executive responsible for high-level oversight.
They reached out to Tursa Group to see what was possible.
The Solution
As an experienced managed service provider in Calgary, we knew automation was still achievable, even without APIs.
We designed a solution using Microsoft Power Automate, Power BI, and SharePoint to fully automate the reporting workflow.
Here’s how it worked:
- Custom Reports in Buildtopia
Three custom Excel reports were created within Buildtopia to capture the required data. - Automated Data Collection (3:00 AM Daily)
Power Automate logs into Buildtopia as a designated user at 3:00 AM and automatically downloads the reports. - Data Transformation & Dashboard Creation
Power BI consolidates the data, performs extract-transform-load (ETL) operations, and builds a unified dashboard. - Automatic Publishing to SharePoint
The updated dashboard is published to a specific SharePoint page.
By 6:30 AM, when the team arrived at work, the dashboard was already live with the most up-to-date data from the previous day, with no manual effort required.
The Results
The impact was immediate:
- 2.5+ hours saved per week (conservative estimate)
- 125+ hours saved per year
- Approximately $5,300 in annual cost savings for an executive role
More importantly, that time was redirected toward higher-value work:
- Analyzing project performance
- Identifying risks earlier
- Making data-driven recommendations
- Keeping construction projects on track
Why This Matters
This automation was included as part of our managed IT services, as we didn’t charge extra. As a managed service provider in Calgary, our role goes beyond IT support and cybersecurity. We actively look for ways to:
- Improve operational efficiency
- Reduce manual, repetitive work
- Optimize how data flows through an organization
We believe technology should work for the business, not slow it down.
As we often say, business success comes from small, incremental improvements sustained over time. When solutions like this are applied across multiple processes, the savings can easily reach $60,000 per year, roughly the equivalent of one full-time employee, depending on salary.
Final Thoughts
If your organization relies on manual data exports, disconnected systems, or repetitive reporting tasks, it may be time to re-evaluate how your tools work together. Even without APIs, there are almost always ways to automate and improve efficiency with the right managed service provider in Calgary by your side.