conference program - 2013 PARTNERS Conference & Expo

---

CONFERENCE PROGRAM

San Diego Convention Center Conference: October 2–6, 2011 Expo: October 3–5, 2011

San Diego Convention Center / San Diego, CA / October 2–6, 2011

2011 Teradata PARTNERS User Group Conference & Expo

THE 2011 DIAMOND SPONSORS

2011 Teradata PARTNERS User Group Conference & Expo

On behalf of the Partners Steering Committee, welcome to the 2011 Teradata PARTNERS User Group Conference & Expo. This year’s conference theme, Conquering Complexity, is designed to help you get the knowledge that produces results. Whether your complexity challenge is bridging the gap between business and IT, managing the influx of big data from a myriad of sources, or stretching limited resources to produce super-creative solutions—PARTNERS offers a host of exciting, real world tools that you can put to use immediately. During the conference, you will gain access to the hottest technology, hear about cutting edge business applications, and see how data warehousing and business intelligence tools increase business value. We encourage you to learn from top industry experts, attend sessions, and network with other attendees while participating in the many events and activities. This year, the PARTNERS conference has even more to offer than ever before—with nearly 300 educational sessions addressing hot-topic business challenges, including the socialization of data, business analytics, marketing and consumer insights, and enterprise performance metrics and reporting. Between sessions, be sure to visit the vendors in the Expo Hall (Exhibit Hall G). The Hall is filled with new technologies and solutions—if you have a specific need, there is no other place to explore the latest data warehousing product and service offerings. At evening events, enjoy even more opportunities to relax and mingle with your fellow attendees. To maximize your experience and your time at PARTNERS, I encourage you to first take a few minutes to review the entire conference program and identify the sessions that are most relevant to you. For a quick overview, the Steering Committee is hosting an orientation session designed to provide helpful insights about the conference in Ballroom 20 A, at 1:00pm on Sunday. If this is your first time attending the conference, I strongly recommend attending this session. Plus, it’s also a great way for past attendees to learn more about the exciting events happening this year. As always, your completed session evaluations are greatly appreciated and give you the chance to influence future conference content and venues. Please be assured that all comments are taken seriously and provide a valuable resource as we direct our planning of future conferences. Sincerely,

Erin Redshaw Erin Redshaw President Partners Steering Committee Senior Manager of ETL Loblaw Companies Limited

www.teradata-partners.com

GENERAL INFO

WELCOME TO PARTNERS!

GENERAL INFO

TABLE OF CONTENTS Agenda-at-a-Glance _______________________________________________________________________ 1 General Information________________________________________________________________________ 2 Experience San Diego PARTNERS Info Hub Centers Teradata Depot Breakfast and Lunch Industry Receptions ________________________________________________________________________ 3 Special Events at PARTNERS_________________________________________________________________ 4 Welcome Reception HISPA-Teradata Charity Golf Tournament Luncheon and Expo Hall Dessert Reception Gala Event Keynote Speakers _________________________________________________________________________ 6 Conference Educational Session Descriptions ___________________________________________________ 8 Poster Sessions __________________________________________________________________________ 10 Conference Educational Sessions Schedule Sunday Agenda _______________________________________________________________________ 16 Sunday Workshops_____________________________________________________________________ 18 Sunday Sessions ______________________________________________________________________ 22 Monday Agenda_______________________________________________________________________ 32 Monday Sessions ______________________________________________________________________ 34 Tuesday Agenda_______________________________________________________________________ 48 Tuesday Sessions ______________________________________________________________________ 50 Wednesday Agenda ____________________________________________________________________ 68 Wednesday Sessions ___________________________________________________________________ 70 Thursday Agenda ______________________________________________________________________ 86 Thursday Sessions _____________________________________________________________________ 88 About the San Diego Convention Center ______________________________________________________ 100 San Diego Convention Center Map __________________________________________________________ 101 Expo Hall Floor Plan _____________________________________________________________________ 102 2011 PARTNERS Exhibitor List ______________________________________________________________ 103 Partners Steering Committee Members _______________________________________________________ 110 Analytical Applications Product Advisory Council Members ______________________________________ 111 Product Advisory Council Members__________________________________________________________ 112 Service Focus Team Members ______________________________________________________________ 113

2011 Teradata PARTNERS User Group Conference & Expo

Conference Program

AgendA-At-A-glAnce Saturday, October 1 3:00pm

–

7:00pm

Sunday, October 2 7:00am 8:00am 8:30am 11:45am 1:00pm 1:00pm 6:00pm

– – – – – – –

9:00pm 3:00pm 11:30am 1:00pm 2:00pm 5:00pm 9:00pm

Monday, October 3 7:00am 7:00am 9:00am Noon Noon 1:30pm

– – – – – –

6:00pm 8:30am Noon 1:30pm 5:00pm 5:30pm

Tuesday, October 4 7:00am 7:00am 8:00am 10:00am Noon Noon 5:30pm

– – – – – – –

6:00pm 8:30am 5:30pm 5:00pm 3:00pm 3:00pm 7:00pm

Wednesday, October 5 7:00am 7:00am 8:00am 10:00am Noon 3:30pm 7:00pm

– – – – – – –

6:00pm 8:30am 2:30pm 3:00pm 1:30pm 5:00pm 10:00pm

Thursday, October 6 7:00am 8:30am

– –

8:30am 12:30pm

Registration Open Registration Open HISPA-Teradata Charity Golf Tournament Sunday Pre-conference Workshops* Lunch** Conference Orientation Conference Educational Sessions Welcome Reception – Hilton Bayfront Park Registration Open Breakfast** General Session with Keynote Speakers Lunch** Expo Hall Open Conference Educational Sessions Registration Open Breakfast** Conference Educational Sessions Expo Hall Open Luncheon** and Expo Hall Dessert Reception Bike Build and Blanket Brigade Teradata Industry Receptions Registration Open Breakfast** Conference Educational Sessions Expo Hall Open Lunch** General Session with Keynote Speakers Gala Event – USS Midway Breakfast** Conference Educational Sessions

Maximize Your PARtneRS experience • Create a plan of action.

Review the conference agenda and set goals you would like to accomplish at PARTNERS. Session abstracts are provided to help you select those that best meet your business or technical needs.

• Make new connections.

PARTNERS provides countless opportunities to meet like-minded data warehousing professionals. Take advantage of this unique learning and networking event to strike up conversations, exchange ideas, and gain new insights.

• Set up private meetings.

Use the PARTNERS e-mail system and/or Peer Advantage to arrange private meetings with Teradata executives and attendees from other companies.

• Social Networking.

Maximize your 2011 PARTNERS experience! Connect with colleagues, share your experiences, and join the online conversation. Visit teradata-partners.com for all of the conference social networking hyperlinks, or search for “Partners User Group” on the following social channels:

* Workshops – Sponsored by Teradata Corporation, workshops are open to all registered conference attendees. ** Dining – Breakfasts and lunches will be served in the Convention Center Exhibit Hall H.

www.teradata-partners.com

1

GEnEral InformatIon Experience San Diego Hosted in vibrant San Diego, California, the 2011 PARTNERS Conference is guaranteed to energize and inspire innovation. During your free time, take advantage of the diverse opportunities to learn, tour, play, and relax in California’s second largest city. With its dazzling array of world-class attractions, exciting spectator sports, and thriving arts and culture community—not to mention miles of pristine beaches and an idyllic climate—San Diego promises a rich and enjoyable experience. Visit www.sandiego.org for more information.

PARTNERS Info Hub Centers

Visit the PARTNERS Info Hub Centers to obtain details regarding the latest conference information. • Connect with colleagues • Research speakers and educational sessions • Learn about the latest conference changes and other hot news items

2

Teradata Depot

Breakfast and Lunch*

Your one-stop shop, the Teradata Depot, returns to the Conference meals will be served in Exhibit Hall H of the 2011 Teradata PARTNERS User Group Conference & Expo. Convention Center (unless specified differently). Breakfast Conveniently located in the Expo Hall, the Teradata Depot is will be provided Monday through Thursday; lunch will be the best place to find the latest books and information from provided Sunday through Wednesday. conference speakers, and industry analysts, plus Teradata * Badges in their badge holders are required for entry to all shirts, jackets, hats, office gear, and more! meals. Attendees will NOT be permitted access without a badge. Guest registration ($350) does not include breakfast and lunch.

2011 Teradata PARTNERS User Group Conference & Expo

Conference Program

IndUStRY RecePtIonS Make the Most of these networking events Join your peers after a full day of sessions on Tuesday at a special cocktail reception open to attendees, exhibitors, sponsors, and speakers. Come unwind, catch up with colleagues, make new contacts, and discuss key technology and business issues at this energizing PARTNERS networking event.

tuesday, october 4 5:30pm – 7:00pm Hilton Bayfront Hotel

Communications, Media, Entertainment, and Utilities

Travel and Transportation

Financial Services & Insurance

Manufacturing

Room Sapphire I, J

Room Sapphire A, B

Room Sapphire C, D

Government

Room Sapphire K, L

Room Sapphire M, N

Retail

Room Sapphire E, F

Healthcare and Life Sciences Room Sapphire G, H

www.teradata-partners.com

3

SPecIAl eventS At PARtneRS In addition to the opportunities to network and learn from your colleagues at the Expo Hall and during educational sessions, you can make business connections at exciting special events scheduled during the conference. Badges in their badge holders are required for entry to all special events except the HISPA Golf Tournament. Attendees will NOT be permitted access without a badge.

Scheduled events

HISPA-Teradata Charity Golf Tournament: Driving for Higher Education

Welcome Reception: Teradata Farmer’s Market

Luncheon & Expo Hall Reception

Tee off at the annual Driving for Higher Education Golf Tournament, benefiting the Hispanic Scholarship Fund. The event will take place at the Maderas Golf Club, San Diego’s leading public golf course, complete with three lakes, five waterfalls, and over forty acres of native wildflowers. Located only 30 minutes from downtown San Diego, the Maderas Golf Club provides the ultimate experience in Southern California, offering beauty and challenge as it winds through the cliffs, rock outcroppings, creeks, and forests of the inland hill country of north San Diego.

This Farmer’s Market event is a recipe for success—great drinks, healthy food, and a stunning setting with good friends! What could be better?

Enjoy lunch and refreshments, and get a first-hand look at hundreds of the latest solutions, products, and services. Meet the exhibitors and exchange ideas with industry visionaries—all in a friendly environment.

Maderas Golf Club Sunday, October 2 8:00am – 3:00pm

Hilton Bayfront Park Sunday, October 2 6:00pm – 9:00pm

☞Just a Reminder Round-trip transportation, continental breakfast, golf contests, refreshments, lunch, and awards are included in the price.

4

2011 Teradata PARTNERS User Group Conference & Expo

Convention Center Halls G & H Tuesday, October 4 Noon – 3:00pm

Conference Program

gAlA event

Gala Event

Wednesday, October 5 7:00pm – 10:00pm USS Midway The Gala Event, hosted at the USS Midway, is a lively evening of dinner, entertainment, and networking among conference attendees and exhibitors. Now located on the “front porch” of San Diego’s revitalized downtown, the USS Midway was the longest serving U.S. Navy aircraft carrier of the twentieth century. A living piece of American history, the USS Midway is now the most visited floating naval ship museum in the world.

☞Just a Reminder Be sure to wear comfortable shoes.

www.teradata-partners.com

5

keYnote SPeAkeRS The conference offers an exciting lineup of world-class keynote speakers. Enhance the knowledge you gain at workshops and educational sessions with the empowering insights from industry visionaries, innovators, and thought leaders!

Erin Redshaw President, Partners Steering Committee Senior Manager of ETL Loblaw Companies Limited

Monday, October 3 9:00am – Noon Hall F, Convention Center

Erin Redshaw is the senior manager of ETL at Loblaw Companies Limited (LCL) and manages a team of ETL Developers responsible for the development, performance, availability, and successful rollouts for the legacy EDW ETL environments. She also manages the SAP ETL Development and testing teams on the multi-phase SAP project at LCL. Erin has been working with Teradata and several applications since 1999. She is a former member of the Service Focus Team where she was Chairperson, and is also a Teradata Certified Master. Michael Koehler President and Chief Executive Officer Teradata Corporation Michael Koehler led the successful spinoff from NCR Corporation in 2007, and has since led Teradata to a continuing record of strong financial performance and technology innovation. Under Koehler’s leadership, Teradata has grown to a $1.7 billion company.

6

2011 Teradata PARTNERS User Group Conference & Expo

Darryl D. McDonald Executive Vice President, Business Development and CMO Teradata Corporation As executive vice president of Business Development and Marketing for Teradata, Darryl McDonald is responsible for providing strategic direction for Teradata products, solutions, and services and for presenting the Teradata brand worldwide to ensure the company’s continued leadership in enterprise data warehousing. Steven Levitt Best-selling Author FREAKONOMICS Originally published in the U.S. in 2005, FREAKONOMICS instantly became a cultural phenomenon. Hailed by critics and readers alike, it went on to spend more than two years on The New York Times bestseller list, having sold more than 4 million copies around the world, in more than 30 languages. Through forceful storytelling and wry insight, Levitt shows how economics is, at root, the study of incentives – that is, how people get what they want, or need, especially when other people want or need the same thing. FREAKONOMICS shows that the modern world, despite a great deal of complexity and downright deceit, is not impenetrable, is not unknowable, and—if the right questions are asked—is even more intriguing than we think. All it takes is a new way of looking. In 2009, Levitt released the highly acclaimed follow-up, SUPERFREAKONOMICS, an even bolder, funnier, and more surprising book that tackles a host of issues at the very center of modern society: terrorism, global warming, altruism, and more.

Conference Program

Wednesday, October 5 3:30pm – 5:00pm Hall F, Convention Center

Aron Ralston Inspiration for the Film 127 Hours In 2003, Aron Ralston’s story made headlines worldwide. After being pinned by a half-ton boulder for nearly a week in a remote three-foot-wide slot canyon in southern Utah, Ralston narrowly escaped death by amputating his own right forearm. Ralston documented the life-altering experience and his remarkable will to survive in his New York Times best-selling book, Between a Rock and a Hard Place, and his story inspired the movie 127 Hours.

www.teradata-partners.com

7

SeSSIon deScRIPtIonS Something for everyone No matter what your area of expertise or interest, the 2011 PARTNERS Conference has something for you. You can attend a variety of sessions at PARTNERS. These value-packed sessions provide an environment to share experiences on how to positively impact business outcomes through the use of data warehousing and business intelligence solutions. Both the business and technical user’s point of view are represented. Conference educational sessions are organized into tracks to help you choose what is most relevant to your needs. Badges in their badge holders are required for entry to all sessions. Attendees will NOT be permitted access to sessions without a badge.

Sunday Workshops

The three-hour workshops are sponsored by Teradata and kick off the week by showcasing how industry leaders are conquering a wide variety of complex data warehousing and business analytics challenges. Leading edge technical topics share specific capabilities of Teradata and related technologies while business topics use examples or testimonials that prove great impact and value to businesses from their technology investments.

8

Poster Sessions

Poster Sessions present a business or technical topic through a visual display, challenging authors with arranging their ideas on a display board in a way that will quickly and efficiently communicate a story. Conference attendees can view these concepts at their leisure throughout the conference. Attendees can also discuss Poster Session topics with the author on Tuesday from 9:00am – 10:00am in the Poster Session Hallway. A brief, oral presentation may take place as an introduction, but the visual presentation carries the bulk of the message.

2011 Teradata PARTNERS User Group Conference & Expo

Industry Spotlights

Industry Spotlights cover content that is extremely relevant to an industry. They vary in format from panels with customers and experts sharing perspectives, best practices and lessons learned to lecture format with a leading customer in the industry sharing how they leveraged technology to solve and support specific critical business needs and opportunities. Various industry sessions will run simultaneously on Tuesday at 11:00am and last approximately 75 minutes.

Conference Program

SeSSIon tRAck deScRIPtIonS Mini Sessions Mini Sessions are short “deep dive” interactive discussions for a small group on identified technical topics. Each subject matter expert/facilitator comes prepared with a tips/techniques sheet and is prepared to start a dialogue and lead a discussion. There is no formal slide presentation. Attendees come prepared with a few questions for this informal 45-minute session during the lunch hour. Technical Sessions The Technical Category focuses on the selection and implementation of data and analytic technology to deliver breakthrough operational and business results. The presentation should address the technical challenge/opportunity, the applied solution (technology & process), and impact to the business. Business Sessions The Business Category focuses on the application of data and analytic technology to deliver breakthrough business results. The presentation should address the business challenge/opportunity, the applied solution, process impacts, and ROI.

Guru Sessions Guru Sessions are designed for a sophisticated audience to gain in-depth knowledge on technical topics from the most recognized subject matter experts. Super Sessions Industry experts present on a variety of topics in broad, diverse subject areas during Super Sessions.

The Edge New in 2011, the Edge centers on new and upcoming trends, technologies, and tools and how they might change the future of Analytics & Data Warehousing environments. Come explore emerging technologies with today’s visionaries on hot topics such as Big Data, Social Media, Digital Marketing, Geospatial, and much more. Aprimo Sessions

Special Interest Groups (SIGs) The purpose of Special Interest Groups is to foster interactive dialogue to advance a specific area of knowledge, learning, or technology. SIGs have no formal slide presentation and are open to all conference attendees. Come prepared to share your first-hand knowledge and experience. Big Data Sessions Sponsorship Sessions

☞Just a Reminder

A legend appears at the top of the right-hand page throughout the Conference Program Educational Sessions sections to help guide you through the session types. The session track type also appears in the abstracts. www.teradata-partners.com

9

PoSteR SeSSIonS located in the Poster Session Hallway Poster Sessions are available to view Sunday, October 2, through Thursday, October 6, in the Poster Session Hallway. Attendees can also discuss Poster Session topics with the author on Tuesday from 9:00am – 10:00am Poster Sessions present a business or technical topic through a visual display, challenging authors with arranging their ideas on a display board in a way that will quickly and efficiently communicate a story.

PS Hall 1

Once data had been defined, we loaded specification sheets, business definitions, active ETL-directing mappings and other key descriptors, tied them together, and presented them under different formats to various classes of stakeholders. A summary of our efforts are shared in this Poster Session.

David Schrader, Director of Marketing Teradata Corporation

1544 Increasing the ROI in Your Data Warehouse with a Logical Data Model

1350 Practical Tips on Overcoming the Barriers to Pervasive Business Intelligence

In the spring of 2010, Teradata Corporation launched a collaborative effort to investigate why more customers don’t move up the Business Intelligence (BI) Maturity Curve to exploit the value of Teradata for operational intelligence. We concluded that in the list of People, Process, and Technology, technology is not a big barrier. Teradata provides the power to do pervasive BI, yet still only 25-30% of the Teradata customer base has taken advantage of these capabilities. People and Process issues are the culprits. This Poster Session surveys those results, identifying three sample companies who faced and overcame the challenges, as well as two that continue to be challenged. We compiled a Top 10 Obstacles checklist and provide tips on what you can do at your company to anticipate—and overcome—them.

1378 Moving towards Enterprise Data Architecture

PS Hall 2

Kevin Messer, Data Architect Standard Register The first phase in Standard Register’s move to an enterprise data architecture is reviewed with an examination of plans for subsequent phases. Phase I focuses on building a Business Intelligence Guide (BIG) that accumulates and catalogs all terms used in the business and technical arenas. Using Meta Data Services, a tool provided free to Teradata customers, Standard Register loaded descriptors from Oracle, Teradata, SQL Server, Supra, XML files, BI tool (BusinessObjects), and various Excel files into a tailored repository.

10

2011 Teradata PARTNERS User Group Conference & Expo

PS Hall 3

William Matera, Product Management Director Teradata Corporation Co-Presenter: Nancy Kalthoff, Senior Product Manager Teradata Corporation Do you have a blueprint for your data warehouse, both now and for the future? Do you understand what kind of data is required to provide the answers to your most important business questions to achieve success? A pre-built industry logical data model (LDM) may be just the answer to jumpstarting your data warehousing program. Today, many organizations utilize a pre-built LDM to quickly align business requirements with enterprise data. An LDM provides a roadmap for data integration across the enterprise for a phased approach to achieving a “single view of your business.” This Poster Session will show how companies utilized a pre-built industry LDM to jumpstart their data warehouse development. Organizations have cut valuable data warehouse development time, saved considerable human and financial resources, and achieved faster time to market and ROI. Learn how you, too, can leverage an industry LDM to cut costly startup mistakes and help make your warehouse a success.

Mini Session

Technical

Business

Guru

Super

1562 The Life of a Teradata Query

PS Hall 4

SIG

Big Data

Sponsorship

The Edge

1965 Leveraging Teradata to Facilitate Vision Chain Demand Signal Implementation PS Hall 6

Pat Alvarado, Senior Solution Architect Teradata Corporation This Poster Session will follow a Teradata SQL (Structured Query Language) query from its origin at the client through the components of the parsing engine (PE), dispatched execution steps through the BYNET, step execution and file system management in the access module processor (AMP), merge and sorting of the response through the BYNET to the PE, and returning the answer set to the client. Exploration of optimizer decisions and key wording in EXPLAIN plans will be highlighted throughout the journey.

1575 Teradata Migration Accelerator—Using Automation to Migrate to Teradata

PS Hall 5

Marc Fabbo, Senior Product Manager Teradata Corporation You have hit the wall on your present database platform, and you think that migrating to Teradata is the answer to your problems. But what about the risks and the costs associated with migration? There are hundreds of tables and views to migrate and hundreds of Structured Query Language (SQL) scripts. What about procedural languages like PL/SQL? How do you convert those to run in a Teradata environment? This Poster Session introduces the Teradata Migration Accelerator. This Teradata Professional Services tool set is designed to help automate many of the tasks that are required in a migration project. Automation lowers migration costs and speeds the time to value in a migration project. That means you can be up and running on Teradata in a shorter period of time, for less cost, with less risk than if you were to migrate manually.

Conference Program

Aprimo

Kevin McCurdy, Vice President of Sales Vision Chain, Inc.

1591 How Teradata’s New Differentiation Tool Made the Difference for Caesars PS Hall 7

Carlos Bolden, Architect Database Products Caesars Entertainment

Co-Presenter: Al Corsino IT Manager Bayer Consumer Healthcare

Co-Presenter: Timothy Clarke, Senior Solution Architect Teradata Corporation

Legacy programming techniques focused on loops and the logic required to manipulate them to create database applications that run slower than necessary with today’s technologies. Massive Parallel Processing (MPP) systems such as Teradata Corporation’s are designed to optimize set logic, based on Structured Query Language (SQL); this significantly improves throughput by processing whole sets of data at once rather than on one record at a time.

In 2010, Caesars came to the realization that the end of the useful life of their two MP-RAS 5450 systems was drawing near. New features and functionality of the current offering of hardware and software also inspired a need for a change. But times have changed, and Teradata Corporation’s broad family of platform choices had made it more difficult to be certain that the best Teradata platform was chosen to do the job. What made the difference for Caesars was Teradata’s new Platform Differentiation Tool.

In order to write effective SQL, it is necessary to think in terms of set logic. It is much easier than you might think to implement set logic SQL. This Poster Session will present several reallife programming examples of how to improve performance by migrating from program logic to set logic.

Over the span of six months, an intensive study was done with the major business stakeholders. Each outlined the specific needs for their business critical application residing on the current Teradata platform. With an online survey tool developed for Caesars, the Teradata sales team collected and scored responses. The tool was used to visually represent the most appropriate platforms for all of the applications, and with the interrelationship of data, a decision was made. This Poster Session will showcase this survey tool.

www.teradata-partners.com

11

PoSteR SeSSIonS

continued...

1600 How to Be Agile in a Waterfall World

PS Hall 8

1610 Five Ways to Incorporate Social Media into Your Marketing Mix

PS Hall 10

Monica Woolmer, Managing Partner Formation Data Agile development methodologies are hot topics and gaining momentum within the Business Intelligence/Data Warehouse (BI/ DW) industry as well. In reality, what does this mean? What is the difference between agile and waterfall methodologies, and more importantly, if my organization follows a traditional Software Development Lifecycle (SDLC) methodology, can the BI/DW projects be more agile and still “tick” all the required boxes of the SDLC? This Poster Session will introduce a hybrid approach which enables BI/DW projects to be more agile while still fulfilling the requirements of a traditional SDLC.

1360 Metadata Implementation—Why a Metadata Solution is not used by the Business

PS Hall 9

Artur Borycki, EMEA Enterprise Architect Teradata Corporation The Metadata Implementation methodology is based on experiences and discussions with Teradata customers. This Poster Session will highlight examples of why Metadata solutions require proper process definition during the implementation as well as maintenance phases to assure successful use of the Metadata in the day-by-day activities.

1656 Managing Large EDWs through Metadata Robert Tuttle, Director of Solution Marketing Aprimo Most companies are still experimenting with social media and are having difficulty deciding where it fits in their marketing mix. How much should we invest? How do we actually get a return on our investment? This Poster Session will highlight how social media can and should be integrated into your marketing plans, and will then explore five specific ways that social media can be leveraged by marketing, with examples, and a real world discussion of the tools that are available now and how they can be employed.

1617 XML Based Integration with Teradata— Customer Use Cases

PS Hall 11

Srinivas Pandrangi, Software Engineer Teradata Corporation XML is the most popular format for data transfer between applications. As such, most applications provide interfaces that accept and/or generate XML formatted data. Teradata can integrate into these environments through capabilities provided by XML Services. XML Services can extract data from your application’s XML messages through its XML shredding capabilities, and it can produce XML for consumption by these applications through the XML publishing capabilities. This Poster Session provides an overview of XML Services, illustrating its capabilities through customer use cases. The use case descriptions will provide a sampling of the common kinds of motivations of XML shredding and publishing. A description of common implementation paths will provide the audience the

12

information needed to get a quick start in integrating their own XML aware applications with Teradata. The Poster Session will also provide information on the future direction of XML capabilities in the Teradata Database.

2011 Teradata PARTNERS User Group Conference & Expo

PS Hall 12

Christopher Ward, Data Integration Center of Enterprise Architect Teradata Corporation Co-Presenter: Michael Klassen, Data Integration Center of Enterprise Architect Teradata Corporation As our enterprise data warehouses (EDW) continue to inflate in size, it becomes increasingly important to automate the processes involved in loading the data, integrating it, presenting it to the business, and retiring it when its useful life expires. As an industry, we have made significant strides on the automation side with improvements in scheduling subsystems, ETL (extract, transform and load) tools, and even hand crafted TPT (Teradata Parallel Transporter) scripts. Until recently, only customers that needed to adhere to compliancy regulations such as SOX (Sarbanes-Oxley) and BASEL II (Basel Accords for Banking Supervision) really paid significant attention to concepts like Automated Balance and Control (ABaC) formulas or operational (run time) metadata as a critical component of their EDW solution. This trend is rapidly changing—as systems become increasingly automated, they rely more and more heavily on process based management facilities to control them as well. An old proven adage is that you cannot manage something you cannot measure.

Mini Session

Technical

Business

Guru

Super

1660 Analytic Sandbox Quick Start Guide—Lessons Learned and Business Value

SIG

Big Data

Sponsorship

The Edge

1622 Case Studies in Analytics: Accelerating Timeto-Value

PS Hall 13

PS Hall 14

Matt Brahm, Data Architect MillerCoors

Vijitha Kaduwela, Founder and CEO Kavi Associates

Co-Presenter: Neel Nanda, Solution Architect Teradata Corporation

Co-Presenter: Rajesh Inbasekaran, Leader Solutions Delivery Kavi Associates

An Analytic Sandbox is an environment that provides end users the ability to rapidly prototype analytic data in a near-production environment. MillerCoors jumped into this space a year ago, leveraging the Teradata ViewPoint, in order to support latent demand for experimental analytics that was not being met with the typical tool set or methodology.

Why do some analytics projects succeed, while so many others flounder? Business and IT leaders responsible for analytics want their projects to be successful, deliver faster, and control costs. For many, these objectives are elusive. Among other things, leadership success depends on their ability to skillfully navigate the complex technology landscape, and to pick the right implementation strategy. There are few tested ways to simplify these decisions, deliver analytics faster, control costs, and accelerate the time-tovalue. This Poster Session centers on a comprehensive technology and implementation framework that has been successfully applied at several businesses to deliver robust analytics solutions.

In this Poster Session, topics for discussion can cover: the steps we took to develop the sandbox framework, the key resources we used in the initial setup, the deliverables created, and the challenges encountered. Lessons learned will be valuable to other organizations who are contemplating setting up a sandbox environment of their own. The sandbox is a great adjunct to a mature enterprise analytics environment. With the right planning and governance, it can be a big win for your organization.

Conference Program

Aprimo

1743 Practical Unicode

PS Hall 15

Tak Takahashi, Globalization Engineering Manager Teradata Corporation Co-Presenters: Stefan Visuri, Software Engineer Teradata Corporation Julia Yang, Software Engineer Teradata Corporation Why do you need unicode? Your business must require global data warehouse, universal applications, and industry standard to support global business transactions. For a better Unicode implementation with Teradata, it is important to understand key features, current limitations and pitfalls the customer often falls in during data loading and data access. This technical Poster Session discussion can include topics such as: the latest Unicode updates from Teradata, the best practice in Unicode data loading, Unicode programming including stored procedures, UDFs, .Net and Java applications, and algorithmic Unicode compression.

www.teradata-partners.com

13

PoSteR SeSSIonS

continued...

1342 Seamless Access from Excel PivotTables to Teradata

PS Hall 16

1976 Migrating from Teradata Manager to Viewpoint PS Hall 18

1942 Implementing a Successful Governance Model between IT and Business for Business Intelligence

PS Hall 20 Sam Tawfik, Marketing Manager Teradata Corporation

Jennifer Mask, Customer Education Trainer Teradata Corporation

Teradata OLAP Connector makes it easy for Excel PivotTables to access Teradata. This tool makes it easy for Excel users to navigate the dimensional data stored in Teradata without having to extract subsets of the data.

Moving forward with Teradata 13.10, Viewpoint will be the tool of choice for system management. This Poster Session will center on how to use Viewpoint for the reports, alerts, and notifications previously handled by Teradata Manager. Information about importing and configuring Teradata Active System Management settings will also be provided.

Extracting data for analysis creates security challenges, inconsistent view of the data, and delay in access to current business data. This session also includes an Excel to Teradata demo.

1960 Five Ways to Bring Twitter Posts into Your Data Warehouse

1934 Communicating YOUR VALUE to Upper Management: The Route to Real Success!

PS Hall 19

PS Hall 17

Ronald Swift, Senior Executive Lecture University of Georgia Paul Barrett, Director Teradata Corporation Twitter and the data warehouse may seem like a modern day odd couple. Your data warehouse is ordered, structured, and neat and clean—while Twitter is messy, unstructured, and immature. How do these co-exist in the marketing organization of the future? This will be the focus of this Poster Session.

14

Each of us is challenged by the reality that our management may not fully understand what it is that we are doing to contribute to the business. How do we truly accelerate profitability, customer loyalty, and revenues, and also improve the effectiveness of the company. This Poster Session will give you excellent hints and practical ideas on how many people have communicated their VALUE to those above them. Whether you are technical, consultative, supportive, or on the business side of the use of the DW (Data Warehouse), you will find the ideas that will assist you in creating a more positive reality of your successes. The case examples come from proven actions to enhance an individual’s opportunities and impressions on senior management.

2011 Teradata PARTNERS User Group Conference & Expo

Daniela Calaes, Senior Manager of Business Intelligence VIVO VIVO, a Telefonica company, is the largest mobile telecommunication company in the southern hemisphere. With more than 60 million customers, it’s the nationwide market leader in Brazil with almost 30% market share. VIVO stands out from the competition in Business Intelligence (BI) development and usage of information and bases its decision process on effective customer knowledge. BI is nowadays present in the entire decision process and also supports the development of new products, promotions, and the improvement of operational efficiency. This Poster Session will focus on some tips and best practices around implementing a successful governance model, between Business and IT, to make the development process faster and to guarantee time-to-market. It will share lessons learned and show the steps the company made to achieve a maturity level in BI, including roles and responsibilities for each area and how they work extremely integrated, with partnership, to enhance BI around the whole company.

SUNDAY

SUN

SUNDAY

Scheduled Events Time

Event

Location

7:00am – 9:00pm

Registration Open

Convention Center

7:00am – 9:00pm

Poster Sessions

Convention Center Poster Session Hallway

8:00am – 3:00pm

HISPA-Teradata Charity Golf Tournament

Maderas Golf Club

8:30am – 11:30am

Sunday Pre-conference Workshops

Convention Center

10:00am – 10:45am

Networking Break

Conference Sessions Area, Upper Level

11:45am – 1:00pm

Lunch

Convention Center Exhibit Hall F

2:30pm – 5:00pm

Conference Educational Sessions

Convention Center

3:30pm – 4:15pm

Networking Break

Conference Sessions Area, Upper Level

6:00pm – 9:00pm

Welcome Reception

Hilton Bayfront Park

Workshops

8:30am – 11:30am Session #

16

Session Title

Room

Session Type

1160

Sunday Workshop: Teradata-SAS

Paul Segal, Teradata Corporation

Technical

1166

Sunday Workshop: Teradata Indexes

25

Alison Torres, Teradata Corporation

Technical

1308

Sunday Workshop: Migrating from Oracle to Teradata, Where, Why and How

22

Mark Shainman, Teradata Corporation

Technical

1326

Sunday Workshop: “Teradata Live”—an End-to-End Demo of Teradata

24

Lance Miller, Teradata Corporation

Technical

1347

Sunday Workshop: ‘Get It Together’ With Teradata Analytical Ecosystem

23

Imad Birouty, Teradata Corporation

Technical

1391

Sunday Workshop: “Enterprise Data Management – A Practical Approach”

Ballrm 20 B, C

Eddie Sayer, Teradata Corporation

Business

1700

Sunday Workshop: Capacity Planning for Enterprise Data Warehouse Deployment

Ballrm 20 D

Stephen Brobst, Teradata Corporation

Technical

1879

Sunday Workshop: A Holistic Approach to Information Security Architecture for Your EDW

30 A, B

Daniel Pumphrey, Teradata Corporation

Technical

1914

Sunday Workshop: Unleash the Power of Data from Your Digital Channels

28 A, B, C

Rebecca Bucnis, Teradata Corporation

Business

2283

Sunday Workshop: A Hands-On Introduction to the Aster Data Analytic Platform

Girish Kirshnamurthi, Teradata Corporation

Business

3340

Sunday Workshop: Aprimo Customer Management Workshop

Wes Moore, Aprimo

Aprimo

2011 Teradata PARTNERS User Group Conference & Expo

29 C, D

Presenter

29 A, B 28 E

Educational Sessions

1:00pm – 2:00pm Session #

Session Title

Room

Presenter

Session Type

Technical

Ballrm 20 A

4:00pm – 5:00pm Session #

Session Title

1388

Real Questions, Real Answers, Real Fast

1444

Managing Nokia’s Complex and Dynamic Enterprise Data Warehouse

Educational Sessions Room

Presenter

Ballrm 20 D

Session Type

Roman Coba, McCain’s

Business

Jari Suurnakki, Nokia

Business

2240

PARTNERS Conference Orientation

1315

No Primary Indexes—A Brave New World

23

Daniel Skidmore, OVERSTOCK.COM

1330

Getting Business Answers Now, Delivery Acceleration through Integrated Data

26

Tim Colbert, Comcast

Technical

1510

Ten Rules for Next Generation Data Integration

25

Philip Russom, TDWI

Technical

1500

How Metro Successfully Manages Their Dual System Environment with TMSM!

25

Martina Ritzer, Metro Systems GmbH

Technical

1543

Ten Practical Steps for Building Data Quality into Your Data Warehouse

24

Andy Bury, Teradata Corporation

Technical

1567

Bringing the Cloud to Earth: How to Navigate Through the Fog

1698

Being Prepared for High Demand in the Massive Scoring Process of Consumer

1708

BI for Finance: Enabling Self-Service Reporting & Analytics at Office Depot

1793

Achieving Real-time Data Quality in the Data Warehouse

1837

Illuminating the Path to Purchase

1890

Research Analytics: Evolving the World of Market Research

28 A, B, C

1943

Integrating Social Media into the Enterprise Marketing Mix

30 A, B

Ballrm 20 B, C Ballrm 20 D 29 C, D 24 29 A, B

Matthew Nylin, MillerCoors

Technical

1608

Ten Things We Love about Social Network Analysis

Fernando Siqueira, Serasa Experian

Business

1623

From Nothing to Something & Beyond: The Data Management Journey for Westpac

30 A, B 29 A, B

Ranjith Chelasani, Office Depot

Business

1771

How to Incorporate Digital Marketing into Your Overall Marketing Strategy

Peter Storer, Blue Cross Blue Shield North Carolina

Technical

1787

United Airlines Active Revenue Management

Corey Bergstrom, Cabela’s Inc.

Business

1804

Near Real-Time Marketing Data Analysis Architecture

Marc Ryan, InsightExpress

Business

1957

Data Science at LinkedIn: Iterative, Big Data Analytics, and You

John Lovett, Web Analytics Demystified

Business

2:30pm – 3:30pm Session #

Session Title

Presenter

23

Brian Mitchell, Teradata Corporation

Technical

1363

Swiftly Transforming Data Transportation and Replication at Swift

25

John Wight, Swift Transportaion Corp.

Technical

1463

Quality Points and Quality Rules - Neglected Key Factor in BI Environment

24

Svilen Stoyanov, Mobiltel

Technical

1481

New Innovations in Data Warehousing Technology

Stephen Brobst, Teradata Corporation

Technical

1516

Using 0perational Data to Improve Customer’s Satisfaction and Reduce Costs

30 A, B

Lino Radakian, Oi

Business

29 A, B

Michael Parduhn, CVS Caremark

Business

Intelligent Loyalty Programs: Insights into the CVS ExtraCare Program Getting Value by Integrating Credit and Retail Data in a Datawarehouse

1716

Performance Tuning Post Agile/Sprint Session

1929

Fly Over the ‘Synapse’ between the Company Neurons

1946

Big Data at eBay—A Technical Discussion

1994

Introduction to Teradata Business Intelligence Optimizer

23 Ballrm 20 B, C Ballrm 20 A

Session Type

Going Small and Fast: Successful Tactical Work Amongst Mixed Workloads

1527

28 A, B, C

Educational Sessions Room

1313

1689

29 C, D

Ballrm 20 A

Ballrm 20 D

Philippe Eymond, Banque Accord - AUCHAN

Business

Ballrm 20 B, C

Michael Brenner, Discover Financial Services

Technical

28 A, B, C

