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

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

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
The 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 The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • Reduced data processing time for ETLs from 3-4 hours to 1 hour.
  • Improved stability of environment, giving nearly 100 users access to reliable data for hundreds of reports.
  • Successful blend of data from old and new systems during extensive digital transformation project.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.