Nearshore Software Development
Download Full Case Study
Development Expertise
Outsourced Services
Bento, a company with a strong commitment to understanding their customer's specific product usage patterns, was grappling with the challenge of disjointed and widespread data. This data held the key to drive their marketing and financial decisions, but accessing it in a meaningful way proved challenging. Their dataset was scattered across numerous internal databases and tables and lacked the format necessary for easy integration with prevalent BI platforms like Tableau, Looker, or Chartio.
Bento offers Bento’s financial operating platform enables businesses to issue physical and virtual payment credentials to people and systems without introducing risk while providing companies unprecedented control and visibility over their B2B expenses and company spend. Open APIs, and White Label partnerships extend these control and management benefits to automate payments well beyond expenses alone. The company was successfully acquired by Union Bank of California
Azumo came in with a dedicated team that quickly grasped our problem and designed and built our data integration solution. They delivered a clearer picture for our business in a timeframe I didn’t think was possible.
The Challenge
Bento knew their customers had specific usage patterns for their product, but wanted to drive more informed marketing and financial decisions based on a considerable amount of usage data they had available.
They want this data to be portrait in an easy to analyze-more fashion way, they wanted a BI platform instead of just numbers. However, the existing data set was spread over dozens and dozens of internal databases and tables. Moreover the data was not readily available in a star-schema format to be ingested by typical data visualization and modern Business Intelligence (BI) tools.
The Solution
We came in with a dedicated team consisting of an architect, one developer and a systems analyst.
Based on Bento’s selection for the underlying data visualization platform, we transformed their customer data into a star schema, created dashboards and extensive filtering options and identified usage patterns for different customer cohorts and successfully modified both their marketing and product offerings, as well as their financial planning accordingly.
In the end, we provided actionable insight into the substantial growth of the business creating more management and board-level visibility.
Azumo came in with a dedicated team that quickly grasped our problem and designed and built our data integration solution. They delivered a clearer picture for our business in a timeframe I didn’t think was possible.
Complete Data Team
We provided a dedicated team consisting of an architect, one developer and a systems analyst.
Star-Schema
Based on Bento’s selection for the underlying data visualization platform, we transformed their customer data into a star-schema.
Built Data Visualizations for Improved Data Exploration
We created dashboards and extensive filtering options so we and them could identify usage patterns for different customer cohorts. Bento used this information to successfully modify both their marketing and product offerings.
Bento was Acquired
Ultimately Bento leveraged their business performance into a successful sale to US Bank
Getting Results
Technical Details
Azumo implemented and scheduled a number of batch jobs to transform PII expunged customer data into a star-schema that allowed any BI platform to quickly visualize and drill down the data. Bento selected Chartio as the underlying platform for data visualization. Azumo also created within Chartio, a number of interactive dashboards with extensive filtering so that Bento could quickly isolate any given pair of data cohorts and generate comparison metrics and visualizations.