Franck Bellaiche, STIME-MOUSQUETAIRES

Business

Tom Fastner, eBay, Inc.

Technical

Shannon Terry, Nationwide

Technical

29 C, D 26

HISPA-Teradata Charity Golf Tournament, Sunday, October 2 at the Maderas Golf Club, San Diego, CA

Judy Bayer, Teradata Corporation

Business

Chaminka De Silva, Westpac

Business

Wes Moore, Aprimo

Business

Carlos Ibarra, Actifact Corp

Technical

Bhanu Pittampally, The Cosmopolitan of Las Vegas

Technical

Scott Nicholson, LinkedIn

Business

FOLDOUT FOR SUNDAY AGENDA

Sunday Sessions

SUNDAY WORKSHOPS 8:30am – 11:30am 1160 Teradata-SAS 8:30am – 11:00am Room 29 C, D

Paul Segal, Regional Lead Teradata-SAS Center of Excellence Teradata Corporation Co-Presenters: James Scoggins, CTO Strategic Alliances Teradata Corporation

8:30am – 11:00am Room 22

Mark Shainman, Global Program Manager Teradata Corporation

Key to the workshop will be a live demonstration of covering the integration between SAS applications and Teradata, showing how the in-database processing can allow the users to work efficiently and with the same (if not more) freedom than they are use to.

1166 Teradata Indexes

1326 Teradata Live—An End-to-End Demo of Teradata

This workshop will demonstrate SAS applications that have been optimized for Teradata In-Database Processing.

8:30am – 11:00am Room 25

8:30am – 11:00am Room 24

Alison Torres, Director Teradata Corporation

Lance Miller, Assistant Vice President, Global Services Marketing Teradata Corporation

Co-Presenter: Larry Carter, Senior Learning Consultant Teradata Corporation This is more than an overview of the Indexes that are available in Teradata and how they work. We will cover Primary Indexes: Unique and Non-Unique, Partitioned Primary Indexes, Multi-Level

17

1308 Migrating from Oracle to Teradata, Where, Why and How

This workshop is an overview on migrating to Teradata. The workshop covers the architectural and functional differences between Oracle and Teradata. It will also translate commonly used terms, functionality, and processes in Oracle into Teradata terms and processes. The workshop will also educate attendees on the types of migrations and each one’s pluses and minuses. Then it will inform attendees about what to do during the initial planning stages of a migration and delve into the processes of data and database migration as well as application, business intelligence, and ETL (Extract, Transform, Load) migration.

Gary Spakes, SAS-Teradata Centre of Excellence SAS

www.teradata-partners.com

Partitioned Primary Indexes; Secondary Indexes: Unique, Nonunique, Single Table Join, Aggregate Join, Value Ordered, Sparse, and Hash Indexes; and some interesting ways to mix and match indexes to gain optimal access and performance.

18

Co-Presenter Gary Richard, Senior Solution Architect Teradata Corporation This session is a “hands-on Teradata” workshop showcasing endto-end Teradata capabilities (tools, products, services, third party

2011 Teradata PARTNERS User Group Conference & Expo

tools) from the time data appears through the time decisions are produced. There will be a live server and dataset used to illustrate the value of Teradata.

1347 Get It Together with Teradata Analytical Ecosystem 8:30am – 11:00am Room 23

Imad Birouty, Program Marketing Manager Teradata Corporation Co-Presenters: Sergio Ferragut, Dual Systems Architect Teradata Corporation Ariff Kassam, Product Manager Teradata Corporation Stan Mlynarczyk, Director Enterprise Architecture Teradata Corporation Whether your goal is high availability, workload optimization, greater throughput and system utilization, or enhanced ROI (Return on Invesment), Teradata’s Analytical Ecosystem can help you achieve these and more. Teradata experts from engineering and professional services will provide an in-depth understanding of our products and services. Teradata Unity, Teradata Multi-System Manager, Teradata Data Mover, best practices for planning and implementation, and more. Come listen, learn, and interact with the experts…and interact with your peers.

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

The Edge

1391 Enterprise Data Management: A Practical Approach

1700 Capacity Planning for Enterprise Data Warehouse Deployment

Eddie Sayer, Service Offer Manager Teradata Corporation

Stephen Brobst, Chief Technology Officer Teradata Corporation

Co-Presenter: Kevin Lewis, Partner, Professional Services Teradata Corporation

This workshop describes a framework for capacity planning in an enterprise data warehouse environment. We will propose a model for defining service level agreements (SLAs), and then use these SLAs to drive the capacity planning and configuration for enterprise data warehouse solutions. Guidelines will be provided for capacity planning in a mixed workload environment involving both strategic and tactical decision support. Performance implications related to technology trends in multi-core CPU deployment, large memory deployment, and high density disk drives will be described. In addition, the capacity planning implications for different approaches for data acquisition will be considered.

8:30am – 11:00am Ballroom 20 B, C

What does it mean to “manage information as an asset”? Most organizations struggle to manage traditional assets—people, equipment, and real estate—much less terabytes or petabytes of data! How do you turn the pipedream into reality? The answer is enterprise data management (EDM). This session examines the underlying components of EDM: data governance and stewardship, data quality, data integration, data security and privacy, metadata, master data management, and data architecture. The presenters will discuss the business case for EDM and how to turn theory into practice. Additionally, the presenters will explore real-world best practices and common pitfalls. The session concludes with “how to get started with EDM.” The presenters will discuss practical steps for getting EDM off the ground. Participants will leave the session not only better educated on EDM, but armed with ideas for managing information as an asset in their own organizations.

Sunday Workshops

Aprimo

8:30am – 11:00am Ballroom 20 D

1879 A Holistic Approach to Information Security Architecture for Your Enterprise Data Warehouse 8:30am – 11:00am Room 30 A, B

Daniel Pumphrey, Senior Security Consultant Teradata Corporation Co-Presenter: Leslie McMonagle, PS Managing Partner Teradata Corporation

policy that limits the collection, processing, storage, and access to the same sensitive information. This presentation will outline how to implement a comprehensive, holistic, and balanced information security architecture for your EDW that satisfies relevant data privacy concerns while enabling the intended business value. A top-down, risk management approach is used along with internationally recognized information security frameworks and best practices to achieve an appropriate “security posture” relative to the specific industry, data content, regulatory environment, and company culture. Attendees will leave with a better understanding of how to achieve an “appropriate” security posture for their EDW.

1914 Unleash the Power of Data from Your Digital Channels

8:30am – 11:00am Room 28 A, B, & C

Rebecca Bucnis, Director, Industry Marketing & Solutions, Retail Teradata Corporation Co-Presenter: Paul Barrett, Director Teradata Corporation New insights from digital channels such as web, social media, and mobile are changing the way companies do business and engage with customers. These channels are delivering a lot of information about customers, behaviors, preferences, and interactions that can ultimately drive many new opportunities... IF companies are leveraging this “Big Data” resource. In this workshop, Teradata experts, partners, and customers will explore the data, new data types, and insight opportunities that these channels offer, where to focus to get more business value, some common obstacles and best practices, and some basic technology principles to think about. This workshop is targeted at marketers, business managers, and IT professionals interested in leveraging these digital channels to improve their business.

Companies implement an enterprise data warehouse (EDW) to exploit raw data from multiple disparate sources and transform it into valuable information through advanced analytics. This is often in contention with information security regulations and data privacy

www.teradata-partners.com

19

SUndAY WoRkSHoPS 2283 A Hands-On Introduction to the Aster Data Analytic Platform

8:30am – 11:00am Room 29 A, B

continued...

it with their CRM strategy; as well as discuss the importance of having more than a one way dialog with their customers and how they can expand their customer relationships by integrating inbound and outbound communications. Finally, the workshop will cover how Teradata customers can integrate marketing operations and marketing automation by leveraging the AMS/ARM integration.

Girish Kirshnamurthi, Manager, Support Engineering Teradata Corporation In this workshop, we will start with an introduction to Aster Data nCluster and discuss some key features of nCluster 4.6, like SQL-MapReduce, Dynamic Workload Management and rowcolumnar hybrid storage. A demo of Aster Data Developer Express (ADE), Aster Data’s development tool for created SQL-MapReduce functions will be given and will demonstrate how easy it is to use ADE for developing SQL-MapReduce programs. Finally, we will learn to apply some of Aster Data nCluster’s popular pre-packaged SQL-MapReduce functions, like nPath and Market Basket generator to gain deeper insights to consumer behavior and how it impacts the business.

3340 Aprimo Customer Management

8:30am – 11:00am Room 28 E

Wes Moore, Vice President, IMM Solutuions Aprimo Co-Presenter: Marc Schroeder, Vice President B2C Solutions Marketing This Customer Management workshop covers three key areas affecting customer management in today’s marketing environment: Digital Marketing, Integration of Inbound and Outbound, and the Integration of Marketing Automation and Marketing Operations. The workshop will discuss what social data organizations should collect and what they can do with this information by integrating

20

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

The Edge

Aprimo

Sunday Sessions

noteS

www.teradata-partners.com

21

SUndAY edUcAtIonAl SeSSIonS 1:00pm – 2:00pm 2240 Conference Orientation 1:00pm–2:00pm Ballroom 20 A

Join members of the Partners Steering Committee as they guide you through the general content and logistics of the conference. This will be your first opportunity to ask questions before the conference shifts into high gear. The orientation will provide a helpful conference overview, including: • A complete conference itinerary and special events • Ways you can maximize your time and experience • Tips for getting around

1315 No Primary Indexes—A Brave New World 1:00pm – 2:00pm Room 23

Daniel Skidmore, EDW DBA OVERSTOCK.COM Teradata 13 introduced a strange new concept of No Primary Index Tables. Strange at least to those of us familiar Teradata and how critical choosing the correct Primary Index is with regards to database and query performance. Though NoPI tables is a new concept, in the correct situation they can be powerful tools to improve system data load time.

1330 Getting Business Answers Now, Delivery Acceleration through Integrated Data 1:00pm – 2:00pm Room 26

Tim Colbert, Principal Data Architect Comcast Co-presenter: Robert Bender, Chief Architect for CMEU Teradata Corporation Comcast completed their first phase of their National Data Warehouse (NDW) last year. They are now beginning to see some outstanding results from the reports and analytics coming out of the NDW. However, these great results lead to more questions by the business. Some of those questions require additional data which is not currently in the NDW. A 3-year roadmap was created to chart the incoming data. But what happens when the Chief Financial Officer asks a question that requires data that is not slated for

22

2011 Teradata PARTNERS User Group Conference & Expo

delivery for another year? Well, that is where Comcast got creative. In this presentation we will explain the new methodology that was created to ensure that the needs of the business would be met when they needed them, while at the same time ensuring that the Core Integrated Data Layer of the NDW was continuing to be built out. Utilizing tools from Teradata like the Comm LDM, EDWR and TMM, they have developed a process to deliver results when the business needs them.

1500 How Metro Successfully Manages Their Dual System Environment with TMSM! 1:00pm – 2:00pm Room 25

Martina Ritzer, Senior Department Manager Application Operations METRO SYSTEMS GmbH Co-Presenter: Luzie Wischka, Senior Architect Data Warehouse Teradata Corporation Metro’s Dual Active System environment executes approximately 50,000 different batch processes per day on each system. This includes more than 10,000 load processes and 10,000 distinct transformation and migration processes in 43 separate database environments for different sales lines in 34 countries. Owing to the high number of different load processes, the Metro Data Warehouse team has a high need for a simplified charts overview of all their load activities. Beginning in 2009, Metro decided to implement the Teradata Multi-System Manager (TMSM) to monitor and manage their load activities. In this session, we will show you the efforts and benefits of using TMSM for Metro. Furthermore, we will describe the different implementation steps, the achieved results, and how Metro uses TMSM to efficiently manage their load processes.

Mini Session

Technical

Business

Guru

Super

1567 Bringing the Cloud to Earth: How to Navigate through the Fog 1:00pm – 2:00pm Ballroom 20 B, C

SIG

Big Data

Sponsorship

The Edge

1698 Being Prepared for High Demand in the Massive Scoring Process of Consumers 1:00pm – 2:00pm Ballroom 20 D

Matthew Nylin, Database Analyst MillerCoors

Fernando Siqueira, Senior Consultant Serasa Experian

Co-Presenter: Sue Paulson, IT Lead Technologist, Data Warehouse GE Healthcare

Panelists: Eder de Abreu Alves, Senior Consultant Serasa Experian

Even though they are in different industries, MillerCoors and GE Healthcare face similar challenges when it comes to environment management and development support in their Teradata environment. About a year ago, both companies began a journey to utilize VMWare and cloud computing concepts along with the Teradata Database. Their goals were similar: to enable better conformity with corporate standards, better coordination during development cycles, and better allocation of database resources to appropriate tasks, and to realize cost savings while still expanding their Teradata capabilities.

Roberto Ângelo Fernandes Santos, Data Intelligence Manager Serasa Experian

Along the way, both companies found unexpected rewards and unforeseen challenges. From the need to change their organizational approach to data warehouse development to the ability to evaluate new functionality in the database without risking existing applications, these two companies would like to share their journey with you and help you bring your organization “to the cloud.”

Sunday Sessions

Aprimo

Companies have been efficient in capturing and storing large volumes of data from their daily transactions. However, this large volume of data does not mean good use of information. In this way, most companies are starting to search patterns from the big data in a rational way. Serasa Experian had the big challenge of processing different types of scoring (credit, collection, fraud, marketing) for its over 180 million Brazilian consumers. So, processing with low time of response and reduced cost to fulfill the growing demand from the massive processing of high complexity statistic models was a serious challenge. Teradata brought good results for Serasa’s massive scoring processing. As remarkable features, we can highlight response time and integration with SAS. This solution has been helping both consolidate Serasa Experian as a reference in the Latam Analytics services as well as an important instrument to increase the offer of new credit products in this moment of vigorous economic growth.

1708 Business Intelligence (BI) for Finance: Enabling Self-Service Reporting & Analytics at Office Depot 1:00pm – 2:00pm Room 29 C, D

Ranjith Chelasani, Business Intelligence Principal Architect Office Depot Prior to 2008, the Office Depot finance department needed to query multiple applications to tie the GL to its corresponding sub-ledgers. Replicating the General Ledger (GL) mapping logic and balancing queries were challenging. To empower business users and reduce Finance’s reliance on IT for ongoing analytical support, Office Depot began sourcing financial data from its newly implemented Oracle E-Business Suite Enterprise Resource Planning (ERP) into its Teradata system. This session will detail how Office Depot designed a financial systems architecture—including Teradata Decision Experts, Oracle BI Hyperion Essbase, and Cognos reports and dashboards—that provided Finance with enhanced reporting and analytic capabilities. Hear about the business value realized by 300+ business users at Office Depot through Teradata and its partnered solutions.

1793 Achieving Real-time Data Quality in the Data Warehouse 1:00pm – 2:00pm Room 24

Peter Storer, Lead Architect Blue Cross Blue Shield North Carolina Blue Cross and Blue Shield of North Carolina has embarked on developing a critical Master Data Management (MDM) solution, anchored by the Teradata Enterprise Data Warehouse (EDW) and www.teradata-partners.com

23

SUndAY edUcAtIonAl SeSSIonS the Trillium Software System for dynamically improving data quality in real-time. Through the implementation phases, BCBSNC has gained a vastly greater understanding of the real-time cleansing and matching processes—in batch and real-time, including some significant differences between operating in an analytics (EDW) versus an operational (MDM) space. Peter Storer of BCBSNC plans to share his best practices, anecdotes, advice, benefits, and horror stories for accomplishing this critical and complex initiative as they move into production. This session will discuss some of these differences in a very pragmatic way.

1837 Illuminating the Path to Purchase 1:00pm – 2:00pm Room 29 A, B

Corey Bergstrom, Senior Director of Direct Marketing and Marketing Research & Analysis Cabela’s Inc. Co-Presenter: John Tanner, Associate Dean Baylor University Marketers, sit up and take heed: What used to be the ‘Art of Marketing’ is quickly becoming a true science. With academic rigor, we tested marketing theories and challenged hypotheses. Now, through a detailed study of integrating true offline and online behavior, we have illuminated the path to purchase, discovering new dynamic marketing strategies yielding impressive ROI. Academia and real-life met at Cabela’s, the world’s foremost outfitter. By enhancing Teradata’s analytic platform with web behavioral data, we studied an integrated view of shopping and purchasing data across multiple channels. The result is insight into the path to purchase that dramatically changes the process of marketing. In this session, we will share that process and discuss how Cabela’s successfully implemented dynamic marketing campaigns with new insights that for many customers, it takes a combination of influences—online, catalog, and in-store—to illuminate a purchase.

24

continued...

1890 Research Analytics: Evolving the World of Market Research

demonstrate the value of social media activities because they rely on counting metrics like fans, followers, views, and visits as measures of success. Companies that transcend these measures and deliver business value metrics that support the goals of the marketing enterprise are infusing social media into their corporate strategies. When operationalized within a proven framework, these efforts deliver sustainable social marketing programs that produce definitive results.

Marc Ryan, Chief Research Officer InsightExpress

In this session, the presenter will share his experience and secrets about how to capitalize on social analytics and integrate social media within the enterprise marketing mix.

1:00pm – 2:00pm Room 28 A, B, & C

Businesses have always made decisions based on data, historically as part of the market research function, but with the emergence of Big Data, research has taken a back seat to analytics. This session will examine the evolution of the research industry highlighting the significant changes that have affected data buyers over the past 50 years. Special attention is paid to how big data has changed the market research landscape and how the market research department is evolving into a research analytics function that answers the “who,” “what,” and “how” questions via big data, and the “why” questions via attitudinal data. Details will be provided on how InsightExpress has evolved from a market research company to a research analytics company through the deliberate implementation of a hybrid attitudinal/data warehouse platform. Discussion will cover the learning and challenges experienced in implementing and deploying a hybrid solution for data collection.

1943 Integrating Social Media into the Enterprise Marketing Mix

1:00pm – 2:00pm Room 30 A, B

John Lovett, Senior Partner Web Analytics Demystified Social media has evolved from a marketing experiment to an enterprise mandate. Yet, many marketers still struggle to

2011 Teradata PARTNERS User Group Conference & Expo

2:30pm – 3:30pm 1313 Going Small and Fast: Successful Tactical Work Amongst Mixed Workloads 2:30pm – 3:30pm Room 23

Brian Mitchell, Senior Consultant Teradata Corporation Panelists: Carrie Ballinger, Senior Technical Consultant Teradata Corporation Claybourne Barrineau, Teradata Architect The Home Depot, Inc. Steve Woodrow, Senior Performance Consultant, GSC Teradata Corporation Tactical query performance is influenced by numerous factors in an active data warehouse environment. Success with tactical query workloads typically requires a multi-disciplinary approach. This panel discussion brings together a multi-disciplinary group of experts, all who have made a career out of focusing on tactical queries.

Mini Session

Technical

Business

Guru

Super

We will share critical lessons learned from the Teradata GSC in solving tactical performance issues, offer direct experiences helping customers tune and manage their tactical query performance, focus on tactical query application design and database opportunities that have been successful, highlight system-level settings that can support tactical performance, and review a few effective workload management techniques. The panel will share good experiences, warn you about pitfalls, and will leave plenty of time to respond to your particular questions around tactical queries.

1363 Swiftly Transforming Data Transportation and Replication at Swift 2:30pm – 3:30pm Room 25

John Wight, Enterprise Data Warehouse Integration DBA Swift Transportation Corp. Co-Presenter: Karlo Borboa, Senior Consultant AVEA Consulting Travel through the experiences gained from the evolution of a Dual Active Enterprise Data Warehouse (EDW) solution for the “Best in Class” transportation company in North America. See how this demand became the main driver for an architectural evolution to a High Availability EDW environment. Understand how, Swift met those challenges by “re-engineering” an extensible ETL (Extract, Transform, Load) Architecture. Observe how Swift Transportation’s EDW Team optimized operational, transaction oriented data extracts by architecting an object oriented change data capture solution—allowing business update cycles that are more frequent and responsive, while minimizing the latency between source and EDW data. Observe how Swift uses TPT (Taradata Parellel Transporter) to read central operational transactions and loads its Dual Systems; minimizing data latency between primary and secondary systems. Witness recoverability features of their ETL architecture in the event of failures. This session shares the experiences gained as Swift delivered a “best in class” EDW solution.

SIG

Big Data

Sponsorship

The Edge

Sunday Sessions

Aprimo

1463 Quality Points and Quality Rules: Neglected Key Factor in Business Intelligence Environment 2:30pm – 3:30pm Room 24

data warehouse deployments and provide a roadmap for effective adoption.

1516 Using 0perational Data to Improve Customer’s Satisfaction and Reduce Costs 2:30pm – 3:30pm Room 30 A, B

Svilen Stoyanov, Head of Business Intelligence Mobiltel The system for quality monitoring in data warehouse data flow is usually neglected by Business Intelligence managers and developers. We will discuss how important it is to monitor the quality your data flows, how to define the appropriate quality points and rules with their definition, and how to automate and present the results of the monitoring. We will look at how such systems can help the company with significant changes to source systems; e.g., changing the billing system. Finally, we will look at what is the impact of the business after full redesign of Data Warehouse and how crucial it is for the business and controlling units in the relay of the data warehouse data in order to drive the business in the new situation coming from the changed environment.

1481 New Innovations in Data Warehousing Technology 2:30pm – 3:30pm Ballroom 20 A

Lino Radakian, Customer Care Manager Oi Learn how Oi, the major convergent communication company in Brazil, with 65 million subscribers, improved customer care quality and reduced operational costs by using analytical information. Starting with cross-channel analysis, customer web surfing data, and IVR traffic, Oi was able to understand customer behavior on the two most important channels, identify issues and solve them— delivering more efficient WEB and IVR services. Additionally, Oi validated campaign effectiveness (product, plans, region and profile), making fast decisions to make changes when necessary. Also, key information for sales, marketing, billing and network engineering was identified. Additional content to be discussed includes: new contact channel options (Mobile Care and chat), reducing traffic on CC, and overall costs. Using HR, customer care and government geo, social, economic population information, Oi defined its call center expansion strategy. Considering the Brazil economic scenario, qualified employees are rare and concentrated in high cost areas.

Stephen Brobst, Chief Technology Officer Teradata Corporation The session examines new innovations and technology trends in the data warehousing marketplace. Important technology trends to be covered include: (1) columnar and compression technologies, (2) new programming paradigms with open source software, SQL-MapReduce, and in-database processing, and (3) deployment of hybrid storage architectures and solid state disk subsystems. We will discuss the implications of these technologies for modern

www.teradata-partners.com

25

SUndAY edUcAtIonAl SeSSIonS 1527 Intelligent Loyalty Programs: Insights into the CVS ExtraCare Program

2:30pm – 3:30pm Room 29 A, B

Michael Parduhn, ExtraCare Analytics and Operations CVS Caremark Remember when loyalty programs were constructed as—buy 10 items and get the 11th one free! They served their purpose at the time but were void of personalization and relevancy. Analytics and customer insights weren’t necessary; however, it did make us rethink our programs—thus smarter, more relevant loyalty programs emerged. The CVS ExtraCare program is world class, has become the core to our business strategy, and provides a targeted and relevant customer management framework instead of just a rewards program. Through insights uncovered from purchase history, ExtraCare is driving hundreds of millions of dollars in sales through targeted offers via multiple channels. Our customer relationship management enables more relevant offers, increased customer satisfaction, and is foundational to the ExtraCare customer experience. This presentation explores the acceleration of business cycle times and the benefits to our customer relationships and loyalty.

1689 Getting Value by Integrating Credit and Retail Data in a Data Warehouse 2:30pm – 3:30pm Ballroom 20 D

Banque Accord is the Auchan entity providing consumer credit and credit cards around Europe. Auchan is among the top ten largest retailers in the world with $50 billion in revenue. Until recently, the credit and the retail businesses didn’t share their Business Intelligence and Customer Resource Management. Leveraging its acquired data warehouse skills and datalab approach, Banque Accord has convinced two retail entities of the group to manage end-to-end customer insights by deepening the analysis of their loyalty data.

1929 Fly Over the “Synapse” Between the Company Neurons 2:30pm – 3:30pm Room 28 A, B, & C

The obvious benefits from this synergy are cost-related and speed using another Auchan entity instead of outsourcing.

Franck Bellaiche, Business Intelligence & Customer Resource Management Director STIME-MOUSQUETAIRES

The ultimate goal of integrating retail and credit data is a multichannel view of customers. This should result in more benefits for retail and consumer credit businesses, enabling accurate credit risk evaluation and growth potential of each customer.

Co-Presenter: Jean-Marc Bonnet, Solution Architect Teradata Corporation

1716 Performance Tuning Post Agile/Sprint Session 2:30pm – 3:30pm Ballroom 20 B, C

Michael Brenner, Discover Financial Services IT Manager In a world of Agile/Sprint Room solutions that quickly deliver critical business data for better decision making, often database performance tuning is an afterthought. With the urgency to deliver in a tight timeframe and with only a high level knowledge the new data, it is very challenging to performance tune during an Agile/ Sprint engagement. This session will provide insight into tips and techniques to improve performance once the Agile/Sprint session is complete.

Philippe Eymond, Data and Architecture Director Banque Accord - AUCHAN Co-Presenter: Edouard Servan-Schreiber, Advanced Analytics Director Teradata Corporation

26

continued...

2011 Teradata PARTNERS User Group Conference & Expo

Mousquetaires Group is the 3rd European retailer with nearly 3,500 points of sales, 40 plants and 44 logistics bases across Europe and the Balkans. Above all Mousquetaires is a 3,000 independent entrepreneurs organisation, 130,000 employees and 35 billion euros turnover. The Stime is an IT subsidiary. It’s mission is to develop and implement Info System and manage its consistency for all subsidiaries. To build our corp DWH, first we used a progressive and transverse consolidation of multiple entities and data sources we called Synapse. The Datalab approach from Teradata allows us to reduce data latency thanks to “service bureau,” and to convince other subsidiaries to join EDW thanks to designing their project with real data loaded in the Datalab. Most recent business application is innovation in new multi-format geomarketing. This project benefits are dramatic optimizations in Master Plan implementation of multi-brand stores by format and One-to-One offers with personalized coupons.

Mini Session

Technical

Business

Guru

Super

1946 Big Data at eBay – A Technical Discussion

2:30pm – 3:30pm Room 29 C, D

Tom Fastner, Senior Member of Technical Staff, Architecture eBay, Inc. What does it take to do analytics on a system designed to hold more data than all written works of mankind? The analytical use of transactional data became part of the corporate DNA over the last decade. Platform, processes, and people are well equipped to master it’s requirements. Competing in tomorrow’s economy will require more—much more! Just adding user behavior information into the mix creates a multidimensional challenge for hardware, software, tools, and processes. This presentation will discuss eBay’s technical challenges managing and processing complex data for a new generation of analytics on one of the largest big data sites on this planet.

SIG

Big Data

Sponsorship

The Edge

Sunday Sessions

Aprimo

1994 Introduction to Teradata Business Intelligence Optimizer 2:30pm – 3:30pm Room 26

Shannon Terry, Director, Customer Analytics Nationwide This presentation will show the practical application of the Teradata Business Intelligence Optimizer (TBIO) suite of tools in addressing a common problem in organizations: spreadsheet proliferation. Spreadsheets are powerful tools, but they can become dangerous when data is taken out of the data warehouse and improperly handled or manipulated. The TBIO tool suite allows you to embrace the reality of spreadsheet-based BI in your organization while creating a safe and structured environment in which spreadsheet users can leverage value in your warehouse.

4:00pm – 5:00pm 1388 Real Questions, Real Answers, Real Fast 4:00pm – 5:00pm Ballroom 20 D

Roman Coba, Chief Information Officer McCain’s Business Intelligence (BI) insight, formerly a strategic weapon for only the most innovative of companies, has become a front-andcenter operational tool for many organizations. This mission critical component of the business has moved from back office analytics to a front office customer interface tool. The use of real-time data analytics within an active data warehouse delivers valuable, consistent, and timely information to customer agents as well as users from almost any corporate functional area. Learn how technical methodologies, such as continuous load architectures, workload management, integrated web-speed queries, and sophisticated dashboards complement business information needs across the enterprise to deliver tangible and immediate value. This customer case study illustrates the practicality and relevance of BI information and tools within the competitive industry faced by

www.teradata-partners.com

27

SUndAY edUcAtIonAl SeSSIonS corporate entities today.

1444 Managing Nokia’s Complex and Dynamic Enterprise Data Warehouse 4:00pm – 5:00pm Room 29 C, D

Jari Suurnakki, Product Manager Nokia Co-Presenter: Risto Rouru, Engagement Manager Teradata Corporation Nokia currently drives complex consumer and enterprise analytics through its data warehouse which has been rapidly growing as more internal departments embrace the company’s information strategy. When Nokia purchased Teradata technology, they knew from the start they would make liberal use of vendors and partners to help build and operate the data warehouse solution. However, to manage multiple vendors, Nokia needed to adopt processes to source the right skills, coordinate resources, and establish operational standards for data warehouse governance and project management. In this presentation, Nokia will discuss the rationale, business case, and selection criteria used in selecting vendors to help support their data warehouse environment—including commissioning of Teradata Managed Services. Nokia will also share how they perform database, ETL (Extract, Transform, Load) and Business Intelligence operations control and monitoring, manage data warehouse changes, improve data warehouse availability, and more.

continued...

1510 Ten Rules for Next Generation Data Integration 4:00pm – 5:00pm Room 25

Philip Russom, Research Director TDWI Data integration (DI) has evolved and grown so fast and furiously in the last ten years that it has transcended ancient definitions of it. Getting a grip on a modern definition of DI is difficult, because “data integration” has become an umbrella term and a broad concept that encompasses many things. To help you get a grip, the Ten Rules for Next Generation Data Integration listed in this presentation provide an inventory of techniques, team structures, tool types, methods, mindsets, and other DI solution characteristics that are desirable for a fully modern next-generation DI solution. Admittedly, the list of ten rules is daunting because it’s thorough. To sort it out, the presentation shows which DI functions are set for growth (based on survey data), as well as which business cases benefit from which DI functions.

1608 Ten Things We Love about Social Network Analysis 4:00pm – 5:00pm Room 28 A, B, & C

Judy Bayer, Director Advanced Analytics Teradata Corporation Co-presenter: Edouard Servan-Schreiber, Director Cross-Channel Analytics Teradata Corporation Social network analysis (SNA) is now becoming an important analytics technology for telecommunications companies. SNA is most often used to help companies reduce churn and increase cross-sell. However, there are many other business applications of SNA.

1543 Ten Practical Steps for Building Data Quality into Your Data Warehouse

Teradata customers have been using SNA for strategic and tactical business opportunities. In this presentation, we describe 10 valuable business applications of SNA. Examples include some types of competitor analysis, imputing demographics, and improved customer lifecycle management. We describe the business applications and the patterns in the data that support the use cases. We also give an overview of the actions that are taken, and the business value achieved.

Andy Bury, Service Offer Manager Teradata Corporation

This presentation is a summary of the use cases of SNA from several telecommunications companies, in different parts of Europe, Middle East, and Africa. For these companies, marketing based on relationships between people is now an important part of their business.

4:00pm – 5:00pm Room 24

This session will review current best practice for building data quality into data warehouses. The presentation will review how data architecture, data management processes, and tools can be leveraged to assess, monitor, and manage data as it enters the data warehouse. The presentation will also examine the roles the business, IT, and data governance and data stewards should play in this process.

28

The session will discuss the relative importance of master data (customer, product, asset, etc.) vs. transaction data (credit, debit, call detail record, etc.) and the different processes, checks, and types of tools that can be applied to different types of data.

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

1623 From Nothing to Something and Beyond: The Data Management Journey for Westpac 4:00pm – 5:00pm Room 30 A, B

Chaminka De Silva, Head of Information Management Westpac With over 10 million customers, Westpac is one of the ‘big four’ banks in Australia. In 2008, Westpac merged with St George, and the world plunged into a global financial crisis! However, Westpac had an enormous opportunity—consolidating technology between the two banks while sustaining its multi-branding business strategy. The information landscape consisted of six data warehouses (two Teradata warehouses), multiple data integrations, reconciliation armies, over 25,000 data marts and 19,000 interfaces, AND no data management team! It kicked off an AUD$1.8bn investment executing IT Strategy of which AUD$200m is focused on data management. How do you take a bank that is a data nightmare and transform it? You hire the best and you start leapfrogging! The presenter will share insight into building an information management capability from scratch, initiating IM strategy, implementing governance, metadata and DQ and pushing one of the largest banks in Australia to a new realm in information management.

SIG

Big Data

Sponsorship

The Edge

Sunday Sessions

Aprimo

1771 How to Incorporate Digital Marketing into Your Overall Marketing Strategy

4:00pm – 5:00pm Room 29 A, B

Wes Moore, Vice President IMM Solutions Aprimo What exactly is digital marketing—a channel, a way of communicating, or a strategy? The answer is all three! It sounds complex and mysterious, but in reality, it’s about engaging the customer when the customer wants to be engaged. How do you incorporate digital into your marketing strategy? And, who are some of the companies engaging in it, and what benefits are they receiving from “going digital.” This session will define the space and explore the common channels and devices used to communicate digitally with customers. You’ll learn how leading edge companies (and not just technology or Internet companies) are driving results, creating better relationships with their customers, and supporting their overall marketing objectives through digital initiatives. You’ll also learn where to start and how specific technology solutions can support your digital marketing efforts. A digital strategy and the tools to execute will be key for new-age consumers to receive your marketing messages!

1787 United Airlines Active Revenue Management 4:00pm – 5:00pm Room 23

Carlos Ibarra, President Actifact Corp Co-Presenter: Anne Marie Reynolds, Director, Data Warehousing United Airlines In the competitive environment of the airlines, a few minutes of data latency can make a significant difference in profitability. Traditionally, airlines have run their revenue management computations nightly on offline systems, preloading the online reservation systems with parameters that drive split-second pricing and seat availability decisions. United Airlines is using its Teradata Active Enterprise Data Warehouse to continuously control these parameters, re-optimizing flights as often as once per minute. In order to support this level of performance and low latency, United optimized its Teradata configuration for active data warehousing through the use of PE-only nodes, real-time ETL (Extract, Transform, Load) for bookings, inventory, forecasting data, and tactical decision support systems that act on booking activity in near-realtime. This session describes how United is leading the way in active revenue management.

www.teradata-partners.com

29

SUndAY edUcAtIonAl SeSSIonS

continued...

1804 Near Real-Time Marketing Data Analysis Architecture

1957 Data Science at LinkedIn: Iterative, Big Data Analytics, and You

Bhanu Pittampally, Database Administrator The Cosmopolitan of Las Vegas

Scott Nicholson, Senior Data Scientist LinkedIn

Co-Presenter: Mike Connell, Senior PS Consultant Teradata Corporation

Companies who compete on analytics and delivering data-driven services need to iterate quickly on big data. This enables rapid data exploration to identify unknown relationships and trends to create new products and services. Come to this session to see how LinkedIn has created a core competency around analytics. Understand about the techniques and technologies LinkedIn data scientists use, including the Aster Data analytic platform, to create data-driven products such as People You May Know. See real-life examples of how Aster Data’s SQL-MapReduce enables analytics that can’t be done (easily) in traditional relational database systems. Get ideas of how to apply iterative big data analytics in your own organization and enable your own analytics center of innovation.

4:00pm – 5:00pm Ballroom 20 BC

Marketers today have more techniques than ever before to drive customer behavior. Increasingly, these methods involve responding to customer events and interactions in real-time. However, these real-time interactions need a historical context to shape the messaging and are deployed with predictive modeling that anticipates the customer’s future behavior. Marketers at the Cosmopolitan of Las Vegas realized the value of predictive analytics combined with near real-time information to differentiate their property in the saturated Las Vegas market.

4:00pm – 5:00pm Ballroom 20 A

To accomplish this, the Cosmopolitan of Las Vegas has implemented several data acquisition strategies that leverage the power of the Teradata Database. This session will cover the Cosmopolitan of Las Vegas’ approach for batch, mini-batch, micro-batch, and change data capture, and when to implement each strategy. Technologies covered include the role of replication, queue tables, triggers, and stored procedures in the architecture.

30

2011 Teradata PARTNERS User Group Conference & Expo

MONDAY

MON

MONDAY

Scheduled Events Time

Event

Location

7:00am – 6:00pm

Registration Open

Convention Center

7:00am – 6:00pm

Poster Sessions

Convention Center Poster Session Hallway

7:00am – 8:30pm

Breakfast

Convention Center Exhibit Hall F

9:00am – Noon

General Session with Keynote Speakers

Convention Center Exhibit Hall H

10:00am – 10:45am

Networking Break

Conference Sessions Area, Upper Level

Noon – 1:30pm

Lunch

Convention Center Exhibit Hall F

1:30pm – 5:30pm

Conference Educational Sessions

Convention Center

2:30pm – 3:30pm

Networking Break

Exhibit Hall G

Expo Hall Hours Exhibit Hall G

Noon – 5:00pm

Mini Sessions

12:15pm – 1:00pm Session # 1223

32

Session Title But I’m Not Ready for Dual Systems......Yet

1303

Implementing an Enterprise Data Warehouse Performance Data Management—Separating Fact(s) from Fiction(s)

1309

Teradata’s Modern Family—Viewpoint and Performance Data Collection

1372

What’s the Scoop on Hadoop?

1531

Demystifying Teradata Subqueries

1551

Leveraging Your Logical Model for Termporal Teradata Database 13.0

1592

Logical Data Model – Blueprint to Successful Implementation

1595

Teradata Concept Factory: Come Influence Teradata’s Next-gen Optimization Tool!

1611

Temporal Database - Definitions, Query Optimization, and Modifications

1869

Workload Management on the Teradata Data Warehouse Appliance

1884

How Do You Create a Wildly Successful Data Warehouse?

2011 Teradata PARTNERS User Group Conference & Expo

Room 29 AB 28 A, B, & C 30 A, B

Presenter

Session Type

Jim Venske, Teradata Corporation

Technical

Gregory Sannik, Teradata Corporation

Technical

Barbara Christjohn, Teradata Corporation

Technical

Ballrm 20 A

Jim Blair, Teradata Corporation

Technical

25

Grace Au, Teradata Corporation

Technical

Ballrm 20 D

Don Tonner, Teradata Corporation

Technical

23

Snezana Banjanin, Group Health Cooperative

Technical

26

Darrick Sogabe, Teradata Corporation

Technical

Bhashyam Ramesh, Teradata Corporation

Technical

29 C, D

Rick Burns, Teradata Corporation

Technical

24

Todd Walter, Teradata Corporation

