About Twist Bioscience
Twist is a public company that manufactures synthetic DNA for clients in the biotechnology industry.
Customer Need / Business Driver
Reporting on Financial, Sales and Operations data from SAP, Salesforce and in-house systems was cumbersome and time-consuming. Results didn’t agree across multiple reports and needed consolidation to a single source of truth. They needed assistance in migrating from Redshift to Snowflake.
Company evaluated many consulting companies but selected KPI Partners because of KPI’s expertise in BI, Data DW, Tableau, Matillion and Snowflake along with cloud technologies. In addition, KPI proposed a team with 100% offshore team resources to minimize cost and risk for the customer.
What KPI Delivered - Tableau
- Statutory and Management reporting for Finance using Tableau.
- Primary revenue dashboard which is consumed by top management
- Developed Backlog reports on Snapshot data which is built using ETL
- Creative Visualizations for financial and sales data
What KPI Delivered – Snowflake and Matillion
- Proposed Snowflake architecture
- Configured SAP extracts to extract the data out of SAP incrementally
- Streamlined and Standardization of ETL process using Matillion. Configured to schedule incremental loads 4 times everyday
- Automated ETL process with no manual intervention
- Developed framework using Matillion to gather ETL statistics
- Consolidation of similar data from multiple source to have single source of truth
- Accelerated the process of internal management reporting
- Automated report distribution to top management
- Budget vs. Actual reporting for improved financial management