Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

TIBCO Spotfire Analyst - Advanced Calculations

( Duration: 3 Days )

The TIBCO Spotfire Analyst - Advanced Calculations training course teaches the concepts required to effectively utilize the broad array of computational features available in the TIBCO Spotfire Analyst client. Learn about the computational capabilities which can be executed from within the TIBCO Spotfire Analyst environment. These include calculated columns, custom expressions, curve fitting, curve drawing, executing statistical code on TIBCO Enterprise Runtime for R (TERR), or external engines such as S+, R, SAS, or MATLAB. In addition, you will learn to discover and evaluate data relationships, as well as generate predictive models or apply computational multivariate data analysis tools such as similarity calculations or clustering techniques.

By attending TIBCO Spotfire Analyst - Advanced Calculations workshop, delegates will learn to:

  • Explain Spotfire expressions and define custom expressions
  • Review purpose and usage statististical engines
  • Use TERR functions with Spotfire expressions
  • Recognize features of relationships and predictions
  • Add horizontal and vertical lines to visualizations
  • Examine relationships between numerical and categorical columns
  • Build and share predictive modelsPerform multivariate data analysis
  • Demonstrate K-means clustering and hierarchical clustering

  • Attend TIBCO Spotfire Analyst training or equivalent experience

Power Users & Analysts who need to use customized expressions, curve fitting, predictive modeling, R statistical code, data functions, or multivariate data analysis tools in order to extend analysis capabilities.

COURSE AGENDA

1

Spotfire Expressions

  • Spotfire Expressions Overview
  • Introduction to Spotfire Expressions
  • Including OVER in Calculated Columns
  • Including OVER in Custom Expressions
  • Collect Property Values for Expressions
  • Use Property Controls to Select Custom Expressions
  • Functions for Use in Expressions:
    • Binning Functions
    • Conversion Functions
    • Date and Time Functions
    • Logical Functions
    • Math Functions
    • Operators
    • OVER Functions
    • Property Functions
    • Ranking Functions
    • Spatial Functions
    • Statistical Functions
    • Text Functions
  • Understand Expression Shortcuts :
    • Cumulative Sum
    • Moving Average
    • Difference
    • % of Total
    • Year to Date Total
    • Change
    • CAGR
    • Year to Date Growth
  • Performing Calculations Across Data Tables
  • Defining Categorical Variables and Hierarchy Levels in Expressions
  • Build Expressions and Understand Expression Syntax
2

Statistical Engines

  • Statistical Engines Overview
  • Execute TERR Functions within Spotfire Expressions
  • Remove Replicates Using a TERR Expression
  • Register and Run Data Functions
  • Data Function Properties - Online vs Offline
  • Using Sample Data Functions
  • Data Functions Review
3

Relationships & Predictions

  • Relationships & Predictions Overview
  • Apply Horizontal or Vertical Lines to Visualizations
  • Apply Curve Fit Algorithms to Visualizations
  • Calculate IC50 Values Using Logistic Regression
  • Options to Draw Lines on Visualizations
  • Perform LOWESS smoothing with TERR
  • Draw regression line confidence intervals with TERR
  • Forecast Values Using the Holt-Winters Method
  • Discover Relationships Between Numerical vs. Numerical Columns
  • Discover Relationships Between Numerical vs. Categorical Columns
  • Discover Relationships Between Categorical vs. Categorical Columns
  • Use Regression Modeling to Predict Numerical Values
  • Use Classification Modeling to Predict Categorical Assignments
  • Save and Share Predictive Models Across Analyses
4

Multivariate Data Analysis

  • Multivariate Data Analysis Overview
  • Visualizing Multivariate Data
  • Apply Line Similarity to Isolate Patterns of Interest
  • Apply K-means Clustering to Group Similar Lines
  • Cluster Stock Data Collected Over Time
  • Apply Hierarchical Clustering to Organize Multivariate Data
  • Interpreting and Interacting with Dendrograms
  • A Quick Review of Hierarchical Clustering
  • Performing Principal Component Analysis Using TERR
  • Normalizing Data in Preparation for Computational Multivariate Data Analysis
  • Consider Empty Values when Applying Computational Multivariate Data Analysis

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X