Technical

28 E

Educational Sessions

1:30pm – 2:30pm Session #

Session Title

Room

Session Type

4:30pm – 5:30pm Session #

Session Title

Insight to Action with MicroStrategy’s Mobile App Platform

1606

Decoding the Perceived Complexities of Teradata Workload Management 14.0

Ballrm 20 A

Darrick Sogabe, Teradata Corporation

Technical

1369

Recursive Structured Query Language for Solving Real Business Problems

23

Darrin Gaines, Teradata Corporation

Technical

1784

Integrated Oilfield Operations of the Future – Data to Decisions

28 A, B, & C

Paul Kissell, ConocoPhillips

Business

1485

What is Hadoop and Why Do You Care?

26

Daniel Graham, Teradata Corporation

Technical

Explains for Dummies Understanding “Big Data”—It’s More Than Just Data Volume

1811

Saks Fifth Avenue Transforms Demand Chain Management

1833

Implementing Complex Data Sharing Rules in a Complex Industry

1834

Teradata Database Architecture Overview—Part 1

1866

Silly Bandz, Jibbitz, & Copernicus: Driving Innovation Through Analytics

1896

SIG: Teradata and SAP BI Enterprise Integration Best Practices

1964

Use Aprimo Marketing Studio to Execute New Go-to-Market Strategies

1970

Tactical Reporting at The Home Depot

2161

Managing Delta’s Customer Transaction Data-Extracting More Value from the Passenger Name Record

Ballrm 20 B, C 26 29 C, D 25 ExHall F Ballrm 20 D 22 29 A, B 23 30 A, B

1204

Hot ‘n Cold Data, Fast ‘n Slow Storage: Get Performance Using Teradata Virtual Storage 13.10

Business

1283

Mastering Metadata Management at Lowe’s

Sheila Pynegar, Teradata Corporation

Technical

1513

One Size Does Not Fit All: Using Multiple Logical Models to Create One Enterprise Data Warehouse

Colin White, BI Research

Technical

1678

Application Tuning with Teradata Database 13.10 Performance Features at Metro

Session Title

1724

Customer Engagement in a Digital World Create Actionable Business Insights from Complex Data

28 A, B, C ExHall F

Tasso Argyros, Aster Data Systems, Inc.

Technical

22

Alan Greenspan, Teradata Corporation

Technical

Haresh Gangwani, Aprimo

Business

Todd Walter, Teradata Corporation

Technical

1741

Do More with Your Data: Deep Analytics Using Big Data

Business

1754

SIG: Teradata Temporal: It’s Time to Look at Time Differently

Jürgen Grap, Teradata Corporation

Technical

1764

Putting Marketers in Control of Data: Using Best Practices of MCM

Sara Costello, Sylvan Learning

Business

1848

How Geospatial Technologies are Taking the US Air Force to New Heights

Claybourne Barrineau, The Home Depot, Inc.

Technical

1936

Using Business Intelligence (BI) and Analytics to Support Product Launches and Sales

Derek Adair, Delta

Business

Presenter

Session Type Technical

Utilizing Teradata Express for Development and Sandboxing

25

Cameron Monson, Overstock.com

DBQL Normalization Keeps Key Data and Saves 99% of Query and Object Tables

23

Nan Yang, Boeing

Technical

1385

Integrating Marketing Processes to Drive Return on Marketing Investment

Kimberly Collins, Gartner

Business

Bryan Rockoff, NBCUniversal

Business

1390

Using Analytics to Select What America Watches—from Concept to Hit at NBC

1518

Teradata Goes Social! IT and Business Intelligence Users Interact with Taradata in a Twitter Chat

Ballrm 20 A

Jean Brant, Oi

Technical

1819

Predictive Business Intelligence—Leveraging Atomic-level Forecasts

Ballrm 20 D

Greg Moore, Aprimo

Business

1836

Teradata Database Architecture Overview—Part 2

ExHall F

Todd Walter, Teradata Corporation

Technical

1906

Global Financial Reporting: The Journey to Finance One

30 A, B

Krishan Kumar, Pfizer

Business

1931

Exploring PERIOD—Your First Step to Temporal Data

Joshua Skarphol, WebMD

Technical

1935

Squeezing Blood from a Turnip or Extending the Life of Your Current System

Ballrm 20 B, C

1966

Bridge the Chasm: Aligning Business and IT for a Financial Data Warehouse

29 C, D

1984

eBay’s Scalable Approach to Clickstream Data Analysis on Multi-Petabytes

3520

The NetApp Solution for Hadoop: Taming the Yellow Elephant from the Land of the Internet Giants

24

26 28 E

Technical Technical

1737

1358

28 A, B, C

Kevin Stallings, United Rentals Inc Joerg Thienenkamp, METRO SYSTEMS

Business

Bill Franks, Teradata Corporation

Bill Grenwelge, FedEx Services

Technical

Daniel Capozzi, Discover Financial Services

Business

Dinesh Chavan, eBay, Inc.

Technical

Jeff O’Neal, NetApp

Business

30 A, B

Technical Business

Technical

1202

29 A, B

24 Ballrm 20 B, C

John Catozzi, Teradata Corporation Kathryn DioQuino, Lowe’s

Bert Crump, Saks Fifth Avenue

Educational Sessions Room

29 C, D

Henry Krewer, ARC

3:00pm – 4:00pm Session #

Ballrm 20 A

Session Type

Teradata Database 13.10 SQL Solutions for Real-World Temporal Problems

1810

Technical

Hugh Owen, MicroStrategy

Presenter

1398

28 E

Darrin Gaines, Teradata Corporation

Educational Sessions Room

1375

1797

24

Presenter

29 A, B 25 Ballrm 20 D

Mohan Sawhney, Kellogg School of Management

Technical

Thomas Bishop, Ohio State University

Business

Timothy Cotton, US Air Force

Technical

Leandro Andrade, VIVO

Business

FOLDOUT FOR MONDAY AGENDA

Monday Sessions

MONDAY EDUCATIONAL SESSIONS Mini Sessions 12:15pm – 1:00pm 1223 But I’m Not Ready for Dual Systems...Yet 12:15pm – 1:00pm Room 29 A, B

1303 Implementing an Enterprise Data Warehouse Performance Data Management—Separating Fact(s) from Fiction(s)

12:15pm – 1:00pm Room 28 A, B, & C

1309 Teradata’s Modern Family—Viewpoint and Performance Data Collection

12:15pm – 1:00pm Room 30 A, B

Barbara Christjohn, Principal Consultant Teradata Corporation Jim Venske, Instructor Teradata Corporation

Gregory Sannik, Principal Consultant Teradata Corporation

More and more Teradata customers are moving to multiple Teradata systems and reaping the benefits. Others see moving to dual systems in the not too distant future. If you see dual systems in your future but aren’t quite ready to make the move, then this session is for you.

Panelists: Robert Fintel, Principal Consultant Teradata Corporation

There are things you can do on your existing system that will not only get your current data warehousing environment running in top form but will also position you for a smoother transition to dual systems. This session highlights some of the major dual systems issues and what you can do to prepare for them.

Thomas Manfredi, Principal Consultant Teradata Corporation Geoff Plummer, Principal Consultant Teradata Corporation Transforming an abstract logical data model into performant physical and semantic data models can be a daunting task — even more so if supporting an Enterprise Data Warehouse/Active Data Warehouse (EDW/ADW). The physical implementation must support often conflicting divisional and corporate data management and Business Intelligence (BI) requirements. It must also balance the integration of new data sources and subject areas in support of acquisitions and mergers, support temporal and non-temporal data access using a variety of BI technologies while being performant and available on a 24/7/365 basis. Feeling overwhelmed? Perhaps talking about it will help. Our panel of LDM/PDM/SDM experts will share and facilitate discussions on the following perhaps all too familiar questions: • Have you ever seen a 3NF that performs consistently without having to materialize anything? • Can a virtual semantic layer meet my performance requirements? • What are the likely challenges to integrating data across the enterprise?

www.teradata-partners.com

33

34

2011 Teradata PARTNERS User Group Conference & Expo

Co-Presenter: Dan Fritz, Senior Product Manager Teradata Corporation Are you responsible for performance on your Teradata systems? If so, this discussion will help you understand where performance data is located and how it can be used to your advantage. We will talk about reasons for establishing a data collection process based on DBC dictionary tables and discover the key tables to maintain. You will learn how to use Teradata Viewpoint for issue identification. The facilitator can also discuss functions and reporting available in Teradata Manager and similar functions available in Teradata Viewpoint. Finally, attendees will discover how to use and report on performance data in Teradata Viewpoint and DBC Dictionary tables to support Application Performance, Workload Management, and Capacity Management.

1372 What’s the Scoop on Hadoop 12:15pm – 1:00pm Ballroom 20 A

Jim Blair, Consultant Teradata Corporation You have heard about big data. And then there’s all the buzz about Hadoop with MapReduce processes. So where does Teradata fit into the picture with Hadoop - MapReduce? This discussion covers what Hadoop – MapReduce is and is not, and how Teradata coexists with Hadoop. We will talk about the basics of Hadoop,

Mini Session

Technical

Business

Guru

Super

when and where and how Teradata “connects” to Hadoop. How does Teradata partner to effectively utilize Hadoop? We can also discuss Teradata’s acquisition of Aster Data and how that fits into the picture of Teradata with big data.

1531 Demystifying Teradata Subqueries

12:15pm – 1:00pm Room 25

Grace Au, Software Engineer Teradata Corporation Co-Presenter: Vijay Sarathy, Software Architect Teradata Corporation Subquery is a powerful Structured Query Language construct that is used frequently to compose queries for complex business questions. At the same, time subqueries can be non-intuitive and complicated to use—sometimes due to its rich set of features. To name a few: a subquery can be connected to an outer query using relational operators such as EXISTS and NOT IN; a subquery can be correlated to an outer query which can be the same or a different one than the connected outer query; a subquery that returns a scalar value can be used anywhere an expression is allowed in a query block. Optimization of subqueries has been one of the strengths of the Teradata Optimizer. In this session, we will review the various characteristics of subqueries. We will discuss the Teradata subqueries optimization techniques, when they are applied or not applied, and how to recognize them from explain outputs.

SIG

Big Data

Sponsorship

The Edge

Monday Sessions

Aprimo

1551 Leveraging Your Logical Model for Teradata Temporal Database 13.0

12:15pm – 1:00pm Ballroom 20 D

Don Tonner, Senior Product Manager Teradata Corporation What is the correct method to show time-varying data in a nondimensional logical model? This session will highlight some of the issues arising with logical modeling and temporal database design. A method will be demonstrated allowing your business friendly logical model to easily transform into a physical model that deploys a sophisticated temporal Teradata Database 13.10.

1592 Logical Data Model—Blueprint to Successful Implementation

12:15pm – 1:00pm Room 23

Snezana Banjanin, Project Manager Group Health Cooperative Co-Presenter: Lee Arnett , Senior Product Manager, Architecture and Modeling Solutions Teradata Corporation Group Health Cooperative (GHC) had a mature data warehouse that, due to its age and design, was limiting integration of information. It needed to be replaced with newer technologies. When choosing an effective solution GHC decided to replace and rebuild the warehouse using the Teradata Health Care Logical Data Model as a blueprint to an integrated enterprise data warehouse.

complete data model. Because the core of the data warehouse was built on an enterprise model, the integration of new consumer health survey information had a straightforward solution. The warehouse was extended to hold the information by building a previously unemployed subject area of the data model. The value of the result exceeded the incremental cost of building the few tables required to hold the survey information.

1595 Teradata Concept Factory: Come Influence Teradata’s Next-gen Optimization Tool!

12:15pm – 1:00pm Room 26

Darrick Sogabe, Product Manager Teradata Corporation Co-Presenter: Mike Coutts, Client Software Chief Technical Officer Teradata Corporation Gathering requirements and collecting feedback from your users is the first and most critical aspect in the software development lifecycle. Furthermore, products are often developed based solely on the vendor’s idea of what the user wants. Teradata’s next generation optimization tool seeks to provide users with an easy to use solution that addresses THEIR business problems (not Teradata’s simulated issues). This interactive session will provide participants with a “sneakpeek” into a future product. Most importantly, it will seek to extract valuable feedback and real life production use case information from the audience that will directly influence the product.

This discussion traces the process that led to a successful implementation, and the value that resulted from having a www.teradata-partners.com

35

MondAY edUcAtIonAl SeSSIonS 1611 Temporal Database—Definitions, Query Optimization, and Modifications

12:15pm – 1:00pm Room 28 E

Bhashyam Ramesh, Teradata Fellow Teradata Corporation This presentation describes the new temporal feature using examples. Temporal support is new to any major database vendor. Starting in Teradata 13.10, built-in support for reasoning with temporal data models is provided. Attendees of this session will learn how to create temporal data models for their problems. They will understand through examples the concepts behind a temporal data model and the kinds of applications that will benefit from temporal analysis. They will also understand from examples how to create temporal tables and specify data base enforced temporal constraints. They will learn how to write optimized queries that benefit from temporal constraints. In addition, the kinds of Structured Query Languages (SQLs) that can be issued for modifications and SELECT will be covered. Finally, specific ideas on how to maintain performance for temporal applications will be covered.

1869 Workload Management on the Teradata Data Warehouse Appliance

12:15pm – 1:00pm Room 29 C, D

Rick Burns, Manager Teradata Corporation While the workload management capabilities of the Teradata Data Warehouse Appliance are not as rich as those on Active Enterprise Data Warehouse systems, they combine strong capabilities and ease-of-use to support mixed workloads and outpace competitive appliances. This session will explore the workload management

36

continued...

features available on the appliance and show how they can be used to implement a variety of service level goals. It will cover priority classes, filters and throttles, exception handling and common classification, and it will describe the range of dispatch control or “gatekeeper” functions available on the appliance, as well as the dynamic priority management of currently executing tasks. We will explain how these capabilities can support a level of mixed workload, including tactical, ad hoc and analytic queries, that go well beyond the needs of simple data marts.

1884 How Do You Create a Wildly Successful Data Warehouse?

12:15pm – 1:00pm Room 24

Data Warehouses are known for storing data over time, both historical point-in-time transactions as well as temporal data that is valid over a range of time. Storing this data is one thing, but retrieving it to answer critical business questions can be a Structured Query Language (SQL) challenge. For example, a business may want to identify suspicious credit card behavior by selecting all 4-hour time periods in which a card member’s dollars purchased exceeded a threshold. These types of temporal problems can be tricky to solve, but this session focuses on Teradata 13.10 SQL features which both simplify the SQL coding and perform well. Key features to be used include: 1) Temporal Constraints, 2) EXPAND ON clause, and 3) Period Table Functions. The business problems in this session span industries, so you are bound to see problems that apply to your organization AND how to solve them.

1398 Insight to Action with MicroStrategy’s Mobile App Platform

Todd Walter, Chief Technologist Teradata Corporation

1:30pm – 2:30pm Room 28 E

How Do You Create a Wildly Successful Data Warehouse? Do you have a wildly successful data warehouse? Would you like to? Best practices taken from a wide variety of customers will be used to show what makes a data warehouse most successful—or not. Many aspects of data warehousing will be discussed, including the processes surrounding the warehouse, the architecture of the analytic environment, funding models, and agile analytics.

Hugh Owen, Director, Mobile Product Marketing MicroStrategy

1:30pm – 2:30pm 1375 Teradata 13.10 SQL Solutions for Real-World Temporal Problems 1:30pm – 2:30pm Room 24

Darrin Gaines, Senior Consultant Teradata Corporation

2011 Teradata PARTNERS User Group Conference & Expo

Which disruptive technology can you use to differentiate what you sell and how you conduct your business? Which technology is redefining entire industries, generating billions in new revenue, and bankrupting companies that are too slow to adapt? Mobile. Find out how to reap the benefits for your organization using MicroStrategy’s Mobile App Platform. See examples from some of the hundreds of organizations that have deployed Mobile Apps built with MicroStrategy over the last year. MicroStrategy’s Mobile Platform includes pre-built mobile functionality and drag-and-drop design tools to help you build apps faster. Learn about the latest developments from MicroStrategy that simplify and accelerate App development to help you rapidly mobilize all of your operational systems, point of sale, marketing, and business intelligence.

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

The Edge

1:30pm – 2:30pm Ballroom 20 A

underway for some time and have generally stalled due to a lack of understanding of the importance of the role of data in the equation. In order to take advantage of real-time operational decision capabilities, you must be able to collect, collate, and communicate terabytes of machine-generated data in a fast and efficient manner to thousands of potential users.

Darrick Sogabe, Product Manager Teradata Corporation

In this session, we will discuss the journey ConocoPhillips and Teradata are on to turn data into information that can be used throughout the organization to impact real-time operational decisions.

1606 Decoding the Perceived Complexities of Teradata Workload Management 14.0

In general, Workload Management is viewed as a challenging and complicated exercise. Granted, other database vendor’s workload management schemes are indeed complex. However, Teradata Active System Management is the exception to this generality. This session will easily articulate the principles behind Teradata’s Active System Management and why it should be implemented at every customer site. In addition, the presentation will walk participants through a generic use-case, to demonstrate the ”Ease of Use” aspects around the new workload management infrastructure in Teradata Database14.0.

1784 Integrated Oilfield Operations of the Future— Data to Decisions

1:30pm – 2:30pm Room 28 A, B, & C

Paul Kissell, IT Manager, Eagle Ford – Integrated Operations of the Future ConocoPhillips Co-Presenter: Glen Sartain, Director, Oil & Gas Practice Teradata Corporation There has been much hype in the Oil and Gas industry about the “Digital Oilfield of the Future.” These initiatives have been

Monday Sessions

Aprimo

1797 Explains for Dummies 1:30pm – 2:30pm Ballroom 20 B, C

Sheila Pynegar, Senior Data Warehouse Consultant Teradata Corporation This entry level session is particularly suitable for developers, business professionals, and support personnel who need to understand and improve the running of Structured Query Language (SQL) on Teradata. The session will assume prior knowledge and will introduce delegates to the various components of a typical Teradata SQL explain statement: • Locking • Confidence levels • Use of indexes • Join plans It will illustrate the importance of indexes and statistics to Teradata performance.

1810 Understanding “Big Data”—It’s More Than Just Data Volume

1:30pm – 2:30pm Room 26

Colin White, Founder BI Research The data warehousing environment is faced with constantly increasing data volumes, growing analytical processing complexity, and the need to handle a wider variety of different types of data and data sources. Some organizations use the term “big data” to describe this situation. However, the business problems being addressed by so-called “big data” solutions do not fit neatly into a single category. Different approaches and techniques have to be used based on business need and the types of “big data” problems that an organization needs to address. This presentation looks at new and evolving technologies for solving “big data” problems and discusses the pros and cons of each. It discusses the business use cases that can be addressed by these various technologies and looks at how they can coexist to provide an integrated business analytics environment.

1811 Saks Fifth Avenue Transforms Demand Chain Management

1:30pm – 2:30pm Room 29 C, D

Bert Crump, Director of Information Technology, Merchandising Systems Saks Fifth Avenue Saks Fifth Avenue has transformed their demand chain environment to a new and sophisticated process that maximizes store support and customer service. The new “hold and flow” philosophy has completely re-engineered their merchandise allocation to leverage www.teradata-partners.com

37

MondAY edUcAtIonAl SeSSIonS actual selling patterns, both at the store level and regionally, as well as the statistical forecasting models within their state-of-theart demand chain management solution.

1833 Implementing Complex Data Sharing Rules in a Complex Industry 1:30pm – 2:30pm Room 25

Henry Krewer, Enterprise Information Architect ARC Co-Presenters: Hans Meijer, Technical Director Protegrity Alicia Sasser, Database Administrator ARC ARC’s Airline Industry Data Warehouse consists of data, owned by multiple carriers and sources, subject to government regulation. This results in complex disclosure rules. Data at the row or column level may be released to groups of carriers based upon market, data source, carrier relationships, and government regulations. A row and cell level data disclosure scheme, based upon dynamic security keys, stored procedures, views and query banding, was designed to meet these requirements. It was natural to turn to Protegrity to implement this scheme since ARC was already leveraging Defiance DPS for data encryption. Additional technical considerations were defining the boundaries of ARC versus Protegrity responsibilities, the ease of use to manage the data disclosure rules, the performance of the external applications, and the stability of the final product. This session presents an in depth discussion of the business drivers, the solution design and implementation.

38

continued...

1834 Teradata Database Architecture Overview— Part 1 1:30pm – 2:30pm Expo Hall F

Todd Walter, Chief Technologist Teradata Corporation The Teradata Database system is different from other databases in a number of fundamental ways. If you want to know what these differences are and how they make it possible for Teradata to deliver unlimited scalability in every dimension, high performance, simple management and all the other requirements of the Active Data Warehouse, then this is the session for you. We will discuss how the architecture of Teradata enables you to quickly, efficiently, and flexibly deliver value to your business.

1866 Silly Bandz, Jibbitz, and Copernicus: Driving Innovation Through Analytics

1:30pm – 2:30pm Ballroom 20 D

Bill Franks, Chief Analytics Officer, Global SAS Program Teradata Corporation Establishing a culture of innovation and discovery is neither easy nor common. Most organizations provide, at most, lip service to the idea. However, without continuous innovation, your organization will be doomed to fade away as your competition relentlessly takes away your business. This is especially true in the area of business analytics. World-class companies need to constantly find new ways to leverage data and analysis to change how they do business. In order to put in place a culture of innovation and discovery, your company will need to challenge ingrained assumptions and thinking. In this session, we will discuss some key concepts to focus on to successfully use innovative analytics to drive change

2011 Teradata PARTNERS User Group Conference & Expo

in your organization. The goal of the session is to get attendees to think differently about how their organization is approaching analytics today.

1896 SIG: Teradata and SAP BI Enterprise Integration Best Practices

1:30pm – 2:30pm Room 22

Jürgen Grap, Senior SAP Technical Consultant Teradata Corporation Panelists: Steve Giansanti, Director, Americas SAP COE Teradata Corporation Mark Marty, Senior Manager, Business Intelligence Architecture Levi Strauss & Co. Innovative companies understand optimal data integration means leveraging all valuable data from disparate systems across the enterprise. By offering a complete and holistic view of enterprise information, optimized data integration improves analysis capabilities at every level and enables executives to pinpoint effective strategies. This Special Interest Group discussion can include topics on how customers can consolidate all enterprise information in one place and benefit from an integrated offering, including everything from data warehouse infrastructure and management to business intelligence tools and in-memory analytics. SAP applications, tools and appliances can also be discussed. Attendees will gain insight into how you can leverage your existing SAP environment and continue to grow that environment with the latest SAP technologies.

Mini Session

Technical

Business

Guru

Super

1964 Use Aprimo Marketing Studio to Execute New Go-to-Market Strategies

1:30pm – 2:30pm Room 29 A, B

Sara Costello, Senior Director, Relationship Marketing II Sylvan Learning Sylvan Learning is the leading provider of tutoring and supplemental education services to students of all ages and skill levels. At Sylvan, tutors tailor individualized learning plans that build the skills, habits, and attitudes students need to succeed in school and in life. Affordable tutoring instruction is available at almost 900 learning centers in the United States, Canada, and abroad. In today’s economic surroundings, it’s clear that customer relationships are a key to success at Sylvan Learning. As a result, leadership was looking for systematic, scalable methods of strengthening communications between centers and customers. Marketing tested new segmentation and lead conversion tactics and found tremendous new opportunities using Aprimo Marketing Studio while not being inhibited by an ability to scale. Sylvan marketing has been able to impact the bottom line and enable their franchises to build tighter customer relationships through communication, and succeed in their local markets.

1970 Tactical Reporting at The Home Depot 1:30pm – 2:30pm Room 23

Claybourne Barrineau, Teradata Architect The Home Depot, Inc. Why start small…The Home Depot’s first two major Teradata reporting applications (StoreWalk Mobility and ProjectOne) have over 30,000 combined distinct users. In order to support the reporting service level agreements (SLAs) for these two

SIG

Big Data

Sponsorship

The Edge

Monday Sessions

Aprimo

applications in our mixed-workload environment, a large amount of time has been spent on modeling and tuning. Of note, we heavily rely on Teradata Active System Management, Query Banding, Single Amp Access Query Plans, and Indexing. The purpose of this presentation is to highlight the pros and cons of our physical implementations and to provide the audience with real-world examples of the challenges faced and results rendered.

2161 Managing Delta’s Customer Transaction Data— Extracting More Value from the Passenger Name Record

1:30pm – 2:30pm Room 30 A, B

Derek Adair, Director, Schedule Distribution and Analysis Delta Co-Presenter: Frank Bush, Senior Industry Consultant Teradata Corporation Booking and ticketing data is the life blood of an airline. The basic structure of an airline booking transaction, the Passenger Name Record (PNR), is the result of a legacy of systems originally designed in the 1950s. Delta embarked on an extensive database build out, using their Teradata platform, to capture and translate this PNR data into a more useful and accessible form. As a result, Delta is now answering more complicated business questions more quickly than ever before. In addition, Delta-Northwest realized an added benefit from the data when it came time to merge the two airlines. This project contributed significantly to the initial merger of passenger data and continues to grow in importance to facilitating core analytics as well as supporting scheduling and planning needs.

3:00pm – 4:00pm 1202 Utilizing Teradata Express for Development and Sandboxing 3:00pm – 4:00pm Room 25

Cameron Monson, Database Architect Overstock.com With increasing demands on our Teradata systems, how do you find a way to perform functional testing and development while decreasing the load on your enterprise systems? Utilizing the Teradata Express offering coupled with VMWare GSX, we were able to provide our developers a private environment for testing and validation. This allowed our test system to take on a workload that is more representative of our production environment for performance testing and Quality Assurance.

1358 DBQL Normalization Keeps Key Data and Saves 99% of Query and Object Tables 3:00pm – 4:00pm Room 23

Nan Yang, Teradata Performance Specialist Boeing This generic process is applied to Teradata Database Query Log (DBQL) tables to enhance the accuracy, performance, and space by keeping all key performance data, query texts, and objects. Duplicate query texts and objects can be normalized to one query text and one set of objects by a unique key to link to the log table. It may save 99% space for millions of dollars over months. A summary table takes 1% space of the log table and can

www.teradata-partners.com

39

MondAY edUcAtIonAl SeSSIonS instantly access years of query text and key performance data for comparison and audit. In January 2011, this processed 1.3 billion queries in a 16-node Teradata 5600 system to get 3.8 TB saving for a month (10 TB for 90 days): • The 1.2 TB table DBC.DBQLOGTBL was added as a key to link to old and new tables to increase 3% space. • The 1.8 TB table DBC.DBQLSQLTBL was normalized to 0.7 GB for new queries only by saving 99% space. • The 2.1 TB table DBC.DBQLOBJTBL was normalized to 0.8 GB for new objects only by saving 99% space.

1385 Integrating Marketing Processes to Drive Return on Marketing Investment (ROMI) 3:00pm – 4:00pm Room 29 A, B

Kimberly Collins, Research Vice President Gartner Chief Marketing Officers (CMO) are under pressure to drive company growth while being more accountable and managing costs, demonstrating ROMI. Integrating people, processes, and technologies is critical to CMO success and will ultimately enable CMOs to secure their seat at the executive table. This presentation discusses how marketing leaders can integrate executional, operational, and analytical processes across the marketing ecosystem to drive growth, cut costs, and improve ROMI.

continued...

1390 Using Analytics to Select What America Watches—from Concept to Hit at NBC

3:00pm – 4:00pm Room 28 A, B, & C

This application makes all kinds of data (enterprise data or system management information) available anytime, anywhere, using just your mobile phone or tablet. The idea behind this tool is: What if I need some specific information right now? Just follow our Teradata system with your Smartphone!

Bryan Rockoff, Director, Enterprise Data Warehouse NBCUniversal This session presents the processes a show goes through before the public sees it. Historically, this process was a “seat of the pants” process where industry experts select the shows based on intuition and experience and not on the analysis of the data. NBCUniversal has improved the process through the collection of data and the application of advanced analytics at key points in the “green lighting” process. This presentation highlights the places where the analytics like viewer habits, pilot previews, social media, and external data is applied to the process to deliver the shows the public wants to watch. The process is applicable to other industries that also have new product launches. We will focus on the use of pilots and social media within the NBCUniversal approach and process.

1518 Teradata Goes Social! IT and Business Intelligence Users Interact with Taradata in a Twitter Chat

3:00pm – 4:00pm Ballroom 20 A

Jean Brant, System Manager Oi Oi is the major convergent communications company in Brazil, with 65 million subscribers. With the aim of being the best communications company in its country, Oi is very focused on innovation. Now Oi has developed an application that gives IT and business users the chance to interact with Teradata like everyone

40

interacts with their friends using tools like Twitter or Facebook.

2011 Teradata PARTNERS User Group Conference & Expo

The audience will also have the opportunity to learn how to interact with Teradata using applications like that, and how useful this application can be to manage your Teradata system and get information from. We will also discuss the end user experience, and we’ll have a presentation of the tool running with Teradata.

1819 Predictive Business Intelligence—Leveraging Atomic-level Forecasts 3:00pm – 4:00pm Ballroom 20 D

Greg Moore, Solution Sales Director Aprimo Traditional BI has been primarily focused on leveraging historical information to mine data and provide insights into business issues and emerging trends. Today retailers and Consumer Goods manufacturers have the ability to leverage Teradata to use detailed, synchronized, atomic level forecasts to drive insights into what will happen in the enterprise over an extended planning horizon for sales, inventory management, DC forecasting, capacity planning, HR planning, logistics, Merchandise Planning, Assortment Planning, and Financial Management. This discussion will focus on how retailers and consumer goods manufacturers can leverage detailed store-sku sales and inventory forecasts to look into the future and anticipate issues with sales, inventory levels, capacity constraints, and financial projections. The discussion will also focus on how companies can leverage Teradata Demand Chain Management to achieve this level of visibility.

Mini Session

Technical

Business

Guru

Super

1836 Teradata Database Architecture Overview— Part 2 3:00pm – 4:00pm Expo Hall F

Todd Walter, Chief Technologist Teradata Corporation The Teradata Database is different from other databases in a number of fundamental ways. If you want to know what these differences are and how they make it possible for Teradata to deliver unlimited scalability in every dimension, high performance, simple management, and all the other requirements of the Active Data Warehouse, then this is the session for you. We will discuss how the architecture of Teradata enables you to quickly, efficiently, and flexibly deliver value to your business.

1906 Global Financial Reporting: The Journey to Finance One

3:00pm – 4:00pm Room 30 A, B

Krishan Kumar, Associate Director Pfizer Over the past decade, Pfizer has grown through a number of acquisitions. As a product of this growth strategy and complexity of the business, economies of scale from acquisitions were difficult to achieve and many business units lacked full integration, particularly from a financial perspective. Additionally, Pfizer was facing enormous growth in data volumes and management mandates to reduce expenditures. To overcome what seemed to be an impossible task, Pfizer needed to derive an innovative and productive solution to integrate its enterprise financial reporting system. The Finance One project combined three financial data warehouses onto a single platform. To accomplish this, Pfizer partnered with Teradata to create a model enabling data reuse and

SIG

Big Data

Sponsorship

The Edge

Monday Sessions

Aprimo

global financial intelligence. By building an agile shared services platform, Pfizer reduced complexity and total cost of ownership, while providing a simple, flexible environment to respond more quickly to the changing business demands.

1931 Exploring PERIOD—Your First Step to Temporal Data 3:00pm – 4:00pm Room 24

Joshua Skarphol, Data Architect WebMD Temporal is a complex topic. Where do you start? Start by understanding PERIOD. The PERIOD data type was introduced in Teradata 13.0. Even if you plan to use the full power of Teradata 13.10 temporal data support, the foundation is PERIOD. And there is significant functionality available in Teradata 13.0. This session will explore the PERIOD data type including concepts, implementation, and how to INSERT, UPDATE, and SELECT records. We will then move to the functions that support PERIODs. There will be code examples for every piece introduced. We will end with a glimpse at the power of using PERIODs and how they can drastically simplify your queries. You will leave this session with a better understanding of PERIOD and how you can leverage its power in your own warehouse.

1935 Squeezing Blood from a Turnip or Extending the Life of Your Current System 3:00pm – 4:00pm Ballroom 20 BC

Bill Grenwelge, Technical Advisor FedEx Services Is your existing Teradata system running at or near full CPU capacity? Do you have users complaining about response times during prime time hours? Are you adding new users and applications faster than you are adding additional resources? Is the next upgrade or system replacement far enough out that you need relief sooner than the hardware will be ready? If so, please read on. We have struggled with these same issues, and in this session we are going to look at four opportunities that we found helped us free up CPU resources, provided more reliable response times, and improved overall query throughput in order to extend the life of our system until we are able to replace it.

1966 Bridge the Chasm: Aligning Business and IT for a Financial Data Warehouse

3:00pm – 4:00pm Room 29 C, D

Daniel Capozzi, Vice President, Corporate Planning and Procurement Discover Financial Services Co-Presenter: Kim Autrey, CPA, Senior Consultant, Financial Transformation Teradata Corporation Creating a financial data warehouse to support financial reporting and analysis takes vision and leadership. How do you begin a multiyear journey while continually delivering value to the business along the way? Discover wrestled with this and other challenges www.teradata-partners.com

41

MondAY edUcAtIonAl SeSSIonS while undertaking the creation of an integrated financial data warehouse (FDW). Estimating the roadmap for an FDW is difficult at best. The building of the business case is often a combination of a hard return on investment (ROI), assigning subjective value and realizing “at some point you just have to believe it is the right thing to do.” Dan Capozzi, Discover’s vice president - corporate planning and procurement, and Kim Autrey of Teradata will discuss their journey. Topics will include evaluating the FDW opportunity, determining where to start, planning approaches, and delivering the initial subject areas. Dan and Kim will share their experiences, input from other chief financial officers (CFOs) and projects, as well as recommendations on how to approach similar projects in the future.

1984 eBay’s Scalable Approach to Clickstream Data Analysis on Multi-Petabytes

3:00pm – 4:00pm Room 26

Dinesh Chavan, Manager, User Behavior Intelligence and APD Architecture eBay This session will provide an overview of eBay’s approach to the capture and analysis of massive amounts of clickstream data to support Business Analysts across the eBay Enterprise. The presentation will focus on eBay’s non-SQL efforts and the design of the user-friendly EWA-browser interface. Data transformation and support for real-time feeds will be discussed. In addition, the presentation will deliver an overview on the unique capabiliities of eBay’s Singularity platform.

continued...

3520 The NetApp Solution for Hadoop: Taming the Yellow Elephant from the Land of the Internet Giants

3:00pm – 4:00pm Room 28 E

Jeff O’Neal, Senior Director, Data Center Solutions NetApp The yellow elephant of Hadoop has emerged as a scalable approach to process very large unstructured datasets. Hadoop infrastructure scales simply, at least in concept, with a server equipped with internal storage as the unit of scale. Well enough for the wilds of the Internet Giants. But what about for Teradata Enterprise customers that rely on business analytics to run their business. Here, expectations are high. Performance, reliability, resilience, predictable scalability and Enterprise Total Cost of Ownership considerations are table-stakes. This talk will discuss the NetApp Scalable Solution for Hadoop, developed in collaboration with Teradata. We will explore the NetApp’s approach to avoid the pitfalls of scaling Hadoop environments, including the “Grad-student Science Project” problem. The NetApp Appliance delivers the benefits of Hadoop in an integrated high-performance package with predicable scalability and performance within a Total Cost of Ownership envelop that is consistent with the expectations of the Enterprise IT professional.

4:30pm – 5:30pm 1204 Hot ’n Cold Data, Fast ‘n Slow Storage: Get Performance Using Teradata Virtual Storage 13.10

4:30pm – 5:30pm Ballroom 20 A

John Catozzi, Senior Teradata Architect Teradata Corporation Teradata Virtual Storage supports the newest Teradata platforms—6650 and 6680. These platforms support multiple tiers of storage from large, slow 7.5K, 2TB spinning disks, all the way to ultra fast 400GB Solid State Drives. Teradata Virtual Storage automatically places the hottest data on the fastest storage and the coldest data on the slowest to optimize your system performance. This talk explains how this works and what controls there are to guide your way to the maximum use of this new technology. You will see examples of controlling the loading of new data via Query Banding, dealing with data already loaded via the Ferret Utility, and how to observe what Teradata Virtual Storage is doing via the Teradata Virtual Allocation Manager and Ferret utilities and new re-usage statistics.

1283 Mastering Metadata Management at Lowe’s

4:30pm – 5:30pm Room 29 C, D

Kathryn DioQuino, Data Governance and Standards Manager Lowe’s Co-Presenter: Taher Borsadwala, Enterprise Data Management Specialist Teradata Corporation From boxes, lines, and lexicon in geek-speak to meaningful,

42

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

cohesive insights on complex data and processes, Metadata often needs a translator to help bridge business and systems understandings. Metadata management is often a low priority, even though both IT and the business agree that it is important. And it also tends to be viewed as a monumental undertaking. The Research and Analytics areas at Lowe’s decided to implement a metadata management tool for their business area—to take the first steps in tackling an enterprise issue. Learn how Lowe’s leveraged an existing tool and a group of systems-savvy users to conquer the complexity of metadata in a highly analytical functional area with multiple sources of data, both internal and external. Hear how the analytic environment has improved and what the plans are for the future.

1369 Recursive Structured Query Language for Solving Real Business Problems 4:30pm – 5:30pm Room 23

SIG

Big Data

Sponsorship

The Edge

1485 What is Hadoop and Why Do You Care?

4:30pm – 5:30pm Room 26

Daniel Graham, GM Enterprise Systems Teradata Corporation Hadoop and MapReduce are seeping into IT data centers around the world. This session gives an overview of Hadoop, the Hadoop Distributed File System, Hive, and popular use cases. Included are the strengths and limitations of Hadoop today. Finally, we will briefly summarize how Hadoop coexists with a Teradata system.

This presentation traces successes and frustrations encountered in combining three LDMs into a single Enterprise LDM. Included will be the unique approaches used to solve the unification of source, application, and reporting data structures; the processes employed to validate, where not to compromise, and to identify what elements from the three models were to be excluded in the final model; the tools and techniques used to discover common elements across all models; and the strategy for handling future versions of the LDMs.

1678 Application Tuning with Teradata Database 13.10 Performance Features at Metro 4:30pm – 5:30pm Ballroom 20 B, C

1513 One Size Does Not Fit All: Using Multiple Logical Models to Create One Enterprise Data Warehouse

Joerg Thienenkamp, Senior Developer METRO SYSTEMS

4:30pm – 5:30pm Room 24

