Tibco Spotfire Online Training

Home / Tibco Spotfire Online Training

TIBCO SPOTFIRE COURSE

Duration: 4-5 Weeks

Reporting Concepts

  • Slicing and dicing measures
  • Measure breakup along dimensions
  • Measure / Value axis
  • Dimension / Category / Discrete axis
  • Popular chart types and it uses
  • Traditional reporting v/s new age reporting

Datawarehousing Concepts

  • ETL
  • Measures & Dimensions
  • Continous & Discrete Values
  • OLTP vs Dimension Model
  • Star schema
  • Snowflake schema

Dashboarding concepts

  • Architecture
  • Filters

Data visualization best practices

  • When to use a bar chart
  • How to show trends (Line chart)
  • Compare between 2 measures

Loading data into Spotfire

  • Files
  • Clipboard
  • Database
  • Information Links

Joining multiple data tables

  • Managing relations
  • Filtering in relations
  • Include filtered rows only
  • Exclude filtered rows out
  • Ignore filtering

Load-time transformations

  • Pivot
  • UnPivot
  • Calculate new columns
  • Rename the column
  • Change data type

Replacing data table

Reloading data

 

Datatable properties

  • Embedded in Analysis
  • Linked to Source
  • Refreshing data

Column properties

  • Calculated columns
  • Hierachies
  • Column binning
  • Sort Order
  • Properties
  • Formatting

Visualizations

  • Table
  • Cross table
  • Bar chart
  • Horizontal
  • Vertical
  • Side-by-side
  • Stacked
  • 100% stacked
  • One axis with single scale
  • Multiple axis
  • Pie chart
  • Graphical Table
  • Treemap
  • Map chart
  • Box plot
  • Combination chart
  • Line chart
  • Scatter plot
  • Summary table
  • Heat map
  • 3D scatter plot

Visualization properties

  • Data table
  • Marking
  • Detailed visualization
  • Data limiting using expressions
  • Axis selectors
  • Using custom expressions
  • Axes
  • X axis
  • Y Axis

[/ezcol_1half]

  • Colour-by axis
  • Size axis
  • Shape axis
  • Area axis
  • Trellis
  • Legend
  • Lines & curves
  • Tooltip
  • Formatting
  • Sorting
  • Ranking
  • Show only Top-n records
  • Filtering Scheme
  • Ranking

Colouring schemas

Filters

  • Types of filters
  • Radio
  • Checkbox
  • List
  • Text
  • Item
  • Range
  • Organizing filters

Page navigation

  • Titled tabs
  • Step-by-step
  • History Arrows

Text area

  • Document properties
  • Axis selector using document properties
  • Chaning colour by axis using document properties
  • Changing data limiting of a visualization using document properties
  • Creating custom filters
  • Inserting dynamic Item
  • Sparkline
  • Calculated value
  • Icon
  • Bullet graph
  • Insert Property Controls
  • Label
  • Input field
  • Input field (multiple lines)
  • Drop down list
  • List box
  • List box (multiple select)
  • Slider
  • Inserting Action controls
  • Actions
  • Script
  • Bookmarks
  • Normal bookmarks
  • Special bookmarks
  • Public & private bookmarks
  • Inserting web links
  • Inserting pictures

Insert External Data

  • Rows
  • Columns

Over expressions

  • Simulating group by as in SQL
  • Comparing values on X axis over time periods

Spotfire Server

  • Managing library
  • Managing users
  • Publishing dashboads
  • Web player

Information Designer

  • Information Link
  • Loading Data-on-demand
  • Columns
  • Filter
  • Joins
  • Parameters
  • Editing SQL
  • Implementing data security
  • Personalized Information Link
  • Parameterized Information Link