Data Engineering
Bento

Building a data lake and visualizations

Sector:
Business Technology
Our Role:
Web Application Development, Data Engineering for Python and SQL
Outcome:
The most complete B2B payments solution that enables Businesses to issue physical and virtual payment credentials to people and systems.

We needed to wrangle some complex data engineering and visualization and our team was swamped. 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.

Sean Anderson
Chief Operating Officer
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. 

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 transform customer data into star-schema, we created dashboards and extensive filtering options and we identify usage patterns for different customer cohorts and successfully modify both their marketing and product offerings, as well as their financial planning accordingly.

At the end, we provided actionable insight into the substantial growth of the business creating more management and board level visibility

benefits

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.

More of our Work

Tool and strategies modern teams need to help their companies grow.