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 amMorning 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 pmLunch
12:45 pm - 3:30 pmAfternoon 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