LegionellaDossier
When you're experts at helping businesses maintain safe water systems, you understand the value of good monitoring. LegionellaDossier's 30-person team was already delivering exactly that to their customers through their specialized software. Now they were ready to bring that same level of clarity and insight to their own business data.
The challenge
Imagine inheriting a complex data system that only one person understood - and that person had left the company. That's exactly what LegionellaDossier was dealing with. Their data was scattered across various open-source tools, filled with unused tables, and different teams were working in isolation. Getting clear insights about sales or customer success? Nearly impossible.
How we fixed it
We stripped everything back and rebuilt it the right way:
- Moved everything to BigQuery (think of it as their new, organized data home)
- Added Stitch to automatically collect data (no coding expertise needed)
- Transformed their complex production data into something everyone could understand
- Created a simpler, more efficient way to organize their data (tech folks call this a star schema)
- Built easy-to-use dashboards in Looker Studio where teams could dig into the details they needed
- Set up special data views for different teams (like finance) so they could work with the numbers their way
What changed
Like running water through a purification system, the transformation was had great results:
No more need for self-hosted Airflow and PostgreSQL. Developers are not needed for data work anymore.
Their data warehouse became much cheaper to run (who doesn't love saving money?)
Everyone could track where numbers came from and trust what they were seeing
Reduced data processing time by 97%
Conclusion
LegionellaDossier went from having a data system they couldn't control to one that actually helps them grow their business. What's really cool is that we didn't just fix their immediate problems - we set them up to handle whatever comes next. Their teams can now focus on growing the business instead of wrestling with data. If you're stuck with a complex data setup that's giving you headaches instead of insights, let's talk. Sometimes you need to strip things back to basics to move forward.
.png)
