Actian Case Studies Actian Helps Fast Growing U.S. Convenience Store Chain to Save Money and Take Action on Big Data

Edit This Case Study Record

	Actian Helps Fast Growing U.S. Convenience Store Chain to Save Money and Take Action on Big Data Actian

Actian Helps Fast Growing U.S. Convenience Store Chain to Save Money and Take Action on Big Data

Actian

Technology Category	Analytics & Modeling - Big Data Analytics
Applicable Industries	Retail
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Predictive Quality Analytics Retail Store Automation
Services	Data Science Services
Challenge	Sheetz, a rapidly growing convenience store chain in the U.S., was facing the challenge of managing and analyzing increasing volumes of data from multiple sources. The company needed to optimize costs, maintain high quality, and ensure a positive customer experience. As data volumes continued to grow, Sheetz recognized the need to switch from a more expensive platform to a more cost-effective and efficient one that could handle the increasing data and provide actionable insights. The company was also looking to expand its data analysis from one year to two years, which equates to approximately three billion rows of data. Furthermore, Sheetz was anticipating its data to double over the next two to three years. Read More
About Customer	Sheetz is a family-owned convenience store chain based in Pennsylvania, United States. The company operates more than 406 locations across six states. For over fifty years, Sheetz's mission has been to meet the specific needs of customers on the go. As life has become faster and busier, customers expect the stores to be there when they are needed the most. To meet these needs, Sheetz performs extensive analysis on various types of data from multiple sources to optimize costs, maintain high quality, and ensure a positive and consistent customer experience. Read More
Solution	Sheetz selected Vectorwise, a fast data analytics engine, to handle its growing data volumes and provide actionable insights. The initial project involved converting a character-based reporting application built in ABF (Applications by Forms) to use Vectorwise. The required application changes were minimal, with the most significant technical changes relating to 'singleton inserts' (row at a time data loading) and table storage structure (schema) definitions. Vectorwise enabled Sheetz to expand its data analysis from one year to two years and manage its anticipated growth. The convenience store chain was surprised at the ease with which new Vectorwise functionality was added to their environment. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Applicable Industries

Retail

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Predictive Quality Analytics

Retail Store Automation

Services

Data Science Services

Challenge

Sheetz, a rapidly growing convenience store chain in the U.S., was facing the challenge of managing and analyzing increasing volumes of data from multiple sources. The company needed to optimize costs, maintain high quality, and ensure a positive customer experience. As data volumes continued to grow, Sheetz recognized the need to switch from a more expensive platform to a more cost-effective and efficient one that could handle the increasing data and provide actionable insights. The company was also looking to expand its data analysis from one year to two years, which equates to approximately three billion rows of data. Furthermore, Sheetz was anticipating its data to double over the next two to three years.

About Customer

Sheetz is a family-owned convenience store chain based in Pennsylvania, United States. The company operates more than 406 locations across six states. For over fifty years, Sheetz's mission has been to meet the specific needs of customers on the go. As life has become faster and busier, customers expect the stores to be there when they are needed the most. To meet these needs, Sheetz performs extensive analysis on various types of data from multiple sources to optimize costs, maintain high quality, and ensure a positive and consistent customer experience.

Solution

Sheetz selected Vectorwise, a fast data analytics engine, to handle its growing data volumes and provide actionable insights. The initial project involved converting a character-based reporting application built in ABF (Applications by Forms) to use Vectorwise. The required application changes were minimal, with the most significant technical changes relating to 'singleton inserts' (row at a time data loading) and table storage structure (schema) definitions. Vectorwise enabled Sheetz to expand its data analysis from one year to two years and manage its anticipated growth. The convenience store chain was surprised at the ease with which new Vectorwise functionality was added to their environment.

Impact #1	Vectorwise enabled Sheetz to expand its data analysis from one year to two years, which equates to approximately three billion rows of data.
Impact #2	The convenience store chain was able to manage its anticipated data growth, which is expected to double over the next two to three years.
Impact #3	Sheetz was surprised at the ease with which new Vectorwise functionality was added to their environment.

Impact #1

Vectorwise enabled Sheetz to expand its data analysis from one year to two years, which equates to approximately three billion rows of data.

Impact #2

The convenience store chain was able to manage its anticipated data growth, which is expected to double over the next two to three years.

Impact #3

Sheetz was surprised at the ease with which new Vectorwise functionality was added to their environment.

Benefit #1	Sheetz was able to save money by switching from a more expensive platform to Vectorwise.
Benefit #2	Vectorwise has achieved performance increases in commercial deployments of 70x that of existing databases.

Benefit #1

Sheetz was able to save money by switching from a more expensive platform to Vectorwise.

Benefit #2

Vectorwise has achieved performance increases in commercial deployments of 70x that of existing databases.

Download PDF Version

Overview

Actian Helps Fast Growing U.S. Convenience Store Chain to Save Money and Take Action on Big Data

Operational Impact

Quantitative Benefit