UK Retailer Shop Direct Chooses Teradata for Enterprise Data Warehouse

System will centralize information from multiple sources, accelerate and expand user insight

Teradata Corporation (NYSE: TDC), announced today that Shop Direct, the UK’s leading online and home shopping retailer, has selected Teradata to consolidate and integrate significant volumes of data from many different sources across the business onto a single Active Enterprise Data Warehouse platform.

The centralized Enterprise Data Warehouse (EDW) will serve as the company’s primary information system. As a result, internal users of Shop Direct information will have immediate access to a single, holistic view of the business.

The integration includes a replacement of their current platform with a new more powerful Active Enterprise Data Warehouse – 5555 platform. The existing platform will be redeployed for disaster recovery, development and testing.

“A centralized, active data warehouse is critical as the pace and complexity of our business – and the influx of fresh data from multiple channels – is growing rapidly,” said Carl Dawson, chief information officer, Shop Direct. “Marketing, merchandising, finance and operations users across the business will benefit as we integrate data to provide a more complete and useful view of the whole business – in near real time.”

The move to a real time capability for information access is referred to as Active Enterprise Intelligence(TM). An Active Enterprise Intelligence(TM) business environment is built on the foundation of a central data warehouse and is able to deliver detailed visibility to a company’s operational front-line employees in real time if required.

Shop Direct has built up multiple data marts over time on various relational databases. They will now consolidate these data marts onto one platform which will reduce costs and allow more cross functional analysis. Shop Direct will also be incorporating new data such as click stream. Key time-critical data will be loaded in near-real time to help facilitate more accurate decision making throughout the enterprise. Shop Direct has also selected Oracle Business Intelligence Enterprise Edition Plus as its enterprise BI tool to run upon the Teradata platform.

“As the pace of business accelerates dramatically, many decisions are time-sensitive and require real-time systems and analytics,” said Chris Armitage, area vice president, Teradata United Kingdom.

“The movement of data into a centralized Teradata database for integration with other information will result in a competitive advantage for companies competing in the face of today’s economic pressures.” Shop Direct will also deploy Teradata Active System Management software, a portfolio of Windows®-based products, to ensure that the active data warehouse operates at peak efficiencies while meeting service level agreements. Teradata Active System Management gives users capabilities to analyze current workloads and allocate resources to best meet specific business needs, monitor database requests efficiency, adapt the workload mix dynamically to meet priorities as workload conditions change, and visualize the current operational environment to see current and long-term trends.

Shop Direct Group, formerly Littlewoods Shop Direct Group, is the UK’s largest online and home shopping retailer. One in three households in the UK has one or more of Shop Direct Group’s catalogues. Shop Direct Group sells exclusive ranges designed by PPQ, Preen and Jasmine Guinness and leading national brands including Apple, Sony, Miss Sixty, Diesel and Nike. For more information, please visit the http://www.shopdirect.comwebsite.

Teradata Corporation (NYSE: TDC) is the world’s largest company solely focused on raising intelligence through data warehousing, data warehouse appliances, consulting services and enterprise analytics. Teradata is in more than 60 countries and on the Web at


About Andy Painter

A passionate Information and Data Architect with experience of the financial services industry, Andy’s background spans pharmaceuticals, publishing, e-commerce, retail banking and insurance, but always with a focus on data. One of Andy’s principle philosophies is that data is a key business asset.
This entry was posted in Uncategorized and tagged , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

One Response to UK Retailer Shop Direct Chooses Teradata for Enterprise Data Warehouse

  1. Andy Painter says:

    A very good move by Shop Direct to implement a data mart consolidation exercise and Teradata is certainly a great choice, however I just hope that Shop Direct implement and deploy an integrated data model/store at the core of the EDW and don’t just create separate silo’s of data inside the Teradata EDW, with views on top. I’ve seen this happen before and it just doesn’t work.
    As a lot of us know, Teradata likes to work with a 3NF model for the EDW with views built on top to support and dimensional models. Teradata have some excellent join ‘magic’ that allows this, (supposedly!)
    If I was going to be involved as the DW Architect, I’d insist that a core, integrated 3NF data model was used as the EDW. I certainly wouldn’t look to buy one from Teradata or others when I could use the excellent set of data models in Len Silverston set of books, (, this very much gives you 80-90% of a Enterprise data model at a very low cost. It will speed up the delivery and also de-risk the project.
    What Teradata don’t yet supply is the ETL, so we can only guess that Shop Direct have such and tool in place, again if it was me, I’d be very tempted to consider Talend, (
    I wish Shop Direct all the best in their project!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s