Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

TIBCO Spotfire: A Comprehensive Primer

By : Phillips

4.1 (15)

TIBCO Spotfire: A Comprehensive Primer

4.1 (15)

By: Phillips

Overview of this book

If you are a business user or data professional, this book will give you a solid grounding in the use of TIBCO Spotfire. This book assumes no prior knowledge of Spotfire or even basic data and visualization concepts.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Show Me the Data

1. 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!

2. 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!

3. 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

4. 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

5. 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

6. 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?

7. 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

8. 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

9. 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

10. 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

Creating metrics using calculated columns

Probably the most fundamental and useful data manipulation tool provided by Spotfire is the ability to create calculated columns in imported data tables. A calculated column is created by writing an expression that references other columns in the table, documents property values, and values that you supply, or hard code. The expression can be a simple piece of arithmetic, such as dividing one column by another to get a proportion, or a more complex piece of conditional logic. Once created, a calculated column can be used exactly like any other column.

Basic metric

Let's work through an example by looking at two key metrics of batting performance in baseball: the on base percentage (OBP), which is essentially how often a batter reaches base, and the walk-to-strikeout ratio (BB/K), which is a measure of a hitter's plate discipline.

The data we will use here is BaseballPlayerData.xls, which you can download from http://www.insidespotfire.com...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

TIBCO Spotfire: A Comprehensive Primer

Search

Your notes and bookmarks