Oracle Data Platform for Retail

Merchandising optimization: Predict, sense, and shape demand

 

Retail optimization challenges and opportunities

Inventory availability and promotions continue to influence customer decisions. As new customer journeys and shopping experiences emerge, execution is everything. Consumers won’t tolerate out-of-stock inventory—63% of consumers confirmed they will try another brand rather than wait for a restock. Retailers with more accurate forecasts and insight into their inventories will be able to quickly pivot to meet customer demand and shopping preferences, whether they’re shopping in store, buying online and picking up in store, opting for curbside pickup, or using other channels.

Consumers shop differently depending on what they’re buying. For example, they have different priorities when shopping for gifts than when shopping for seasonal items: Sometimes price is everything; sometimes it’s no object. Retailers can now understand how shoppers respond to every item at a localized level, enabling them to factor the effects of promotions, seasonality, and weather into their forecasts.

Additionally, retailers can increase personalization by targeting customers based on their real-time needs. Customers are more likely to accept offers that have been targeted to them based on an understanding of their behavior, how they shop, and the services they subscribe to, increasing offer acceptance rates and, ultimately, revenue. Conversely, pushing untargeted cross-sell or upsell offers can lead to customer fatigue and ignored or disabled notifications.

Simplify retail planning with advanced analytics and machine learning

Having the right inventory available in the right place to quickly fulfill customer demand, no matter when and where a purchase is made, will help retailers overcome the challenges and exploit the opportunities described above.

Retailers can use advanced analytics and machine learning to identify products and services that are relevant to a given customer. They can then push these products and services to the customer through the appropriate channel at the appropriate time.

Let’s take a closer look at how Oracle Data Platform can help retailers improve forecast accuracy, simplify planning, and optimize inventory.

merchandising optimization diagram, description below

This image shows how Oracle Data Platform for retail can be used to support merchandising optimization and help retailers predict, sense, and shape demand. The platform includes the following five pillars:

  • Data Sources, Discovery
  • Ingest, Transform
  • Persist, Curate, Create
  • Analyze, Learn, Predict
  • Measure, Act

The Data Sources, Discovery pillar includes four categories of data.

Business record data comprises sales transactions, customer data, product data, returns transactions, suppliers, inventory, POS system data, revenue, and margin data.

Application data comes from ERP, SCM, CX, and WMS, Fusion SaaS, NetSuite, E-Business Suite, PeopleSoft, JD Edwards, SAP, Salesforce, and Workday applications.

Third-party data includes data from Oracle Data Cloud and social data.

Technical input data includes logs, web clicks, event streams, and beacons.

The Ingest, Transform pillar comprises four capabilities.

Batch ingestion uses OCI Data Integration, Oracle Data Integrator, and DB tools.

Bulk transfer uses OCI FastConnect, OCI Data Transfer, MFT, and OCI CLI.

Change data capture uses OCI GoldenGate.

Streaming ingest uses Kafka Connect.

All four capabilities connect unidirectionally into the serving data store and cloud storage within the Persist, Curate, Create pillar.

Additionally, streaming ingest is connected to stream processing within the Analyze, Learn, Predict pillar.

The Persist, Curate, Create pillar comprises five capabilities.

The serving data store uses Autonomous Data Warehouse and Exadata Cloud Service.

Managed Hadoop uses Oracle Big Data Service.

Cloud storage uses OCI Object Storage.

Batch processing uses OCI Data Flow.

Governance uses OCI Data Catalog.

These capabilities are connected within the pillar. Cloud storage is unidirectionally connected to the serving data store and managed Hadoop; it is also bidirectionally connected to batch processing.

Managed Hadoop is unidirectionally connected to the serving data store.

Two capabilities connect into the Analyze, Learn, Predict pillar: The serving data store connects to both the analytics and visualization capability and the data products, APIs capability, and the cloud storage capability connects to the machine learning capability.

The Analyze, Learn, Predict pillar comprises four capabilities.

Analytics and visualization uses Oracle Analytics Cloud, GraphStudio, and ISVs.

Data products, APIs uses OCI API Gateway and OCI Functions.

Machine learning uses OCI Data Science, Oracle ML, and Oracle ML Notebooks.

