Coffee retailer analyzes 32k locations in real time

With Incorta and Microsoft Azure, the world’s largest coffee retailer analyzes billions of daily transactions in real time

Retail
Imndustry
Finance and Supply Chain
Department
10,001+ employees
Company size
Oracle EBS and Excel
Technology
40%

decrease in food production cost

$35M

annual savings in inventory carrying costs

99%

reduction in time to deliver reports

THE CHALLENGE

Lack of insight into performance across locations and gift card transactions

Our customers realized that they needed timely, comprehensive access to data across all locations, like the cost of goods sold at a granular, transactional level: by product, region, store and week, to elevate operations. Improving visibility into their multiple lines of business would sharpen the supply chain and help them choose the right products for the right places for stronger profitability. They also needed a solution that could integrate seamlessly with one of their primary technology providers: Microsoft.

eed to do their jobs,” said Alan Davidson, Director of IT Infrastructure. “But at the same time, we have billions of rows of data in our database. It’s no small challenge to quickly slice and dice that amount of information.”

THE SOLUTION

Next-generation data analytics that offer profit-boosting insights in real time

Incorta is the only data platform that can perform direct data mapping: the ability to gather and join data from anywhere across a technology stack — regardless of source, size, format or complexity, and unify it without any need for complex and time-consuming data modeling or transformations. Our platform’s ability to load data (from anywhere) and seamlessly process and tailor analytics to meet objectives, and offer actionable insights in real time, helps customers move faster than ever before.

During a proof of concept, this leading global retailer saw Incorta extract and deliver billions of data points with ease, immediately realizing the speed and value of unified analytics. Incorta’s integrations with today’s major cloud technologies give brands unparalleled flexibility and control of their data. Incorta even allows brands to enable stickier, more advanced Azure Data Services such as cognitive services, bots, artificial intelligence and machine learning. This is because Incorta can extract data from a brand’s original application and/or data store and bring it into a single location in standard Parquet format for seamless management in Microsoft Azure and other programs.

“Incorta has been critical to our brand, enabling faster delivery of data engineering and analytics capabilities in the finance and supply chain spaces.”

SVP of Corporate Technology
Position, Company name

A real-time analytics platform seamlessly integrated with Oracle EBS

With the implementation of Incorta, users can see work orders and billable and non-billable work hours in seconds. When users log into EBS, the first thing they see is an Incorta dashboard, and they can seamlessly switch between Oracle transactions and Incorta analytics with a single sign-on (SSO). The SSO and the option to leverage roles and responsibilities already assigned to university users within EBS increases data security. And with the ability to click on individual work orders and make changes to its EBS transaction record (like adding hours or shifting due dates from within Incorta), users can work quickly and effectively.

Featured resources

See the Incorta Difference for Yourself