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

TIBCO Spotfire Advanced Data Services

We're going to finish this chapter with a look at TIBCO Spotfire Advanced Data Services, which is an on-demand data integration service that allows you to create aggregated and mashed-up views of business objects from multiple source applications and deliver those views directly to Spotfire users or via the information and library services on the Spotfire server. The resulting data views are well suited for self-service visual data discovery.

In addition to all the standard database connections and specialized data connectors supported by Spotfire, Advanced Data Services can also connect to database applications such as Oracle E-Business Suite, Salesforce.com, SAP BW, SAP ERP, and Siebel CRM, as well as other applications through web services APIs.

Data delivery

The Advanced Data Services platform supports multiple data delivery mechanisms: SQL (ODBC and JDBC), web services (HTTP, SOAP, and JSON), messaging (JMS), URIs, Java, and application APIs.

Caching...

Previous Section
End of Section 7
Next Section