Now Available On-Demand | AI. The Future of Data Engineering - Today. Not Just Tomorrow.

Watch now
Back to all
Eposability logo

Robust, metadata-driven business intelligence

Eposability banner

1/10

time needed

for data warehouse refresh & extraction

One

version of the truth

served to Power BI

100%

infrastructure

hosted in the cloud

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:

Location:

Industry:

Employees:

Product:

Use case: 

Website:

Eposability

London, England

IT Support Services-Hospitality

1-15

Matillon ETL for Snowflake

Data warehouse modernization

eposability.com

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.

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 solution as a whole brings real benefit to our client base and is a real differentiator for our business in such a busy market place. It’s incredible that Big Data is now so accessible to even the smallest of businesses, and we see that businesses leveraging this for decision making are growing a lot faster than those not. With the groundwork complete, the real challenge is to continue to discover the value hidden within the data.

 

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.

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 solution as a whole brings real benefit to our client base and is a real differentiator for our business in such a busy market place. It’s incredible that Big Data is now so accessible to even the smallest of businesses, and we see that businesses leveraging this for decision making are growing a lot faster than those not. With the groundwork complete, the real challenge is to continue to discover the value hidden within the data. Robbie Francis Managing Director| Eposability