#Japan #Tokyo #POS System #Marion Crepes #Looker Studio

Introduction

Marion Crepes, a prominent crepe retailer in Japan, has successfully embarked on a journey to streamline its massive data management through advanced integration and data analytics solutions. With approximately 100 stores across the nation, both directly operated and franchised, Marion Crepes faced challenges due to the ever-growing volume of scattered data as they expanded their business.

Addressing Data Dispersal with Integration

Given the issue of data being spread across various systems, our company took the initiative to seamlessly integrate this data. Our first step was to connect the Point of Sale (POS) systems, attendance management systems, and core business systems with a Data Warehouse (DWH). By utilizing Robotic Process Automation (RPA), we established automated updates for data, effectively enhancing both data integration and quality.

Additionally, the implementation of RPA automated daily and monthly report creation tasks, resulting in a significant reduction in the workload for store employees.

BI Implementation for Enhanced Visibility

Following the data integration, we introduced Looker Studio, a Business Intelligence (BI) tool, to capitalize on the newly amalgamated data. The BI dashboard sourced from this data allowed us to visualize previously monitored Key Performance Indicators (KPIs) while incorporating new metrics for observation. Consequently, Marion Crepes was able to accurately manage sales and cost of goods on a store-by-store basis, paving the way for improved operational efficiencies and effective strategy formulation.


Masked BI Dashboard Example

Future Prospects for Data Utilization

Now that Marion’s data analytics infrastructure is live, the next step is to expand the data integration to cover franchise stores and further maximize the use of the integrated data. We are considering several initiatives involving the utilization of AI, including:

• - Demand Forecasting with AI: Optimizing orders for crepe ingredients based on accurate demand predictions.
• - Cost Rate Alert System: Creating a system using AI and mathematical optimization for alerting cost rates.

Our company remains committed to supporting Marion Crepes as they expand their data analytics infrastructure and leverage AI and other technologies for effective data utilization.

Conclusion

In an industry where efficiency can significantly impact profitability, Marion Crepes’ proactive approach to integrating and analyzing data is setting a benchmark. By embracing modern technologies, they are not only optimizing their operations but also preparing to harness the power of data for future advancements. We look forward to continuing our partnership with Marion Crepes and contributing to their journey towards data-driven excellence.