Custom Business Intelligence Solutions

1 Billion Rows of Analytics Data

A horse racing startup needed to run reports and analysis on the data they were collecting from various API sources. We setup a complete ETL infrastructure, including data warehousing built with PostgreSQL and AWS, allowing them to quickly query and pull the business insights they need.

Screenshot of a database query

Funnel Data From One Service To Another

Our customer is an industry leader and top-tier provider of rail related services. They engaged us to develop custom software to help them track the training their 1100+ employees required and completed. They needed to funnel this data into their business intelligence solution so they could analyze the data for compliance and trends across their 1100+ employees.

Learn More

Migrate Away From Legacy Analytics

With many years invested in a legacy analytics tool that was no longer supported, our client needed to find a replacement that would allow their business users to continue to analyze and evaluate Key Performance Indicators (KPIs) and to pull reports for organizational activities and data. We designed and built a data warehouse and developed numerous (ETL) processes to organize and move data from their operations database into the data warehouse. We built an ETL framework that shared libraries with the operations database to cut down on development time and prevent errors caused by the ETL data models and operations data models getting out of sync.

Learn More