Big Analytics Workshop: From Hype to Business Results


The Big Analytics Workshop: From Hype to Business Results is a 1-day introductory workshop. This highly interactive workshop is led by practitioners with firsthand experience working with Teradata’s technology and customers.

You’ll walk through several real big data analytics use cases maximizing your understanding of how to do new types of analytics on multi-structured data. Come prepared to learn how to query both structured and multi-structured datasets.


Workshop Pre-Requisites

Working knowledge of SQL. Basic knowledge of scripting languages. Experience with command-line interfaces.

Due to the fast-paced nature of this workshop, all labs are done via Teradata Studio client using pre-configured queries. Students will have the chance to write their own queries during some of the labs, if desired, and you will receive a UDA on a Stick with the data sets and VM images to practice on your own after the Big Analytics Workshop.

This course uses Teradata QueryGrid, MapReduce, Teradata Aster SQL-MapReduce, (SQL-MR), Aster Lens, Tableau, Spotfire, R Studio, and QlikView.


Upon completing this course, you will improve your ability to:

  • Describe the Teradata Unified Data Architecture and underlying Teradata QueryGrid connectors
  • Articulate the difference between Hadoop’s MapReduce and Aster’s SQL-MapReduce
  • Differentiate when to use MapReduce and when to use ANSI SQL in your queries
  • Write Aster SQL-MR syntax
  • Visualize queries using Aster Lens, Tableau, Spotfire, R Studio and QlikView
  • Code the SQL-MR function nPath (a pattern detection function) 


8:30 am - 11:45 am Morning Session: Overviews and a Use Case (Includes Hands-On Labs)
  • Teradata’s definition of Big Analytics
  • The Teradata Unified Data Architecture™ for Big Analytics 
  • The Teradata Integrated Data Warehouse
  • The Teradata Aster Database: Understanding discovery analytics on big data
  • Introduction to Apache™ Hadoop®
  • Teradata Unified Data Architecture Components Drill Down 
  • The SQL-MapReduce® (SQL-MR) framework
  • Loading big data and executing SQL on Hadoop data (SQL-H)
  • Pattern matching on time series data: The nPath function
  • New types of data visualization: The nPathViz function
11:45 am - 12:45 pm Lunch
12:45 pm - 3:30 pm Afternoon Session: Applying Concepts (Includes Hands-On Labs)
  • Business Case Study – A Real-World Telco Example
  • Solution: Utilize the Teradata Unified Data Architecture Technology 
  • Detailed step-by-step execution roadmap
  • Working code examples
  • 3-way join between Aster, Teradata, and Hadoop
  • Execution of nPath and Pathmap SQL-MapReduce® functions sourced by the 3-way join
  • Visualization of the results
  • Report on analysis performed / results
  • Additional Use Cases of Big Data Analytics


Workshop Tour Schedule





February 11

Doubletree by Hilton Dallas near the Galleria

St. Louis

February 13

St. Louis City Center Hotel


March 20

Motif Seattle

San Francisco

March 25

Hilton San Francisco Airport Bayfront


April 8

Hilton Meadowlands


April 10

Radisson Blu Minneapolis


May 6

Ramada Plaza Hotel & Conference Center


May 20

Chicago Marriott Northwest


June 5

DoubleTree by the Hilton Toronto Downtown

San Jose

June 17



June 26

Hyatt Atlanta Perimeter at Villa Christina

Register for a city near you