Onix Spearheads a Comprehensive GCP Data Warehouse Modernization for Batteries Plus

"Onix was engaged to overcome the lack of internal expertise with BigQuery and Looker implementations — and the management of data security."

Batteries-Plus-Bulbs-Logo-Digital

PROJECT SCOPE

INDUSTRY
Retail
 
SERVICES USED

GCP

cloud-vpn-512-colorpub_sub-512-colordataflow-512-colorcloud-functions-512-colorbigquery-512-color

About the Customer

Founded in 1988 in Green Bay, Wisconsin, Batteries Plus is the nation’s largest and fastest-growing battery franchise, with 700+ locations throughout the United States. Their stores serve millions of customers and have access to tens of thousands of products, from every day to the hard-to-find. Customers appreciate convenient services such as battery testing, phone repair, key fob programming and much more.

Customer Challenge

The company wanted to enable real-time insights into sales performance and inventory for their franchise stores. Their highly complex legacy Azure data warehouse and EDW environment for E-Commerce, accounting, CRM, ERP, product and inventory, POS systems and approximately 300 databases, integrations and nightly maintenance jobs presented challenges to produce real-time data. After a disappointing attempt to gain near-real time data using Birst, the company decided to move to GCP. Onix was engaged to overcome the lack of internal expertise with BigQuery and Looker implementations — and the management of data security.

Partner Solution

Onix conducted a data strategy and design engagement and led the implementation. Since the data warehouse and real-time data pipeline would include Corporate and Franchise owner stores nationwide to connect to the existing order management process, BigQuery was the best option for data management.

The Data Strategy engagement focused on requirements analysis, design, a roadmap and the backlog — and on governance and creating an operations plan. The implementation centered around the data pipeline, schema, queries, data security — and hooking up a Looker dashboard before a handoff to the customer's operations team.

Onix used Google Pub/Sub to facilitate asynchronous streaming functions to ingest data from Azure and create publisher and subscriber event streams — systems of event producers and consumers — and Google Cloud Dataflow to facilitate and optimize the streaming pipelines.

Ongoing MSP-managed data operations to help the customer maintain and optimize the EDW environment were also provided by Onix.

Impact and Results

Batteries Plus executive leadership and franchise owners now have near real-time dashboards not previously possible to produce; the organization is positioned to incorporate additional data sources and dashboards such as inventory and CRM. Further, the company IT team now has the tools and skillsets to analyze Looker query results and make necessary changes to the Looker code rapidly if needed. The Batteries Plus data architect reports that user feedback from the launch has been very positive so far. He keeps hearing how it's so much faster and more intuitive than their last system.

Case studies

Dominion Enterprises

Dominion Enterprises

Florida Fish and Wildlife Conservation Commission

Florida Fish and Wildlife Conservation Commission

The Garland Company

The Garland Company

Grand Traverse County

Grand Traverse County

Jarlette Health Services

Jarlette Health Services

Macomb County Circuit Court and Clerk

Macomb County Circuit Court and Clerk

Manitoulin Group of Companies

Manitoulin Group of Companies

United States Holocaust Memorial Museum

United States Holocaust Memorial Museum

University of Notre Dame

University of Notre Dame

Whirlpool Corporation

Whirlpool Corporation

Hurley Medical Center

Hurley Medical Center

Gordon Food Service

Gordon Food Service

Batteries Plus Bulbs

Batteries Plus Bulbs

The Garland Company

The Garland Company

JP Recovery Services

JP Recovery Services

Large Public University

Large Public University

UNICO Technologies Group

UNICO Technologies Group

Specialty Financial Institution

Specialty Financial Institution

Catalyst Tech Ventures

Catalyst Tech Ventures

dots