With advanced business intelligence requirements in mind, Quid’s main priority was to automate data collection from disparate data sources, without requiring significant engineering resources. “All of the tools we use have data. Being able to connect all that data in a way to understand what’s working and what’s not is critical to the growth of our business.” According to Kate Wiggin, VP of Business Operations: “We (as the Analytics function within the org) are keen on empowering people with data they need to make day-to-day decisions.
"Alooma provides the flexibility we need: just the right balance between being able to automate changes with the click of a button"
Data needs to reliably flow from Salesforce, MySQL (product user data), Google Analytics, Hubspot (for marketing), Greenhouse (for recruiting), and Zendesk (for support) into an Amazon Redshift data warehouse which underpins our business intelligence solution.” Quid stressed the importance of data integrity and reliability. For example, Kate’s team wanted to correlate the recruiting team’s data for new hires with performance data of the new hires over time in order to optimize company’s talent acquisition and training processes.
“Alooma provides the flexibility we need: just the right balance between being able to automate changes with the click of a button, yet working with embedded Python code to easily transform the data as much as we need on the fly. All without requiring any engineering resources to build the data collection infrastructure.” Wiggin explained.
Alooma made Quid’s “dream business intelligence” infrastructure a reality, enabling the company to make crucial business decisions--all while saving the Quid team development time and significant engineering costs.
“We were able to get data from many sources into Redshift very quickly. The speed at which the data is available is amazingly fast.”
Additionally, Alooma’s automated error handling ensures data integrity and allows for graceful recovery from any errors. Consolidation and having all the data in near real-time has created a shift in culture at Quid; anyone on the sales, marketing, and support teams can now leverage the data as necessary without having to engage engineering resources for help. With the Alooma platform replacing the manual workflows and reports, engineering and business intelligence staff has been relieved of the drudgery of data movement, and can focus entirely on delivering insights. Quid achieved the company’s data-driven business requirements by utilizing the Alooma platform without incurring additional engineering costs. “With Alooma, we move all of our data without using in-house engineering resources.”