Co-Presenter: Luzie Wischka, Senior Architect Data Warehouse Teradata Corporation

Kevin Stallings, Project Manager United Rentals Inc

Metro joined the Teradata 13.10 Beta program to gain experience with new performance features. Many of them showed good results, others needed revision. To draw benefit from some of the features with promising performance improvements, there is need to fulfill pre-conditions which are also discussed.

Darrin Gaines, Senior Consultant Teradata Corporation Does your data warehouse contain organizational hierarchies, bills-of-material, or transportation networks? If so, you likely have a good candidate business problem for recursive Structured Query Language (SQL). Data often contains parent-child relationships, for which recursive SQL is well suited. In addition, when the solution to a problem requires multiple iterations, rather than a single pass of data, recursive SQL is an alternative. This session provides an overview of recursive SQL, then solves multiple business questions, using both non-recursive and recursive SQL. The session uses DBQL metrics of Elapsed Time, CPU Time, IO Count, and Spool Usage to compare performance of the non-recursive and recursive SQL solutions. Lastly, the session offers considerations for when to choose recursive SQL.

Monday Sessions

Aprimo

Co-Presenter: John Aaydelotte, PS Consultant Teradata Corporation The diversity of today’s business structures often means that one size does not fit all. As a first step in designing and implementing an Enterprise Data Warehouse (EDW) for improved reporting and analysis, United Rentals opted to create an Enterprise Logical Data Model (LDM) to support their three major business domains. The plan was to buy an existing LDM, customize it very little, and implement the logical to physical with few changes. This seemed a workable approach until discovering three different LDMs were required.

In this session, we will discuss features like Temporal, NoPI Tables, Distinct vs. Group By, New Hash Algorithm, No spool FastExport, Scalar Sub Query, Timestamp PPI and show if and how they can be used at Metro shortly.

www.teradata-partners.com

43

MondAY edUcAtIonAl SeSSIonS 1724 Customer Engagement in a Digital World

4:30pm – 5:30pm Room 30 A, B

Mohan Sawhney, McCormick Tribune Foundation Professor of Technology Kellogg School of Management The transformation of media in the digital world presents new challenges and opportunities for marketers as they seek to engage with consumers to build its brand and drive sales growth. Media channels are proliferating and audiences are fragmenting. Social media is emerging as an important new form of media, and is opening up new opportunities for customer engagement. However, social media requires a new mindset, new skills, new processes, and new metrics for managing marketing activities. Social media needs to be integrated into the fabric of the business. Marketers need to be prepared to give up some control over the medium as well as the message. Learn how the “command-and-control” mindset needs to evolve towards the “connect-and-collaborate” mindset and how marketing organizations will need to adapt to these new realities. Ideas will be illustrated with strategic best practices drawn from teaching and advising various global brand marketers as well as technology platform providers.

44

continued...

1737 Create Actionable Business Insights from Complex Data

1741 Do More with Your Data: Deep Analytics Using Big Data

4:30pm – 5:30pm Room 28 A, B, & C

4:30pm – 5:30pm Expo Hall F

Thomas Bishop, Executive Director, Nationwide Center for Advanced Customer Insights Ohio State University

Tasso Argyros, Chief Technology Officer Aster Data Systems, Inc.

Co-Presenter: Chris Nicholas, Director, Customer and Operational Analytics Nationwide The fundamental goal of analytics is prediction leading to insights which serve as a rational basis for action. Nationwide Insurance Company partnered with Ohio State University to develop a problem formulation methodology and data analysis strategy based on the theory of statistical process control created by Dr. Walter Shewhart that applies many business processes. Dr. Shewhart gave us a new lens to view complex data based on understanding the sources and nature of variation affecting the data which he referred to as “chance cause systems of variation.” His analytic methodology is not mathematically complex, but is profound in terms of creating a practical understanding of the variation affecting research data leading to better predictions. Learn how the Nationwide Customer Insights and Analytics research staff used this methodology for efficient creation of actionable insights from complex data in various business applications and how this could be applied in your organization.

2011 Teradata PARTNERS User Group Conference & Expo

Co-Presenter: Stephen Brobst, Chief Technology Officer Teradata Corporation Analytics are evolving to a new world from a focus on transactions to a focus on interactions. The analysis of detailed transactional data provides insight into the value created from customer relationships whereas the analysis of interactions provides insight into the experience provided to a customer. Analytic models for predicting defection, buying patterns, etc., can be significantly enhanced when interaction data is used to augment traditional transaction data. And yet, managing the immense volume of interaction data comes with a unique set of challenges for cost effective data warehouse deployment. Moreover, the sources for interaction data are different than transactional data, and the methods by which interaction data is stored for optimal usage is often quite different than what has been done with traditional data warehouse deployments. This session will explore the best practices for getting full value out of new analytic capabilities targeted at big data.

Mini Session

Technical

Business

Guru

Super

1754 SIG: Teradata Temporal: It’s Time to Look at Time Differently

4:30pm – 5:30pm Room 22

Alan Greenspan, Product Marketing Manager Teradata Corporation Teradata Temporal, available with Teradata 13.10, provides automated temporal data management and optimized temporal query processing. Now you can let the database rather than your applications and ETL processes handle the temporal aspects of your data. You can now analyze data that changes over time more simply and more effectively. But, how? This session will review the basics of temporal data and processing and then help prepare you to effectively use this new database capability.

1764 Putting Marketers in Control of Data: Using Best Practices of MCM

4:30pm – 5:30pm Room 29 A, B

Haresh Gangwani, Vice President of Strategic Alliances Aprimo Learn how Aprimo empowers marketers to centrally manage multichannel campaigns while providing them with real-time analytics. Learn how companies representing financial services, life sciences, and retail, to name a few industries, are executing campaigns by incorporating a set of standard templates and reusable components.

SIG

Big Data

Sponsorship

The Edge

Aprimo

1848 How Geospatial Technologies are Taking the US Air Force to New Heights 4:30pm – 5:30pm Room 25

Timothy Cotton, Program Manager US Air Force Co-Presenter: Teal Walker, Engagement Director USAF As the US Air Force continues to develop a more robust analytical and reporting environment for tracking not only status, but also location of their assets, it becomes more critical to combine strong data visualization and reporting capabilities with Geospatial technologies. The enhanced data visualization, utilizing geospatial capabilities, allows for quick data analysis via map-based views by providing status and location information for thousands of assets and parts worldwide. This session will focus on the how-to’s: design principles, technologies used such as Google Maps, solution approaches and overall benefits to the end user. In addition, we will show examples of capabilities that led to more compelling and engaging experiences for the US Air Force.

Monday Sessions

almost 30% market share, it is the nationwide market leader in Brazil. VIVO stands out from the competition in BI development and usage of information, basing its decision process on effective customer knowledge. BI is present in the entire decision process and supports the development of new products, promotions and the improvement of operational efficiency. This case will present the use of data mining and analytics to launch new product, showing an end-to-end management of marketing actions to maximize sales by defining targets using behavior cluster and geo-marketing, defining best actions, and directing customers to the right channel. Results: ten times more effective model and more than two million customers using the service. The presenters will provide tips on creating a governance model to have more agility in development and present lessons learned.

1936 Using Business Intelligence (BI) and Analytics to Support Product Launches and Sales

4:30pm – 5:30pm Ballroom 20 D

Leandro Andrade IVO VIVO, a Telefonica company, is the largest mobile telecom in the southern hemisphere. With more than 60 million customers and

www.teradata-partners.com

45

noteS

46

2011 Teradata PARTNERS User Group Conference & Expo

TUESDAY

TUE

TUESDAY

Scheduled Events Time

Event

Location

7:00am – 6:00pm

Registration Open

Convention Center

7:00am – 6:00pm

Poster Sessions

Convention Center Poster Session Hallway

7:00am – 8:30pm

Breakfast

Convention Center Exhibit Hall F

8:00am – 5:30pm

Conference Educational Sessions

Convention Center

10:30am – 11:15am

Networking Break

Conference Sessions Area, Upper Level

Noon – 3:00pm

Expo Hall Lunch & Dessert Reception

Convention Center Exhibit Hall F & G

5:30pm – 7:00pm

Teradata Industry Receptions

Hilton Bayfront

Expo Hall Hours Exhibit Hall G

10:00am – 5:00pm 8:00am – 9:00am Session #

48

Educational Sessions

Session Title

Room

Presenter

1203

How to Identify Inefficient Queries and Fix Them

Ballrm 20 B, C

Dirk Anderson, Bank of America

Technical

1280

Performance Management Techniques and Strategy

23

Brian Mitchell, Teradata

Technical

1289

Part One: Teradata Database 13.10 Overview

25

Rich Charucki, Teradata Corporation

Technical

1365

Temporal: It’s About Time!!!

Patrick McHugh, Teradata

Business

1470

Observed Service Level: Do You Truly Know Your Customer Fill Rate?

1552

How ISC, MGM Resorts, Bank of America & Avaya Are Revolutionizing Marketing

Ballrm 20 D 28 A, B, C

Session Type

Alexander Quinn, The Home Depot

Business

Ballrm 20 A

Lisa Arthur, Aprimo

Business

24

1568

Leaping Forward in Time with the Teradata CLDM

Bill Turner, Comcast

Technical

1720

Customer Connections: Social & Customer Data to Improve Email Relevancy

29 A, B

Stephanie Miller, Aprimo

Business

1732

Delivering BI Value with Teradata and SAP

ExHall F

Rich Peters, Levi Strauss & CO

Business

1735

Quenching the Thirst for Master Data at MillerCoors

22

Sara Wondergem, MillerCoors

Business

1821

Teradata Decision Experts Keeps the Air Force Flying through an ERP Rollout

29 C, D

Larry Potts, US Air Force Mitre

Business

1853

3D Performance Management – Navigating Profits in the Airline Business

30 A, B

Jo Boswell, British Airways

Business

1987

Dealing with Big Data the Aster Data Way: Architecutre, Analytics, and More

George Kong, Teradata Aster Center of Innovation

Technical

3480

Building Applications to “Process” Big Data

Martin Redington, Microgen

Business

2011 Teradata PARTNERS User Group Conference & Expo

26 28 E

Poster Sessions* Poster Session Hallway

9:00am – 10:00am

* See page 10 for listing.

Educational Sessions

9:30am – 10:30am Session #

Session Title

Room 23

Presenter

Session Type

Sorana Rabinovici, Teradata Corporation

Technical

3:00pm – 4:00pm Session #

Session Title

1168

Size Matters: Saving Disk Space with Block Level Compression in 13.10

1170

Rows versus Columns? Why Not Both?

Educational Sessions Room

John Catozzi, Teradata Corporation

Technical

ExHall F

Paul Sinclair, Teradata Corporation

Technical

1307

Sandbox Bullies? Tips to Help Ad-Hoc Users Play Nice

1323

Data Movement Options in the Teradata Ecosystem

Ballrm 20 B, C

Donna Becker, Teradata Corporation

Technical

25

Betsy Huntingdon, Teradata Corporation

Technical

1368

So... Do I Really Need a Data Model?

1547

How Coca-Cola Leverages Rocket Science to Drive Retail Results

29 A, B

24

Thomas Manfredi, Teradata Corporation

Technical

Phil Sanford, The Coca-Cola Company

Business

1614

Mega Merger in UK Banking: The Strategic view from the EDW

30 A, B

1639

Social Network Analysis Case Study—from PoC to Delivered Value

Teradata’s New Priority Scheduler

1306

Teradata Performance: Why DBQL Matters Most

Ballrm 20 A

Donna Becker, Teradata Corporation

Technical

1337

Teradata Database 13.10 Overview—Part 2

25

Rich Charucki, Teradata Corporation

Technical

1379

Competitive Intelligence in Vodafone in Spain

24

Vicente Moreno Díez, Vodafone

Business Business Business

1671

Enterprise Reporting & Financial Reconciliation from an EDW

29 C, D

Business

1891

Multi-echelon Replenishment Modeling for The Home Depot

28 A, B,& C

Jeff Barnhart, Sabre-Holdings

Business

1923

Leveraging TASM Event Driven Throttles to Manage Tactical Workload

Robert Catron, Freeport-McMoRan Copper & Gold

Business

Lisa Rossjohn, National Australia Bank

Business

Rosie Jergovic, Kaiser Permanente

Technical

Ballrm 20 D

Thomas Pagano, The Hertz Corporation

Business

26

Peter Pawlowski, Teradata Corporation

Technical

1381

Reinventing Michigan: $1 Million in Financial Benefits Each Business Day

30 A, B

1501

eXtreme Data Warehousing: Business Applications and Issues

ExHall F

Stephen Brobst, Teradata Corporation

1535

Geomarketing—Where is Your Business?

1578

Taking a Data-Rich Executive Dashboard from Desktop to Mobile

1621

Improving Mining Operational Decision Making with “Active” Dashboards Using Microsoft .NET, Teradata Database, and SAP Data Services

1649

Analytics Platform Governance: Managing Demand from Multi Business Units

1778

Capacity Forecasting and Management: Building a Comprehensive Process

1875

Building Justification for a Global Integrated Data Environment

1880

Introduction to the Aster Data SQL-MapReduce API

29 A, B 29 C, D 28 A, B, C 22 Ballrm 20 B, C

Wojtek Pawlowski, Polkomtel

Industry Spotlights

11:00am – 12:15pm Session #

Session Title

Room Ballrm 20 A

1948

Structured and Unstructured Data Solutions with Aster Data’s SQL-MapReduce

2162

The Healthcare Data Warehouse

3500

Information Advantage—Vision Driven BI Initiative by WellPoint

22

David Bargeron, Lloyds Banking Group

Business

Konstantin Romanov, Mobile TeleSystems

Business

Mark Humphreys, Qantas Airways Ltd

Business

Arash Bateni, Teradata Corporation

Business

23

Nicholas Polizzi, Enterprise Holdings Inc.

Technical

26

Don Watters, Myspace

Technical

Richard Winter, Winter Corporation

Business

Ballrm 20 D 28 E

Business

4:30pm – 5:30pm Session #

Session Type

Ballrm 20 A

1240

Carol Steele Sherman, Michigan Department of Technology, Management & Budget

Presenter

Educational Sessions

Session Title

Room

Presenter

Session Type

1200

Teradata for the SAS Programer

Ballrm 20 B, C

1263

Aggregate Join Indices and Dimensional Models to Deliver Performance

Richard Arndrews, CMS

Technical

25

Jose Borja, APP Consulting

Technical

Presenter

Session Type

1333

Grainger Drives Business Growth Using Profitability Analytics

29 C, D

John Myers, WW Grainger

Business

David Sirag, Pratt & Whitney

Business

1414

Teradata Viewpoint—Ask the Experts

ExHall F

Gary Ryback, Teradata Corporation

Technical

1201

Advanced Analytics in Zero Fault Tolerance World of Aircraft Engines

1320

Health Care Informatics

30 A, B

Siva Yannapu, Blue Cross Blue Shield of North Carolina

Business

1446

Social Customer Relationship Management Social Means Business

1361

Making Data Warehousing a Meaningful Experience for HSBC Risk Analytics

29 C, D

John Oldham, HSBC

Business

1554

Transforming Web Data into Web Intelligence to Inform Marketing Strategy

1377

Best Practice Campaign Management at T-Mobile USA

ExHall F

Philipp Von Holtzendorff-Fehling, T-Mobile

Business

1569

Squeezing the Margins Out of a Barrel of Oil

1411

Driving Customer Loyalty through Analytics in Action

Kathy Koontz, Nationwide Insurance

Business

1586

Best of Breed Business Intelligence and Data Integration in an SAP Environment

1613

SCE SmartConnect™ Using Teradata to Build a Smarter, Cleaner Energy Future

Andrew Eisses, Southern California Edison

Business

1706

Vodafone UK’s BI Transformation—Journey to a High Performance BI Service

30 A, B

1717

Branded and Private Label Price to Volume Sensitivity Analytics

Richard Welling, Dean Foods

Business

1715

SQL or NoSQL - That is NOT the Question! (It’s How You Combine Both to Win)

26

Steve Wooledge, Teradata Aster Center of Innovation

Technical

1791

The Battle for the Living Room

Xavier Dreze, UCLA Anderson School of Business

Business

1746

SIG**Best Practices Implementing Teradata with IBM Software Solutions

22

Michael Hortatsos, IBM

Technical

1801

DECKPLATE: The US Navy’s Aviation Data Management System

Commander Chris Hammond, US Navy Aviation System Command

Business

1978

eBay’s Innovative Approach to Clickstream-driven Data Insights

Ballrm 20 A

Dinesh Chavan, eBay, Inc.

Business

1806

Retail Industry Spotlight: The Future of Retail Analytics

Bill Franks, Teradata Corporation

Business

2200

How to Improve Performance Using Multilevel Partitioned Primary Indexes

23

Marcio Moura, IBM Global Business Services

Technical

1876

Transportation Industry Spotlight: Navigating the Explosion of Sensor Data

Business

3540

Tokenization on the Node—Data Protection for Security and Compliance

28 E

Ulf Mattsson, Protegrity

Business

1885

Travel Industry Spotlight: Turbo Charged Data Insight Opportunities

Hani Mahmassani, Northwestern University

Business

23 Ballrm 20 B, C Ballrm 20 D 26 29 A, B 24 28 A, B, & C 25

24 29 A, B 28 A, B, C Ballrm 20 D

Adam Saner, Gartner

Business

Joseph Stanhope, Forrester Research

Business

Blake Larsen, Western Refining

Business

Joseph Choi, SAP

Business

Niall Cottrill, Vodafone UK

Business

FoldouT For TuEsday aGEnda

Tuesday Sessions

TuEsday EducaTional sEssions

BikE Build & BlankET BriGadE

8:00am – 9:00am 1203 How to Identify Inefficient Queries and Fix Them

8:00am – 9:00am Ballroom 20 B, C

Dirk Anderson, Senior Architect Bank of America

Bike Build and Blanket Brigade Tuesday, october 4

A busy Teradata system may run over a million queries a day and thousands of ETL (Extract, Transform, Load) processes. How do you identify and categorize inefficient queries? What strategies work best to fix each category? How do you differentiate between mild problems and major problems? How do you keep poorly-performing queries from ever getting implemented in a production data warehouse? These questions and more will be answered as Bank of America provides insight into how they keep their 400 TB data warehouse humming.

Noon – 3:00pm Expo Hall, Exhibit Hall G

Join us Tuesday from noon to 3:00pm in the Expo Hall, in Exhibit Hall G.

Grab a wrench and build a bike for a great cause! Teradata Cares is proud to sponsor our third annual Bike Build at PARTNERS 2011! Plan to roll up your sleeves and join Teradata employees on Tuesday afternoon. Together we will build bicycles for children at the Boys and Girls Club. In addition, this year, participants can also help make tie blankets that will be donated to Project Linus. There is something to do for anyone who wants to participate. It is a great way to make new friends and help us give back!

1280 Performance Management Techniques and Strategy

If you can sling a mean screwdriver, read an instruction manual, or want to help decorate bikes or make blankets for children, we invite you to join in!

8:00am – 9:00am Room 23

Brian Mitchell, Senior Consultant Teradata Corporation

Teradata professional services performance engagements. We will cover the basics for managing performance of enterprise and active data warehouses; from organizational considerations to the establishment of workload management policies and service level agreements (SLAs). In addition, the presenter will cover metrics for tracking application performance, system utilization, and for measuring the success of performance tuning efforts. This includes quantifying the significant dollar value of CPU saved as well as response time improvements. The presentation will also highlight the efforts required during the application development life cycle, address training, as well as new performance data available and its use.

1289 Part One: Teradata Database 13.10 Overview

8:00am – 9:00am Room 25

Rich Charucki, Engineering Fellow Teradata Corporation Teradata Database 13.10 is here and available today! Learn about new compression capabilities, query band directives, character-based and timestamp partitioning, time series expansion support, read from fallback fault isolation, Teradata Active System Management enhancements, large cylinder support, packed-row format for 64-bit systems, hashing algorithm enhancements and of course, the new and wonderful Temporal Table support. All of this is part of Teradata 13.10, the current advancement in the Teradata database technology stack.

Co-Presenter: Donna Becker, Director Performance and Workload Management COE Teradata Corporation Solid performance management is a critical component to successful applications, satisfied users, and significant cost savings, yet all too often falls through the cracks of short deadlines and limited resources. This presentation will cover best practices in performance management, based on over 125 www.teradata-partners.com

49

50

2011 Teradata PARTNERS User Group Conference & Expo

1365 Temporal: It’s About Time!!!

8:00am – 9:00am Ballroom 20 D

Patrick McHugh, Principal Consultant Teradata Corporation Panelists: Bruce Pluchinsky, Director, Project Alliance AT&T Gregory Sannik, Principal Consultant Teradata Corporation Business intelligence has had a time component forever: sales by day, staffing levels by hour, call volume by minute. More sophisticated time-sensitive applications have emerged such as future-dating purchases, as-is / as-was hierarchical changes, SOX (Sarbanes-Oxley) traceability, zero sales day identification, and others. Face it: maintaining a time-sensitive data warehouse is not easy. Supporting slowly-changing dimensions is hard. It’s easy to overlook periods with no activity. Often the result is a solution that does not meet the business needs. This panel will expand upon the newly-released Teradata 13.10 temporal capability in several ways. First, we will explore practical use cases. Secondly, we will discuss customer experiences both with old-style temporal management as well as anticipated use of Teradata Database13.10 features. Finally, we’ll offer observations based on experiences to date about this powerful capability and suggest strategies for its integration into your current Enterprise Data Warehouse.

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

1470 Observed Service Level: Do You Truly Know Your Customer Fill Rate?

1552 How ISC, MGM Resorts, Bank of America, and Avaya Are Revolutionizing Marketing

industry logical model returned the business intelligence they needed but did not know how to ask for. In this presentation, you will hear from the Senior Manager of Data Management and the Principal Warehouse Architect at Comcast about how their team used modeldriven design based on the Teradata cLDM. You will learn the role the cLDM played in the NDW development, the standards they used, the tools they used to speed up their development, lessons learned from their successful implementation, and the value to Comcast.

Alexander Quinn, Manager, Inventory Analytics The Home Depot

Lisa Arthur, Chief Marketing Officer Aprimo

Co-Presenter: Eddie Kim, Senior Consultant Teradata Corporation

All marketers struggle to keep pace with the rapidly changing landscape of marketing—the need to integrate channels, improve campaign results and effectiveness, and prove return on investment (ROI)—despite shrinking budgets. So how are ISC, MGM Resorts, Bank of America, and Avaya revolutionizing their marketing to stay first in their categories? The presenter will share stories via video vignettes. She also outlines the imperatives of the Marketing Revolution—a 10-step strategic roadmap of changes that need to occur to help drive marketing forward.

1720 Customer Connections: Social and Customer Data to Improve Email Relevancy

8:00am – 9:00am Room 28 A, B, & C

Historical Observed Service Level (OSL) is a critically important metric in tracking and setting target service levels for managing inventory levels and driving consumer demand. A key component of OSL is the estimation of lost sales during stock outs. But what about “effective” stock outs? This is the well known situation where a few products may be on the shelf (e.g., two handles) but most consumers will not make a purchase unless they can buy multiples of eight or more items. This presents serious challenges as the non-zero inventory will not trigger a stock-out exception and yet the product may go unreplenished, perpetuating the lost demand. The Home Depot and Teradata have devised a novel stochastic method to estimate the OSL using the underlying demand and inventory distributions. Rather than fitting parameterized distributions, an in-database analytics was implemented to estimate the OSL by aggregating the lost sales instances when the expected demand exceeds the inventory.

8:00am – 9:00am Ballroom 20 A

1568 Leaping Forward in Time with the Teradata Communications Logical Data Model

8:00am – 9:00am Room 24

Bill Turner, Senior Manager Data Architecture Comcast Co-Presenter: Tim Colbert, Principal Data Architect Comcast

8:00am – 9:00am Room 29 A, B

Stephanie Miller, Vice President, Digital and Email Services Aprimo There is more pressure than ever to be relevant in email marketing. The inbox has fragmented to mobile and social networks, mailbox providers like Gmail and Hotmail are making it easier for users to ignore non-priority messages, and subscribers are fatigued by the clutter. The only way to improve relevancy is to listen to subscribers and customize content, cadence, and frequency to meet the needs of unique segments. Getting that data in a place where you can use it is not trivial. We’ll look at ways to gather, analyze, and most importantly, utilize demographic, behavioral, and social data to improve subscriber experience and earn higher response and revenue. You’ll hear how top tier marketers have done it, and pick up some ideas for testing the waters with your own program. Plus, get a checklist of ideas and questions to ask your vendors that will help you assess your readiness and take your existing efforts to the next level.

In 2009, Comcast, the largest cable company in the US, embarked on setting up yet another data warehouse. Previous attempts had either become frozen in scope, redundant with operational systems, or failed to complete. However, by basing the National Data Warehouse (NDW) on Teradata’s Communications Logical Data Model (cLDM), Comcast found that a foundation of integrated core data based on an

www.teradata-partners.com

51

tUeSdAY edUcAtIonAl SeSSIonS 1732 Delivering BI Value with Teradata and SAP

8:00am – 9:00am Expo Hall F

Rich Peters, Senior Consultant, Business Intelligence, Master Data and Metadata Strategy and Implementations Levi Strauss & Co. Co-Presenter: Mark Marty, Senior Manager BI Architecture Levi Strauss & Co Find out how Levi laid the architectural foundation for the full business intelligence (BI) suite of toolsets and techniques with integrated SAP and non-SAP data. Discover the methods that Levi used to build a hybrid solution that integrates all your data into one effective and fast solution.

1735 Quenching the Thirst for Master Data at MillerCoors

8:00am – 9:00am Room 22

Sara Wondergem, Manager of Data Services MillerCoors MillerCoors continues every day to drive value and synergies from our joint venture to deliver America’s best beer. The competition and the economy are formidable, but we are reaching our goals. One of the keys to achieving our goals is to recognize our corporate data as a strategic asset.

and reduced long-term costs. Most important, MillerCoors achieves a single view of their enterprise with a core of consistent Master Data including customers, suppliers, products, and other critical information. In this session MillerCoors will share their journey into MDM: from operating as two separate companies with two sets of legacy Master Data, to the current vision and approach of a single view of the enterprise enabled by MDM.

1821 Teradata Decision Experts Keep the Air Force Flying Through an Enterprise Resource Planning Rollout—Fasten Your Seatbelts!

8:00am – 9:00am Room 29 C, D

Larry Potts, Senior Information Systems Engineer US Air Force Mitre Fasten your seatbelts! The US Air Force has embarked upon one of the largest Oracle Enterprise Resource Planning (ERP) logistics implementations. As this multi-year rollout and transformation occurs, the commanders must ensure that there is no interruption in information flow for the airmen to do their job. While this could be a bumpy ride, the AF’s data warehouse organization, in partnership with the ERP program, performed extensive research into the best way to avoid any turbulence and still maintain existing business intelligence capabilities for logistics functions throughout the ERP rollout. As a result of the analysis, Teradata Decision Experts’ (TDE) application, in conjunction with the Teradata Travel Logical Data Model (LDM), is being used to support a smooth transformation. In this session, we will discuss the Business Intelligence analysis, the use and implementation of TDE and the lessons learned.

MillerCoors has developed an “enterprise” strategy to maintain consistent and accurate data. This enterprise strategy includes sound data governance, data stewardship, and data architecture. This strategy helps MillerCoors achieve high data quality, low complexity,

52

continued...

2011 Teradata PARTNERS User Group Conference & Expo

1853 3D Performance Management—Navigating Profits in the Airline Business 8:00am – 9:00am Room 30 A, B

Jo Boswell, Head of Revenue and Customer Analysis British Airways In the volatile and data intensive airline business, effective metrics and quick action are essential. But in a complex business where revenue management, sales, and marketing need to work in an integrated way, being focused and addressing problems takes priority over “finding culprits.” British Airways competes with an overarching performance management process encompassing all commercial activities. Operating on a weekly, monthly, and quarterly basis and ranging from long-term forecasts through to monitoring activities, the process ensures visibility, clear communications, and accountability for decision making. Built around a single version of the truth, and tools delivering consistent information to a wide audience, the process reduces time to action and increases depth of response. The airline is adapting the approach for its joint ventures, whilst becoming increasingly focused on margin and contribution, not just revenue.

1987 Dealing with Big Data the Aster Data Way: Architecture, Analytics, and More

8:00am – 9:00am Room 26

George Kong, Director, Technology Delivery Teradata Aster Center of Innovation This session will discuss the best practices for acquiring, analyzing, and managing “big data” with Aster Data. Data architectural basics

Mini Session

Technical

Business

Guru

Super

will be discussed as the foundation for the session. Data loading options and best practices will be explored leveraging real world experiences. Integration with traditional data warehouse and BI tools will also be covered as will the basics of managing and administering the Aster Data analytic platform.

3480 Building Applications to “Process” Big Data

8:00am – 9:00am Room 28 E

Martin Redington, Senior Vice President, Product Management Microgen The majority of comments about “big data” is focused on the analysis and reporting of very large amounts of data in an “acceptable period” of time. However, enterprises have to build business processes and applications to “action” this data within the business operations to drive sustainable value and business advantage.

9:30am – 10:30am 1240 Teradata’s New Priority Scheduler

9:30am – 10:30am Room 23

Sorana Rabinovici, Senior System Architect Teradata Corporation Co-Presenter: Carrie Ballinger, Senior Technical Consultant Teradata Corporation Don’t miss this opportunity for an in-depth discussion about the “New” Priority Scheduler for Teradata 14, available for the Linux SLES 11 operating system. Sorana, Teradata Architect of this new feature, will step you through how it works, while Carrie, author

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

of the “New Priority Scheduler Orange Book,” will offer you some usability pointers to get you ready for the change-over. During this session, you’ll get a close look at the architecture of this new feature, and will get acquainted with the new priority groupings and their characteristics. We’ll show how resources are divided up by the New Priority Scheduler and examine special benefits it will make available to your tactical workloads. Whether you’re a DBA, a data warehouse architect, or just technically curious, you’ll leave this session with a clear understanding of how priorities will work in your Teradata systems tomorrow.

1306 Teradata Performance: Why DBQL Matters Most

9:30am – 10:30am Balloorm 20 A

Donna Becker, Director Performance and Workload Management Center of Expertise Teradata Corporation Co-Presenter: Barbara Christjohn, Principle Consultant Teradata Corporation When it comes to Teradata Performance, DBQL matters the most. DBQL (Data Base Query Logs) tables are the number one source of data to support application performance and workload management analysis. DBQL data helps identify problem queries and what makes them suspect. In this presentation you will learn the latest on how to identify opportunities to significantly decrease batch processing time and enhance query performance. Also, discover how to validate savings in CPU, IO, and time when doing performance tuning. Finally, you will uncover how DBQL data can help adjust workload mix; from identifying problem areas for service level agreements (SLAs) to identifying queries classified in the wrong workload. DBQL matters the most and you won’t want to miss this presentation!

1337 Teradata Database 13.10 Overview—Part 2

9:30am – 10:30am Room 25

Rich Charucki, Engineering Fellow Teradata Corporation Teradata Database 13.10 is here and available today! Learn about new compression capabilities, query band directives, characterbased and timestamp partitioning, time series expansion support, read from fallback fault isolation, TASM (Teradata Active Systems Management) enhancements, large cylinder support, packed-row format for 64-bit systems, hashing algorithm enhancements and, of course, the new and wonderful Temporal Table support. All of this is part of Teradata 13.10, the current advancement in the Teradata Database technology stack.

1379 Competitive Intelligence in Vodafone in Spain 9:30am – 10:30am Room 24

Vicente Moreno Díez, Competitive Intelligence Manager Vodafone Co-Presenter: Francisco Javier Azores, Head of Competitive Intelligence Vodafone Spain Competitive Intelligence in Vodafone in Spain integrates in depth market, competitors and customer research with best in class Data Warehouse (DWH) analysis. Accurate and complete reporting, and most importantly, extremely cherished insights are the main results of this blend. On-going innovation in both business intelligence tools and information structures in the DWH complete the Competitive Intelligence strategy and way of work.

www.teradata-partners.com

53

tUeSdAY edUcAtIonAl SeSSIonS Partnership with Teradata is key, managing a fully operative data lab and developing and testing in a flexible way to cope with the ever changing total telecommunications environment.

1381 Reinventing Michigan: $1 Million in Financial Benefits Each Business Day

9:30am – 10:30am Room 30 A, B

Carol Steele Sherman, Director, Data Center Operations Michigan Department of Technology, Management and Budget How does an enterprise data warehouse provide $1 million in financial benefits each business day? With nearly 10,000 users in five major departments, 20 agencies and more than 100 bureaus, the Enterprise Data Warehouse (EDW) is intricately and integrally woven into the lives of more than three million Michigan citizens. And, it will be a key resource to support Michigan 3.0, reinvigorating the state to grow and compete in the global economy. This session focuses on the value of Michigan’s EDW, which is not just about the number of people who use it and the amount of data that is shared—those facts are a means to an end. The true measure of the success is this: No other state in America has achieved such concrete and impressive business results from its innovative use of an EDW to improve outcomes, reduce costs, streamline operations, and manage programs. Nor has any other state been so ambitious in its attempts to solve as many real-life problems through the innovative sharing and comprehensive analyses of data.

continued...

1501 eXtreme Data Warehousing: Business Applications and Issues

9:30am – 10:30am Expo Hall F

9:30am – 10:30am Room 29 C, D

Stephen Brobst, Chief Technology Officer Teradata Corporation

Jeff Barnhart, Product Manager Sabre-Holdings

What is the future of business intelligence? What are the application possibilities for data warehouses with extreme service levels in performance, data freshness, and availability? How can extreme data warehousing be used to enable new business models across a variety of industries? This session’s goal to get you to think “out of the box” about advanced applications of business intelligence. It will cover futuristic case studies that are closer than you may initially think. We will explore business issues related to privacy, organizational change, and breakthrough customer experiences that result from these applications.

In today’s ever changing airline industry, building a comprehensive data warehouse is only the initial step. Delivering the data in detailed reports or executive dashboards in adaptable ways is crucial to gain user adoption. The emerging delivery path for data and reports, especially executive dashboards, is via smart phones and personal devices. Today’s mobile devices can accommodate more complex applications yet retain flexible and user friendly interfaces.

9:30am – 10:30am Room 29 A, B

One of the greatest challenges with Sabre’s Executive Dashboard mobile initiative was developing a high performance method to deliver this data and generate reports for the target user, the airline executive on the go. Data is updated without a refresh button or the need to run a report for current information and is delivered in a simple at-a-glance mobile display with multiple sources and areas of data.

Wojtek Pawlowski, Business Intelligence Business Partner Polkomtel

1621 Improving Mining Operational Decision Making with “Active” Dashboards Using Microsoft .NET, Teradata Database, and SAP Data Services

1535 Geomarketing: Where Is Your Business?

Co-Presenter: Arkadiusz Wisniewski, Account Director Teradata Corporation Where do your customers live? Where are your prospects and who are they? Where are customers using your services and why? Which of your stores do they visit and why? Geomarketing is not about drawing maps (although it’s fancy and helpful as well). This is business optimization by raising awareness of geospatial characteristics of your operations.

54

1578 Taking a Data-Rich Executive Dashboard from Desktop to Mobile

2011 Teradata PARTNERS User Group Conference & Expo

9:30am – 10:30am Room 28 A, B, & C

Robert Catron, Project Manager Freeport-McMoRan Copper & Gold Freeport-McMoRan Copper and Gold is the world’s largest public traded copper company operating mines in North America, South America, Africa, and Indonesia. In 2006 it acquired Phelps Dodge

Mini Session

Technical

Business

Guru

Super

Corporation. Freeport had developed for its flagship Grasberg mine in Indonesia a highly visible dashboard application that made transparent detailed operational information on an every 15-minute basis. With the Phelps Dodge acquisition, operations management was impressed with the capabilities but wanted it extended to all mines. This presentation will describe the objectives, challenges, and the solution delivered.

1649 Analytics Platform Governance: Managing Demand from Multi-Business Units

9:30am – 10:30am Room 22

Lisa Rossjohn, Team Leader Customer Relationship Management (CRM) Development, CRM and Sales Support National Australia Bank The customer analytics platform within National Australia Bank has undergone major transformation, and huge growth of return on investment (ROI). From inception in 1997 as a marketing data mart, the platform is now the home of customer analytics, wealth marketing, cards, collections, fraud and risk analytics (and OS subsidiaries in UK and NZ). When servicing one business unit, resolution of issues such as project prioritization, workload management, service level agreements (SLAs), and of course chargeback, was relatively simple. With the addition of new business units exploiting the Teradata Analytics Infrastructure, the management constructs to support a cohesive platform vision, adherence to prioritization processes, workload management principles; the governance model required a refresh.

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

1778 Capacity Forecasting and Management: Building a Comprehensive Process

1875 Building Justification for a Global Integrated Data Environment

Rosie Jergovic, Director, Technology Resource Planning, Care Delivery BIO Kaiser Permanente

Thomas Pagano, Director, Marketing Planning Information eBusiness Technology The Hertz Corporation

Co-Presenter: Charles Griffith, Senior Industry Consultant Teradata Corporation

Co-Presenter: Frank Bush, Senior Industry Consultant Teradata Corporation

This presentation describes practical steps for developing a capacity plan that incorporates future business needs and emphasizes demand management. In today’s budgetary climate, a request for additional capacity must have comprehensive justification and demonstrate demand efficiencies in order to achieve timely approval by senior management. Being able to assess underlying issues driving demand such as new regulations, major new projects, industry trends, and plans/actions to mitigate demand growth are key areas for a successful capacity plan. The capacity planning milestones should be built around a schedule that flows into financial and capital forecasting cycles as well as the business and technology lead times for deployment of additional capacity.

Hertz is one of the world’s leading car rental companies. Hertz business units include car rental, for corporate accounts, leisure travel customers, insurance replacement customers, as well as equipment rental business.

9:30am – 10:30am Ballroom 20 B, C

9:30am – 10:30am Ballroom 20 D

Hertz’s data environment has become increasingly complex over the years. In an effort to drive greater shareholder value, Hertz undertook an extensive review of their current data environment with the aim toward upgrading their data analytics, reporting capabilities, and improving employee efficiency. To that end, Hertz evaluated every business unit to identify where value may be going unrealized. This effort resulted in the decision to invest in a new corporate wide integrated data warehouse.

This presentation articulates the definition and implementation of a governance framework to ensure optimal operation of the platform, with the aim of delivering the highest possible levels of service and opportunity to all business units.

www.teradata-partners.com

55

