Case Studies: Eposability

As a result of adopting Snowflake and Matillion ETL, Eposability now has a robust, meta-driven BI solution. Data warehouse refresh and extraction into Power BI used to take 30 minutes per client – now it takes 3 minutes.

Their success

1

Data refresh & extraction into Power BI cut from >30 minutes per client to <3 minutes total

2

Embeded business logic in ETL so that a single version of the truth is served to Power BI

3

Created a single client dashboard with row level security so each client sees their data only

About

Eposability launched over a decade ago, initially providing traditional IT support & consultancy services to a large UK retailer before focusing on the hospitality technology and restaurant consultancy services sector. Today, Eposability challenges the perception of technology as merely a tool. In their experience, leading hospitality focused technologies as well as expert insight services, when correctly implemented, deliver undeniable value to their hospitality clients and catapult expansion.

Company: Eposability

Location: London, England

Industry: IT Support Services - Hospitality

Employees: 1-50

Product: Matillion ETL for Snowflake

Use Case: Data Warehouse Modernization

Website: https://www.eposability.com/

The challenge

With a client base consisting of over 200 companies, serving in excess of 36,000 people per day, Eposability’s clients amass a vast amount of data relating to orders, accounts, menus, staff, and payments. Robbie Francis, Managing Director of Eposability, knew his clients could gain a much deeper understanding of their business if they could better leverage this data. Eposability’s implementation of Power BI dashboards for its clients was a step in the right direction, but there were still some limitations in this approach that needed to be solved in order to develop a simplified and scalable business intelligence solution for its clients.

The solution

Eposability engaged Altis Consulting, a vendorindependent Data & Analytics specialist. Together, Eposability and Altis jointly designed a solution that removed Eposability’s limitations and freed up its team to focus more valuable projects for its clients. The solution developed by Altis and Eposability included selecting Snowflake as the cloud data warehouse provider, and Matillion ETL for Snowflake as the product to move data into Snowflake as well as perform the necessary transformations to make client data ready to be consumed by Power BI, enhancing its performance. In addition, both Snowflake and Matillion offered a pay-as-you-go model that fit with Eposability’s business model.

The benefits

As a result of adopting Snowflake and Matillion, Eposability now has a robust, metadata-driven business intelligence solution that has been rolled out to many of its existing clients. Snowflake’s cloudbased infrastructure has proven to be a good fit for Eposability’s requirements based on its performance and the pay-as-you-go pricing model allows Eposability to scale this solution easily as its client base grows. In addition, Eposability has been able to self manage their solution from go-live without having to call on Altis for support. Onboarding new clients takes only a few minutes and those clients can access their dashboards the very next day!

The results

  • A single client dashboard with row level security so each client sees their data only.

  • Data Warehouse refresh and extraction into Power BI cut from >30 minutes per client to <3 minutes in total.

  • Business logic embedded in ETL (back end Data Warehouse refresh) so that a single version of the truth is served to Power BI.

  • All Infrastructure hosted in the cloud.

  • Ability to scale the solution on demand.

  • Matillion supports incremental loads, rollback processes, error management, etc.

What's next

Based on the success of its initial roll-out, Eposability is continually making incremental enhancements to its business intelligence solution, and embarking on larger projects such as, ingesting additional data sources from other 3rd parties and augmenting this data by using Matillion in order to enrich existing and new reports.

About our partner

Altis

Altis is a Data and Analytics consultancy built on the philosophy that their people make their business and their clients’ businesses successful. Combining industry expertise, technical skill, communication and listening, the Altis team delivers results to maximize your business performance.

Begin your data journey

Matillion provides simple, powerful, easy to use data integration and ETL products that enable your company's data journey.