Consolidating Apps and Data at Gainsight with a Cloud Data Warehouse| Persistent Systems

Consolidating Apps and Data at Gainsight with a Cloud Data Warehouse

Here’s how Gainsight accelerated insights development by consolidating multiple data sources into a single cloud data warehouse in under 4 months.

Challenges

Gainsight, a leading customer success software provider, 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 related reporting requirements to a cloud-based warehousing and reporting system
  • Inefficient reporting due to multiple manual Excel-based reporting methods
  • Need for a centralized data lake catering to future reporting needs at minimal cost

“Persistent helped us accelerate insights development and dashboards for business users by modernizing our data stack in under 4 months.”

Karl Mosgofian, CIO Gainsight
Outcomes
  • Modernized data stack in under 4 months
  • One warehouse now takes care of all inter-app reporting needs.
  • Eliminated Excel-based manual reporting
  • Gained the ability to maintain a single copy of data without any issues with timing or disparate data feeds
  • Enabled lightning fast processing of data
Technologies Used
  • Moved to a cloud-native data warehouse
  • Used an intelligent automation platform to extract and load data from app to the cloud data warehouse
  • Enabled landing of data in the staging layer of data lake
  • Transformed data from staging to EDW-core using the cloud data warehouse’s SQL scripts
  • Created views from EDW-core per reporting requirements
  • Connected views to Tableau online

Contact us

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

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