Data Management

/Restaurant Chain

BI Infrastructure Design and Implementation for a Restaurant Chain

How our Data Management solutions led to 90% reduction in effort to track business performance

Overview

Client is a Michelin star restaurant chain spread across Southeast Asia.

There was an opportunity to improve reporting infrastructure to track KPIs across data sources, geographies and functional areas such as Strategy, Marketing, Finance and Operations.

Merilytics partnered with the client to design and build an integrated data warehouse, data cubes and executive level dashboards that are updated automatically on a daily basis.

Consolidated different data sources (ERP – Ascentis, POS systems – Acewill, Seito), and built an integrated data warehouse
Defined KPIs and built data cubes to track Sales, P&L, Inventory, Production and Supply Chain performance, and also enable efficient data management
Designed, developed and deployed 30 distinct dashboards on Power BI to track performance by department and provide transparency on business performance to the Management team

The reporting infrastructure and dashboards supported critical decision making for the Management
On average, 90% reduction in time taken to manage the data and gain visibility into the business performance
Six weeks turnaround time for BI Transformation

90%

reduction in effort

30

executive reports automated

Six weeks for BI Transformation

Thank you all for the support for the past year. Really enjoyed working with the team. You guys always made me feel “No Fear!” knowing how strong and supportive the team is.

Senior Executive – Strategy & Analysis