tUeSdAY edUcAtIonAl SeSSIonS 1880 Introduction to the Aster Data SQL-MapReduce API 9:30am – 10:30am Room 26

Peter Pawlowski, Software Engineer Teradata Corporation SQL-MapReduce is Aster Data’s technology for pushing analytic applications into a parallel data platform, enabling analysts to extract more insight from their big data. These SQL-MapReduce functions are written in a language like Java or C but are invoked from SQL. This talk will present SQL-MapReduce from the developer’s perspective, focusing on how easy it is to get started writing SQLMapReduce functions. Whether you’re interested in pushing an existing application onto Aster Data’s platform or whether you’re just interested in getting a look under the covers, this talk is a good introduction.

continued...

Industry Spotlights 11:00am – 12:15pm 1201 Advanced Analytics in Zero Fault Tolerance World of Aircraft Engines

11:00am – 12:15pm Ballroom 20 A

David Sirag, Manager, Engine Data and Forecasting Pratt & Whitney Co-Presenter: Scott Dupertuis, Director of Consulting – Manufacturing Teradata Corporation This presentation will focus on the advanced analytical capabilities of Pratt & Whitney’s Military Engine Data and Forecasting organization who meet the challenges of managing and maintaining unique, high-reliability, long life cycle products. Aircraft engines have over 3,000 parts, a zero tolerance for failure, and are used and maintained by a variety of customers in diverse operating environments. Pratt & Whitney’s Engine Data and Forecasting Group has recently used Teradata capabilities to integrate analytics into business operations in a mass production way. The Pratt & Whitney architecture uses Teradata’s temporal logic to simultaneously maintain both original data and multiple layers of cleansed data in a seamless manner. Other Teradata features relied on include the utilization of Master Data Management and Teradata Warehouse Miner to keep business people highly functional and IT independent.

1320 Health Care Informatics

11:00am – 12:15pm Room 30 A, B

Siva Yannapu, Data Architect Blue Cross Blue Shield of North Carolina To present implementation and usage of business analytics and customer insights in the health care arena focusing on member information, product information and disease information. How health care informatics is used for competitive advantage for member health improvement and predictive analysis for decision making. To discuss tips and techniques of how Teradata helped/optimized us to store massive amounts of data for this project. This session will also be utilized to discuss future trends in health care analytics monitoring member health for member as well as health care company mutual advantage.

1361 Making Data Warehousing a Meaningful Experience for HSBC Risk Analytics 11:00am – 12:15pm Room 29 C, D

John Oldham, Regional Head of Risk Analytics HSBC HSBC is one of the largest and most diverse financial institutions in the world. With this position comes the challenge to make sense of the vast and complex data that HSBC generates and stores. HSBC UK Retail Risk is on a mission to leverage their Teradata System to create a consistent version of the truth, where the provenance of information is clearly understood and available to analysts when they need it. Faced with a large and complex organization, the effort required to

56

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

accomplish this is not insignificant. Success involves investment in time, collaboration with disparate groups (including external partners) and a large dose of perseverance. The business results associated with achieving this makes the above worthwhile. This session will provide insight into this initiative, providing examples of the impact to risk decisions and the financial rewards for getting it right.

1377 Best Practice Campaign Management at T-Mobile USA 11:00am – 12:15pm Expo Hall F

Philipp Von Holtzendorff-Fehling, Vice President Marketing T-Mobile T-Mobile USA recognized that CRM efforts must evolve as the U.S. wireless communications market has become increasingly saturated, fueling the need to focus on customer base marketing. Multiple customer touch points, greater personalization, and real-time interaction have fundamentally altered the marketing landscape. With objectives of increasing base revenue growth, loyalty, and retention T-Mobile USA embarked on a program that contains international cross-industry best practices. The program effort combined new business processes with marketing automation and analytics capabilities from Teradata and SAS. The new solution is measured against the following metrics: • Decrease lead time. • Increase campaign profitability. • Ensure scalability and sustainability. • Increase number of campaigns. • Increase conversion rate. • Raise customer satisfaction.

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

1411 Driving Customer Loyalty through Analytics in Action

1613 SCE SmartConnect™ Using Teradata to Build a Smarter, Cleaner Energy Future

11:00am – 12:15pm Room 23

11:00am – 12:15pm Ballroom 20 B, C

Kathy Koontz, Associate Vice President, Customer Information Management Nationwide Insurance

Andrew Eisses, Enterprise Portfolio Architect Southern California Edison

Co-Presenter: Barb Ward, Director Marketing Information Management Nationwide Insurance Nationwide Insurance embarked on a journey three years ago to use analytics to make its strategy of differentiated customer care and treatment real as customers interact with its sales and servicing associates. By using our Teradata System, Aprimo MRM/MCM solution, advanced analytic techniques, business process integration and strong change management, we now prioritize the outbound sales activities for our exclusive and direct agents and deliver analytic insights to customer service agents to allow associates to have the right conversation with the right customer at the right time to drive improved acquisition, retention, and share of wallet. This provides Nationwide with the ability to reinforce our brand promise during every customer interaction.

Southern California Edison (SCE) is one of the largest investor-owned electric utilities in the US, serving more than 14 million people in California. SCE’s smart metering program, Edison SmartConnect, will empower residential and small business customers to more effectively manage their electricity use, helping them save energy, money, and the environment. Teradata was selected as the data warehouse (DW) engine to enable this functionality. The presentation will cover implementation of an active, highly available, 50+TB smart meter data warehouse; how the DW is enabling our internal and external customers; and SCE’s vision for expanding this foundation over time.

1717 Branded and Private Label Price to Volume Sensitivity Analytics

11:00am – 12:15pm Ballroom 20 D

The program has shown extraordinary results providing an almost 100% increase in retention for certain customer groups for some agents. Richard Welling, Business Relationships Manager Dean Foods Co-Presenter: James Wentz, Senior Consultant Teradata Corporation Dean Foods leverages Teradata to provide insights about branded and private label volume and margin impact based on retail price and price gap for the Dean Foods Customer Leadership Team www.teradata-partners.com

57

tUeSdAY edUcAtIonAl SeSSIonS category management and financial analytics business users. This pilot solution helps address aggressive competitive pricing tactics magnifying the implications of price on profitability; eliminates the time consuming, manual, and latent analytics of previous processes; and provides a foundation upon which to deliver insights on pricing relationships to volume and profit sensitivity. Automated executive and field level visibility to retail price and gap between branded and private label product helps this leading consumer goods company take action. Jointly developed by Dean Foods’ business, finance, IT, and Teradata, the solution streamlines current advanced sensitivity modeling. The solution uses daily, store-level retailer point of sale data integrated with Dean Foods’ internal data.

1791 The Battle for the Living Room 11:00am – 12:15pm Room 26

Xavier Dreze, Associate Professor UCLA Anderson School of Business The Center for Management of Enterprises in Media, Entertainment and Sports (MEMES) at UCLA Anderson and Teradata collaborate in a special M&E spotlight: The Battle for the Living Room. Convergence is rapidly blurring the lines between distribution channels and platforms. Consumers can view movies on game consoles, online, mobile phones, and tweet from their televisions. They can consume this entertainment individually, or socially.

1801 DECKPLATE: The US Navy’s Aviation Data Management System

1806 Retail Industry Spotlight: The Future of Retail Analytics

Commander Chris Hammond, Deputy Program Manager US Navy Aviation System Command

Bill Franks, Chief Analytics Officer, Global SAS Program Teradata Corporation

Co-Presenter: Lisa Clark, Senior Vice President Spalding Consulting, Inc.

Co-presenter: Bert Crump, Director of Information Technology, Merchandising Systems Saks Fifth Avenue

11:00am – 12:15pm Room 29 A, B

When the earthquake/tsunami hit Japan earlier this year, the Navy turned to DECKPLATE, their next generation data warehouse to determine the readiness of aircraft to support an unforeseen and evolving rescue mission. Providing real-time 24x7 decision support, DECKPLATE houses all aspects of information on 11,000+ Navy and Marine Corps aircraft. NAVAIR can now effectively obtain readiness data in a near real-time environment, as well as 23 years of historical data for trend analysis and records reconstruction. This internal, private cloud environment provides total asset visibility and has made an immeasurable impact on safety, parts management, mission readiness, and cost efficiencies. This session covers the business value, the tools and techniques employed to address the underlying complexity, the process engaged to evaluate the technology against other alternatives, and the future direction of DECKPLATE.

In this industry spotlight, we will hear from digital and traditional media companies about this new ecosystem for consuming entertainment. We will hear from gaming companies about plans to expand beyond gaming into more traditional entertainment. We will hear from social media companies about how home movie watching will shift from an individual to a social experience. We will also discuss how companies can harness the vast amounts of data generated by social media and other sources to better target consumers and enhance product design

58

continued...

2011 Teradata PARTNERS User Group Conference & Expo

11:00am – 12:15pm Room 24

As more data types are available, and a new generation of customers emerge, analytics will be the key ingredient in leveraging new frontiers like social media, digital signage, video intelligence, and numerous other emerging topics. Retailers are turning to large repositories of corporate and external data to uncover trends, statistics, customer behaviors, and other actionable information to help decide on their next move. Those data sets, along with their associated tools, platforms, and analytics, are often referred to as the popular term “big data.” In this session, our panel of retailers and industry experts in partnership with the International Institute of Analytics will share opportunities for leveraging big data and some examples on where they are seeing business benefit from the integration of big data into their analytic processes.

1876 Transportation Industry Spotlight: Navigating the Explosion of Sensor Data

11:00am – 12:15pm Room 28 A, B, & C

The transportation industry isn’t short on sensors that can track everything from where a truck or train is located to the fuel being leveraged on a route. With GPS, RFID, and other types of sensors

Mini Session

Technical

Business

Guru

Super

located everywhere generating lots of data points, how does a company navigate through all this data to leverage the nuggets that will provide the most business benefit? This session will feature a panel of experts that will share their insights on the value that sensor data brings to a business, some real case examples, and how this exploding data source can add even more insight when integrated across your business to improve decision making in operations, profitability, and customer services.

1885 Travel Industry Spotlight: Turbo Charged Data Insight Opportunities

11:00am – 12:15pm Room 25

Hani Mahmassani, Director Northwestern University Panelist: James Vollmer, Lead Architect Enterprise Holdings, Inc. The travel industry has always been analytically innovative—from complex revenue management tools, to frequent flyer programs to operational precision, such as reliability centered maintenance for aircraft. With the evolution of Internet capabilities, the industry is experiencing changes in both access to data as well as (massive) increases in new data availability. From new competitive marketing tools to behavioral information from clickstream and social media, existing tools are being turbocharged and new ones created. Better forecasting and sharper marketing are the result. Moreover, airlines are expanding the community of users who now have actionable metrics in areas that could never be systematically measured before, such as the customer experience. In this session, a panel of experts across the travel industry will share examples on how they are leveraging the explosion of data to realize opportunities in their business.

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

3:00pm – 4:00pm 1168 Size Matters: Saving Disk Space with Block Level Compression in 13.10

3:00pm – 4:00pm Ballroom 20 A

a column store with Teradata’s existing row store, a mix and match approach for physical database design is provided, instead of an either/or approach. The columnar features are presented followed by a discussion of the benefits and tradeoffs.

1307 Sandbox Bullies? Tips to Help Ad-Hoc Users Play Nice

3:00pm – 4:00pm Ballroom 20 B, C John Catozzi, Senior Teradata Architect Teradata Corporation Co-Presenter: Carrie Ballinger, Senior Technical Consultant Teradata Corporation

Donna Becker, Director Performance and Workload Management Center of Expertise Teradata Corporation

The new big hammer for saving space in a Teradata Database is Block-Level Compression (BLC), available in Teradata 13.10. As with any powerful tool, the benefits can be large, but the trade-offs are critical to understand. This presentation will introduce you to how BLC works and step you through some implementation basics. But we’ll do a lot more: You’ll get our most current usability tips, receive helpful insights into the underlying technology, and we’ll give you a peek at some actual before and after comparisons to ground your expectations in reality. We’ll wrap up with clear guidelines on where BLC will fit, and where it will not, and conclude with a few words about Teradata’s newest compression options.

Co-Presenter: Brian Mitchell, Senior Consultant Teradata Corporation

1170 Rows versus Columns? Why Not Both?

3:00pm – 4:00pm Expo Hall F

When business users access data in a sandbox environment, they have the opportunity to create value through exploration and experimentation. However, these same queries are often not tuned and sandbox tables can be poorly designed, thus creating performance challenges. To help ad hoc users not be “bullies,” priorities must be addressed via workload management techniques, new business policies and objectives and adhoc-user training. This presentation is based on engagements and best practices from Teradata’s Center of Expertise on Performance. These learnings will help database administrators guide business policies, control ad-hoc workloads, and provide training and guidance to ad-hoc users. A portion of this presentation will provide easy-to-follow query and load performance tips targeted at ad-hoc users, ensuring all users get maximum benefit from the data warehouse. If you have bullies in your sandbox, then this presentation is for you.

Paul Sinclair, Software Engineer Teradata Corporation This presentation introduces the new optional columnar capabilities coming in Teradata 14. Teradata columnar consists of column partitioning, column and row store options for column partitions, auto-compression, and supporting functionality. By fully integrating

www.teradata-partners.com

59

tUeSdAY edUcAtIonAl SeSSIonS 1323 Data Movement Options in the Teradata Ecosystem 3:00pm – 4:00pm Room 25

Betsy Huntingdon, Product Marketing Teradata Corporation As the Teradata Ecosystem expands, there are several different ways and locations to move your data around to depending on its purpose and ultimate resting place. This high-level session will discuss the options for moving directly from one Teradata system to another (Data Mover, Dual Active), for transporting your data off Teradata for data protection (BAR, Disaster Recovery), and for moving data to a data retention site for online, long-term, lower-cost storage (Teradata Extreme Data Appliance).

1368 So... Do I Really Need a Data Model?

3:00pm – 4:00pm Room 24

Thomas Manfredi, Principal Consultant Teradata Corporation The practice of modeling our data prior to a data warehouse implementation has long been a pillar of Teradata best practices. Yet the value of this practice is often questioned by those looking for shortcuts. Some have a physical model on a different database and want to port it to Teradata unchanged to avoid impact to existing applications. Others see modeling as an expensive and timeconsuming exercise that is more academic in nature and removed from practical realities.

to a Teradata migration and highlight practical steps to achieving a high performance and robust warehouse. We will also explore some of the enabling features within the Teradata DBMS (Database Management System) that help accelerate the performance of wellmodeled databases.

1547 How Coca-Cola Leverages Rocket Science to Drive Retail Results

3:00pm – 4:00pm Room 29 A, B

Phil Sanford, Director The Coca-Cola Company Co-Presenter: Bob Hannah, President Data Ventures This session will show how exploiting pattern recognition over large data sets can better understand shopper behavior and how shopper and consumers interact with Coca-Cola products. The speakers will demonstrate how to execute advanced shopper insights with practical application and proven results. The devil is in the details which means the analysis has to be at the item (SKU), store, basket, and shopper level. This deep understanding leads to quantitative decision making that is driving improved volume, share, and profit. This is a global initiative that crosses channels. The pattern recognition opportunities uncovered highlight causal factors driving shopper behavior and can also predict behavior based on past experience. The presentation will conclude with a real market example of Rocket Science at work in the retail environment.

Rather than reprising best practices in data modeling techniques, this session will focus on calling out the risks of not modeling. Using case studies and real-world examples, this session will drive home the importance of revisiting modeling decisions prior

60

continued...

2011 Teradata PARTNERS User Group Conference & Expo

1614 Mega Merger in UK Banking: The Strategic View from the Enterprise Data Warehouse 3:00pm – 4:00pm Room 30 A, B

David Bargeron, Senior Information Architect Lloyds Banking Group Following the Global financial crisis of 2008, in the UK the opportunity arose for LTSB to acquire HBOS—both Banks have a history reaching back over 300 years. On completion, this would create the UK’s largest retail bank and would form a new group known as Lloyds Banking Group. The presentation gives insight into the alternative data warehousing strategies of both banks and the architectural thinking, early value generators, challenges and implementation strategy for an Enterprise Data Warehouse based on the Teradata platform (due for completion in July 2011).

1639 Social Network Analysis Case Study—from PoC to Delivered Value

3:00pm – 4:00pm Room 22

Konstantin Romanov, Head of Customer Relationship Management Development Mobile TeleSystems Co-Presenter: Roman Postnikov, Senior Consultant Teradata Corporation Practical case study of implementation of a Teradata Social Network Analysis solution based on a unique IP Social Pattern Matching algorithm for “MTS”—largest mobile provider in Russia and Commonwealth of Independent States (CIS) countries with more than 70 million clients and annual turnover of $11.3 billion. In this session

Mini Session

Technical

Business

Guru

Super

you will know how Teradata and MTS jointly developed a solution to drive the “share of wallet” issue on the very competitive and highly penetrated Russian mobile market, how this solution differs from standard SNA applications, and what unique business benefits it generated for six months after implementation.

1671 Enterprise Reporting and Financial Reconciliation from an Enterprise Data Warehouse 3:00pm – 4:00pm Room 29 C, D

Mark Humphreys, Head of Business Intelligence Qantas Airways Ltd Qantas is a global airline with a global reputation. Finance reporting is key to running any business, and even more so to the complexities of a multi business segment operation like Qantas Airlines. The airline operates 11 different main stream business segments, and integrated data feeding operational decisions and financial reporting is key to helping us operate our business and costs. The Qantas warehouse has three main business domains: Customer, Flying Business, and Finance. Finance Data Warehouse, which has been implemented over the past two years, now serves as the centre for the airline financial IM reporting serving over 350 global operational users. The data is extracted, loaded and fully reconciled and joined to the corporate general ledger (GL) on a daily and interim basis. The future is to extend to include other corporate functions such as payroll and HR operations in a fully integrated and single view business solution.

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

1891 Multi-echelon Replenishment Modeling for The Home Depot

3:00pm – 4:00pm Room 28 A, B, & C

Arash Bateni, Director of Advanced Analytics Teradata Corporation Co-Presenter: Stuart Shiplett, Director, Supply Chain Systems The Home Depot Some of the largest retailers in the world have employed Teradata’s advanced analytics to forecast their products’ demand and manage their inventories along their supply chain network. For multi-national retailers like Home Depot, managing global replenishment systems has become more sophisticated, and hence, demands more advanced analytics and solutions. This session introduces a novel multi-echelon replenishment scheme designed by Teradata Demand Chain Management (DCM) in partnership with The Home Depot to forecast and optimize the inventory and transportation units across multiple layers of vendors, warehouses and distribution centers, as a single cohesive model. The proposed model includes advanced features such as Trans-load Centers (to receive and de-consolidate overseas shipments), Rapid Deployment Centers (to serve as flow-through stations), Stocking DC’s (to store goods for future demand), and multiple transportation paths between these centers.

1923 Leveraging Teradata Active Systems Management Event Driven Throttles to Manage Tactical Workload

3:00pm – 4:00pm Room 23

Nicholas Polizzi, Teradata Architect Enterprise Holdings Inc. Co-Presenter: Steve Woodrow, Senior Performance Consultant, GSC Teradata Corporation Managing workload in an aggressively expanding Active Data Warehouse poses many challenges, especially when trying to balance the priority of tactical Golden Gate activity with that of ADHOC business reporting and day time ETL (Extract, Transform Load). Join the Data Warehouse Team of Enterprise Holdings Inc., and Teradata Professional services, as they share key tips and techniques in managing the complexities of Real Time Performance Management in a mixed workload environment. Observe, first hand, a customer’s perspective on the importance of identifying workload compatibility, tracking capacity trends and Viewpoint alerts, and having an automated strategy for combating system flow control states within your TASM rule sets.

www.teradata-partners.com

61

tUeSdAY edUcAtIonAl SeSSIonS 1948 Structured and Unstructured Data Solutions with Aster Data’s SQL-MapReduce 3:00pm – 4:00pm Room 26

Don Watters, Chief Data Architect Myspace Co-Presenter: Qi Su, Senior Solutions Architect Aster Data Center of Innovation (Teradata) Have you thought about how to use commodity hardware to solve big data problems? Myspace has done just that for many years with Aster Data nCluster. We are going to show you how to walk through use cases to go from problem to solution, thinking not just in sets, but in iteration within the set as well. We will discuss how Myspace has used SQL-MapReduce with Aster Data nCluster to solve big data problems. There will be a short discussion about the data and analytic environment at Myspace, followed by a hands-on demonstration of three use cases going from simple to complex. Please join us for a deep dive into SQL-MapReduce and some of the problems that it helps Myspace solve.

2162 The Healthcare Data Warehouse

3:00pm – 4:00pm Ballroom 20 D

Richard Winter, President and Chief Executive Officer Winter Corporation Government health care programs face ever increasing demands to care for more patients, provide higher quality care, and contain or reduce cost. Two of the big opportunities for making progress with these goals are electronic patient records (EHR) and electronic medical devices that monitor patient health remotely. But taking full

62

continued...

advantage of either development requires a mechanism to store, integrate, and make accessible large volumes of medical data. The health care data warehouse is the way to accomplish this. Health care data warehousing is not far advanced or widespread in government, but there have been some notable successes. This session will describe what is involved in health care data warehousing, review successful cases of actual implementation at the state and federal level, and discuss some key factors critical to success, focusing on architectural features required in the solution.

3500 Information Advantage—Vision Driven BI Initiative by WellPoint

3:00pm – 4:00pm Room 28 E

The presentation shall outline the strategy and implementation model of the data warehousing and business intelligence solution at WellPoint, one of North America’s largest health benefits company. Topics to be discussed will include the operational and strategic setbacks faced by the firm, business drivers, details of the technical solution and the benefits derived through the implementation. WellPoint was looking to establish a centralized, near real-time EDW (Enterprise Data Warehouse) by integrating multiple sources of data into a single enterprise-wide data model and also promote standardized platforms, tools and definitions. They initiated the program to build EDWard (Enterprise Data Warehouse and Reporting Depot). EDWard provides an integrated view of health profiles of 33.5 million subscribers. It hosts data from 30 disparate sources and handles 9 major subject area including membership, revenue, capitation, claims, provider, product, chart of accounts, medical management, and health risk assessment. EDWard has over 1500+ attributes and has more than 5 years of enterprise data (~70TB core subject area). EDWard has been built on Teradata and Informatica to extract data from varied operational systems (relational, mainframe) and IBM event publisher as Change Data Capture mechanism. The new architecture and the associated tools have effectively reduced the delays and enhance the speed-to-market rollouts of new products to subscribers, providers, and abide by the reporting rules for regulatory compliance.

2011 Teradata PARTNERS User Group Conference & Expo

4:30pm – 5:30pm 1200 Teradata for the SAS Programmer 4:30pm – 5:30pm Ballroom 20 B, C

Richard Andrews, Senior Technical Developer Centers for Medicare and Medicaid Services (CMS) Co-Presenter: Jignesh Miyani, Senior Consultant Teradata Corporation The manner and speed in which information is hashed and indexed makes Teradata a valuable tool for satisfying time sensitive Congressional requests at the Centers for Medicare and Medicaid Services (CMS). Ordered Analytical Functions enable On-Line Analytical Processing (OLAP) requests containing ANSI SQL: 2003 window functions, which greatly enhance the functionality of the Structured Query Language (SQL). This session will discuss how SAS 9.1 programming techniques can be imitated within the Teradata 12 environment using SAS\ACCESS pass- through queries and the simulation of By-Group processing with dot notation. The methods discussed will help users make an easier transition from traditional SAS programming to a Massively Parallel Processing (MPP) Teradata platform running shared nothing architecture.

Mini Session

Technical

Business

Guru

Super

1263 Aggregate Join Indices and Dimensional Models to Deliver Performance 4:30pm – 5:30pm Room 25

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

1333 Grainger Drives Business Growth Using Profitability Analytics

4:30pm – 5:30pm Room 29 C, D

Jose Borja, Senior Teradata Data Warehouse Consultant APP Consulting

John Myers, Group Business Systems Manager RTR WW Grainger

Co-Presenter: Lana Gozman, Senior DBA & Supervisor Independence Blue Cross

Co-Presenters: David Rosal, Senior Industry Consultant Teradata Corporation

By creating architectures built with Dependent Dimensional Models on top of our core 3NF Data Warehouse, we were able to deliver extraordinary performance from large tables to our user bases. The implementation of a dimensional modeling architecture in our semantic layer using a mix of Partitioned Primary Indexes and Join Index strategies helped us meet our goals to provide fast response times without leaving a footprint on the core base tables.

Tammy Watson, Solution Architect Teradata Corporation

The techniques covered in this presentation have been used successfully in large Teradata Data Warehouse implementations to resolve the long running times needed to access and aggregate large amounts of data from multiple tables in the 3NF core. The deployment of a Dimensional Model in the semantic layer leveraged with a wide mix of Aggregate Join Indices per fact table cut down significantly on resource consumption, taking many large reports down from 30 minutes to seconds.

Grainger is utilizing profitability analytics to gain deeper insights into the key value drivers including product, customer, vendor, location and sales force. Business users can now understand profitability at a granular level (including down to the SKU level) and take targeted actions in response. By summarizing from this lower level of detail, Grainger can enforce a consistent model which gives multidimensional views of performance and leverages existing information in the company’s data warehouse.

Driven by the desire to improve and extend existing profitability models, WW Grainger implemented Teradata’s Value Analyzer, enhancing their profitability analytic capabilities and enabling the company to gain a competitive edge and drive growth.

The speakers will discuss the business case for profitability, implementation methodology and the business value generated from the implementation of TVA at Grainger.

1414 Teradata Viewpoint—Ask the Experts 4:30pm – 5:30pm Expo Hall F

Gary Ryback, Product Manager Teradata Corporation Co-Presenter: Steve Ratay, Viewpoint Architect Teradata Corporation Panelists: Philip Foutty, Database Admin Senior Advisor WellPoint Inc. Blaise McEvoy, Viewpoint Engineering Manager Teradata Corporation Steve Ratay, Viewpoint Architect Teradata Corporation Micah Steadman, Manager, EDW Engineering and Operations Overstock.com This panel discussion will offer an open and lively discussion on Teradata Viewpoint best practices, high availability configuration, migration from TTU products, administrative configuration, performance, and best-in-class problem solving scenarios with both Teradata R&D expertise and Teradata customer panel members. The session will dive into out-of-the-box thinking of how Viewpoint can be used to solve your toughest problems. It will combine exploration into real customer scenarios as well as open forum for audience feedback and questions.

www.teradata-partners.com

63

tUeSdAY edUcAtIonAl SeSSIonS So what Teradata system management issues can we help you with? What success stories have you had? What frustrations do you have with Viewpoint? What aspects will improve your Viewpoint performance and experiences? We have the experts, experienced customers, and a live Viewpoint system at your disposal to get the answers you need.

1446 Social Customer Relationship Management Social Means Business

4:30pm – 5:30pm Room 24

continued...

Behind the complexity, silos, and breadth of web data lies a treasure trove of web intelligence just waiting to be tapped to provide a holistic view of customers, support marketing strategy, and drive marketing execution. To become more adaptive and meet customer expectations, marketers must develop the technology, skills, and processes to harness web data, transform it into web intelligence, and apply it to multichannel marketing.

1569 Squeezing the Margins Out of a Barrel of Oil

4:30pm – 5:30pm Room 28 A, B, & C

1586 Best of Breed Business Intelligence and Data Integration in an SAP Environment

4:30pm – 5:30pm Ballroom 20 D

Joseph Choi SAP Co-Presenter: Wayne Boyle, Vice President Technology and Strategy Teradata Corporation

Adam Saner, Research Director Gartner

Blake Larsen, Vice President of Information Technology Western Refining

Many customers go through similar buying processes when making purchases. Mass adoption of the web channel among customers has shifted a typical buying process of need/want recognition, information search, evaluation, and purchase from an offline to an increasingly online activity. Within each stage of the buying process, socialization technologies have an opportunity to improve the customer experience and influence the customer through all stages toward a purchase.

Co-Presenter: Glen Sartain, Director, Oil & Gas Practice Teradata Corporation

1554 Transforming Web Data into Web Intelligence to Inform Marketing Strategy

4:30pm – 5:30pm Room 29 A, B

Joseph Stanhope, Senior Analyst Forrester Research

The refining and petrochemical industry is unique in the economic cycle. They do not follow the standard economic conditions of their upstream cousins in oil and gas. When oil prices go higher, their cost of goods sold also moves higher, and there is a significant lag in the prices they are receiving for their end products—all driven by market conditions. So the question is, in an industry where margins have been squeezed and costs have been cut to the bone, how do you squeeze more margins out of the same barrel of oil? How does the business utilize items within their control to maximize benefit to the bottom line? In this session we will discuss and explore the journey taken to turn data into information that can be used throughout the refining organization to positively impact real-time business decisions.

As interactive marketing rises in influence and proportion of marketing spend, organizations have no shortage of web data. But turning that online data into actionable intelligence is another story. Few marketers have progressed beyond an overwhelming number of metrics and dashboards that do little to provide real business insight.

64

2011 Teradata PARTNERS User Group Conference & Expo

Discover how to leverage Teradata in an SAP environment. This session will explore the customer options for utilizing Teradata, SAP data, and a variety of SAP and non-SAP tools to drive an integrated single view of your business. Join this session to realize benefits in areas such as data storage and information life cycle management; network management, and business intelligence self-service. This interactive session will explore how a properly designed and executed business intelligence strategy can substantially lower the total cost of IT as well as align strategic and operations systems, people, technology, and processes across the organization.

1706 Vodafone UK’s Business Intelligence (BI) Transformation—Journey to a High Performance BI Service

4:30pm – 5:30pm Room 30 A, B

Niall Cottrill, Head of Business Intelligence Vodafone UK Transforming business intelligence (BI) within a major business creates significant challenges in managing people, process, data, and technology while delivering value to the business. This presentation will describe Vodafone UK’s experiences in bringing about a BI

Mini Session

Technical

Business

Guru

Super

transformation focusing on some key initiatives from that journey including: • Building a vision for BI that motivated the Chief Executive Officer and Board. • BI resource consolidation and the importance of the BI operating model. • Developing data management disciplines. • Delivering an audit of business value from analytics. • Living with IT cost reduction and outsourcing. This session will be valuable for all organizations wanting to move their BI forward and while facing issues around BICCs and value delivery.

1715 SQL or NoSQL—That is NOT the Question! (It’s How You Combine Both to Win) 4:30pm – 5:30pm Room 26

Steve Wooledge, Senior Director, Product Marketing Teradata Aster Center of Innovation Co-Presenter: John Cieslewicz, Software Engineer Teradata Corporation (Aster Data) The either-or decision about whether to use a purely SQL and NoSQL system—such as Hadoop—can limit your insights and speed of analytic innovation. Use the right tool for the job. What if you had both procedural SQL-MapReduce processing and the strengths of an SQL RDBMS (relational database management) on one analytic platform for fast, interactive analytics on diverse types of big data? Attend this session to hear how data scientists and business analysts can seamlessly combine their work to innovate faster. See how SQLMapReduce powers deeper social network analysis, personalization, marketing attribution, risk analysis, and more.

SIG

Big Data

Sponsorship

The Edge

Tuesday Sessions

Aprimo

1746 SIG: Best Practices Implementing Teradata with IBM Software Solutions

1978 eBay’s Innovative Approach to Clickstreamdriven Data Insights

Michael Hortatsos, Business Executive, Global Strategic Alliances IBM

Dinesh Chavan, Manager, User Behavior Intelligence and APD Architecture eBay

4:30pm – 5:30pm Room 22

Co-Presenter: Christine Sellman, Global Alliance Manager Teradata Corporation Teradata’s partnership efforts with various IBM software groups (e.g., Cognos, SPSS, InfoSphere) continue to expand. Subject matter experts from both companies will be available to answer questions about the partnership, product integration, and implementation best practices. This Special Interest Group will be open to questions from attendees about their current and planned uses of IBM software in their Teradata environments. Topics discussed can include ROLAP/ MOLAP with IBM Cognos business intelligence, SPSS in-database predictive analytics, ETL/ELT and Dual Load with IBM InfoSphere DataStage, Database Activity Monitoring with IBM InfoSphere Guardium, and Data Lifecycle Management with IBM InfoSphere Optim.

4:30pm – 5:30pm Ballroom 20 A

In order to harness and understand the vast amounts of valuable insights derived from clickstream data analysis, eBay had to take a unique approach to transform and mine the data. eBay’s approach was to design an immensely scalable platform capable of managing and storing the data and then to enable the mining of customer behavior data for better decision-making across the enterprise. Marketing, finance, advertising, experimentation, mobile, and site analytics teams were a few of the internal teams that required datadriven insights into the clickstream data.

2200 How to Improve Performance using Multilevel Partitioned Primary Indexes (MLPPI)

4:30pm – 5:30pm Room 23

Marcio Moura, Solution Teradata Architect IBM Global Business Services Having an MLPPI implementation methodology and process in place will increase the performance of critical reports and improve overall system performance. An MLPPI process will help you design and implement multi level PPI on tables, Join Indexes (JI), and Aggregated Join Index (AJI). The presenter will provide all the details of a case study on how to design and implement MLPPI on Tables, JI and AJI taking into consideration the reporting and loading sides.

www.teradata-partners.com

65

tUeSdAY edUcAtIonAl SeSSIonS 3540 Tokenization on the Node—Data Protection for Security and Compliance

4:30pm – 5:30pm Room 28 E

Ulf Mattsson, Cheif Technology Officer Protegrity Data security is the ultimate Catch 22—organizations invest countless resources researching, developing and producing top-ofthe-line security platforms for today’s problems, but cyber-criminals have tomorrow’s solution. Ultimately, there is no single silver bullet for keeping databases protected, but a technology at the forefront of innovation is tokenization. Recent advances have made it a legitimate alternative to encryption for the enterprise data warehouse. In this session learn about the security power behind tokenization, benefits of this technology and proven use cases.

66

2011 Teradata PARTNERS User Group Conference & Expo

continued...

WEDNESDAY

WED

WEDNESDAY

Scheduled Events Time

Event

Location

7:00am – 6:00pm

Registration Open

Convention Center

7:00am – 6:00pm

Poster Sessions

Convention Center Poster Session Hallway

7:00am – 8:30pm

Breakfast

Convention Center Exhibit Hall H

8:00am – 2:30pm

Conference Educational Sessions

Convention Center

10:00am – 10:45am

Networking Break

Conference Sessions Area, Upper Level

Noon – 1:30pm

Expo Hall Lunch & Dessert Reception

Convention Center Exhibit Hall H

2:30pm – 3:30pm

Networking Break

Exhibit Hall G

3:30pm – 5:00pm

General Session with Keynote Speakers

Convention Center Exhibit Hall F

7:00pm – 10:00pm

Gala Event

USS Midway

Expo Hall Hours Exhibit Hall G

10:00am – 3:00pm

8:00am – 9:00am Session #

68

Session Title

1290

Part One: Terdata Database 14 Overview

1499

Active Data Warehouse Management at The Home Depot Using Teradata Active System Management

1521

Analytics Strategy and Approach Leveraging SAP and Teradata

1672

Driving Value through Aprimo Relationship Management and Aprimo Usage in Barclays

1697

Panel Discussion—Translating Geospatial Analytics into Reality

1699

Lessons from the Sandbox: Tips to Fix Crucial Issues Yourself Quickly

1731

Isle of Capri Casinos: Meeting Customers Where They Live

1748

Multi-Channel Analytics

1830

A Strategic Tool for the CFO: Ford Credit’s Global Finance Analysis System

1924

What Does Solid State Drive Storage Mean to the Data Warehouse: The Experts Speak

1972

SQL-MapReduce Panel: Fusing MapReduce with SQL for Big Data Analytics

1983

Your Teradata Database Administration Team—Peeling the Complexity Onion

3521

Enabling the Bank of America Analytical Ecosystem

2011 Teradata PARTNERS User Group Conference & Expo

Educational Sessions Room Ballrm 20 A Ballrm 20 B, C

Presenter

Session Type

Rich Charucki, Teradata Corporation

Technical

Alpesh Desai, The Home Depot

Technical

28 A, B, & C

Joe Young, Lexmark International

Business

29 A, B

Kevin Heggie, Barclays Bank PLC

Business

Michael Gonzales, Claraview

Business

Ballrm 20 D 23

Robert Sievert, Teradata Corporation

Technical

Ryan Murphy, Isle of Capri Casinos, Inc.

Business

Mike Mischel, Numeric Analytics

Technical

David Hickey, Ford Credit

Business

Jim Dietz, Teradata Corporation

Technical

Richard Winter, Winter Corporation

Technical

25

Sue Paulson, GE Healthcare

Technical

24

Bob Nicholson, Bank of Amercia

Technical

30 A, B 26 29 C, D 28 E ExHall F

Educational Sessions

9:30am – 10:30am Session #

Session Title

1163

AMP Worker Tasks

1338

Teradata Database 14 Overview—Part 2

1362

Aprimo Utilization to Mitigate Risk

1453

Transforming the Traditional Approaches to Client Client at RBC

1549

Now You See It, Now You Can’t—How to Use Encryption in Teradata Systems

1559

Nike’s Data Warehouse Gets Fit!

1589

Driving Business Value from HSBC’s Information Strategy

1609

The New Integrated Aprimo Marketing Suite

1633

Self Service-”Distributed Marketing”

1714

Fireside Chat with Teradata and Aprimo Executives: Here’s the Plan

1808

SIG: Data Architecture

1823

The Role of the Data Warehouse in an Information Management Platform

1959

Teradata Temporal—Implementation Best Practices

2160

The Road to a Successful Single Source of Truth

Room

Presenter

Technical

1459

Metrics and Visualization for Teradata Service Levels

Rich Charucki, Teradata Corporation

Technical

1461

Preparing for the Future by Replaying the Past: The DBQL Query Replay Tool

29 C, D

28 E

1719

Cost-Based Optimization: Best Execution Plan for Complex Queries

25

Bhashyam Ramesh, Teradata Corporation

Technical

Meeting of the Models—Building Blocks for Integrated Solutions

24

Ojustwin Naik, Teradata Corporation

Technical

Sharon Allsop Kenney, HSBC

Business

Gonzalo Hidalgo, Aprimo

Technical

29 A, B

Lisa Loftis, Baseline Consulting

Business

ExHall F

Lisa Arthur, Aprimo

Business

Tom Russell, Teradata Corporation

Technical

28 A, B, & C 24 30 A, B

Mark Beyer, Gartner, Inc.

Technical

Igor Machin, Teradata Corporation

Technical

Hina Patel, Cisco Systems

Business

Educational Sessions

Session Title

Room

Presenter

Session Type

Ballrm 20 B, C

