Support for Data Integration and Data Analysis Platform Construction at Major Crepe Shop 'Marion Crepes'

'Marion Crepes' Logo We supported Marion Co., Ltd., which operates the major crepe shop 'Marion Crepes.' Marion Co., Ltd. has approximately 100 'Marion Crepes' stores nationwide, including directly managed stores and FC stores, and felt challenged by the scattered data that had become enormous with store expansion. Visualization of Sales and Cost of Goods Sold through Data Integration In response to the scattered data, we first started with data integration. By linking POS / attendance management systems / core systems with DWH and realizing automatic data updates with RPA, we were able to achieve data integration and improve data quality. In addition, the implementation of RPA also automated daily and monthly report creation tasks for stores, leading to a reduction in employee workload. After data integration, Looker Studio was introduced as a BI tool. The BI dashboard uses the integrated data as a source, and in addition to visualizing conventionally observed KPIs with BI, new indicators were also added. This enabled accurate management of sales and cost of goods sold for each store, establishing a system for rapid store operation improvement and policy planning. Part of the actual BI screen: Masked Future Outlook for Data Utilization - Building AI-powered Demand Forecasting and Cost of Goods Sold Alert Systems Currently, Marion Co., Ltd.'s data analysis platform is in full operation, and future plans include expanding to FC stores and utilizing the integrated data. The following initiatives are being considered for future data utilization: Optimizing order quantities for crepe raw materials through AI-powered demand forecasting Building a cost of goods sold alert system using AI and mathematical optimization We will continue to support Marion Co., Ltd. in expanding its data analysis platform and utilizing data, including AI, in the future.