Delivered Single Source of Truth

Case Study

About the client

The client is a hospitality company specializing in restaurant operations services with a mission to give the guests a one-of-a-kind experience that they can expect time and time again. Through strong dedication and integrity for their line of restaurants.

Industry

Hospitality

Revenue (USD)

Million

Head Count

Employees

Countries Of Operation

US

Overview

The client believes in serving the best food and creating a unique experience for their guests.
The primary objectives revolved around assisting the client in optimizing their data management and reporting processes.
For example: Instance Setup and Integration, Federated Data Integration, Data Connection Strategy, etc.

Challenges

Difficulty in transforming federated datasets to make them compatible with the clients reporting requirements.
Challenges in connecting and aggregating data from different platforms into the federated datasets.
Limitations in the availability of data from existing connectors in DOMO.

Tools and Technologies

Domo Connectors were used for data integration and visualization, Python was employed for scripting and automation and MagicETL enabled federated dataset functionality.

Impact

The implementation of BI, alongside Python automation and a change in the production environment, resulted in significant benefits:

Enhanced data transformation and integration processes improved data quality and reliability.

Automation reduced manual efforts and accelerated the reporting cycle.
PDP automation ensured data security and compliance with privacy regulations.
Executives and stakeholders gained access to real-time insights, facilitating more informed strategic decisions.
Transitioning to a new instance without additional charges provided cost savings for the client

Solution

Analysis

The BI tool was crucial in overcoming challenges with federated data, improving the client's dashboards by addressing limitations in data transformation and integration, enhancing overall effectiveness.

Implementation

Instance Production Environment Change: To enable data sharing, the client and their partner transitioned to a shared production environment. A new clean instance was established for the client at no extra cost

Data Connection Strategy

Restaurant365: An email connector was used to obtain required data due to limitations in the existing BI connector. Toast POS: Efforts were underway to develop a custom connector to enhance integration. Email Connector: This connector was set up to ensure timely data updates in JRI's instance. PDP Automation: A Python script automated the application of PDPs to datasets, streamlining permission management with pre-defined rules.