Greg Hamilton, Teradata Corporation

Technical

1450

Cardinal Health’s Innovative Use of Data Lab and Agile Data Development

25

Renee DePalo, Cardinal Health, Inc

Technical

1474

Meet the Team: Teradata IDE and SQL Assistant JE

23

Mike Coutts, Teradata Corporation

Technical

1509

Deep Analytics with Big Data: New Requirements for New Practices

26

Philip Russom, TDWI

Technical

1514

Supporting Multiple Languages with Oracle Business Intelligence Enterprise Edition (OBIEE) and Teradata Using Unicode

22

Brandy Tunnell, Teradata Corporation

Technical

Enterprise Information Models as Key Drivers for Pervasive and on Demand BI Morgan Stanley and Smith Barney—A Data Warehouse Integration Story

1839

Conquer Complexity: Implementing a Corporate Data Warehouse User Group

1843

Whats New in TASM?

1845

Implementing a Data Mining Solution with SAS and Teradata

1868

Where is Waldo: Leveraging MapReduce for Location Analytics on nCluster

28 A, B, & C

Ehtisham Rao, Mobilink

Business

30 A, B

Samit Korgaonkar, Morgan Stanley

Business

29 C, D

Blair Hanna, Norfolk Southern Corporation

Business

Ballrm 20 A 28 E Ballrm 20 D

Technical Technical

1933

Technical

22

Nachum Shacham, eBay Aaron Klang, Teradata Corporation

Business

Technical

26

Session Type

Business

James Lee, Nike, Inc

Ballrm 20 D

26 Ballrm 20 B, C

Presenter

Robert Keast, RBC Jim Browning, Teradata Corporation

25

Room

Kathy Greene, Citizens Financial Group

Getting the Most Out of Workload Management on the Appliance

1661

Session Title

Carrie Ballinger, Teradata Corporation

1332

1679

Session #

23

Ballrm 20 B, C

Mini Sessions

12:15pm – 1:00pm

Ballrm 20 A

11:00am – Noon Session #

Session Type

Doug Brown, Teradata Corporation

Technical

Angela Watson, Overstock.com

Technical

Amiya Mansingh, Cobi Systems LLC

Business

1895

Data Singularity & Extreme Analytics at eBAy

ExHall F

Oliver Ratzesberger, eBay

Business

1955

Leveraging Aprimo Marketing Studio to “Think Nationally, Act Locally”

29 A, B

Gregg Dertinger, UnitedHealthcare

Business

1986

Introducing Fact Based Decision Making to Physical Database Design

24

Michele Pugliese, Travelers Insurance

Technical

1:30pm – 2:30pm Session #

Session Title

1282

The Information Paradox – Why does Simplicity cause so much Complexity?

1339

Breaking through the Partition Barrier

Room 24 Ballrm 20 B, C

Rob Armstrong, Teradata Corporation

Technical

Paul Sinclair, Teradata Corporation

Technical

1401

Patterns, Trends and Anomalies—Identifying, Mitigating and Preventing Fraud

Becky Briggs, ARC

Business

1475

Right Time Business Intelligence (BI) at Travelers’ Select

30 A, B

Amir Farid, Travelers Insurance

Business

1659

An Analytic CRM Journey in Maybank

29 A, B

Ahmad Hishamuddin Mohammed Salleh, Malayan Banking Berhad

Business

1692

Always On, Always Available, Always Right! The Commander and Staff Need 24x7x365 Data Availability as Their Stuff Moves Globally to Support the Troops

John Rusnak, The MITRE Corporation

Technical

1736

Innovative Usage of SAP BI on Teradata

1770

Combining ETL and ELT for Active Data Warehousing

1827

Mining Hidden Treasures in the Volvo Cars Information Landscape

Ballrm 20 A

Presenter

Educational Sessions Educational Sessions Session Type

23 28 E

Mark Marty, Levi Strauss & Co

Technical

25

Gerry Lager, Lockheed Martin

Technical

Henrik Högberg, Volvo Car Corporation

Business

29 C, D

1874

Introducing the Analytic Platform: Next-Generation Big Data Analytics

Stephanie McReynolds, Teradata Corporation / Aster Data

Technical

1882

Making EDW Data Easy for Business People to Access and Use

28 A, B, & C

Blake Johnson, Stanford University

Business

1962

Business Intelligence (BI) Delivery Framework 2020

Ballrm 20 D

Wayne Eckerson, BI Leadership Forum

Business

3560

SIG: ‘Big Data & Analytics’ What Is It? What Challenges Does It Create for You? How are SAS and Teradata Responding?

26

22

Murray Maloney, Teradata Labs

Foldout For Wednesday agenda

Wednesday Sessions

Wednesday educational sessions 8:00am – 9:00am 1290 Part One: Teradata 14 Overview

8:00am – 9:00am Ballroom 20 A

Rich Charucki, Engineering Fellow Teradata Corporation Come and hear all about Teradata Database 14! Learn about the exciting Teradata columnar implementation, the raising of PPIpartition limits, hash join improvements, statistics enhancements, query redrive capability, write from fallback fault isolation, brand new datatypes, new calendars for SQL expansion, new industry compatible functions, temperature based compression, partial online reconfiguration, and row-level security. Teradata Database 14 represents the next major step in the evolution of data warehousing excellence.

1499 Active Data Warehouse Management at The Home Depot Using Teradata Active System Management 8:00am – 9:00am Ballroom 20 B, C

Alpesh Desai, Database Administrator The Home Depot

1521 Analytics Strategy and Approach Leveraging SAP and Teradata

1672 Driving Value through Aprimo Relationship Management and Aprimo Usage in Barclays

Joe Young, Manager, Business Intelligence and Master Data Management Lexmark International

Kevin Heggie, Senior Change Manager Barclays Bank PLC

8:00am – 9:00am Room 28 A, B, & C

Panelists: Ellen Boerger, Director, SAP Program Teradata Corporation Srikant Dharwad, Enterprise Data Architect Lexmark International Business Intelligence environments are required to support a diverse collection of data sources and a heterogeneous collection of applications and tools. Join this session to learn how Teradata enables customers to conquer complexity by providing a single unified platform for analytics which include SAP data and nonSAP data. Realize the business and technical benefits of this solution and architecture including accelerated, unified access to detailed enterprise data for improved business visibility. Lexmark International will provide insight into their environment and roadmap to for deployment of the integrated architecture from SAP and Teradata. Come away with an understanding of how to consolidate data within a single Teradata Database, lower your total cost of ownership, and provide business critical analytics to your business user community.

Co-Presenter: Claybourne Barrineau, Teradata Architect The Home Depot The Home Depot heavily utilizes Teradata Active System Management to manage a mixed workload environment consisting of everything from complex analytics to applications requiring subsecond response times. The session will provide insight into real world Teradata Active System Management implementation. www.teradata-partners.com

69

70

2011 Teradata PARTNERS User Group Conference & Expo

8:00am – 9:00am Room 29 AB

Co-Presenter: Bev Pilbeam, Head of Change, Marketing Barclays Bank PLC Barclays has been using Teradata for over 15 years supporting a range of analytical capabilities which deliver huge value to the business. In 2005, Barclays embarked on a journey to use the Teradata CRM package to deliver all the Direct Marketing activity for the UK Retail Bank, and in 2010, completed the upgrade of the system to Aprimo Relationship Management 6.2. The presentation will explain to the audience the value Barclays received through the exploitation of the Teradata environment using Aprimo Relationship Management, what drove them to choose Aprimo Relationship Management to underpin their activity, and provide best practices with regards to delivering a successful upgrade project. The session will also explain how Barclays is using Aprimo today, and what their plans are for Aprimo in the future.

Mini Session

Technical

Business

Guru

Super

1697 Panel Discussion—Translating Geospatial Analytics into Reality 8:00am – 9:00am Ballroom 20 D

Michael Gonzales, Principal Claraview Panelists: Glenn Facey, Vice President Claraview

SIG

Big Data

Sponsorship

The Edge

Even if you have experience, database space issues, spool space issues, and unexpected query results can still appear suddenly and stop you in your tracks. Techniques and troubleshooting code will be discussed and handed out—so you can get past some issues on your own without the help desk or the DBA. If you are a DBA, you can share these with your customers and perhaps lighten your own load by preventing a few future incidents. While our session won’t cover every issue, everything we do cover comes from real world examples.

1731 Isle of Capri Casinos: Meeting Customers Where They Live 8:00am – 9:00am Room 30 A, B

William Smith, PS Senior Partner Claraview- a division of Teradata This session offers valuable insight for a panel of leading experts on the fundamentals of Geospatial Analytics and how it is being applied in both the private and public sector. Attendees will learn the importance of developing a Geospatial strategy as well as best practices and lessons learned from industry.

1699 Lessons from the Sandbox: Tips to Fix Crucial Issues Yourself Quickly 8:00am – 9:00am Room 23

Robert Sievert, Senior Consultant Teradata Corporation If you are an end-user in an analytic sandbox finding yourself dead in the water with an intractable problem or a Database Administrator (DBA) tasked with supporting and solving problems for those sandbox users, this session may provide some relief. With more companies using ad-hoc non-production spaces, often called sandboxes, we see an increasing pool of analytic users writing their own Structured Query Language (SQL) instead of relying on code generated by a Business Intelligence tool.

Wednesday Sessions

Aprimo

Ryan Murphy, Senior Director of Business Intelligence Isle of Capri Casinos, Inc. Isle of Capri Casino is leveraging their Teradata and IBM Cognos environment to understand their customers and improve their business intelligence reporting. Isle of Capri will focus on discussing the article that was published in Teradata Magazine and the Teradata white paper that was released in Q4 of 2010. The company has dramatically accelerated and expanded the process of information gathering and dispersal, producing about 150 reports on a daily basis, 100 weekly, and 50 monthly, in addition to ad-hoc queries, completed within minutes, all day every day. After an initial data warehouse implementation was derailed in 2005, in part by Hurricane Katrina, Isle decided to reboot the project with entirely new components and Teradata as the core solution and key partner, along with IBM Cognos 8 Business Intelligence. The Teradata and Cognos solution could enable key decision makers throughout to easily frame their own initial queries and have timely follow-up questions.

1748 Multi-Channel Analytics 8:00am – 9:00am Room 26

Mike Mischel, Vice President of Analytics and Optimization Numeric Analytics From call centers to stores to websites, customers have an increasing number of ways to engage with your business, and connecting the dots between online and offline channels can aid marketers by highlighting previously unobserved correlations. Etisalat’s Head of Enterprise Information Management, Mr. Mohammed AbdelRahim, explains how Etisalat is using the KXEN software solution, within its Teradata infrastructure, for carrying on all their SNA, from acquisition to contagious churn prediction, through multi-SIM, rotational churn detection, and influencer’s identification. He will share Etisalat’s best practices for significant cut in churn, improved return rates on Member-GetMember campaigns, and a significant boost in customer ARPU.

1830 A Strategic Tool for the CFO: Ford Credit’s Global Finance Analysis System 8:00am – 9:00am Room 29 C, D

David Hickey, Senior Business Intelligence Technical Specialist Ford Credit Co-Presenter: Christopher Garland, Solution Architect Teradata Corporation The finance department at Ford Credit struggled to report financial results and forecast future performance with the speed and accuracy demanded by external stakeholders. The technology solution in place relied on manual manipulation of data views from multiple disparate systems, was labor intensive, and did not www.teradata-partners.com

71

WedneSdAY edUcAtIonAl SeSSIonS scale effectively with system changes and data volume growth. Ford addressed this by combining technologies including Teradata, Oracle Essbase, and Webfocus to develop the Global Finance Analysis System (GFAS) application. The primary function of GFAS is to provide the data that feeds external financial statements at Ford Credit, including annual and quarterly income statement and balance sheet reporting and supporting footnotes. This critical application provides nearly 400 users with proven data consistency and integrity, accelerated planning, forecasting and variance analysis capabilities, and a more efficient, integrated and scalable data architecture.

1924 What Does Solid State Drive Storage Mean to the Data Warehouse: The Experts Speak 8:00am – 9:00am Room 28 E

Jim Dietz, Marketing Manager Teradata Corporation This panel discussion will cover the basics of Solid State Drives, their use in a mixed storage system, their optimum use with automatic data migration, and the impact on data warehousing. The topics will be covered by the industry experts that enable the new Teradata mixed storage Active Enterprise Data Warehouse (EDW) platforms. This will include senior architects from Teradata platform and data base engineering, SSD and storage system technologists from Pliant Technologies, and industry analyst experts.

continued...

1972 SQL-MapReduce Panel: Fusing MapReduce with SQL for Big Data Analytics

1983 Your Teradata Database Administration Team— Peeling the Complexity Onion

Richard Winter, President and CEO Winter Corporation

Sue Paulson, Data Management Architect GE Healthcare

Panelists: Navdeep Alam, Director, Data Architecture Mzinga

The Teradata DBA team in your enterprise works diligently to deliver valuable service to daily production and developing business intelligence operations. A barrier to entry for a company looking to add Teradata to the technology stack is staffing the support and development teams, especially the DBA team. Finding persons with Teradata platform knowledge and experience is a time-consuming and expensive proposition. Look first at the DBA staff that is already working for your enterprise, or job seekers that possess valuable experience working on a similar database platform that can be leveraged for Teradata. This session details best practices in sourcing and building a team that can meet the demands of highly complex data queries, hot rod hardware, and constantly changing business reporting needs. Attendees will hear current best practices for elevating DBA productivity above routine tasks to take on challenging areas that deliver the most value to the business.

8:00am – 9:00am Exhibit Hall F

Tasso Argyros, Chief Technology Officer Aster Data Systems, Inc. Jay Thomas, Senior Data Scientist Linkedin Don Watters, Chief Data Architect Myspace This session will discuss the key capabilities and uses of the Aster Data analytic platform and Structure Query Language (SQL)MapReduce—an integration of MapReduce and SQL. Customers and an expert from Aster Data will join Richard Winter in discussing actual examples from practices employing SQL, Hadoop MapReduce, and/or SQL-MapReduce. Each panelist will describe an architecture in actual use for analytical data management—an architecture involving Aster Data, Hadoop, Teradata, or any in combination. Panelists will discuss how these platforms are used to meet the requirements they face and how they decide which platform to use to solve a given problem.

8:00am – 9:00am Room 25

3521 Enabling the Bank of America Analytical Ecosystem

8:00am – 9:00am Room 24

Bob Nicholson, Senior Vice President Bank of America Learn how Bank of America optimizes and transforms its operational platform to enable strategic utilization of data for a competitive advantage. See how Bank of America’s Chief Data

72

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

Officer Organization is well on its way toward implementation of its Analytical Ecosystem vision. This session will describe the logical architecture and approach that leverages current and planned investments toward the build out of the analytical Ecosystem. With this approach, Bank of America will leverage Teradata’s “Fit for purpose” platform family and high speed data movement capability to enable the separation of mission.

9:30am – 10:30am 1163 AMP Worker Tasks

9:30am – 10:30am Ballroom 23

Carrie Ballinger, Senior Technical Consultant Teradata Corporation Stop by this session and get the most current recommendations on managing AMP Worker Tasks in your platform. You’ll get a close-up picture of what AMP worker tasks are, how they support user work, and what happens when you run out. But we’ll also consider what’s changed in the Teradata 13.0 and 13.10 releases that impacts AMP Worker Tasks. You’ll get some insights into the new increased AMP worker task limits, when they can help you, and when you’re better off sticking with the defaults. We’ll wrap up listing the factors that contribute to AMP worker task exhaustion, and leave you with some tips on managing this important resource. Give us 60 minutes, and we’ll give you the world of AMP Worker Tasks!

SIG

Big Data

Sponsorship

The Edge

Wednesday Sessions

Aprimo

1338 Teradata Database 14 Overview—Part 2

9:30am – 10:30am Ballroom 20 A

Rich Charucki, Engineering Fellow Teradata Corporation Come and hear all about Teradata Database 14! Learn about the exciting Teradata Columnar implementation, the raising of PPIpartition limits, hash join improvements, statistics enhancements, query redrive capability, write from fallback fault isolation, brand new datatypes, new calendars for Structured Query Language (SQL) expansion, new industry compatible functions, temperature based compression, partial online reconfiguration, and row-level security. Teradata Database 14 represents the next major step in the evolution of data warehousing excellence.

1362 Aprimo Utilization to Mitigate Risk

9:30am – 10:30am Room 29 C, D

Kathy Greene, Assistant Vice President Citizens Financial Group Financial institutions must comply with numerous and various banking laws and regulations. A large institution may create and process thousands of documents each year. Come see how Citizens Financial Group utilizes the Aprimo Marketing Resource Management tool to track the required legal and regulatory compliance for audits, processes, review and approvals of documents. Aprimo is used to prepare for audits by both internal and external resources, providing clear concise documentation that demonstrates well-executed predefined processes which minimizes our exposure to risk. Areas we focus on to enhance our efficiencies and minimize risk include: Critical Process Management, Vendor Management, review and approval of documents for compliance.

1453 Transforming the Traditional Approaches to Client Client at RBC

9:30am – 10:30am Room 20 B, C

Robert Keast, Head, Marketing Channels and Transformation RBC As clients place new and more complex demands on the companies they do business with, these companies strive to ensure that how they interact with their clients continually evolves to be effective and relevant. It is becoming increasingly apparent that an organization which leverages its resources—people, processes, and information—will be a competitive differentiator in the marketplace. Marketing Transformation within RBC is responsible for testing new approaches to interacting with clients and enabling channels in order to have an integrated approach to reach more clients to deliver best-in-class advice, sell more product, and gain client insights to drive immediate and future value. This discussion will provide an overview of the key drivers behind Marketing Transformation, our approach to change, and some key lessons we have learned through this ongoing journey.

1549 Now You See It, Now You Can’t—How to Use Encryption in Teradata Systems 9:30am – 10:30am Room 28 E

Jim Browning, Enterprise Architect Teradata Corporation Many industry regulations, standards, and policies mandate the use of strong encryption to meet various security requirements. Fortunately, encryption is widely supported within Teradata www.teradata-partners.com

73

WedneSdAY edUcAtIonAl SeSSIonS systems to secure access to systems and to protect sensitive information during transmission when stored in the database and when archived to tape. This session identifies key issues and considerations for the use of strong encryption technology, describes how to enable and use the various encryption features provided with the Teradata Database and platforms, and offers some important best practices learned from customer experiences to ensure the effective operation of systems where encryption is deployed.

1559 Nike’s Data Warehouse Gets Fit! 9:30am – 10:30am Room 25

James Lee, Expert Architect Nike, Inc In order to get the Teradata platform up and running quickly, Nike adopted a forklift approach in provisioning data from its Enterprise Resource Planning (ERP) system. As use of the data warehouse increased, Nike started to experience growing pains related to a complex relational model which left much of the data transformation to the consumers of the data. To address this, Nike launched the “Base Consumption Layer” project. Come hear how Nike is applying best practices and leveraging Teradata features after the fact in order to: • Increase report development speed and decrease time to market • Increase data reuse and data quality • Enable self-service report development • Increase report performance

74

continued...

1589 Driving Business Value from HSBC’s Information Strategy

1609 The New Integrated Aprimo Marketing Suite

9:30am – 10:30am Ballroom 20 D

9:30am – 10:30am Room 26

Sharon Allsop Kenney, Senior Manager, Business Intelligence Competency Centre HSBC

Gonzalo Hidalgo, Vice President Business Applications Research and Development Aprimo

HSBC believes that Business Intelligence (BI) and a deep understanding of data can drive spectacular results. Two years ago, HSBC UK migrated to Teradata and removed the technical barriers to driving business value from their Enterprise Data Warehouse (EDW). However, the cultural and process challenges remained. The mission of HSBC’s Business Intelligence Competency Centre (BICC) is to address these challenges, acting as the catalyst to enable the creation of business value.

The Teradata acquisition of market leader, Aprimo, excited the marketplace, which saw the tremendous potential of a broad product line with tightly integrated, best-in-class capabilities across the Integrated Marketing Management spectrum. Immediately upon finalization of the merger, Teradata and Aprimo engineers went to work to integrate Teradata Relationship Manager into the Aprimo Marketing Suite. In this session, Gonzalo Hidalgo, vice president of development for Aprimo, will describe the status and roadmap for integration across Aprimo’s new, merged product line in the areas of Multichannel Campaign Management (MCM), Marketing Performance Management (MPM), Marketing Resource Management (MRM), and EMail, with a commitment to continued innovation in the areas of social media and Marketing Performance Management.

The BICC has been successful working with existing users of the data warehouse to drive millions of dollars of benefit, for example through the BI optimization program. This session will provide details of how the BICC’s approach to internal stakeholder management and external partners such as Teradata and SAS, made these business benefits possible. Buoyed by this success, the BICC is looking beyond its existing user base to bring new business functions to the EDW, helping to shape requirements and a data strategy based on delivering business value.

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

1633 Self Service “Distributed Marketing”

9:30am – 10:30am Room 29 A, B

Lisa Loftis, Senior Consultant Baseline Consulting Panelists: DeAnna Blair, Marketing Project Leader Hallmark Mary Smith, Consumer Insights & Analytics Manager Ace Hardware Today’s consumer is increasingly demanding, and marketing budgets aren’t getting any bigger. Smart businesses recognize the need to be relevant to their target market, but exploding technology and consumer expectations are making that task even more complex. An emerging reaction to this conundrum is self-service marketing, where local branches, agencies, stores, or even vendors can participate in your marketing process by infusing local market knowledge and external product expertise into more effective promotions and offers. This panel will provide an overview of this new marketing technique and the results that have been attained by early adopters like Ace Hardware, Lloyds Bank, and Hallmark.

SIG

Big Data

Sponsorship

The Edge

Wednesday Sessions

Aprimo

1714 Fireside Chat with Teradata and Aprimo Executives: Here’s the Plan

9:30am – 10:30am Exhibit Hall F

Lisa Arthur, Chief Marketing Officer Aprimo Panelists: Mike Koehler, President and CEO Teradata Corporation Bill Godfrey, President Aprimo Darryl McDonald, Executive Vice President Applications, Business Development & CMO Teradata Corporation Another acquisition announcement? Yawn. But not Teradata’s January acquisition of Aprimo, a global leader in cloud-based integrated marketing software, a growing, $5 billion sector and a critical focus for businesses, representing one of the most strategic and largest areas of investment for most corporations. Extra! Extra! Hear all about it! It’s big data news, straight from Teradata Chief Executive Officer Mike Koehler, Teradata Executive Vice President and Chief Marketing Officer Darryl McDonald and Aprimo President Bill Godfrey. Aprimo Chief Marketing Officer Lisa Arthur will moderate the discussion. Learn what’s in it for you—about the company vision, updated go-to-market strategy, and how you can innovate your marketing.

1808 SIG: Data Architecture

9:30am – 10:30am Room 22

Tom Russell, Vice President Architecture and Modeling Solutions Teradata Corporation This data architecture SIG is intended to enable attendees to learn from one another regarding experiences with the various deployment data architectures, developmental paths for architecture layers, issues concerning various forms of data modeling, data mapping, physical database design, data integration issues, and other related topics. It also provides the opportunity to understand what Teradata is doing in the data architecture space.

1823 The Role of the Data Warehouse in an Information Management Platform 9:30am – 10:30am Room 28 A, B, & C

Mark Beyer, Research Vice President Gartner, Inc. The traditional concept of the data warehouse as a centralized repository is expanding to become a major player within a broader information management platform. This visionary presentation presents the new data warehouse role of the future—to serve as an information mediation and delivery platform addressing “big data,” “content,” “rich media,” and other information asset types. The rich combination of repository, analytics processing, and solid metadata practices place data warehousing practices and data integration at the center of the coming “data economy.

www.teradata-partners.com

75

WedneSdAY edUcAtIonAl SeSSIonS 1959 Teradata Temporal—Implementation Best Practices 9:30am – 10:30am Room 24

continued...

required partnerships between both IT and the business in order to ensure data quality and adoption. This presentation will delve into each aspect of this implementation and leave the audience with invaluable tips on how to transform their business with Teradata.

1450 Cardinal Health’s Innovative Use of Data Lab and Agile Data Development 11:00am – Noon Room 25

11:00am – Noon Igor Machin, Senior Product Manager Teradata Corporation The Teradata Temporal feature, available with Teradata 13.10, allows the customer to capture, track, and analyze the full history of evolving business data rather than just the most current updates. This lecture will accumulate lessons learned related to implementing temporal databases in the field. The main topics will include temporal data loading, data modelling, partitioning and change management; temporal semantic layer creation and maintenance; querying temporal data; security implications and others.

2160 The Road to a Successful Single Source of Truth 9:30am – 10:30am Room 30 A, B

Hina Patel, Senior Manager, Finance Transformation Office Cisco Systems This presentation will delve into both the positives and negatives the Teradata team faced in implementing the first single source of truth (SSOT) at Cisco Systems. At Cisco, the move to Teradata was essential in the future success of the company, giving it high priority and importance as a project. It gave Cisco the speed and agility to meet our growth targets as well as the needs of multiple business models and a growing global organization. The road to the development and adoption of Teradata as an SSOT required the effective leadership of several Cisco project managers. They served as the catalyst to the project, bringing together teams from across the company to successfully implement Teradata at Cisco. It

76

1332 Getting the Most Out of Workload Management on the Appliance 11:00am – Noon Ballroom 20 B, C

Greg Hamilton, PS Senior Consultant Teradata Corporation Co-presenter: Srini Gorrella, Senior Consultant Teradata Corporation Sometimes simpler is better. The Data Warehouse Appliance, designed for maximum query throughput, offers a simple and easy-to-use approach to workload management. This presentation summarizes experiences and lessons learned implementing workload management on 2xxx series platforms from Teradata’s Professional Services Performance and Workload Management Center of Expertise. During this session, we’ll walk attendees through the workload management capabilities of the appliance, the methodology and analysis we use to make best use of the available options, and post-implementation monitoring recommendations. Real-life examples will be provided. Learn how to make the most of workload management on your appliance.

2011 Teradata PARTNERS User Group Conference & Expo

Renee DePalo, Manager, Information Management & Reporting Cardinal Health, Inc. Your process to source your data into the warehouse fosters complete, integrated, rigorous design to ensure success and stability. You have sophisticated business intelligence and advanced analytics tools. But it’s not enough—your business users want the data faster to keep up with the speed of their business. And they will circumvent IT to get the value they require, leading to database sprawl, information inconsistency, and an unsatisfied business community. Learn how Cardinal Health changed its data development process by putting the business first—shortening the initial data delivery process from months to days—affording their business partners the opportunity to evaluate, analyze, and act on the data much sooner. Cardinal Health will share how governance practices drive this flexible approach, tying back to the full data integration practice. The results are a more agile, flexible, and optimized use of information resources and a greater partnership between IT and Business.

Mini Session

Technical

Business

Guru

Super

1474 Meet the Team: Teradata IDE and SQL Assistant JE

SIG

Big Data

Sponsorship

The Edge

1509 Deep Analytics with Big Data: New Requirements for New Practices

11:00am – Noon Room 23

11:00am – Noon Room 26

Mike Coutts, Chief Technology Officer Teradata Corporation

Philip Russom, Research Director TDWI

Panelists, Charles Eutsler, Software Engineer Teradata Corporation

According to a recent TDWI survey, 38% of organizations surveyed are practicing advanced analytics today, whereas 85% say they’ll be practicing it within three years. This means that many organizations are embracing advanced analytics for the first time, and are confused about how to go about it. Even if users have related experience in data warehousing, reporting, and online analytic processing (OLAP), they need to adjust existing skills and develop new ones prior to implementing advanced or “deep” forms of analytics (like data mining, statistical approaches, in-database analytics, complex SQL, MapReduce, natural language processing, and so on). Plus, there are tough architectural questions to answer, such as: Do you manage analytic data within a data warehouse, mart, sandbox, or independent analytic database? And today’s analytic datasets involve “Big Data” (many terabytes), which makes scalability and performance challenging.

Francine Grimmer, Software Engineer Teradata Corporation Gary Seller, Software Engineer Teradata Corporation Darrick Sogabe, Product Manager Teradata Corporation Teradata provides you with a range of free tools to help you develop database applications and work with them at the Structured Query Language (SQL), Embedded, and Enterprise Application level. This includes the Teradata Plug-in for Eclipse, SQL Assistant JE, and other Administration and Analysis tools. So, whether you use these tools every day or are completely new to them, we invite you to come meet the developers and find out what they have cooking. During this panel discussion we will introduce the latest capabilities of these tools and take a look at what’s coming next. We will also open up the conversation to you, our customers, so we can hear from you what we are missing.

Wednesday Sessions

Aprimo

1514 Supporting Multiple Languages with Oracle Business Intelligence Enterprise Edition (OBIEE) and Teradata Using Unicode

11:00am – Noon Room 22

Brandy Tunnell, Pre Sales Consultant Teradata Corporation Co-Presenter: Tak Takahashi, Globalization Engineering Manager Teradata Corporation A case study was conducted with OBIEE to determine if data could be displayed in the end user’s native language using Teradata. For this case study, translation user defined functions and code pages were tested to pass UNICODE formatted data from Teradata to OBIEE. This presentation will cover the techniques used, process, results, and useful tips and/or challenges we found along for each approach.

1661 Enterprise Information Models as Key Drivers for Pervasive and On-demand Business Intelligence 11:00am – Noon Room 28 A, B, & C

Ehtisham Rao, Director Business Intelligence and Billing Mobilink What if you had to effectively communicate with a subscriber base of more than 30 million in a highly price-sensitive and multi-cultural market? How would you sustain the pressure of being the number one communication service provider with more than 30% market share in a 100 million subscriber market while competing with five major telco groups of the world for over a decade?

www.teradata-partners.com

77

WedneSdAY edUcAtIonAl SeSSIonS

continued...

This presentation is about a journey of one organization from complete dependency on reporting from a data warehouse to becoming self-sufficient in use of information. We will take you through phases of design and deployment of the information models and the essential ingredients for success of the models, and discuss how it helped Mobilink in maintaining the number one position in the Pakistan telecom market.

1839 Conquer Complexity: Implementing a Corporate Data Warehouse User Group

1679 Morgan Stanley and Smith Barney—A Data Warehouse Integration Story

Blair Hanna, Manager eCommerce Marketing Norfolk Southern Corporation

11:00am – Noon Room 30 A, B

Samit Korgaonkar, Executive Director Morgan Stanley Morgan Stanley and Smith Barney formed a joint venture (Morgan Stanley Advisors) to merge their wealth management businesses and become the number one provider of retail brokerage and wealth management services. Upon completion of the venture, the resulting firm has over 18,000 brokers. To support the joint venture, the Morgan Stanley Wealth Management Data Warehouse played a key integration role. The Teradata system provided management with critical metrics in order to manage both businesses during the integration. The Teradata system also provided insight into post integration vision for the next generation data warehouse.

11:00am – Noon Room 29 C, D

Co-Presenter: Matthew Bailey, Manager Marketing Systems Norfolk Southern Corporation Are you interested in starting a Teradata user group forum at your company? For the past four years, Norfolk Southern Corporation has successfully implemented and maintained a corporate data warehouse user group forum. This session will review Norfolk Southern’s Teradata user group from inception through execution. Topics covered will include the design and formation of a data warehouse user group, business reasons to create a user group, and how Norfolk Southern set up and structured their own Teradata user group forum. From there, the discussion will move past the foundation of the user group and into the added value provided back to the company, as well as user group fundamentals to longterm success.

Participants will hear about the approach, techniques and architecture used which will be valuable for anyone who is (or will be) part of a joint venture or merger across any industry.

78

2011 Teradata PARTNERS User Group Conference & Expo

1843 What’s New in Teradata Active System Management?

11:00am – Noon Ballroom 20 A

Doug Brown, Software Architect Teradata Corporation Co-Presenter: Gary Ryback, Product Manager Teradata Corporation Teradata Active System Management continues to evolve to increasingly higher levels of automation and usability. Come hear what new Teradata Active System Mangement offerings are available in Teradata 13.x, get a peek at what’s coming in Teradata 14, plus how you can best leverage these new features.

1845 Implementing a Data Mining Solution with SAS and Teradata 11:00am – Noon Room 28 E

Angela Watson, Vice President, Customer Relationship Management and Analytic Marketing Overstock.com This session will discuss the challenges that were overcome and the benefits that were achieved by implementing SAS Analytics with Teradata at Overstock.com. Follow the steps from ”Decision to Implement” to ”Production Analytics.” Experience business transformation, from initial model development and knowledge transfer to business process change, that resulted in significant performance and productivity improvements.

Mini Session

Technical

Business

Guru

Super

1868 Where is Waldo: Leveraging MapReduce for Location Analytics on nCluster

11:00am – Noon Room 20 D

Amiya Mansingh, Chief Executive Officer Cobi Systems LLC Enterprises and government agencies can become overwhelmed with information. The value of all that data lies in the insights it can reveal. Adding geospatial data to the analytics provide an added dimension to decision making. To get the maximum value, you need an analytic platform that lets you analyze terabytes of information rapidly for immediate actionable insights. Innovative product and service offerings can be created by levering GIS data along with the traditional data sets. Cobi Systems has developed a set of location-based analytics leveraging Aster Data’s massively parallel database that allow users to compute complex GIS calculations.

1895 Data Singularity and Extreme Analytics at eBay 11:00am – Noon Exhibit Hall F

Oliver Ratzesberger, Senior Director, Analytic Platforms eBay, Inc. Inspired by Ray Kurzweil’s book, “The Singularity It Is Near,” eBay’s goal was to redefine our capabilities around big data and extreme analytics. Building a data management infrastructure to support the processing of multi-petabytes of data in a cloud environment, running hundreds of virtual data marts, and supporting thousands of users and millions of daily requests was the challenge and our ultimate goal.

SIG

Big Data

Sponsorship

The Edge

Wednesday Sessions

Aprimo

1955 Leveraging Aprimo Marketing Studio to “Think Nationally, Act Locally”

11:00am – Noon Room 29 A, B

Gregg Dertinger, Director, Acquisition and Retention Marketing United Healthcare United Healthcare is an operating division of UnitedHealth Group, the largest single health carrier in the United States. Our family of companies delivers innovative products and services to approximately 70 million Americans. In late 2009, the entire organization was given the directive by company leadership to “think nationally and act locally.” In 2010, UHC began to build a strategy that would allow the company to deliver locally relevant and relatable messaging to business prospects in 110+ unique markets as part of their national direct marketing efforts. In addition, UHC began a second initiative to improve the quality of its data to increase the probability of reaching prospects at their peak buying interest. Learn how UHC leveraged segmentation functionality from Aprimo Marketing Studio to significantly increase response rates and generate almost double the amount of new leads.

1986 Introducing Fact-Based Decision Making to Physical Database Design 11:00am – Noon Room 24

Michele Pugliese, Teradata Database Team Manager Travelers Insurance This presentation discusses when to include physical design in the development lifecycle. The goal is to optimize resources and eliminate rework with a performing design upon implementation. This process change helps to improve project speed to market

while keeping performance in mind. This has provided an added benefit of hardware cost avoidance through a more thoughtful use of system capacity. The presentation also focuses on using a fact-based decision making approach to determine the best database physical designs. A fact-based approach utilizes prototypes and analysis of CPU and IO metrics to determine designs that best perform while weighing any tradeoffs. We are able to use this approach to create a cost benefit analysis for future design improvements.

Mini Sessions 12:15pm – 1:00pm 1459 Metrics and Visualization for Teradata Service Levels 12:15pm – 1:00pm Room 26

Nachum Shacham, Distinguished Researcher eBay, Inc Teradata provides an effective tool (Teradata Active System Management) for provisioning distinct service levels to multiple classes of users and batch jobs through concurrency limits and CPU rationing. The resulting service levels are primary factors affecting user satisfaction and system usability. This talk will present new metrics and visualization methods that quantify service levels for individual queries, groups of queries (workload), and across multiple workloads and systems. Time expansion will be introduced as a robust measure of latency, and statistical graphs will be used to compare service level distributions of multiple groups of jobs. We will also present results of measurements conducted on eBay’s multiple Teradata systems, which show the impact of query characteristics and workload affiliation on its service levels. The use of these methods in detecting service and performance issues will also be discussed.

www.teradata-partners.com

79

WedneSdAY edUcAtIonAl SeSSIonS 1461 Preparing for the Future by Replaying the Past: The DBQL Query Replay Tool

continued...

1719 Cost-Based Optimization: Best Execution Plan for Complex Queries

1933 Meeting of the Models—Building Blocks for Integrated Solutions

12:15pm – 1:00pm Ballroom 20 B, C

12:15pm – 1:00pm Room 25

12:15pm – 1:00pm Room 24

Aaron Klang, Regional Technical Specialist Teradata Corporation

Bhashyam Ramesh, Engineering Fellow Teradata Corporation

Ojustwin Naik, Director Product Management Teradata Corporation

Co-Presenters: Steve Hager, Data Warehouse DBA Wal-Mart

Co-Presenter: Stephen Brobst, Chief Technology Officer Teradata Corporation

Co-Presenter: Sachin Grover, Senior Product Manager Teradata Corporation

Brent Hubin, CSR Teradata Corporation

Optimizer choices in determining the execution plan for complex queries is a dominant factor in the performance delivery for a data warehouse environment. This workshop de-mystifies the inner workings of cost-based optimization for complex query workloads. We will discuss the differences between rule-based and costbased optimization with a focus on how a cost-based optimization enumerates and selects among possible execution plans for a complex query. The influences of parallelism and hardware configuration on plan selection will be discussed along with the importance of data demographics. Advanced statistics collection is discussed as the foundational input for decision-making within the cost-based optimizer. Performance characteristics and optimizer selection among different join and indexing opportunities will also be discussed with examples. The inner workings of the query re-write engine will be described along with the performance implications of various re-write strategies.

Don Tonner, Senior Product Manager Teradata Corporation

Syed Qadri, Data Warehouse DBA Wal-Mart Testing applications is a challenge in a mixed workload environment. Enter the Database Query Log (DBQL) Query Replay tool with the ability to duplicate the workload of one system on another system by utilizing DBQL data. Customers with key workloads, like a business intelligence or decision support system, need to maintain the same performance across databases and Teradata Tools and Utilities (TTU) versions to provide users with a consistent experience. Having a repeatable and measurable benchmark test that is based on production queries proactively helps discover user impacting issues. Developers work on test systems that are under utilized compared to production systems. This can lead to unrealistic query response times as times are low when compared to a production system. The DBQL Query Replay tool can replay a production workload on the idle test system to simulate the production environment and set more accurate Service Level Agreements. Creating a test system that represents peak usage of a production system drives application optimization.

80

