Book Image

TIBCO Spotfire: A Comprehensive Primer

By : Michael Phillips
Book Image

TIBCO Spotfire: A Comprehensive Primer

By: Michael Phillips

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
TIBCO Spotfire: A Comprehensive Primer
Michael Phillips
Feb, 2015 | 348 pages
No titles found
Table of Contents (18 chapters)
TIBCO Spotfire – A Comprehensive Primer
TIBCO Spotfire – A Comprehensive Primer
Credits
Credits
Foreword
Foreword
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Show Me the Data
Show Me the Data
Adding data to Spotfire from files
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
Connecting to a database
Key data concept – data queries
Summary
2
Visualize This!
Visualize This!
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
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
Summary
3
Analyze That!
Analyze That!
Framing your analysis using text areas
Key Spotfire concept – document properties
Increasing interactivity using property controls
Providing summary information at a glance
Customizing the filter panel
Getting details of marked items
Annotating data using tags and lists
Creating analysis snapshots using bookmarks
Summary
4
The Big Wide World of Spotfire
The Big Wide World of Spotfire
An overview of Spotfire components and architecture
A quick guide to Administration Manager
Using the Library Administration interface
A quick tour of Information Designer
An overview of Spotfire Analyst (formerly Professional Client)
An overview of Spotfire Consumer (formerly web player)
An overview of Spotfire Business Author (new with Version 6.5)
Automating tasks using Automation Services
An overview of system monitoring tools
Summary
5
Source Data is Never Enough
Source Data is Never Enough
Creating metrics using calculated columns
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
Merging data from multiple sources
Key data concept – narrow tables versus wide tables
Transforming data structure through pivots and unpivots
Using Spotfire's Information Designer
Optimizing complex data manipulations using in-database analytics
Summary
6
The World is Your Visualization
The World is Your Visualization
Applying custom expressions directly to visualization properties
Key Spotfire concept – 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
Visualizing categorical information and trends together in combination charts
Visualizing statistical measures using box and whisker plots
Summarizing statistical measures using summary tables
Visualizing complex multidimensional data using heat maps
Profiling your data using parallel coordinate plots
Exporting and publishing data and visualizations
Summary
7
What's Your Location?
What's Your Location?
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
Incorporating and using a feature layer
Adding Web Map Service data to a map chart
Using the map chart for nongeographic spatial analysis
Summary
8
The Secret Life of Python
The Secret Life of Python
Introduction to IronPython
Overview of the Spotfire API
Some useful external libraries
Creating scripts
Referencing and manipulating the primary elements in an analysis file
How to manipulate visualization properties
How to manipulate color
How to manipulate filters
Manipulating data already loaded into Spotfire
How to add data to an analysis
Summary
9
It's All About Self-service These Days
It's All About Self-service These Days
Building a guided analysis
Key data concept – metadata
Incorporating configurable business rules into your analysis
A metadata-driven self-service analytics case study
Summary
10
Beyond the Horizon
Beyond the Horizon
TIBCO Enterprise Runtime for R (TERR)
JavaScript
Mobile Metrics
Event analytics
Spotfire data connectors
TIBCO Spotfire Advanced Data Services
Summary
Index
Index

Key Spotfire concept – filters

You should have noticed by now the filter panel on the right-hand side of each page. By default, every column, or variable, in the data tables in the analysis file is represented in the filter panel by a filter. Each of those filters contains every value in the data for the respective column.

There are six filter types to cover the range and extent of the data that can be encountered.

Filter Type

Good for

Range filter

Allows you to filter a range of values. Very good for columns with large, continuous sets of numerical data or dates.

Item filter

Like the range filter, it uses a slider, allowing you to select one value at a time, including All and None. Can be used for small and medium lists of text values or discrete number sets (integers rather than decimals).

Check box filter

Allows you to select one or multiple values by checking or unchecking a box. Good for relatively small sets of text values or integer number sets.

Radio button filter

Similar...

Previous Section
End of Section 11
Next Section