AtScale Case Studies Global Agriculture, Chemical, and Energy Leader Transforms Their Operational Data and Analytics for the Cloud

Edit This Case Study Record

	Global Agriculture, Chemical, and Energy Leader Transforms Their Operational Data and Analytics for the Cloud AtScale

Global Agriculture, Chemical, and Energy Leader Transforms Their Operational Data and Analytics for the Cloud

AtScale

Technology Category	Analytics & Modeling - Real Time Analytics Infrastructure as a Service (IaaS) - Cloud Computing Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Agriculture Chemicals
Applicable Functions	Discrete Manufacturing Quality Assurance
Use Cases	Inventory Management Predictive Maintenance Supply Chain Visibility
Services	Cloud Planning, Design & Implementation Services Data Science Services
Challenge	The Company’s operational data was siloed and difficult to access. Users wanted to leverage modern BI tools such as Tableau and Excel, and were being forced to extract data from databases and work with local copies. This “pump and dump” strategy of extracting data and working locally meant analytics were scattered across employees’ desktops, data governance and accuracy problems were endemic and the Company struggled to maintain one single version of the truth for their analytics. The Company developed strict criteria for their intended data solution: Ease of Use, Tool Agnostic, Disruption Free, and Single Source of Truth. Read More
About Customer	The Company and its affiliates are a global provider of value-added solutions for the agriculture, energy and chemical markets. The Company produces the vital ingredients used in food and energy creation. The Company’s operational data was siloed and difficult to access. Users wanted to leverage modern BI tools such as Tableau and Excel, and were being forced to extract data from databases and work with local copies. This “pump and dump” strategy of extracting data and working locally meant analytics were scattered across employees’ desktops, data governance and accuracy problems were endemic and the Company struggled to maintain one single version of the truth for their analytics. Read More
Solution	The Company selected AtScale for its ability to virtualize data across a hybrid cloud architecture enabling consistent and accurate query results across business intelligence (BI) tools and data platforms, acceleration of query performance, abstraction of data locations unlocking data agility and mobility, and a unified view of enterprise data. The implementation began with setting up instances of Amazon Redshift on Amazon Web Services. The Company seamlessly implemented data models they had been using with prior solutions. Within the proof of concept, the Company created cases to test building and consuming models with more than one fact table and mixed granularity across fact tables. The models performed to the Company’s satisfaction; for BI compatibility, they tested PowerBI, Tableau, and Excel to confirm queries would yield the same results, which they did. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Infrastructure as a Service (IaaS) - Cloud Computing

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Agriculture

Chemicals

Applicable Functions

Discrete Manufacturing

Quality Assurance

Use Cases

Inventory Management

Predictive Maintenance

Supply Chain Visibility

Services

Cloud Planning, Design & Implementation Services

Data Science Services

Challenge

The Company’s operational data was siloed and difficult to access. Users wanted to leverage modern BI tools such as Tableau and Excel, and were being forced to extract data from databases and work with local copies. This “pump and dump” strategy of extracting data and working locally meant analytics were scattered across employees’ desktops, data governance and accuracy problems were endemic and the Company struggled to maintain one single version of the truth for their analytics. The Company developed strict criteria for their intended data solution: Ease of Use, Tool Agnostic, Disruption Free, and Single Source of Truth.

About Customer

The Company and its affiliates are a global provider of value-added solutions for the agriculture, energy and chemical markets. The Company produces the vital ingredients used in food and energy creation. The Company’s operational data was siloed and difficult to access. Users wanted to leverage modern BI tools such as Tableau and Excel, and were being forced to extract data from databases and work with local copies. This “pump and dump” strategy of extracting data and working locally meant analytics were scattered across employees’ desktops, data governance and accuracy problems were endemic and the Company struggled to maintain one single version of the truth for their analytics.

Solution

The Company selected AtScale for its ability to virtualize data across a hybrid cloud architecture enabling consistent and accurate query results across business intelligence (BI) tools and data platforms, acceleration of query performance, abstraction of data locations unlocking data agility and mobility, and a unified view of enterprise data. The implementation began with setting up instances of Amazon Redshift on Amazon Web Services. The Company seamlessly implemented data models they had been using with prior solutions. Within the proof of concept, the Company created cases to test building and consuming models with more than one fact table and mixed granularity across fact tables. The models performed to the Company’s satisfaction; for BI compatibility, they tested PowerBI, Tableau, and Excel to confirm queries would yield the same results, which they did.

Impact #1	The Company had been attracted to AtScale’s ability to automatically build data structures to accelerate query response times and minimize cloud computation costs.
Impact #2	Without moving or replicating their data, the global business leaders now have access to a common, business-centric view of their global performance.
Impact #3	The Company plans to continue to push to get additional data into the virtualized analytical environment.

Impact #1

The Company had been attracted to AtScale’s ability to automatically build data structures to accelerate query response times and minimize cloud computation costs.

Impact #2

Without moving or replicating their data, the global business leaders now have access to a common, business-centric view of their global performance.

Impact #3

The Company plans to continue to push to get additional data into the virtualized analytical environment.

Benefit #1	They ran tests with and without AtScale’s intelligent aggregates and found speed improvements of 5x to 40x, depending on the workload.

Benefit #1

They ran tests with and without AtScale’s intelligent aggregates and found speed improvements of 5x to 40x, depending on the workload.

Download PDF Version

Overview

Global Agriculture, Chemical, and Energy Leader Transforms Their Operational Data and Analytics for the Cloud

Operational Impact

Quantitative Benefit