2011 Teradata PARTNERS User Group Conference & Expo

A successful integrated data warehouse solution should have a focused, business intelligence friendly access layer built upon a comprehensive core data layer to support all forms of analysis. Both these layers require different modeling competencies (dimensional and normalized), and developing these stacked data layers can be time consuming. The resulting time crunch can lead to rushed decisions that limit analysis or prevent reuse. Teradata solution integrated modeling portfolios can be used to reduce the time needed to design these data layers for a specific solution. The concept is that each portfolio includes a solution focused inventory of pre-mapped dimensional and normalized building blocks across both the data access and core layers. The portfolio would also include business requirements, measures, alternate design patterns, and templates for commonly used building blocks. Since the portfolio is synchronized with the Teradata Unified LDM framework, the integrated data warehouse can be incrementally expanded.”

Mini Session

Technical

Business

Guru

Super

1:30pm – 2:30pm 1282 The Information Paradox—Why Does Simplicity Cause So Much Complexity?

SIG

Big Data

Sponsorship

The Edge

1339 Breaking through the Partition Barrier 1:30pm – 2:30pm Ballroom 20 B, C

1:30pm – 2:30pm Room 24

Paul Sinclair, Software Engineer Teradata Corporation Rob Armstrong, Director Teradata Corporation With the theme of “Conquering Complexity,” the question must be asked as to what is creating all this complexity that we are trying to conquer, and is this really anything new in the area of business intelligence and data management? Unfortunately, the major cause of complexity is self imposed through politics and not having a defined set of business objectives. Fortunately, this means that much of the complexity is not caused by technology or areas of which we have little to no control over resolving. There are many such seemingly contradictory causes to this problem. One example is that decentralizing data will cause the centralization and bottlenecking of process. In contrast, centralizing data actually enables and increases distributed processing. The presenter will challenge your thinking while he explores the major paradoxes with data warehousing in his entertaining and informative manner. He will also give examples and next steps to get you moving in the right direction.

Wednesday Sessions

Aprimo

The new partition limit of Teradata Database 14, 9,223,372,036,854,775,807 (over 9 quintillion), is coming. Learn the basics of defining 8-byte partitioned tables and join indexes. Delve into direct partitioning on TIMESTAMP and BIGINT in order to take advantage of this new limit. And come away with some insider perspectives. If 65,535 partitions isn’t enough for you, you won’t want to miss this.

1401 Patterns, Trends and Anomalies—Identifying, Mitigating, and Preventing Fraud

1:30pm – 2:30pm Ballroom 20 A

Becky Briggs, Director, Office of Strategic Management ARC Many companies deal with identification, prevention, reduction, and mitigation of fraudulent activities that impact the bottom line. As one of the proxies for risk and fraud management in the travel industry, ARC will share how to stay agile and nimble, and how we try to keep ahead of the fraudsters. Using Teradata, SAS, and SQL, combined with data mining, statistical analysis, data trending, behavioral analysis, and embedded fraud risk management models in our daily data processes, ARC has shown success in reducing the impact of fraud in the US travel industry.

1475 Right Time Business Intelligence (BI) at Travelers’ Select 1:30pm – 2:30pm Room 30 A, B

Amir Farid, Vice President, Business Intelligence Travelers Insurance Since 2006, Travelers’ Select has made significant investments to drive top line growth and maintain industry leadership. These investments include sophisticated products, robust platforms, and a world class BI strategy. Business Intelligence is a key competitive differentiator for Travelers, and BI solutions like Account Executive/Sales Executive (AE SE) Dashboard are changing the face of the business execution model. In this ever changing economy, simplified access to actionable information is critical for profitable growth, which led senior executives to sponsor a dashboard program to improve strategic execution. The system was piloted to select regions in January 2011 and, due to its overwhelming success, it was deployed countrywide by the end of February 2011. Timely, accurate, and actionable information, and scalable and extensible solution architecture are hallmarks of this solution. Select’s dashboard program continues to drive value resulting in top line growth.

1659 An Analytic CRM Journey in Maybank

1:30pm – 2:30pm Room 29 A, B

Ahmad Hishamuddin Mohammed Salleh, Head Analytics, Customer Relationship Management Malayan Banking Berhad This presentation is about a business analytical journey that Maybank has embarked on since 2007. It describes how Maybank www.teradata-partners.com

81

WedneSdAY edUcAtIonAl SeSSIonS improved customer loyalty, retention, and profitability with the launch of the Analytical Customer Relationship Management (aCRM) project by deploying Teradata system and Teradata Relationship Management software. Maybank increased marketing campaign success rates tenfold. Lead generation times were slashed from weeks to hours, new campaign time to market was cut from weeks to days, and the average conversion rate jumped from a low of 0.3% to an average of 8% and a high of 30%. From August 2007 until late 2009, Maybank gained US $961 million in new sales.

1692 Always On, Always Available, Always Right! The Commander and Staff Need 24x7x365 Data Availability as Their Stuff Moves Globally to Support the Troops 1:30pm – 2:30pm Room 23

John Rusnak, USTRANCOM J6 Technical Director The MITRE Corporation Co-Presenter: LTC Rodrigue Aleandre, IGC Program Manager Defense Logistics Agency Senior Department of Defense (DoD) leaders want their data management system “always on, always available, and always right!” Integrating two high visibility programs that manage and track all defense commodities between the factory and foxhole, and move all DoD warfighters and their weapon systems anywhere on the globe, is a daunting task. USTRANSCOM and DLA rely on a strong management/integration team, and Teradata’s inherent high availability, to address continuity of operations and disaster recovery. The drive toward a dual-active architecture leverages Teradata’s data management tools and managed servers to ensure multi-classification and multi-system considerations are load balanced and highly available. Added challenges include growing two primary and two alternate site systems to meet user needs and still be cost-effective, technically sound, and realistic! In this session, you’ll learn that building a highly available, load balanced

82

continued...

infrastructure requires clear vision and appropriate capacity planning.

1736 Innovative Usage of SAP BI on Teradata 1:30pm – 2:30pm Room 28 E

Mark Marty, Senior Manager Business Intelligence Architecture Levi Strauss & Co This session will focus on how Levi Strauss & Co. laid the architectural foundation for the complete business intelligence (BI) suite of toolsets and techniques centered on the full suite of SAP Information Management tools. Discover how the initial project “go live” started the integrated usage of multiple data sources. Levi will share the results of their ramp-up project and will focus on the technical wrinkles such as, patches, procedures, techniques, and lessons learned. Discover how Levi ensured a single version of truth, including master data, while still expanding the scope of data beyond the core business warehouse (BW) instance. Find out how: • Data harmonization was made easier to combine BW data and traditional Enterprise Data Warehouse (EDW) normalized model structures. • Learn the next steps in Levi’s architectural direction, tighter integration of data services, and fully leveraging mobility across the platform.

2011 Teradata PARTNERS User Group Conference & Expo

1770 Combining ETL and ELT for Active Data Warehousing 1:30pm – 2:30pm Room 25

Gerry Lager, Database Engineer Lockheed Martin Co-Presenter Greg Wade, Chief Architect Lockheed Martin This presentation will focus on the design for populating a multitiered data warehouse using a combination of Extract Transform and Load (ETL) and Extract Load and Transform (ELT) to meet extreme performance and scalability requirements in a hostile data environment where complex business logic must be applied to achieve end-to-end enterprise integration. Topics covered will include the tradeoffs between ETL and ELT, the advantages to combining ETL and ELT, and data modeling considerations for extreme performance and scalability.

1827 Mining Hidden Treasures in the Volvo Cars Information Landscape 1:30pm – 2:30pm Room 29 C, D

Henrik Högberg, Enterprise Architect Volvo Car Corporation Co-Presenter: Bertil Angtorp, Senior Business Analyst Volvo Car Corporation Volvo Corporation has realized over the last four years that valuable nuggets of information gold are buried in 40 years of building

Mini Session

Technical

Business

Guru

Super

information systems, and are using the Volvo Cars Data Warehouse to mine for the hidden treasures. The data warehouse plays a key role in the defined Volvo Cars Information Delivery Architecture strategy and enables business analytics to deliver significant return on investment. The managed information architecture approach turns the IT landscape from a lawless prospector outpost to a wellstructured, modern, and vibrant city to better support future business needs. The architecture also dismantles the current complexity of point-to-point integrations to remove a large hidden IT cost.

1874 Introducing the Analytic Platform: NextGeneration Big Data Analytics

1:30pm – 2:30pm Room 26

Stephanie McReynolds, Director of Product Marketing Aster Data The Analytic Platform has emerged as a critical component of a comprehensive approach to big data analytics. In this session we’ll discuss the drivers that are leading organizations to implement analytic platforms as well as explore the differences between analytic platforms and other systems including data warehouses, packaged analytic applications, and other data processing platforms like Hadoop. We’ll discuss how analytic platforms enable investigative analytics, interactive querying, and rapid results on new and emerging data types and sources. Attendees will gain valuable insight into where and how an analytic platform can complement and increase the value of their data and current investments in managing that data.

1882 Making Enterprise Data Warehouse Data Easy for Business People to Access and Use 1:30pm – 2:30pm Room 28 A, B, & C

Blake Johnson, Consulting Professor Stanford University

SIG

Big Data

Sponsorship

The Edge

Wednesday Sessions

Aprimo

To realize the full value of the data in a company’s EDW, the data must be easy for business people to access and use. This often isn’t the case today. Many business users lack awareness of EDW capabilities, and continue to request static reports or periodic extracts to redundant datamarts. Many IT organizations limit access to all but a small group of IT specialists. The reality, and opportunity, is that current technologies allow large numbers of users to scalably and reliably access EDW data directly. These technologies place the full breadth of EDW data at the fingertips of business users, enabling huge business value to be created. By eliminating the need for IT staff to intermediate the use of EDW data, the technologies also provide unprecedented scalability and enable large reductions in IT cost and lead time. In this session, leaders in enabling business access to EDW data will share both the technologies and the business-IT collaboration processes behind their success.

1962 Business Intelligence (BI) Delivery Framework 2020 1:30pm – 2:30pm Ballroom 20 D

Wayne Eckerson, Founder BI Leadership Forum For too long, BI professionals have tried to shoehorn casual and power users into the same BI architecture with disastrous results. Given advances in analytic technology, it’s now possible for BI teams to create distinct BI architectures optimized for different classes of users and types of data and workloads. This presentation will introduce the BI Delivery Framework, a new reference architecture that maps classes of users to tools, architectures, and governance structures.

3560 SIG: ‘Big Data & Analytics’ What Is It? What Challenges Does It Create for You? How are SAS and Teradata Responding?

1:30pm – 2:30pm Room 22

Murray Maloney, Director Teradata Labs According to Wikipedia, “big data” is a phrase applied to data sets whose size is beyond the ability of commonly used software tools to capture, manage, and process the data within a tolerable elapsed time. Big data sizes are a constantly moving target currently ranging from a few dozen terabytes to many petabytes of data in a single data set. Gartner defines data growth challenges (and opportunities) as being three-dimensional, i.e., increasing volume (amount of data), velocity (speed of data in/out), and variety (range of data types, sources). What is the impact of big data on IT processes, and what does big data mean for the future of analytics? What new business questions might you be able to address if you had the right technology? These are just some of the questions we plan to discuss during this interactive session. Be prepared to share what big data means to you and to describe the associated hurdles that are facing you and your team. Customers as well as SAS and Teradata experts will be on hand to share their views on the topic and to outline strategies for tackling the evolving big data challenges.

The Framework posits that there is not just one type of ”intelligence” but four that BI managers will need to oversee, or at least interoperate within the coming years. The presentation will take a close look at the dynamics between two of these intelligences: top-down reporting and bottom-up analytics, and offer advice for keeping these polar opposites in balance. It will also examine the emerging BI disciplines of continuous and content intelligence.

www.teradata-partners.com

83

noteS

84

2011 Teradata PARTNERS User Group Conference & Expo

THURSDAY

THU

THURSDAY

Scheduled Events Time

Event

Location

7:00am – 8:30am

Breakfast

Convention Center Exhibit Hall F

8:30am – 12:30pm

Poster Sessions

Poster Session Hallway

8:30am – 12:30pm

Conference Educational Sessions

Convention Center

Educational Sessions

8:30am – 9:30am Session #

86

Session Title

1311

Vendor to Partner, Improving ROI on Your Teradata Partnership

1410

SIG: Case Study: Improving Performance with OBIEE on Teradata

1456

Teradata Unity: An Introduction and Technical Overview

1497

Teradata and Hadoop Integration

1520

An Efficient Row Level Security Implementation

1570

Integrated Marketing Management

1574

The DIY DBA, Just Set It and Forget It

1636

Applying EDW Lessons Learned During a Bank’s Merge Process

1644

Self-service Business Intelligence: The Hows and Whys

1686

Linking Analytic Capability to Corporate Strategy Execution

1730

The (R)evolution from Business Intelligence to Consumer Intelligence

1873

The SAS Embedded Process on Teradata

1894

Deploying Advanced Analytics: Managing The Data, Processes, and Environment

2011 Teradata PARTNERS User Group Conference & Expo

Room

Presenter

Session Type

Andrew Coleman, Teradata Corporation

Business

22

Brandy Tunnell, Teradata Corporation

Technical

24

Ariff Kassam, Teradata Corporation

Technical

30 A, B

Ballrm 20 A

Yu Xu, Teradata Corporation

Technical

Milan Marovic, Intel Corporation

Technical

Jenelle Kueter, International Speedway Corporation

Business

Ballrm 20 B, C

Donald Gross, American Eagle Outfitters

Technical

29 C, D

Jorge Garcia Romaris, NovaCaixaGalicia

Business

26

Claudia Imhoff, Intelligent Solutions, Inc.

Business

Ballrm 20 D

Anthony Torusoglu, Cardinal Health, Inc.

Business

28 E

Jeff Bedell, MicroStrategy Incorporated

Business

Robert Ray, SAS Institute

Technical

David Hastings , Teradata Corporation

Business

23 29 A, B

25 28 A, B, C

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

Thursday Sessions

The Edge

Aprimo

Room

Presenter

Session Type

Educational Sessions

10:00am – 11:00am Session #

Session Title

1312

A Proactive Automated Data Quality Methodology

23

Hend Dwiyono, Intel Corporation

Technical

1383

EDW Usage for Marketing in the Casino Industry

30 A, B

Marc Oppenheimer, Station Casinos

Business

1594

Teradata Parallel Transporter: Like Fine Wine, It Gets Better With Age

25

Steven Feinholz, Teradata Corporation

Technical

1597

Backups, Shmackups! What You Really Need to Know About – Restores!

Josh Mereminsky, Teradata Corporation

Technical

Ballrm 20 B, C

1632

Gaining Business Buy-In for the Logical Data Modeling Process

29 C, D

1725

Using Analytics for Excellent Customer Lifecycle Management

28 A, B, C

1739

Integrating Geospatial Information in Enterprise Systems

1747

SIG: Securing Your Teradata Database

1760

Using Social Intelligence to Help Shape Customer Relationships and Drive ROI

1786

Teradata in the Clouds—A hands-on Demonstration

1789

Microsoft Business Intelligence (BI) and Teradata: Don’t Struggle, Snuggle

Ballrm 20 A 22 28 E 24 Ballrm 20 D

1932

The Need for Speed: Keeping Up with EA Customers

29 A, B

1969

eBay’s Self-Service Analytics: Tools to Work Smarter

26

Nancy Couture, OptumInsight / UnitedHealth Group

Business

Andreas West, Celcom Axiata Berhad

Business

David Sonnen, IDC

Business

Alan Greenspan, Teradata Corporation

Technical

Navdeep Alam, Mzinga

Technical

Michael Riordan, Teradata Corporation

Technical

Kensly Alexander, NCR

Business

Jason Chitwood, Electronic Arts, Inc

Business

Peter Bense, eBay

Technical

Educational Sessions

11:30am – 12:30pm Session #

Session Title

1346

New Teradata Data Warehouse Appliance

1452

A Structured Method for Tuning Teradata SQL

1473

Simplifying TPT Scripts with Templates

Room 26

Presenter

Session Type

Ed White, Teradata Corporation

Technical

Arnoldus VanWyk, Teradata Corporation

Technical

24

Nam Tran, Teradata Corporation

Technical

23

Matthew Zenus, Teradata Corporation

Technical

Steve Timmons, WellPoint, Inc.

Technical

Ballrm 20 A

Mark Isbell, Teradata Corporation

Technical

28 E

Alvaro Velasquez, Movistar Chile

Business Business

29 A, B

1523

Putting It on the Map with Teradata Geospatial

1550

ViewPoint At WellPoint

1556

Mixed Storage and TVS: A Customer/User Perspective from Verizon Wireless

1583

Implementing Aprimo Relationship Manager (ARM) in a Quick Win to Integrate Wireline and Mobile Customer Data

1766

CRM Shared Service Center for the BNP Paribas Retail Banking

30 A, B

Xavier Joly, BNP PARIBAS

1775

Supply Chain Traceability

29 C, D

Simon Ellis, IDC Manufacturing Insights

Business

1814

Uncovering New Insights in Your Data Using Graph Analytics

28 A, B, & C

Molly Stamos, Teradata Corporation

Business

1820

Balancing Business and IT interests to Improve Data Governance

Ballrm 20 D

Laerte Piva, Teradata Corporation

Business

Ballrm 20 B, C

1847

SIG: Agile Analytics within the Data Warehouse

22

Arlene Zaima, Teradata Corporation

Technical

1967

Analytics for Big Data Using SAS High Performance Analytics and Teradata

25

Michelle Wilkie, SAS Institute

Technical

www.teradata-partners.com

87

tHURSdAY edUcAtIonAl SeSSIonS 8:30am – 9:30am 1311 Vendor to Partner, Improving ROI (Return on Investment) on Your Teradata Partnership

8:30am – 9:30am Room 30 A, B

Andrew Coleman, Area Director Teradata Corporation Teradata’s most successful clients view the relationship with Teradata as one of a partnership (not a vendor to customer relationship). The goal of this presentation is to provide the audience with specific ways to realize better ROI from the direct support of Teradata. This session will include proven practices (like lunch and learns, onsite team presence, industry award submissions, etc.) so the attendee leaves with actionable ideas.

1410 SIG: Case Study: Improving Performance with OBIEE (Oracle Business Intelligence Enterprise Edition) on Teradata

8:30am – 9:30am Room 22

Brandy Tunnell, Pre Sales Consultant Teradata Corporation Panelists Pam Fisher, Senior Systems Engineer WalMart Stores, Inc. Kaylee Parker, Customer Service Representative Teradata Corporation Carrie Wells, Senior Programmer Analyst WalMart Stores, Inc.

88

continued...

A case study was conducted with OBIEE on Teradata to prove dashboards could be significantly optimized without changing workload management rules or increasing the capacity of the current systems. After analyzing the opportunities, it was decided join indices and query bands be implemented in the OBIEE/Teradata environment. During this Special Interest Group discussion, we can touch on the goals of the case study, details, process, results, advantages/disadvantages, and additional tips that could benefit any business intelligence project on Teradata.

1456 Teradata Unity: An Introduction and Technical Overview 8:30am – 9:30am Room 24

• Automatically resubmits queries that are lost due to a database restart or other failures • Integrates with Teradata Multi-System Manager for efficient monitoring and control

1497 Teradata and Hadoop Integration

8:30am – 9:30am Ballroom 20 A

Yu Xu, Architect Teradata Corporation Co-Presenter: Pekka Kostamaa, Engineering Fellow Teradata Corporation

Ariff Kassam, Product Manager Teradata Corporation Co-Presenter: Jeff Schemanske, Product Manager Teradata Corporation Teradata Unity is the latest addition to Teradata’s family of single and multi-system products. It provides a robust solution for routing sessions or individual reads across multiple systems based on where the data resides, or based on pre-defined routing rules. Teradata Unity also offers DDL (Data Definition Language) and DML (Data Manipulation Language) synchronization across multiple systems through a method known as SQL (Structured Query Language) Multicast. Client DDL and DML SQL updates are applied to all participating systems within the Teradata Analytical Ecosystem. Benefits include: • Transparent routing of user sessions and queries • Routing of queries to where the data exists with no effort or knowledge required by the user • High availability failover and failback of user sessions and queries • Keeping databases in sync across separate systems

2011 Teradata PARTNERS User Group Conference & Expo

Teradata’s parallel DBMS (Database Management System) has been successfully deployed in large data warehouses over the last two decades for large scale business. Recently, the Hadoop SQLMapReduce programming paradigm has gained rapid momentum as another way of performing large scale data analysis. By now most data warehouse researchers and practitioners agree that both parallel DBMS and SQL-MapReduce paradigms have advantages and disadvantages, and thus, both paradigms are going to coexist for a long time. In fact, a large number of Teradata customers have seen increasing needs to perform business intelligence (BI) over both data stored in Hadoop and data in Teradata system. One common thing between Hadoop and Teradata system is that data in both systems are partitioned across multiple nodes for parallel computing, which creates integration optimization opportunities not possible for DBMSs running on a single node. In this talk, we describe our current efforts towards tight and efficient integration of Hadoop and Teradata system.

Mini Session

Technical

Business

Guru

Super

1520 An Efficient Row Level Security Implementation 8:30am – 9:30am Room 23

Milan Marovic, Senior Software Engineer Intel Corporation Co-Presenter: Miroslav Dzakovic, Data Warehouse Architect Intel Corporation

SIG

Big Data

Sponsorship

The Edge

Marketing Management strategy to manage and execute their plan. This meant integrating all of their marketing channels under one system to gain that 360-degree view of their customer that was critical to their future success. Their reason for integrating multiple disparate systems was simple: to drive business results. Learn how ISC has weathered the economic downturn using Aprimo Marketing Studio as a platform to manage workload, engage their customers on a personal-level, and ultimately drive business growth.

1574 The Do-It-Yourself DBA (Database Administration), Just Set It and Forget It

8:30am – 9:30am Ballroom 20 B, C

There are many benefits to having more granular, completely transparent access to the data warehouse that can be achieved by implementing row level security directly in the database. However, row level security (RLS) comes at a cost. This presentation will demonstrate the importance of a comprehensive benchmark as the primary tool to select the least costly implementation and uncover any hidden overhead.

Donald Gross, Senior Data Warehouse Developer American Eagle Outfitters

This presentation discusses an efficient RLS implementation in the Manufacturing Integrated Data Analysis System (MIDAS) at Intel. MIDAS is a centralized data warehouse that stores Work in Process (WIP) and unit level tests and parametric data from all manufacturing sites, enabling full cross-functional traceability and commonality engineering analysis. The efficient RLS implementation is a key enabler for a diversified customer base and allows the inclusion of additional engineering data domains.

In an economically challenging environment, companies are continuously looking for ways to maximize return on investment. We found ourselves in such a situation, looking for ways to extend the useful life of our existing Teradata platform.

1570 Integrated Marketing Management

8:30am – 9:30am Room 29 A, B

Thursday Sessions

Aprimo

Co-Presenter: Carrie Falcone, Lead Data Base Administrator American Eagle Outfitters

We focused on three issues: making the most of our existing space, improving query performance, and handling both of these items without impacting our batch window or requiring a dedicated resource.

Jenelle Kueter, Senior Manager, Consumer Marketing International Speedway Corporation

In this session, we will discuss how we addressed these issues by partitioning tables and placing a greater emphasis on the collection of statistics. Our solution leverages valuable dictionary information from the DBC, uses stored procedures and executes dynamic SQL (Structured Query Language). The model we developed automates repetitive administrative tasks using a flexible framework that can be easily adapted for other uses.

IIn 2007, market forces required ISC to rethink their go-to-market strategy, and it ultimately led them to adopting an Integrated

In this presentation, we plan to discuss our recipe and the lessons learned with respect to managing the challenges outlined above.

1636 Applying Enterprise Data Warehouse (EDW) Lessons Learned During a Bank’s Merge Process

8:30am – 9:30am Room 29 C, D

Jorge Garcia Romaris, Data Warehouse Manager NovaCaixaGalicia NCG is involved in a merger process, and the EDW enables a fully merged information view of the combined entities from day one of the merger—long before physical and technical integration takes place. The EDW delivers a single version of the truth allowing like for like comparisons across customers, products and channels, showing practical and real examples, such as, profitability calculations using the Teradata Value Analyzer (TVA) advanced scenarios capability to get an integrated vision of the merger, in addition to individual calculations and before the OLTP (Online Transaction Processes) Systems are integrated. Finally, NCG applies innovative techniques of using the EDW for the merger process supporting and improving the OLTP systems providing information already analyzed and validated in the EDW environment accelerating the merger process, being more efficient.

www.teradata-partners.com

89

tHURSdAY edUcAtIonAl SeSSIonS 1644 Self-service Business Intelligence (BI): The Hows and Whys 8:30am – 9:30am Room 26

Claudia Imhoff, President Intelligent Solutions, Inc. Co-Presenter: Colin White, Founder BI Research The velocity of business is dramatically increasing; decision-making must keep up with this. Business users cannot wait for the IT department to create custom reports and analytics. In fact, many users now expect to be able to interact with information and create their own views of data to address pressing business issues. At the same time, BI teams would like to offload report and analytics creation duties to users and focus on more value-added activities. Fortunately, there is a new crop of self-service BI tools that promises to empower users while liberating the BI team from ad hoc reporting tasks. But what does this mean to the ultimate BI technology? These tools must be easier to use than previous generations of BI tools while giving the IT department a measure of control and oversight into the users’ creation of reports and dashboards for decision making.

continued...

1686 Linking Analytic Capability to Corporate Strategy Execution

1730 The (R)evolution from Business Intelligence to Consumer Intelligence

Anthony Torusoglu, Director Business Intelligence and Analysis Cardinal Health, Inc.

Jeff Bedell, Chief Technology Officer MicroStrategy Incorporated

Co-Presenter: Frank Bush, Senior Industry Consultant Teradata Corporation

Co-Presenter: Stephen Brobst, Chief Technology Officer Teradata Corporation

Cardinal Health is a healthcare services company. Actually we like to say we’re the business behind healthcare. Nuclear Pharmacy Services (NPS) is a significant and growing division within Cardinal.

The proliferation of mobile devices and a new breed of consumers is driving a revolution in requirements for pervasive access to data warehouses content. Historically, data warehouses have been constructed to provide intelligence to business knowledge workers within large enterprises. A new breed of consumers is emerging with a DIY (Do-It-Yourself) mindset related to technology, and an unprecedented sophistication in using data for personal decisions. This change in consumer behavior is creating demand for consumer intelligence capability in which direct access to data is required for personal decision making. We will discuss the implications for data warehouse deployment in this new world and illustrate leading edge case studies in the delivery of consumer intelligence.

8:30am – 9:30am Ballroom 20 D

To increase responsiveness to the increasingly competitive environment, NPS embarked on an ambitious transformation initiative. A significant aspect of this redesign was to understand how our current analytic capabilities did, or did not, support our strategy execution. The PROJECT evaluated current business strategies and objectives and identified the analytics required to support those strategies; thus ensuring the building of a “best in class” analytics capabilities and facilitating a cultural change. An assessment of NPS’ current analytic capabilities was conducted and a GAP was identified (required future state vs. current state). In addition to understanding gaps in analytic capabilities, over forty analytic opportunities were identified as best in class analytic capabilities.

8:30am – 9:30am Room 28 E

1873 The SAS Embedded Process on Teradata

8:30am – 9:30am Room 25

Robert Ray, Director, Research and Development SAS Institute Co-Presenter: Greg Otto, Software Engineer Teradata Corporation

90

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

SAS In-Database has opened doors for analysts and business users by accelerating performance and productivity, improving data governance, and making effective use of SAS and Teradata investments. The next generation of SAS In-Database processing utilizes the SAS Embedded Process on Teradata. The SAS Embedded Process runs the SAS DS2 language in parallel within a tightly coupled but separate process on all Teradata nodes, activated from Teradata SQL. Embedded DS2 enables rapid and flexible deployment of scoring routines, and provides a platform for scripting a new generation of SAS analytic components to run in Teradata. Topics include the SAS Embedded Process architecture, capabilities of the DS2 language inside the database, usage examples including the simplified SAS Scoring Accelerator, and manageability of the SAS Embedded Process environment including integration with Teradata workload management, SQL security, installation, and support.

SIG

Big Data

Sponsorship

The Edge

In this talk, we’ll discuss how analytics teams can make full use of Teradata as they attempt to scale their efforts. We’ll cover the creation, maintenance and structure of Analytic Datasets, the management of models, how to configure Teradata to optimize performance, and policy & procedure considerations.

1312 A Proactive Automated Data Quality Methodology

10:00am – 11:00am Room 23

Hend Dwiyono, Senior Software Developer Intel Corporation

David Hastings, Director, Advanced Analytics COE Teradata Corporation

Data Quality/Data Integrity (DI) is a critical success indicator for any database, but is often enforced as an afterthought when the database is deployed, and in an ad-hoc manner, as users find problems with the data. DI is at risk when there are no quantifiable DI% metrics in place and no standardized reporting tools to allow for quick troubleshooting.

Co-Presenter: Bill Franks, Chief Analytics Officer, Global SAS Program Teradata Corporation Historically, those who work in the world of advanced analytics and data mining have done their work in a separate environment that they control. This approach made sense in the days before Teradata Enterprise Data Warehouses made most, or all, of the needed data available in a scalable environment. Analysts today are moving more and more to an in-database architecture for as much of their work as possible. While this is a good thing if done correctly, it requires a tighter level of planning and integration to put analytics processes into production on a Teradata system. The benefits of the extra effort far outweigh the costs, however.

1383 EDW (Enterprise Data Warehouse) Usage for Marketing in the Casino Industry

10:00am – 11:00am Room 30 A, B

10:00am – 11:00am

1894 Deploying Advanced Analytics: Managing The Data, Processes, and Environment 8:30am–9:30am Room 28 A, B, & C

Thursday Sessions

Aprimo

The presentation describes CARES (Categorize, Automate, Report, Empower, Speed-up) — a novel systematic methodology developed for Intel MIDAS Data Warehouse. We started with a DI framework, which categorized seven DI types inside a centralized metadata repository in Teradata. Then we devised an automated, meta-data driven method for DI script generation and reporting. DI reports were deployed ”early in development cycle,” empowering developers to resolve DI issues well before the production release. Subscribing to scheduled DI reports in production provides proactive monitoring with quantifiable DI% metrics on daily/ weekly/monthly basis.

Marc Oppenheimer, Corporate Vice President of Relationship Marketing Station Casinos Over the past 30 months, Station Casinos has worked with Teradata to install and operationalize an Enterprise Data Warehouse. This session will provide highlights about how that warehouse has been used to improve the marketing strategy of the company, deepen guest relationships, and drive financial performance. While the strategies will be focused on the casino industry, these strategies are potentially applicable in any CRM (Customer Relationship Management) driven organization.

1594 Teradata Parallel Transporter: Like Fine Wine, It Gets Better with Age

10:00am – 11:00am Room 25

Steven Feinholz, Client Load/Unload Architect Teradata Corporation Teradata Parallel Transporter (TPT) is the premiere client load/ unload tool, providing parallel extraction and loading of critical data. It is a flexible, high-performance data warehouse loading tool specifically optimized for the Teradata Database that enables high speed data extraction and loading under a single framework. TPT employs a single scripting language, utilizing the FastExport, MultiLoad, FastLoad, TPump, and ODBC protocols. We are making great strides in each release to improve its easeof-use and provide features that add value to the customer, their loading environment and their data. This presentation will describe www.teradata-partners.com

91

tHURSdAY edUcAtIonAl SeSSIonS enhancements made to the EasyLoader interface as well as the valuable features in the 13.10 and 14 releases.

1597 Backups, Shmackups! What You Really Need to Know about Restores!

continued...

1632 Gaining Business Buy-In for the Logical Data Modeling Process

10:00am – 11:00am Room 29 C, D

1725 Using Analytics for Excellent Customer Lifecycle Management

10:00am – 11:00am Room 28 A, B, & C

10:00am – 11:00am Ballroom 20 B, C

Josh Mereminsky, Senior Presales Consultant Teradata Corporation There’s no doubt, backups and backup windows are very important. They occur on a regular basis and must be carefully planned for. Often, backup requirements overshadow restore requirements which are far less frequent and at times not well thought out. Is the system restore rate the same as the backup rate? Why would I want to consider disk backup instead of tape backup? Is my optimized backup solution the best for performing restores? In this session, we’ll discuss several different areas to consider when defining your backup solution that takes data restores and system recovery into play. Topics such as restore performance, RTO (recovery time objective), hardware and infrastructure selection and other factors that affect data restore will be covered.

Nancy Couture, Vice President Data Management Solutions OptumInsight / UnitedHealth Group Co-Presenter: Karmon Schmitt, Industry Consultant Teradata Corporation Many organizations struggle with articulating the inherent value of completing a logical data model. Business stakeholders see this effort as further delaying the actual creation of something they can use to address their business challenges. This presentation will show how establishing a logical modeling framework, providing education and effectively engaging business constituents will lead to a successful modeling exercise. This foundation ultimately results in greater success when the project moves to subsequent phases. Understanding business requirements is paramount to project success. A logical data modeling exercise can help guide the discussion; asking questions that help one get to the heart of the business situation and needed requirements. Would a logical data model have improved your overall project experience?

Andreas West, Senior Vice President Customer Management Celcom Axiata Berhad It’s not only since Tom Davenport’s ”Competing on Analytics” book that companies have understood that using analytics can be the key differentiator in today’s highly competitive and saturated markets. The demand by the Generation Millennium customer to use all your data to come up with products and services identifying their needs is what sets companies apart. Customer Lifecycle Management is looking at turning your prospects into customers, developing your customers into ambassadors, stimulating them to use more of your products, and preventing them from cancelling accounts and using your competition. Using analytics is an art in this game!

1739 Integrating Geospatial Information in Enterprise Systems 10:00am – 11:00am Ballroom 20 A

David Sonnen, Global Analyst IDC Implemented correctly, geospatial capabilities can enhance business analytics. Today, Teradata includes comprehensive geospatial elements in its enterprise products. These elements lower the costs and risks of implementing geospatial capabilities significantly. However,

92

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

The Edge

users still need to understand basic geospatial concepts and best practices as they use Teradata’s geospatial elements.

monitoring solutions and how they interoperate with the Teradata Database will be reviewed.

In this session, we provide the basic information users need to take advantage of geospatial analytics. We outline the essential concepts and best practices for selecting, integrating, and analyzing geospatial capabilities into high-performance information systems.

1760 Using Social Intelligence to Help Shape Customer Relationships and Drive ROI

10:00am – 11:00am Room 22

Alan Greenspan, Product Marketing Manager Teradata Corporation Panelists: Jim Browning, Enterprise Architect Teradata Corporation Leslie McMonagle, Managing Partner for Teradata Information Security COE Teradata Corporation Matthew Zenus, Product Manager Teradata Corporation An interactive session with Teradata and partner experts as well as joint customers— targeted to database administrators and security/privacy personnel interested in securing their data warehouse. During this session, Teradata and partner experts will lead an interactive discussion focused on how various technologies, techniques, and policies can be employed with your Teradata Database to ensure you meet your enterprise, regulatory, customer, and statutory requirements. Best practices along with Teradata Database authorization and authentication methods and technologies will be discussed. Also, best-in-class partner technologies such as encryption, tokenization, and activity

1786 Teradata in the Clouds—A hands-on Demonstration

10:00am – 11:00am Room 24

10:00am – 11:00am Room 28 E

We illustrate best practices with case studies in insurance, logistics, and telecommunications.

1747 SIG: Securing Your Teradata Database

Thursday Sessions

Aprimo

Michael Riordan, Product Manager Teradata Corporation Navdeep Alam, Director, Data Architecture Mzinga We’ve all heard about the wisdom of crowds, including employees, partners and customers—but can the crowd really help you find answers to business problems? Can it help you gain greater insight into meeting customer needs, improving loyalty, and sustaining and growing revenue? The answer is yes. With today’s social analytics technologies and techniques enabled by the Aster Data Analytic Platform, you can use data from your audience’s behavior to change your own online interactions and communication strategies. But you need more than just technology—you need an understanding of how collaboration and engagement play into customer behaviors, needs and interests.

Co-Presenter: Steve Mazingo, Product Manager Teradata Corporation At the 2009 PARTNERS Conference, Teradata announced the extension of the Teradata Express program onto the leading cloud platforms: VMware and Amazon EC2. These platforms are delivering great benefits to our customers as easy to use development and test environments. In this session, we will give an overview of this Teradata program and a hands-on demonstration of how to deploy and configure Teradata on a local workstation environment as well as on the Amazon EC2 public cloud. Included will be examples of how these cloud instances can be used to help add value to your existing Teradata ecosystem.

1789 Microsoft Business Intelligence (BI) and Teradata: Don’t Struggle, Snuggle

10:00am – 11:00am Ballroom 20 D

Kensly Alexander, Business Intelligence Solution Architect NCR Co-Presenter: Sonny Ali, Senior Program Manager, Global Alliance Microsoft Corporation Making the Most of a Blockbuster Night—How NCR created powerful BI solutions utilizing MS BI Tools and Teradata. www.teradata-partners.com

93

tHURSdAY edUcAtIonAl SeSSIonS This session will cover how NCR’s Entertainment line of business, which owns the Blockbuster Kiosks, was able to leverage the power of the Teradata EDW (Enterprise Data Warehouse). The EDW team partnered with Teradata and Microsoft to form a strategic alliance that provided a smooth transition to 100% reporting from the Teradata EDW. Microsoft BI tools have empowered the user to develop reports, dashboards, and collaborate with peers.

1932 The Need for Speed: Keeping Up with EA Customers

10:00am – 11:00am Room 29 A, B

Jason Chitwood, Senior Customer Relationship Management Manager Electronic Arts Inc. Co-Presenter: Debbie Doran, Business Consultant for CRM Electronic Arts, Inc. As customers have changed how they view entertainment, content providers have needed to adapt quickly to keep up. Games are no longer just purchased in a store and played at home through a PC or console, they can now be played anywhere on a mobile device and are now played by non-gamers. EA recognized this shift in play and in relationships with their customers.

1969 eBay’s Self-Service Analytics: Tools to Work Smarter 10:00am – 11:00am Room 26

Peter Bense, Staff Framework Engineer eBay, Inc. While Teradata is the cornerstone of the data warehousing environment at eBay; we have multiple classes of analytics systems (e.g., Hadoop) in multiple data centers. This varying landscape introduces challenges insofar leveraging the right tool for the job—especially when decision support systems need to be built upon both structured and unstructured data. In this session we will provide an overview of the eBay environment in the context self-service analytics concepts such as: Virtual Data Mart, Atlas Data Mover (patent pending) and Data Upload Tool working together to provide a cohesive user experience. We will articulate how we manage sandboxing and demonstrate how we abstract users from the onerous technical details of platform-native bulk utilities without limiting the power such tools provide; and how we manage the complexity of moving data to remote locations when needs require it — quickly and easily.

