Hitachi Vantara (Hitachi) Case Studies Data Reliability Supports Real-time Reporting & Analytics for Bing Lee

	Data Reliability Supports Real-time Reporting & Analytics for Bing Lee Hitachi Vantara (Hitachi)

Data Reliability Supports Real-time Reporting & Analytics for Bing Lee

Hitachi Vantara (Hitachi)

Technology Category	Application Infrastructure & Middleware - Data Exchange & Integration Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries	Electronics Retail
Applicable Functions	Quality Assurance Sales & Marketing
Use Cases	Inventory Management Retail Store Automation
Services	Data Science Services System Integration
Challenge	Bing Lee, a consumer electronics retail chain in Australia, was facing a significant challenge in integrating business data during a complex digital transformation project. The company's legacy ERP had become a highly customized system, dependent on a single point of failure. Its data was unstructured, and problematic processes were making the data generated by the system unreliable. Bing Lee invested in a new cloud-based ERP and developed their own Point of Sale (POS) system. A new reporting tool was also selected to improve user experience for employees. However, the transition to the new ERP was slowed down by the Covid-19 pandemic, and the company's sales and number of transactions substantially grew, increasing the volume of data through its systems. Read More
About Customer	Bing Lee is a consumer electronics retail chain with more than 35 stores across New South Wales, Australia. Family-owned and founded in 1957, Bing Lee is known for affordability and a radio jingle that has become part of the local pop culture. Its annual turnover is almost 500 million AUD. Though a traditional family business, Bing Lee recognized a need to change with the times and began a technology transformation. The company invested in a new cloud-based ERP and developed their own Point of Sale (POS) system. A new reporting tool was also selected to improve user experience for employees. Read More
Solution	Bing Lee decided to use BizCubed’s Data Engineering and Enablement Platform (DEEP) for data management, with Hitachi Vantara’s Pentaho Data Integration (part of the Pentaho Platform Suite) as the engine for ETL design and orchestration. This solution is provided as-a-service, which allows Bing Lee to continually update its data processing at the pace of business. The project team uses Pentaho to generate ETL processes that successfully merge and blend daily reporting data from two ERP solutions and more than 45 different API sources. BizCubed’s methodology provides a framework for rapid data acquisition, monitoring, recovery, and governance. This means that Bing Lee can have confidence in the reliability and accessibility of its data, every single day. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Data Exchange & Integration

Functional Applications - Enterprise Resource Planning Systems (ERP)

Applicable Industries

Electronics

Retail

Applicable Functions

Quality Assurance

Sales & Marketing

Use Cases

Inventory Management

Retail Store Automation

Services

Data Science Services

System Integration

Challenge

Bing Lee, a consumer electronics retail chain in Australia, was facing a significant challenge in integrating business data during a complex digital transformation project. The company's legacy ERP had become a highly customized system, dependent on a single point of failure. Its data was unstructured, and problematic processes were making the data generated by the system unreliable. Bing Lee invested in a new cloud-based ERP and developed their own Point of Sale (POS) system. A new reporting tool was also selected to improve user experience for employees. However, the transition to the new ERP was slowed down by the Covid-19 pandemic, and the company's sales and number of transactions substantially grew, increasing the volume of data through its systems.

About Customer

Bing Lee is a consumer electronics retail chain with more than 35 stores across New South Wales, Australia. Family-owned and founded in 1957, Bing Lee is known for affordability and a radio jingle that has become part of the local pop culture. Its annual turnover is almost 500 million AUD. Though a traditional family business, Bing Lee recognized a need to change with the times and began a technology transformation. The company invested in a new cloud-based ERP and developed their own Point of Sale (POS) system. A new reporting tool was also selected to improve user experience for employees.

Solution

Bing Lee decided to use BizCubed’s Data Engineering and Enablement Platform (DEEP) for data management, with Hitachi Vantara’s Pentaho Data Integration (part of the Pentaho Platform Suite) as the engine for ETL design and orchestration. This solution is provided as-a-service, which allows Bing Lee to continually update its data processing at the pace of business. The project team uses Pentaho to generate ETL processes that successfully merge and blend daily reporting data from two ERP solutions and more than 45 different API sources. BizCubed’s methodology provides a framework for rapid data acquisition, monitoring, recovery, and governance. This means that Bing Lee can have confidence in the reliability and accessibility of its data, every single day.

Impact #1	Bing Lee now has a low-risk data management platform that is reliable and accessible for its analysts and managers. Rather than waiting for all of the required ETL logic to be engineered so it could all “go live” at once, individual ETL processes were built, put through user acceptance testing and moved to production as soon as they were ready. Up to two dozen complete, new processes went live each week, with new reporting capabilities accessible to users every day. This complex digital transformation was supported with minimal disruption, and an effective staged approach moved dozens of data processing changes through testing to production, weekly.

Impact #1

Bing Lee now has a low-risk data management platform that is reliable and accessible for its analysts and managers. Rather than waiting for all of the required ETL logic to be engineered so it could all “go live” at once, individual ETL processes were built, put through user acceptance testing and moved to production as soon as they were ready. Up to two dozen complete, new processes went live each week, with new reporting capabilities accessible to users every day. This complex digital transformation was supported with minimal disruption, and an effective staged approach moved dozens of data processing changes through testing to production, weekly.

Benefit #1	Reduced data processing time for ETLs from 3-4 hours to 1 hour.
Benefit #2	Improved stability of environment, giving nearly 100 users access to reliable data for hundreds of reports.
Benefit #3	Successful blend of data from old and new systems during extensive digital transformation project.

Benefit #1

Reduced data processing time for ETLs from 3-4 hours to 1 hour.

Benefit #2

Improved stability of environment, giving nearly 100 users access to reliable data for hundreds of reports.

Benefit #3

Successful blend of data from old and new systems during extensive digital transformation project.

Download PDF Version

Overview

Data Reliability Supports Real-time Reporting & Analytics for Bing Lee

Operational Impact

Quantitative Benefit