Case Study: Twist Bioscience achieves a single source of truth and faster reporting with KPI Partners, Tableau, Snowflake and Matillion

Twist Bioscience automates SAP reporting with KPI Partners, loading data 4 times a day

Twist Bioscience, a public company that manufactures synthetic DNA, faced a significant challenge with its reporting on financial, sales, and operations data from SAP, Salesforce, and in-house systems. The process was cumbersome and time-consuming, with reports from multiple sources failing to agree, necessitating a single source of truth. They selected KPI Partners for the vendor's expertise in BI, data warehousing, Tableau, Matillion, and cloud technologies to assist in their migration from Redshift to Snowflake.

KPI Partners implemented a solution using Tableau for statutory and management reporting and Snowflake with Matillion for data architecture. They configured incremental SAP data extracts, streamlined the ETL process with Matillion, and automated incremental loads four times daily. For Twist Bioscience, this resulted in a consolidated single source of truth, accelerated internal reporting, automated report distribution to top management, and improved budget vs. actual financial reporting.

Twist Bioscience