Client Success

Building a Modern Cloud Data Warehouse

Challenges

Leading customer success software provider Gainsight wanted to move to a single cloud-based data warehouse to simplify and speed-up reporting.

  • Multiple cloud solutions across business functions – Salesforce, Financial Force, People.ai, Expensify, Sage Intacct, UltiPro.
  • Desire to consolidate all inter-application reporting needs into a central system.
  • Inefficient reporting due to multiple manual excel-based reporting methods.

Solutions

  • Moved to a cloud-native data warehouse.
  • Used an intelligent automation platform to extract and load data from applications to the cloud data warehouse..
  • Re-wrote SQL scripts using the cloud data warehouse’s native script to transform data.
  • Created multiple views into the data warehouse to support numerous reporting requirements without usage contention issues.
  • Connected views to Tableau online.

Outcomes

4 months

to deploy a modern data stack

1 warehouse

for all inter-app reporting needs

Enabled lightning-fast

processing of data

Eliminated

Excel-based manual reporting

Contact us

    You can also email us directly at info@persistent.com.

    You can also email us directly at info@persistent.com