Big Analytics Workshop: From Hype to Business Results

BigAnalyticsWorkshop_Header2

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.

Register-Now

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.

Objectives

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) 

Agenda

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

City

Dates

Hotel

Dallas

February 11

Doubletree by Hilton Dallas near the Galleria

St. Louis

February 13

St. Louis City Center Hotel

San Francisco

March 25

Hilton San Francisco Airport Bayfront

Newark

April 8

Hilton Meadowlands

Minneapolis

April 10

Radisson Blu Minneapolis

Columbus

May 6

Ramada Plaza Hotel & Conference Center

Chicago

May 20

Chicago Marriott Northwest

Toronto

June 3

DoubleTree by the Hilton Toronto Downtown

San Jose

TBD

TBD

Atlanta

TBD

TBD


Register for a city near you


Register-Now