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