This week, I’ve been diving deep into one of my favorite topics: Data Sovereignty and the “Art of the Possible.” I was working with a global partner on a challenge many large-scale operations face—how to get highly specific, multi-site contractor hours reports out of their system and into their executive dashboards.
Every business has a different “flavor” for how they want to see this. Some need it by project code, some by geographic region, and some by safety risk category. If you try to force that into a standard, “out-of-the-box” report, you’ll usually find yourself frustrated by the limitations.
The Secret Sauce: The Webhook
The solution we discussed isn’t about clicking a “Download CSV” button. It’s about Automation. We walked through how to use a Webhook to pull raw sign-in and sign-out data directly from OnLocation the moment it happens. Instead of the data sitting idle, it’s “pushed” instantly into the customer’s own environment.
BigQuery vs. Snowflake: It Doesn’t Matter the “Bucket”
At Time & People, our “brain” of choice is BigQuery. For this particular partner, their ecosystem lives in Snowflake.
The beauty of a modern data stack is that the destination doesn’t change the value of the journey. Once that raw data hits your warehouse—whether it’s Snowflake, BigQuery, or Redshift—the “Software Walls” disappear.
Enter: The Mathematical Gymnastics
I told our partner that once the data is in your warehouse, the rest is just “Mathematical Gymnastics.” When you have the raw timestamps, you can manipulate, pivot, and calculate that data any way you want. You can:
- Cross-reference hours against specific site safety inductions.
- Compare contractor time-on-site against project milestones.
- Build custom “Fatigue Alerts” based on rolling 7-day totals.
Your Data, Your Way
At Time & People, we see two types of successful customers:
- The Do-It-Yourselfers: Customers who have their own data science teams and want the raw feed to build their own proprietary magic.
- The “Done-For-You” Crowd: Customers who ask us to perform the gymnastics for them and deliver the finished reports.
The moral of the story? You should never be a prisoner to your software’s reporting tab. It’s your data. You gathered it. You own it. And with a little bit of “gymnastics,” you can make it tell whatever story your business needs to hear.