Streaming processing uses GoldenGate Stream Analytics and stream analytics from third parties.

The Measure, Act pillar comprises three consumers: people and partners, applications and models.

People and partners comprise Historical Sales Analysis, Customer Segmentation, Promotion Impact Analysis, Pricing Impact Analysis.

Applications comprises Economic Indicators, Buying Behaviour, Real Time Demand Prediction, Inventory Prediction.

Models comprises Social Media Sentiment Analysis, Collaborative Forecasting and Demand Planning.

The three central pillars—Ingest, Transform; Persist, Curate, Create; and Analyze, Learn, Predict—are supported by infrastructure, network, security, and IAM.


There are three main ways to inject data into an architecture to enable retailers to predict, sense, and shape demand.

  • To start our process, we need to understand our overall inventory position. To do so, we use Oracle GoldenGate to enable change data capture ingestion of near real-time warehouse inventory data from operational databases for all or a subset of product lines.
  • We can now add datasets relevant to retail demand, such as point-of-sale information. In addition to sales information, this data provides us with multiple insights, such as the time and location of the sale or information about refunds and swaps. These datasets often comprise large volumes of often on-premises data, and in most cases, batch ingestion is typically most efficient. For our point-of-sale data, we will use Oracle Data Integrator to ingest the data on a four-hour cycle.
  • Streaming ingestion will be used to ingest data read from beacons at in-store locations through IoT, machine-to-machine (M2M) communications, and so on. Video imaging can also be consumed this way. Additionally, in this example, we intend to analyze and rapidly respond to consumer sentiment by analyzing social media messages, responses to first-party posts, and trending messages. Social media (application) messages/events will be ingested with the option to perform some basic transformation/aggregation before storing the data in cloud storage. Additional stream analytics can be used to identify correlating consumer events and behavior, and the identified patterns can be fed back (manually) for OCI Data Science to examine the raw data.

Data persistence and processing is built on three (optionally four) components.

  • Ingested raw data is stored in cloud storage. We will use OCI Data Flow for the batch processing of this now persisted streamed data, such as tweets (JSON), location, sensor data from beacons and apps, geo-mapping data, and product reference data. These processed datasets are returned to cloud storage for onward persistence, curation, and analysis and ultimately for loading in optimized form to the serving data store. Alternatively, depending on architectural preference, this can be accomplished with Oracle Big Data Service as a managed Hadoop cluster.
  • We have now created processed datasets that are ready to be persisted in optimized relational form for curation and query performance in the serving data store. This will enable us to identify and return the top trending product and consumer hashtags that can be enriched with location, inventory, and product data from enterprise systems.

The analysis part is built on two technologies.

  • Analytics and visualization services deliver descriptive analytics (describes current trends with histograms and charts), predictive analytics (predicts future events, identifies trends, and determines the probability of uncertain outcomes), and prescriptive analytics (proposes suitable actions, leading to optimal decision-making), to answer questions such as
    • How do actual sales this period compare to the current plan?
    • What is the retail value of inventory on hand, and how does it compare to the same period last year?
    • What are the best-selling items in a division or department?
    • How effective was the last promotion?
  • Alongside the use of advanced analytics, machine learning models are developed, trained, and deployed. These models can be accessed via APIs, deployed within the serving data store, or embedded as part of the OCI GoldenGate streaming analytics pipeline.
  • Our curated, tested, and high-quality data and models can have governance rules and policies applied and exposed as a “data product” (API) within a data mesh architecture for distribution across the retail organization.

Increase profitability with a retail data platform

The forecast and corresponding pricing and promotional effects, paired with underlying costs and inventory availability, are the foundation for effective pricing and promotional decisions. Increase profitability and assortment flexibility with decreased inventory levels. Anticipate customer demand by maximizing the value of your data, applying analytics that draw from machine learning, artificial intelligence, and decision science disciplines to achieve the following:

  • Increase revenue and expand a loyal customer base with higher in-stock rates.
  • Increase brand loyalty by up to 77% with higher in-stock rates. Forecasts powered by automated intelligence can drive replenishment and allocation processes at a massive scale. The forecast and corresponding statistical prediction intervals enable supply chain success—having the right product in the right place at the right time—helping retailers plan forward-looking demand and statistical safety stocks while minimizing overall inventory costs.
  • Convert up to 50% of shoppers into buyers with time-sensitive sales and promotions. Drive these decisions using forecasts based on contextual what-ifs and predictive analytics as well as optimized and forward-looking prescriptive analytics.