Enabling the business to keep up with a changing customer landscape required alignment and support from all stakeholders to shift to a data-driven strategy based on the following key values: • Governance Process – view information as an asset • Link to Strategic Objectives – driven by business value • Flexibility in Solutions – to support new requirements • Measure Results – to validate/refine strategy This session will explore how EA has anticipated these changes and adapted their business to keep up with their customers— wherever and however their customers are interacting with them.

94

continued...

2011 Teradata PARTNERS User Group Conference & Expo

11:30am – 12:30pm 1346 New Teradata Data Warehouse Appliance

11:30am – 12:30pm Room 26

Ed White, GM Appliances Teradata Corporation Co-Presenter: Rob Kubo, Appliance Platform Chief Engineer Teradata Corporation This session will provide an overview of Teradata’s appliance strategy, success, and a preview of Teradata’s next generation Data Warehouse Appliance that’s coming in early 2012. It will include an introduction to some of the newest innovations that are being incorporated, along with competitive positioning.

1452 A Structured Method for Tuning Teradata SQL

11:30am – 12:30pm Room 29 A, B

Arnoldus VanWyk, Consultant Teradata Co-Presenter: David Gardner, Solution Architect Teradata SQL performance is vital for driving value from a data warehouse and with today’s growing query complexity; optimizing SQL can be a daunting task. This presentation provides a fundamental method for SQL tuning that has been used and refined through thousands of tuning exercises. The structure and process in this method generates a context that minimizes the complexities and gets to the root of the performance issues which enable faster remediation.

Mini Session

Technical

Business

Guru

Super

SIG

Big Data

Sponsorship

The Edge

Thursday Sessions

Aprimo

Further, the method provides a consistent, repeatable process that can be leveraged across the organization from end user to database administrator. In addition to the structured method, this presentation provides insight on typically seen performance problem types and provides sample remedies providing the attendee with insight to commence their own tuning efforts.

11:30am – 12:30pm Room 23

11:30am – 12:30pm Ballroom 20 A

1473 Simplifying Teradata Parallel Transporter (TPT) Scripts with Templates

Matthew Zenus, Product Manager Teradata Corporation

Mark Isbell, Offer Manager Teradata Corporation

The Teradata Database provides a powerful and scalable platform for supporting and growing your geospatial analytical requirements. This presentation will cover some of the key Teradata geospatial capabilities, features, and performance enhancement techniques and how they can be leveraged. Visualization and GIS tool interoperability via WFS (web features services) allowing for reading and writing of geospatial features in Teradata will also be highlighted. During this session, we will demonstrate the geospatial analytic steps: creating the tables with the geospatial data type, geocoding data, loading spatial demographic data, transforming across various spatial reference systems and datums, performing spatial analytics integrated with business data, spatial performance optimization, and establishing interoperability with GIS tools.

Verizon Wireless is a leading telecommunications company that recently made a decision to utilize mixed storage along with TVS (Teradata Virtual Storage) in their Active EDW (Enterprise Data Warehouse) environment. This session explores their path, findings, benefits and lessons learned as they upgraded from an all HDD Active EDW 55XX Teradata 12 environment to a Teradata Active EDW 6680 mixed storage SSD and HDD platform on Teradata 13.10 utilizing TVS.

11:30am – 12:30pm Room 24

Nam Tran, Engineer Teradata Corporation Customer ease-of-use is of paramount importance to Teradata’s strategy, and this is no different in the Teradata extract/transform/ load (ETL) application space. Teradata Parallel Transporter (TPT), a high-performance parallel and scalable extract and load utility for Teradata, extends its ease-of-use by enabling users to write simple job scripts through the use of “template” and “schema inference” techniques of TPT. This presentation will focus on how to use these techniques for building simple, reusable, and easy-to-maintain job scripts without sacrificing the power of TPT. These techniques also form the backbone of the EasyLoader feature, which allows users to execute a set of commonly-used load jobs without using scripts, thus dramatically reducing development time for ETL processes. In addition, this session will reinforce the usage of TPT job variables to better manage users’ job scripts in their test and production environments.

1523 Putting It on the Map with Teradata Geospatial

1550 ViewPoint at WellPoint

11:30am – 12:30pm Ballroom 20 B, C

1556 Mixed Storage and TVS: A Customer/User Perspective from Verizon Wireless

Teradata recently delivered mixed storage (HDDs—hard disk drives and SSDs—solid state drives) offerings together in their Active EDW product line utilizing TVS. TVS automatically monitors data temperature and migrates hot data to faster SSDs and cooler data to less expensive HDDs. The session will touch on the customer path to migrating to a mixed storage and TVS environment including the upgrade plan, testing techniques, data load verification, hot/cold data analysis, upgrade to production, monitoring, query results, data load results, benefits and lessons learned.

Steve Timmons, Senior Database Administrator WellPoint, Inc. This Teradata ViewPoint presentation will focus on the new features in ViewPoint 13.11. We will review how the ViewPoint portlets are used by DBAs and business users at WellPoint. Many of the portlets will be shown as a live demo of WellPoint’s ViewPoint setup.

www.teradata-partners.com

95

tHURSdAY edUcAtIonAl SeSSIonS 1583 Implementing Aprimo Relationship Manager (ARM) in a Quick Win to Integrate Wireline and Mobile Customer Data

11:30am – 12:30pm Room 28 E

continued...

1766 CRM (Customer Relationship Management) Shared Service Center for the BNP Paribas Retail Banking

1775 Supply Chain Traceability

11:30am – 12:30pm Room 29 C, D

11:30am – 12:30pm Room 30 A, B

Simon Ellis, Practice Director, Supply Chain Strategies IDC Manufacturing Insights Alvaro Velasquez, Customer Intelligence Manager Movistar Chile

Xavier Joly, Manager in Retail Banking Information System BNP PARIBAS

After the mix of the wireline and wireless operators of Telefonica by end 2009—with an aggressive exposure in the local media— Movistar transformed itself as the first operator that integrates wireline and wireless phone, digital TV, and fixed and wireless broadband in Chile. This process challenged the business in several ways, such as the treatment of the customer as unique for both businesses which motivated a project: unified campaign management. The tools, technologies, and processes of both companies were completely different: wireline operations had TRM running on Teradata with a centralized process, and wireless operations had an in-house tool running on Oracle with a decentralized one. The business need was to deploy a fast and high value project, a quick win that enabled both operators to take advantage of what they had as soon as they could, using Teradata to have a unique vision of the customer and TRM as the unified campaign management tool for implementing the new customer centric strategy.

BNP PARIBAS, the euro-zone’s largest bank by deposits, generates 45% of its revenues from retail banking. The banking networks serve more than 16 million clients in almost 6,000 branches throughout the world. During more than 10 years, BNPP has capitalized on the French Market skills and know-how, first on marketing data warehouses and campaign management and after on commercial reporting for the sales force. Proud of this best practice, BNPP decided to deploy this all over the international entities and created the CRM Shared Service Center. Each entity, can choose among a large scope of service depending on their needs from development to hosting or production services. This strategy aims to: normalize the developments, reduce maintenance costs, improve time to market, and reduce the entrance barrier to access the technology for smaller branches. The centralization of the administration team around the hub of infrastructure brings key Teradata competencies synergies.

Traceability is among the hottest topics, currently, for supply chain and business executives. Growing regulatory pressures, the globalization of supply networks, and the significant cost of product returns are driving businesses to invest in traceability capabilities—both ‘inter-company’ supply chain traceability and ‘intra-company’ factory level (MES) traceability. Manufacturing companies are asking four key questions: 1. How can I track ingredients or components back to the primary supplier? 2. How do I know what ingredient or component went into which finished product? 3. How can I be more targeted in my product returns process? 4. And perhaps, most importantly, how can I better protect my brand? In this session, we will provide some examples of how companies are answering these questions, and what the current best practices are.

1814 Uncovering New Insights in Your Data Using Graph Analytics

11:30am – 12:30pm Room 28 A, B, & C

Molly Stamos, Director of Product Management Teradata Corporation Graphs, that is, data about connections between people or objects, are everywhere in today’s world. The mining of graph data is known

96

2011 Teradata PARTNERS User Group Conference & Expo

Mini Session

Technical

Business

Guru

Super

as Graph Analytics. Fraud detection, criminal activity monitoring, influencer marketing, and social network analysis are just a few applications of Graph Analytics. The science behind graph analytics has been around for hundreds of years, but existing data management solutions simply weren’t designed to handle the kind of algorithms, or the scale of data, necessary to deliver high performance graph analytics. In this session, we’ll cover Teradata’s approach to Graph Analytics with the Aster Data Analytic Platform. We’ll walk through examples of how Aster provides insights, previously unachievable, by traversing the massive graphs that are found in social networks and financial environments. We’ll also discuss how you can use Aster’s graph analytic engine to uncover new insights in your data.

1820 Balancing Business and IT interests to Improve Data Governance

11:30am – 12:30pm Ballroom 20 D

Laerte Piva, Account Executive Teradata Corporation In 2010 Telefonica, a telecommunication company in Brazil, embarked on structural BI Project to face a new challenge: improve the Data Governance. The project was strategic for the company to attend its continuous focus on Customer’s needs and Service improvement. With strong governance and leadership from the BI Department, Telefonica was able to provide trustable information to different departments and unify reports publishing by achieving data quality improvement. All these actions were defined by an 18-month BI Strategic Planning that involved all the company. The project brought an important lesson of implementing cultural change management, balancing Business and IT interests and a glance for the future. Audience will have the opportunity to learn: how to manage cultural changes; tips for a BI Plan; how to make a micro management in a BI Plan (small deliveries); manage the quality and trust of information; the negotiation between BI and Business Areas (final users perceptions).

SIG

Big Data

Sponsorship

The Edge

Aprimo

1847 SIG: Agile Analytics within the Data Warehouse

11:30am – 12:30pm Room 22

Thursday Sessions

a seconds/minutes instead of hours/days). This presentation will demonstrate the capabilities provided by Teradata and SAS to answer big data issues with complex analytics.

Arlene Zaima, Product Marketing Manager Teradata Corporation Innovative companies rely on agile development in their data warehouse to enable ad hoc exploration of untested data and rapid prototyping of new theories. This environment must be designed for the unknown, however, this contradicts the characteristics of an enterprise data warehouse (EDW), known for its governance, stability, and predictable performance. This Special Interest Group discussion allows businesses to ask subject matter experts, of some of the most successful and innovative companies how they adapted their EDW to deliver an agile development environment.

1967 Analytics for Big Data Using SAS High Performance Analytics and Teradata

11:30am – 12:30pm Room 25

Michelle Wilkie, Product Manager SAS Institute How do you find and predict the answers from “big data”? As data grows, as industries encounter issues in the market and are recovering from a depression; the answer to analyzing your data becomes more and more relevant. The SAS High-Performance Analytics appliance on Teradata provides highly parallelized in-memory analytical and workflow management capabilities across a distributed computing environment. It has been developed to solve complex business problems that require sophisticated high-end analytics and access to big data. The goal, removing today’s limitations arising from big data issues in current modeling tools, aims to deliver answers in near real-time (typically within www.teradata-partners.com

97

noteS

98

2011 Teradata PARTNERS User Group Conference & Expo

EXPO

EXPO

EXPO

THE SAN DIEGO CONVENTION CENTER The San Diego Convention Center (SDCC) is located on sparkling San Diego Bay in the heart of vibrant downtown San Diego—and right at the center of all the action. The SDCC is just a short walk to the historic Gaslamp Quarter, the city’s hottest dining and entertainment area with an exciting array of restaurants, sidewalk cafes, specialty shops, and clubs. This beautiful bayside location is also only a stroll away from the USS Midway and PETCO Park, home to the San Diego Padres.

Hotel Proximity to the SDCC

Walking distance from each hotel to the SDCC is just minutes away! 1

• The daily rate is $10. Parking rates may range from $10 to $20 on days when there is special event activity at PETCO Park or other downtown events. • Payment is due upon entry and there are no in and out privileges.

Approximate walking time from hotel to SDCC:

E ST.

E ST.

Courtyard by Marriott San Diego Downtown 15 minutes

9 F ST.

F ST.

HORTON PLAZA

Hard Rock Hotel San Diego 3 minutes

G ST.

G ST.

MARGET STREET

5

Tro lley

Hilton San Diego Bayfront Resort 3 minutes

ISLAND AVE.

Lin e

8

I ST.

PETCO PARK

7

4

K ST.

2 CO NV SAN EN D TIO IEG N O CE NT

6

BL VD .

Directly across the street from the SDCC, on the corner of Harbor and Eighth Avenue, is a 2,000-space parking structure. Off-site parking is available at numerous nearby parking lots and garages in downtown San Diego, and many are within walking distance of the SDCC.

Hotel Map Legend

BROADWAY

K

On-site private vehicle parking is available at the SDCC’s 1,950-vehicle underground garage located below the building (no overnight parking is permitted). Enter the parking garage on Harbor Drive between First Avenue and Fifth Avenue.

PA R

Parking

ER

HA

3

RB

OR

DR

IV

E

Trolley Station

Hilton San Diego Gaslamp Quarter 3 minutes Manchester Grand Hyatt San Diego 6 minutes Omni San Diego Hotel 3 minutes San Diego Marriott Gaslamp Quarter 6 minutes San Diego Marriott Hotel & Marina 3 minutes

EXPO

Westin Gaslamp Quarter 10 minutes

100

2011 Teradata PARTNERS User Group Conference & Expo

Conference Program

conventIon centeR MAPS Upper level

L3

MAP legend

L3

L2 L1

L1

L3

RE TID STAU ES RA NT

ground level

Upper Level Mezzanine Level Ground Level (Street)

www.teradata-partners.com

101

exPo HAll flooR PlAn exhibit Hall g Main Entrance 207

201

213

Appfluent

306

Protengrity

219

231

225

SUSE

Informatica Corporation

233

APOS Symantec Systems

Teradata Corporation

318

Cognizant

Ab Initio

330

KXEN

307

313

Microgen

402

321

430

432 Kalido

401 403

407

Ward Analytics

413

521

Kalido

MicroStrategy

601 603 605 607 Tibco

102

Software

WhereScape

Angoss Software

513

531

525

Ataccama Corporation

Teradata Corporation

620

507

Private Meeting Space B

Private Meeting Areas Bike Build

Private Meeting Space C

Trillium Software

501

Wireless Cafe

NetApp

Tableau Software

502

Denotes Walk-Thru Space

Celebrus Technologies

432

Oracle Talend

Exhibitor Booths

333

SAS

Teradata Pavilion

500

MAP legend

Teradata Depot

Private Meeting Space A

301 303 400

221

Blanket Brigade

533

Computer Sciences Corporation

630

Private Meeting Space D

Teradata Certified Pro. Program

Teradata Depot

IBM

625 627 629 631 633 611 613 615 617 619 621 623 Information Quest Voltage

Attensity

arcplan

RainStor

Attunity

Clarabridge QuantiSense

Security

iOLAP TDWI

2011 Teradata PARTNERS User Group Conference & Expo

Builders

Software

Air2Web

Bike Build and Blanket Brigade

Private Meeting Space E

Wireless Cafe

Conference Program

2011 PARtneRS exHIBItoR lISt explore the latest Solutions Visit the Expo Hall in Exhibit Hall G and see first-hand what PARTNERS is all about. Open Monday through Wednesday, the Expo Hall offers exciting opportunities to learn from industry experts and make new networking connections among your peers. The following companies are exhibiting at the 2011 PARTNERS Expo: Company ....................................................................................Booth

corporate Teradata Corporation ........................................225, 321, 525

diamond MicroStrategy ...................................................................501 SAS....................................................................................313 Tableau Software..............................................................407

gold Ab Initio.............................................................................306 Appfluent Technology........................................................207 Celebrus Technologies ......................................................333 Informatica ........................................................................318 KXEN .................................................................................330 Teradata Certified Professional Program ..........................630 Teradata Customer Education...........................................630

Silver Platinum Cognizant...........................................................................213 IBM....................................................................................513 Kalido ................................................................................507 Microgen ...........................................................................307 NetApp ..............................................................................413 Protegrity...........................................................................201

Angoss Software Corporation...........................................620 Ataccama Corporation ......................................................531 Computer Sciences Corporation (CSC)..............................533 Oracle ................................................................................601 Quest Software .................................................................631 SUSE..................................................................................221 Trillium Software...............................................................521

Bronze Air2Web ............................................................................633 APOS Systems...................................................................231 arcplan...............................................................................613 Attensity Corporation........................................................611 Attunity..............................................................................617 Clarabridge........................................................................619 Information Builders Inc./IWAY ........................................629 iOLAP.................................................................................625 QuantiSense......................................................................621 RainStor.............................................................................615 Symantec...........................................................................233 Talend................................................................................603 TDWI .................................................................................627 Tibco Software ..................................................................605 Voltage Security................................................................623 Ward Analytics..................................................................432 WhereScape......................................................................607

www.teradata-partners.com

103

2011 PARtneRS exHIBItoRS corporate

diamond

Teradata Corporation

MicroStrategy

The global leader in data warehousing, Teradata solutions give companies the people, technology, and innovation to make smarter, faster decisions that help them achieve competitive advantage to master their markets. Our people distinguish us—in the data center or the boardroom—Teradata employees set the benchmark for passionate professionalism. We are masters of solution development; deeply knowledgeable in the industries we serve, and relentlessly committed to solving our customers’ business and information challenges. Our technology outperforms every alternative—Teradata delivers integrated, enterprisescale analytical solutions based on the powerful, scalable and reliable technology platform. The world’s largest and busiest data management environments are running and growing on Teradata technology. Simply put, Teradata solutions make companies smarter and give them the competitive edge to win. To learn more about our solutions, go to teradata.com.

Founded in 1989, MicroStrategy is a global leader in Business Intelligence technology. MicroStrategy software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make better business decisions. The MicroStrategy platform delivers actionable information to business users via the web and mobile devices, including the iPad, iPhone, and BlackBerry. Companies choose MicroStrategy for its ease-ofuse, sophisticated analytics, and superior data and user scalability. MicroStrategy offers free reporting software and free mobile software, along with a full array of products for any size organization across all industries. To learn more about MicroStrategy, visit microstrategy.com.

Booth #225, 321, 525

Booth #501

SAS

Booth # 313 SAS is the leader in business analytics software and services, and the largest independent vendor in the business intelligence market. Through innovative solutions delivered within an integrated framework, SAS helps customers at more than 50,000 sites improve performance and deliver value by making better decisions faster. Since 1976 SAS has been giving customers around the world THE POWER TO KNOW®. With the SAS and Teradata partnership, you’ll get unmatched SAS data management, analytics and reporting with worldclass Teradata technology and data warehousing expertise. Our partnership provides a compelling and robust business analytics and data warehousing environment that allows your organization to derive greater value from existing technology and information

104

2011 Teradata PARTNERS User Group Conference & Expo

assets, helping you reduce risk and total cost of ownership. In addition, the SAS and Teradata Advantage Program delivers pre-packaged offerings with software, hardware and services to help customers quickly turn their data into analytical insights that will drive better decision making and dramatically impact their business’ bottom line. www.sas.com/teradata

Tableau Software Booth #407

Tableau Software provides rapid-fire business intelligence applications that help people see and understand data. By connecting directly to Teradata and nearly any other data source, Tableau lets you gain data insight quickly and easily. Customers create interactive data visualizations and dashboards, execute robust analytics and seamlessly share results across their organization and on mobile devices. Tableau provides flexibility to leverage Teradata by analyzing it “live” or using extracts within Tableau. Headquartered in Seattle with offices in Kirkland, San Mateo and London, Tableau is used by over 6,500 organizations and is recognized by Gartner as the fastest growing company in BI.

Conference Program

Platinum Cognizant

Kalido

NetApp

Cognizant (NASDAQ: CTSH), headquartered in Teaneck, New Jersey (U.S.), is a Fortune 500 provider of information technology, consulting and business process outsourcing services. Cognizant’s Data Warehousing, Business Intelligence & Performance Management Practice (DWBI&PM) has over 8,570+*consultants across the globe and is at the forefront of partnering with leading companies in architecting pragmatic, business-focused, enterprisewide information management solutions.

Kalido is the leading provider of business-driven information management software. Kalido enables companies to manage data as a shared enterprise asset by supporting the business process of data governance. By combining Kalido’s flexibility and agility with Teradata’s scale and speed, customers can improve analytical performance to make better business decisions and gain competitive advantage. http://www.kalido.com

NetApp creates innovative storage solutions that deliver outstanding cost efficiency and accelerate business breakthroughs. Our dedication to the principles of simplicity, innovation, and customer success has made us one of the fastest-growing storage and data management providers today. Customers around the world choose us for our “go beyond” approach and broad portfolio of solutions for server-to-storage virtualization, business applications, data protection, and more. Our modular and high bandwidth storage technologies provide nonstop availability of critical business data. Inside Teradata NetApp’s storage speeds up business intelligence so Teradata customers can gain business insight with confidence and get to revenue faster than ever before. Discover our passion for helping companies around the world go further, faster at www.netapp.com.

Booth #213

Booth #507

Microgen IBM

Booth #513 IBM Business Analytics software delivers complete, consistent, and accurate information that decision-makers trust to improve business performance. A comprehensive portfolio of business intelligence, advanced analytics, financial performance, and strategy management and analytic applications gives you clear, immediate, and actionable insights into current performance and the ability to predict future outcomes. Combined with rich industry solutions, proven practices, and professional services, organizations of every size can drive the highest IT productivity and deliver better results.

Booth #307

Microgen develops and implements enterprise software for the world’s largest organisations. Its high performance software and detailed understanding of specific markets enable customers to quickly realize business value from their investment in technology. The company’s flagship technology, Microgen Aptitude, processes large volumes of transactions and data at unparalleled speed—in environments where complex business rules apply, such as the financial services and digital media sectors. The Microgen software is also capable of addressing the challenge of “Big Data.”

Booth #413

Protegrity Booth #201

Protegrity is the leading security software company providing high performance, infinitely scalable, end-to-end data security solutions. Protegrity customers centrally develop, manage and control data security policy that protects sensitive information across the enterprise. Protegrity’s solutions give corporations the ability to implement a variety of data protection methods, including strong encryption and tokenization to ensure the protection of their sensitive data and enable compliance for PCI-DSS, HIPAA and other data security requirements. For information, visit www.protegrity.com or call 203-326-7200.

www.teradata-partners.com

105

2011 PARtneRS exHIBItoRS

continued...

gold Ab Initio

Informatica

Teradata Customer Education

Ab Initio Software is a general purpose data processing platform for enterprise-scale, mission-critical applications such as batch and real-time processing for data warehousing, operational systems, billing systems, transactional systems, and analytics. Ab Initio solves the problems of scalability, development time, performance, metadata management, and integration at the world’s largest companies.

Informatica is the world’s number one independent leader in data integration software. Thousands of organizations around the world gain a competitive advantage in today’s global information economy with timely, relevant and trustworthy data for their top business imperatives, whether using traditional IT computing systems or the internet cloud.

Teradata Customer Education offers Teradata customers top-quality, Teradata education that builds their skills and capabilities, enabling them to maximize their Teradata investment. Our blended learning approach combines web and classroom training to provide all user levels with a wide variety of opportunities to gain knowledge.

Booth #306

Appfluent Technology Booth #207

Booth #318

KXEN

Booth #330

Appfluent enables enterprises to manage data smarter and better aligned with the business. Appfluent Visibility® for BI and Data Warehousing provides insight into business activity and usage, exposes how data is used and what data is unused, and tracks inappropriate or unauthorized user activity.

KXEN is revolutionizing the way companies use predictive analytics to make better decisions. Based on patented innovations, the company’s flagship product InfiniteInsight™ delivers orders of magnitude improvements in speed and agility to optimize every step in the customer lifecycle - including acquisition, cross-sell, up-sell, retention and next best activity.

Celebrus Technologies

Teradata Certified Professional Program

Celebrus Technologies (formerly Speed-Trap) delivers complete real-time data on every individual online customer and prospect including their current and historic behavior, experience and transactions. Customers integrate this data into their information architecture to drive applications as diverse as Customer Analytics, Business Intelligence, Marketing Automation, Behavioral Targeting, CRM and Fraud Detection.

The Teradata Certified Professional Program develops and manages Teradata’s premier Certification Testing Program. Teradata’s authorized training and proctored exams are instrumental in establishing an industry standard measure of technical competence for IT professionals using Teradata technology. Recognized and valued by major global companies, more than 52,500 Teradata Certifications have been awarded.

Booth #333

106

Booth #630

2011 Teradata PARTNERS User Group Conference & Expo

Booth #630

Conference Program

Silver Computer Sciences Corporation (CSC)

SUSE

Angoss is a global leader in delivering predictive analytics to businesses looking to improve performance across sales, marketing, and risk. With a suite of desktop, client-server, and indatabase software products, and Software-as-a-Service solutions, Angoss delivers powerful approaches to turn information into actionable business decisions and competitive advantage. Angoss software products and solutions are user-friendly and agile, making predictive analytics accessible and easy to use.

CSC’s Manufacturing Group provides innovative, technologyenabled business solutions for industries including Aerospace & Defense, Automotive, Industrial, and Architecture, Engineering & Construction. Our offerings address all phases of the product life cycle, from engineering thru aftermarket. As a global leader in manufacturing, with over fifty years of experience in consulting, business systems, technology integration and outsourcing, we help our clients perform and prosper in today’s competitive, global markets. For more information, visit www.csc.com/manufacturing.

SUSE is a leading provider of enterprise Linux solutions that increase agility, reduce cost, and manage complexity. With a portfolio centered around SUSE Linux Enterprise, the most interoperable platform for mission-critical computing, SUSE enables the delivery of computing services across physical, virtual, and cloud environments. For more information, visit www.suse.com.

Ataccama Corporation

Oracle

Booth #531

Booth #601

Ataccama Corporation is a leading software company which develops Data Quality, MDM and Data Governance solutions for enterprise customers. Major financial institutions, insurance firms, telecommunication companies, utilities, and government agencies choose Ataccama technologies to improve the quality of the data. Our free data profiling tool is available at www.ataccama.com/ teradata.

Oracle (NASDAQ: ORCL) is the world’s most complete, open, and integrated business software and hardware systems company. For more information about Oracle, visit oracle.com.

Angoss Software Corporation Booth #620

Booth #533

Booth #221

Trillium Software Booth #521

Trillium Software is the global leader in Enterprise Data Quality. We deliver global data profiling, cleansing, enhancement, linking, geocoding, and governance for data warehouse, CRM, MDM, ERP, business intelligence, supply chain management, e-business, and other enterprise applications. The Trillium Software System is critical for data integration, data migration, data stewardship, and data governance.

Quest Software Booth #631

Quest Software (Nasdaq: QSFT) simplifies and reduces the cost of managing IT for more than 100,000 customers worldwide. Our innovative solutions make solving the toughest IT management problems easier, enabling customers to save time and money across physical, virtual and cloud environments. For more information about Quest solutions, go to www.quest.com.

www.teradata-partners.com

107

2011 PARtneRS exHIBItoRS

continued...

Bronze Air2Web Booth #633

Air2Web is a turn-key mobile marketing and customer care solutions provider. With over 12 years of experience working with leading brands across all verticals, Air2Web provides both the technology and the strategic leadership needed to launch your company’s mobile presence, including mobile customer care, mobile marketing, mobile app/web development, mobile CRM, and highthroughput bulk SMS messaging.

arcplan

Booth #613 arcplan is a leader in innovative Business Intelligence, Dashboard, Corporate Performance and Planning software solutions for desktop and mobile use. Since 1993, arcplan has enabled more than 3,000 customers worldwide to leverage their existing infrastructure and achieve organizational efficiency through the powerful combination of analysis, insight and collaboration.

Clarabridge Both #619

Clarabridge is the leading provider of sentiment and text analytics for extracting actionable insights from the voice of your customer. No matter where your customer is talking about you, Clarabridge allows you to hear what they say, analyze what they say in real-time and make better business decisions.

Information Builders, Inc./IWAY APOS Systems Booth #231

We make business intelligence (BI) and location intelligence (LI) smarter, better, and easier. Our focus is on SAP BusinessObjects platform management (administration, system monitoring, alerts), BI publishing (scheduling, bursting, distribution, report packages), pervasive BI (integration with content management), and location intelligence (Esri GIS integration, cloud hosted, Teradata). An SAP BusinessObjects Technology Partner, Esri Gold Partner.

Attensity Corporation Booth #611

Attensity’s text analytics solutions are the choice of the world’s leading brands for Customer Experience Management. Attensity is the only company that lets business users analyze millions of customer conversations from any online, social media or internal source, and extract the industry’s most accurate insights to drive business decisions. Visit www.attensity.com.

Attunity

Booth #617 Attunity provides real-time data integration and event capture software. Using Attunity’s low-impact CDC and data replication technology, companies can seamlessly connect to heterogeneous data sources and stream changes across the enterprise, simplifying and accelerating Teradata data warehousing initiatives. Connect with us on Facebook, Twitter, and LinkedIn.

108

2011 Teradata PARTNERS User Group Conference & Expo

Booth #629

Information Builders brings smarter decision-making and streamlined processes to leading businesses, worldwide. WebFOCUS business intelligence delivers massively scalable information applications, analytics, and customer-facing portals for game-changing business results. iWay Software streamlines business processes while escalating the overall accessibility and integrity of information regardless of environmental complexity.

iOLAP

Booth #625 If you need Business Intelligence, you need iOLAP. For enterpriseclass companies, we leverage our extensive knowledge of Business Intelligence technologies and methodologies to quickly develop and implement Data Warehouse and reporting solutions of the highest quality at a lower cost. Business Intelligence and Data Warehousing is all we do.

Conference Program

Symantec

Tibco Spotfire

Ward Analytics

Symantec is the global leader in securing and managing the world’s information. Our Veritas NetBackup software, the leading data protection solution, was selected by Teradata as their primary BAR offering, providing customers confidence that their information is safely backed up and restorable, ensuring business continuity. For more information, visit www.symantec.com.

From interactive dashboards and data visualization to predictive analytics, Spotfire’s intuitive business intelligence and analytics software provides an astonishingly fast and flexible environment for visualizing and analyzing your data – helping you make smarter decisions every day. Unlike traditional business intelligence that delivers data in rigid reports, Spotfire empowers business users with speed and freedom.

Teradata performance analysis and management software vendor.

Booth #233

Talend

Booth #603 The recognized leader in open source middleware, Talend makes data management and application integration solutions available to organizations of all sizes and for all integration needs. Talend offers open, innovative and powerful solutions, used primarily for operational data integration, ETL, data profiling and cleansing, MDM, and application integration. Visit us at www.talend.com.

Booth #605

Voltage Security Booth #623

Voltage Security, Inc., an enterprise security company, is an encryption innovator and global leader in enterprise data protection for data residing both inside and outside the cloud. Voltage solutions provide cloud-scale encryption and simplified key management for protecting sensitive information wherever it is stored and processed, on-premise or in private and public clouds.

Booth #219

WhereScape Booth #607

WhereScape RED is a unique, *agile* development environment specifically designed for data warehouses. Utilizing WhereScape, developers build Teradata objects, such as views and join indexes, in minutes compared to traditional approaches. Use RED in sandbox environments to validate data without hand coding. Meta-data generated code and documentation drive the process.

TDWI

Booth #627 TDWI, a division of 1105 Media, Inc., is the leading provider of high-quality education, in-depth training, and CBIP certification for the business intelligence and data warehousing industry. TDWI offers business and IT professionals a worldwide membership program, a comprehensive curriculum of educational events, onsite training, informative publications, an exhaustive research program, and a comprehensive Web site, tdwi.org. www.teradata-partners.com

109

coMMIttee MeMBeRS PARtneRS Steering committee Erin Redshaw President, Partners Steering Committee Senior Manager of ETL Loblaw Companies Limited Rudolf Holzapfel Co-Vice President, Partners Steering Committee Division Manager, Enterprise Delivery Center MGI Metro Group Susan Watson Co-Vice President, Partners Steering Committee Database Director Cardinal Health Connie Garritsen Secretary, Partners Steering Committee Manager, Global Enterprise Data Warehouse 3M Joyce Wells Treasurer, Partners Steering Committee Technology Manager Well Fargo Technology Information Group

Betsy Burge Director of Data Warehouse Business Content WellPoint

Matthew Laney Data Warehouse & Business Intelligence Manager Winn-Dixie Stores, Inc.

Mark Cooper Technical Fellow FedEx Services

Darryl McDonald Executive Vice President, Business Development & CMO Teradata Corporation

Elizabeth Corley Executive Liaison to the Partners Steering Committee Vice President, Marketing Communications Teradata Corporation

Randall D. Parman Database Architect DineEquity, Inc.

Troy Crites Senior IT Architect Express Scripts Jim Donovan Vice President, Global Industry Solutions Teradata Corporation Scott Gnau Vice President, Teradata R&D Teradata Corporation Russ Hendley Senior Application Architect Barclays Bank Plc

110

2011 Teradata PARTNERS User Group Conference & Expo

Karen Ritzinger Partners Conference Director Teradata Corporation Rebecca Salsbury Partners Conference Manager Teradata Corporation James Vollmer Lead Architect, Data Warehouse Enterprise Holdings, Inc.

Conference Program

Analytical Applications Product Advisory Council James Moore Senior Manager, Client Decisioning & Reporting Royal Bank of Canada

Josh Anderson Engineering Manager Teradata Corporation

Karen Ann O’Dell Director IT Business Systems; BI Product Director Station Casinos

Ben Ceranowski TRM Product Management Teradata Corporation

Mike Breitenbeker Manager of EDW Applications Overstock.com

Bev Pilbeam Service & Delivery, CRM & Marketing Service UK Retail Banking Barclays Bank

Tom Doyle ARM Product Management Teradata Corporation

Debbie Doran Business Consultant for CRM Electronic Arts Inc.

Chris Prymak Marketing Manager CVS Pharmacy

Jack Graham Principal Member-Applications Staff Verizon Wireless

Margaret Lee Sun Head Data Environment & DM Technology Standard Bank SA

Kim Karriker Senior Manager, Database Marketing Operations Saks Fifth Avenue

Megan Watson CRM Analyst Penn Gaming

Krystal Maher TCRM Administrator Meredith Corporation

Susan Zimmer CRM Senior Project Manager JC Penney

Greg Moore 2011 AAPAC Chairperson Team Leader CRM Operations & Reporting National Australia Bank DeAnna Blair Marketing Project Leader Hallmark Cards, Inc.

Dan Summerlin TRM Product Manager Teradata Corporation John Timmerman Solutions Marketing Specialist Teradata Corporation Deb Woods Director of Product Management Teradata Corporation

☞For More Information

For more information on committee members, including bios, or for information on how to join a committee, visit: www.teradata-partners.com www.teradata-partners.com

111

coMMIttee MeMBeRS

Continued...

Product Advisory council Tom Campbell Chairperson Director Business Intelligence Kelly Services Tom Jung Vice-Chairperson Manager – IM Database Administration WellPoint, Inc. Arthur J. Brown Lead Data Warehouse Architect Verizon Wireless Chet Aitken Manager Business Solutions Development: Business Intelligence Hudson’s Bay Company (HBC) Clay Barrineau Teradata Architect The Home Depot Michelle Fadel Advisory Database Administrator for Enterprise Business Intelligence Delta Air Lines Ruth Fenwick Teradata Technical Lead RBC Financial Group

112

Peter Hennes Project Manager Data Warehousing & BI Lufthansa German Airlines

Donna Becker Director of the America’s Professional Services Teradata Corporation

Paul Longhurst Director of Data Warehousing Overstock.com

Phil Bucci PM Strategic Director Teradata Corporation

Chad Meley Director of Business Intelligence Electronic Arts

Rich Charucki Teradata Engineering Fellow Teradata Corporation

Cameron Morrison Senior Enterprise Application Developer Intel Corporation

Gene-o Erickson Director of America’s CS Critical Support Office Teradata Corporation

Michele Pugliese Teradata Database Team Manager Travelers Insurance

Patsy Martin Program Manager, PAC Facilitator Teradata Corporation

Joerg Thienenkamp Senior Developer METRO SYSTEMS

Jeff Shelton Senior Consultant Software Engineer Teradata Corporation

Ian Willson Boeing Technical Fellow IT Enterprise Architecture The Boeing Company

Chris Twogood Director, Product and Service Marketing Teradata Corporation

Tim Zeitter Technical Manager BI & EDW Meijer

2011 Teradata PARTNERS User Group Conference & Expo

Conference Program

Service focus team Kiki Sanchez, SFT Chairperson Data Warehouse Group Senior Manager – DBA Continental Airlines Heidi Beaber Teradata Infastructure Support Supervisor Ford Motor Company David Belcher Team Leader, Teradata DBAs British Airways Joanne Erceg Team Leader and Principal Performance Analyst eBay, Inc. Philip Foutty Database Admin Advisor WellPoint Inc. Jeanette Gamble Executive Director Morgan Stanley Carl Martin IT Engineering Project Manager Lowe’s Companies, Inc.

Evie Pauze Lead Database Engineer Ceasar’s Entertainment, Inc.

Jeff Amos Area Director, Americas Customer Services Teradata Customer Services

Shelley Perrior Sr. Teradata Database Analyst Loblaw Companies Limited

Jerry Blevins Director, Global Remote Services Teradata Customer Services

Larry Pitkeathly Data Warehouse Specialist RBC Royal Bank

Jean Cline Program Manager Teradata Customer Services

Kim Poley Senior DBA Express Scripts, Inc.

Randy Eskridge Manager, Platform Hardware Engineering Teradata Platform Engineering

Kyle Prescott DBA Manager Unum

Tony Nevarez Senior Program Manager Teradata Service Product Management

Mike Simek Team Lead AT&T

Hatsue Ogo APJ Regional Operation Manager Teradata Global Support Center

Bruce Watterson Senior Technical Manager Bank of America

www.teradata-partners.com

113

tableau_teradata_adv3_FINAL-outlines.pdf 1 8/31/2011 9:33:23 PM

C

M

Y

CM

MY

CY

CMY

K

PAR TN ERS US E R GR O UP c/o Teradata Corporation 10000 Innovation Drive Miamisburg, OH 45342 Phone: (858) 485-3312 Fax: (513) 719-6971

www. t e r ad a t a- partne r s .com # TDP UG1 1