Tibco Spotfire Training

  • Installing Spotfire: Learn an end-to-end procedure of installing Spotfire, configure, and deploy the TIBCO Spotfire
  • Dealing and Visualizing the Data: Learn how to visualize the data by adding to Spotfire and connect to a database with examples
  • Analysing the Data: Learn to analyse data using text areas, customize filters, tags, and lists to identify new markets
  • Deployment and Automation Services: Get introduced to Spotfire architecture and various automation services to deploy to the customers
  • Data Preparation: Learn to manipulate and analyse the raw data into the appropriate one for further processing
  • Techniques to Visualize Data: Understand different ways to modify visualization techniques and implement them to create charts
  • Location-based visualization: Understand how to create maps charts based on location and for non-geographic spatial analysis

5 Days

Knowledge of basic DWH Concepts

  • Adding data to Spotfire from files
  • Importing a Microsoft Excel spreadsheet into Spotfire Importing a text file into Spotfire
  • Importing other file types into Spotfire
  • Key data concept – basic row/column structure of a data table
  • Key data concept – data types
  • Using the inbuilt filters in Spotfire
  • Key data concept – data relationships
  • How to link data in Spotfire
  • How to relate two tables Column matching
  • Connecting to a database Using ODBC
  • How to set up an ODBC connection in Microsoft Windows Using an ODBC connection in Spotfire
  • Key data concept – data queries
  • Anatomy of a SQL statement
  • Displaying information quickly in tabular form
  • Enriching your visualizations with color categorization Visualizing categorical information using bar charts Dividing a visualization across a trellis grid
  • Key Spotfire concept – marking
  • How to change the marking color
  • How to set the marking behavior of a visualization Visualizing trends using line charts
  • Visualizing proportions using pie charts
  • Visualizing relationships using scatter plots
  • Visualizing hierarchical relationships using treemaps
  • Key Spotfire concept – filters
  • Enhancing tabular presentations using graphical tables
  • Creating metrics using calculated columns
  • Basic metric
  • Dynamic metric
  • Using the Data Panel tool
  • Key data concept – dimensional hierarchies
  • Adding dimensionality to your data by defining hierarchies Categorizing continuous numerical data using binning functions
  • Slicing and dicing data using hierarchy nodes
  • LastPeriods
  • Parent
  • PreviousPeriod
  • ParallelPeriod
  • NavigatePeriod
  • Intersect
  • Merging data from multiple sources Insert columns
  • Insert rows
  • Key data concept – narrow tables versus wide tables Transforming data structure through pivots and unpivots
  • Unpivot
  • Pivot
  • Using Spotfire’s Information Designer
  • Building an information link to multiple source data tables Building an information link that writes data back to a database
  • Optimizing complex data manipulations using in-database analytics
  • Selecting data for a data connection
  • Creating in-database
  • Applying custom expressions directly to visualization properties
  • Difference between calculated columns and custom expressions
  • Annotating visualizations with reference lines, fitted curves, and error bars
  • Defining color rules and organizing document color schemes
  • Slicing and dicing visualizations using hierarchy nodes
  • Mashing up data from different tables in a single visualization
  • How to create dynamic pivots using cross tables
  • Pivot aggregations Cross tabulation
  • Visualizing categorical information and trends together in combination charts
  • Visualizing statistical measures using box and whisker plots
  • Summarizing statistical measures using summary tables
  • Heat maps
  • Dendrograms

Exporting and publishing data and visualizations

 

Location based analytics

  • Creating background map layers
  • Key Spotfire concept: map chart layers
  • Key mapping concept – coordinate reference systems
  • Using automatic geocoding to accurately position locations from your data on a map
  • Geocoding
  • Coordinate columns
  • Incorporating and using a feature layer Geographic drill-down
  • Using the map chart for non-geographic spatial analysis
  • Introduction to iron Python
  • Control Structures
  • Libraries
  • Lists
  • Functions
  • Object orientations
  • Over view of the SpotFire API
  • Creating Scripts
  • Referencing and Manipulating the Primary Elements in an
  • Analysis File
  • How to manipulate visualization properties
  • Manipulating Data already loaded in Spotfire
  • How to add data to an analysis
  • How to Use TERR Tools
  • TERR Tools – Details on Engine
  • TERR Tools – Details on Package Management
  • Configure R Studio to use TERR
  • Run the TIBCO Enterprise Runtime for R console
  • Package management in TIBCO Enterprise Runtime for R
  • Command line options for TIBCO Enterprise Runtime for R
  • Move data between TIBCO Enterprise Runtime for R and open-source R
  • Accessing TIBCO Enterprise Runtime for R directly from Spotfire