TERADATA INDUSTRIES / DATASHEET

Teradata® Retail Data Model

Retail transformation is being driven from •• What is vendor performance relative to other vendors
unprecedented changes in consumer behavior, in category in terms of sales, profitability, and
intensified pressure on margins, the changing role of service level?
stores, and intensified competition for both on and •• What is the in-stock percent of my
offline channels. top-selling products?
•• What would be the optimal price for this item
To survive and thrive in this challenging environment,
on promotion?
retailers must improve efficiency and automation across
multichannel processes. They must stay ahead of •• What promotions should we offer to each customer
customer demands, and optimize customer journeys segment, when, for how long, and in which channels?
to create a frictionless, seamless online and offline •• What is a product’s viability and substitution
customer experience. value based on customer browsing versus
purchase behavior?
To achieve this, retailers must capture vast amounts
•• Is my labor being planned and scheduled efficiently
of data (customer, store, financials, product, inventory,
to maximize customer service and sales, while
employees, and call center) and be able to deliver an
minimizing labor costs?
integrated view of the business, trends, and insights
into customer behavior—across the enterprise. That •• How can I improve customer service and the
transformation process begins by implementing an products that I offer based on customer feedback?
advanced data and analytics environment—consisting of •• What is the preferred interaction channel for a given
an integrated data warehouse (IDW). Teradata Vantage, type of customer for different shopping interactions
the powerful analytics platform for Pervasive Data and item categories?
Intelligence, empowers you to do this.
•• What is the company’s total associate benefits liability,
and how has it increased or decreased from the prior
Armed with better, faster, and more precise answers
year by plan and by associate demographics?
based on all data, Teradata lets you identify new
opportunities, create personalized marketing
and communications programs, improve revenue
streams with profitable customers, and provide the
right products and services that meet and exceed
consumer expectations. By seeing how all aspects of
your business relate to one another, you can discover
answers to critical questions such as:

•• Which products are my best customers buying and

from which channels?
•• Am I selling those products at the right price, at the
right place in the store, and in the right color, size,
and quantity combinations?
•• Which products drive the highest baskets in terms of
sales volume, revenue, or profitability?

1 TERADATA® RETAIL DATA MODEL

Journey to a Better Business
Teradata Industry Data Model
Teradata understands that aligning your enterprise
goals with the practical reality of creating a data Reference
repository to answer key business questions can be a Data

daunting task. That’s why our focus is to provide the Master

Data
tools and expertise necessary to make the planning and
implementation of an IDW less daunting.

Teradata provides consulting services combined with

industry-specific tools—such as the Teradata® Retail Data Unified Industry
Model (RDM) within Teradata Vantage—to jump-start Transaction
Data
your IDW planning and development process. Data

Similar to planning a journey, building an IDW requires

three key components to succeed: Power of Integrated Data

Figure 1. Teradata Industry Data Model.

The Teradata Retail Data Model (RDM) allows

your enterprise to: •• A clear and worthwhile objective or destination

•• Create a robust foundation of non-redundant, •• A map that shows you how to get to your objective
high value, high quality enterprise data. or destination

•• Facilitate the rapid development of •• A navigational device that helps you know exactly
business analytics with repeatable and where you are during your journey
matching outcomes.
•• Easily define your data requirements for Defining Your Business Objectives
your organization. Teradata retail experts help you start the journey by
•• Validate on paper that business defining business objectives, and linking them to the
requirements will be met prior to investing analytics, actions, and results that could be taken by
in costly implementations. leveraging available data. We call this a business use
case assessment, and we do this to help you determine
•• Leverage a well-documented set of data
and prioritize your business goals.
definitions and relationships, which can be
customized for your environment.
Supporting Your Use Cases
•• Facilitate communication between the IT and
Teradata has identified numerous use cases that
business communities.
typically challenge most retailers, such as reducing out
•• Accelerate time to market of your IDW by of stocks, optimizing demand forecasts, or increasing
leveraging Teradata Vantage and deep market basket revenue for declining customer spends.
industry knowledge.
Navigating and Running Your Business
When combined with Teradata Retail Analytic Teradata® Industry Data Models (Figure 1) facilitate
Schemas (RAS) your enterprise is also enabled for: the task of creating an enterprise data model for your
•• Business insight-driven data analytics. organization, and is the foundation by which the RDM is
built. The Teradata RDM is the map that shows all of the
•• Outcome plans that encompass a subset of
pieces of information required to support the use cases
the RDM business scope.
that challenge your business. Just as you would not
•• Ease of quickly building out the access layer. begin a journey without a map, you would not build an
•• Leveraging pre-built dimensional data models IDW without an enterprise data model.
and analytic data sets for advanced analytics.

2 TERADATA® RETAIL DATA MODEL

 The Teradata RDM supports analytics for key retail business process areas including:
•• Merchandising •• Plan-o-gram •• Privacy and
Vendor Management
•• Assortment/Category •• Promotion Management
Management/Product Mix and Marketing •• Call Center Productivity
(PMIX) •• Point-of-Sale Transactions •• Omnichannel Commerce
•• Item Pricing and Cost Detail and Interactions
•• Detail and Fulfillment
•• Inventory Management •• Forcasting and Scoring
•• Catalog Sales and
•• RFID/Serialized Item Track Content Management •• Financial Management
and Trace •• Recall Management •• Retail Pharmacy
•• Shipment, Freight Billing, •• Customer Value, Shopping, and •• Grocery
and Claims Product Purchase Behavior •• Apparel
•• Transportation Logistics •• Quality Feedback
(Distribution an Logistics) •• Table Dining Servicing
•• Loyalty and Gift Card •• Kitchen and Wait
•• Invoice Usage Behavior Time Management
•• Agreements •• Store Labor and Operations
(Terms and Conditions) •• Service Tips
•• Human Capital Management Reporting Compliancy
•• Procurement (Human Resources) •• Sales Tax and Fee Compliance

Proven Value and Expertise About Teradata

What makes Teradata different from the competition Teradata leverages all of the data, all of the time, so
when it comes to data and analytics? It is the business you can analyze anything, deploy anywhere, and deliver
value and the retail expertise that we provide. We help analytics that matter. By providing answers to the
your business and IT functions collaborate and agree on complexity, cost and inadequacy of today’s analytics,
the requirements for meeting business objectives and Teradata is transforming how businesses work and
managing data assets better. people live. Get the answer at [Link].

Teradata is the market leader in advanced analytics

and data warehousing, and we have built that expertise, For More Information
best practices, and intellectual property into our tools.
Our team of industry professionals has business and To learn more about how the Teradata Retail Data
technical knowledge. They work with all types of retailers Model can help you align analytical capabilities
to solve key business problems with the goal of helping across your organization, contact your local Teradata
them view and align their businesses around one of their representative, or visit [Link].
most important assets—data.

17095 Via Del Campo, San Diego, CA 92127     [Link]

Teradata and the Teradata logo are registered trademarks of Teradata Corporation and/or its affiliates in the U.S. and worldwide. Teradata continually improves products
as new technologies and components become available. Teradata, therefore, reserves the right to change specifications without prior notice. All features, functions and
operations described herein may not be marketed in all parts of the world. Consult your Teradata representative or [Link] for more information.

© 2018 Teradata Corporation    All Rights Reserved.    Produced in U.S.A.    12.18    EB4245