開始使用 Oracle Modern Data Platform

試用 20 多項永遠免費雲端服務,並可在 30 天内試用其他服務

Oracle 所提供的 Free Tier 包含無時間限制使用 20 多項服務 (如 Autonomous Database、Arm Compute 和 Storage) 以及 300 美元的免費額度,可試用其他雲端服務。取得詳細資料,並立即註冊您的免費帳戶。

  • Oracle Cloud Free Tier 包含哪些項目?

    • 2 個 Autonomous Database,每個 20 GB
    • AMD 和 Arm 運算 VM
    • 200 GB 總區塊儲存體
    • 10 GB 物件儲存體
    • 每月 10 TB 輸出資料傳輸
    • 10 多項永遠免費服務
    • 300 美元的免費點數,可在 30 天内試用其他服務

深入瞭解逐步指引

透過教學課程和實作實驗室來體驗廣泛的 OCI 服務。無論您是開發人員、管理員還是分析人員,我們都可以協助您瞭解 OCI 的運作方式。許多實驗室是在 Oracle Cloud 免費層或 Oracle 提供的免費實驗室環境上執行。

  • 開始使用 OCI 核心服務

    此研討會中的實驗室涵蓋 Oracle Cloud Infrastructure (OCI) 核心服務介紹,包括虛擬雲端網路 (VCN) 以及運算和儲存服務。

    立即開始 OCI 核心服務實驗
  • Autonomous Database 快速入門

    在此研討會中,您將會瞭解使用 Oracle Autonomous Database 的步驟。

    立即開始 Autonomous Database 快速入門實驗
  • 以試算表建立應用程式

    本實驗將引導您將試算表上傳到 Oracle Database 表中,然後根據此新表格建立應用模組。

    立即開始此實驗
  • 在 OCI 上部署 HA 應用程式

    在本實驗中,您將會在 Oracle Cloud Infrastructure (OCI) 中的兩個運算執行處理上部署 Web 伺服器,並使用負載平衡器以高可用性模式 (High Availability) 進行設定。

    立即開始 HA 應用程式實驗

探索 150 多種最佳實務設計

瞭解架構師與其他客戶如何部署各種工作負載,從企業應用程式至 HPC,以及從微服務到資料湖。透過「Built & Deployed」影片系列,瞭解最佳實務,聽聽其他客戶架構師的分享,您也可使用我們的「按一下即可部署」功能來部署許多工作負載,或者從我們的 GitHub 存放區自行部署。

熱門架構

  • Apache Tomcat 搭配 MySQL Database Service
  • Kubernetes 上的 Oracle Weblogic,搭配 Jenkins
  • 機械學習 (ML) 與人工智慧環境
  • Arm 上的 Tomcat,搭配 Oracle Autonomous Database
  • 日誌分析與 ELK 堆疊
  • HPC 與 OpenFOAM

瞭解 OCI 可以助您節省多少成本

Oracle Cloud 的定價簡單明瞭,在全球各地保持一致的實惠價格,而且支援廣泛的使用案例。若要預估您的費率,請查看費用預估工具,並依照您的需要設定服務。

體驗與衆不同之處:

  • 1/4 的外送頻寬成本
  • 3 倍運算性價比
  • 每個區域的定價同樣實惠
  • 定價實惠,且無須長期履行合約

聯絡業務代表

有興趣深入瞭解 Oracle Cloud Infrastructure 的資訊嗎?讓我們的專家助您一臂之力。

  • 我們的業務代表可以爲您解答以下問題:

    • 哪些工作負載在 OCI 上的執行效果最佳?
    • 如何從 Oracle 的整體投資中獲得最大收益?
    • OCI 如何與其他雲端運算提供者比較?
    • OCI 如何支援您的 IaaSPaaS 目標?