下载PDF
Kyvos Insights > 实例探究 > Retail Chain Transforms Customer Experiences with BI Acceleration
Kyvos Insights Logo

Retail Chain Transforms Customer Experiences with BI Acceleration

技术
  • 分析与建模 - 大数据分析
  • 平台即服务 (PaaS) - 数据管理平台
适用行业
  • 零售
适用功能
  • 商业运营
  • 销售与市场营销
用例
  • 需求计划与预测
  • 库存管理
  • 供应链可见性(SCV)
服务
  • 云规划/设计/实施服务
  • 数据科学服务
挑战
The grocery chain wanted to use their data to understand their customers better and maintain their market-leader position. They decided to align their merchandise mix and store inventory to match each customer’s specific needs. With hundreds of stores, thousands of products, and daily visitors, the store had details on almost 140,000 transactions per day and wanted to use this data to support their business decisions. However, their current environment could not handle the data scale and complexity, making it impossible to conduct Year-over-Year, much less Month-over-Month analysis. They resorted to writing complex queries using Impala to fetch data from their Cloudera platform. But when they tried to join tables with more than one billion cardinalities, Impala usually timed out.
关于客户
The customer is a leading US-based grocery chain that has carved a niche by building a loyal customer base. They have hundreds of stores and thousands of products, with daily visitors resulting in almost 140,000 transactions per day. The company is known for its unique shopping experience and customer loyalty. They wanted to use their data to understand their customers better and maintain their market-leader position. To offer a unique shopping experience to each customer, they decided to align their merchandise mix and store inventory to match each customer’s specific needs.
解决方案
The company evaluated several options for almost three years, ultimately choosing Kyvos as their BI acceleration platform. Kyvos created a universal semantic layer on Azure to solve complex use cases and get quick answers to business questions. Smart OLAP™ technology helped them pre-aggregate two years of historical data, leveraging Azure Databricks service and ADLS for storage. Analysts and business users could plug their Tableau and MicroStrategy dashboards into Kyvos and conduct self-service, interactive analysis on enterprise data with 100x faster performance than Impala.
运营影响
  • The retailer transformed its customer analytics by achieving faster and deeper data insights.
  • Mapping purchase data with the customer’s profile data provided an in-depth understanding of their behavior and purchase patterns.
  • Analysts could identify the items customers bought most often, the stores most frequently visited, the day and time when they preferred to buy, whether they purchased a single item or in bulk, etc.
数量效益
  • Two-second query responses on 12 billion rows and 1 billion distinct count
  • Year over Year analysis of two-year history with instant response
  • High performance on Tableau dashboards involving Complex LOD calculations on multiple dimensions

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

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