ThoughtSpot Administration & Advanced Data Modeling

This course is divided into two sessions. The first session, ThoughtSpot Administration, discusses the role of the Administrator in the ThoughtSpot environment. The second session, Advanced Data Modeling takes a deep dive into data modeling and optimizing the loaded data for the ThoughtSpot search experience.

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

6 Hours

Who Should Attend

• ThoughtSpot Administrators & Implementers
• ThoughtSpot Implementation Partners

Prerequisites

ThoughtSpot Data Expert Training, ThoughtSpot Cloud Essentials Training, or equivalent knowledge.

ThoughtSpot Administration - 3 Hours

This session discusses the role of the Administrator in the ThoughtSpot environment. We will take a deep dive into Administration beginning with topics on user and group management and a thorough discussion on various authentication methods. The class quickly moves into discussions on security covering system level, login/authentication level with hands on lectures regarding object level, table and column level and row level security implementations. Indexing strategies, logical multi-tenancy with Orgs, monitoring and troubleshooting, and performance tuning round out the course.

Topics Covered:

• Users and Group Management
• Authentication Methods
• Local
• LDAP
• SAML
• Trusted Authentication
• Security
• System     
• Login
• Object Level
• Table and Column Level
• Row Level
• Monitoring and Troubleshooting
• Performance
• Logical Multi-tenancy with Orgs
• Indexing

ThoughtSpot Advanced Data Modeling - 2.5 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