ThoughtSpot Data Expert Training

The ThoughtSpot Data Expert Training is a two-day class which covers data connectivity and modeling data in ThoughtSpot.  Day 1 is our Data Modeling Essentials course which covers two of the primary disciplines in implementing ThoughtSpot: Data Connectivity & Making Data Searchable. Data Connectivity is devoted to connecting ThoughtSpot to your data warehouse using Embrace and Making Data Searchable will look into the many ways in which connected data can be prepared for searching by end users.  Day 2 is our Advanced Data Modeling course which takes a deep dive into data modeling and challenges you may run into like Many to Many relationships, Chasm Traps, Fan Traps, Hierarchies, Multiple Join paths and how to resolve each of them.  

The ThoughtSpot Data Expert Training Day covers material that helps prepare students to pass the ThoughtSpot Cloud Architect Certification exam.

An additional 30% discount is available for for groups of 3 or more from the same company. To register multiple users, please contact education@thoughtspot.com.

Duration

1.5 Days In-Person, 2 Days Virtual

Who Should Attend

• ThoughtSpot Administrators & Implementers
• ThoughtSpot Implementation Partners
• Data Experts

ThoughtSpot Data Modeling Essentials - Day 1, 5 hours

The Data Modeling Essentials training involves an end-to-end discussion on the process of connecting to your data and optimizing it for search in ThoughtSpot. It also introduces several relevant data modeling topics. Includes hands-on, interactive lecture allowing participants to experience setting up the data connection for themselves.

ThoughtSpot Data Connectivity - 1 hour

This topic focuses on the main technical topics and best practices around connecting ThoughtSpot to your data with Embrace. Through interactive lecture and specially designed training environments, you will then get hands-on practice creating a connection to a Cloud Data Warehouse (CDW) and deciding which tables and columns will be available for search by your business users. You will learn how to maintain your ThoughtSpot environment by editing or remapping your connection if changes occur in your CDW.

Topics Covered:

• Introduction to Embrace
• Creating a Connection
• Editing an Existing Connection
• Remapping a Connection

ThoughtSpot Making Data Searchable - 4 hours

Modeling and optimizing your data for the ThoughtSpot search experience will be covered in detail in this course. Beginning with topics on data management in ThoughtSpot, the class quickly moves into hands-on lecture around Worksheet design. Advanced topics include custom calendars, formula creation, creation of views and custom SQL views and ThoughtSpot Modeling Language (TML).

Topics Covered:

• Exploring Data Management
• Creating Worksheets
• Custom Calendars
• Creating Formulas & Parameters
• Creating Search-Based and Custom SQL Views
• ThoughtSpot Modeling Language (TML)
• SpotApps

ThoughtSpot Advanced Data Modeling - Day 2, 3 hours

Building upon the skills learned in the Making Data Searchable course, this session will take a deep dive into data modeling and optimizing the loaded data for the ThoughtSpot search experience. Beginning with topics on data modeling design types you will learn about the benefits and detractions of different modeling design choices. The class quickly moves into hands-on lecture around Modeling challenges like many to many relationships, 1 to 1 relationships, chasm and fan traps and multiple join paths and how to resolve them. Guidelines for building worksheets within different models and understanding the worksheet join rule round out the course.

Topics Covered:

• Data Model Design Types
  
  • Snowflake
  • Star
  • Inverted Star
  • Flat Denormalized
• Modeling Challenges and How to Resolve them
  
  • Many to Many     
  • 1 to 1
  • Chasm Traps
  • Fan Traps
  • Multiple Join Paths
• Hierarchies
  • Balanced
  • Ragged
  • Unbalanced
• Worksheet Join Rule and Directionality
• Worksheet Design Best Practices

Prerequisites

ThoughtSpot End User Functionality Training Day or equivalent knowledge.