TIBCO Spotfire – A Comprehensive Primer

Michael Phillips

• Verlag: Packt Publishing
• Jahr: 2015
• ISBN:
  9781782176411
• Thema: Business
• Thema: Business Intelligence

About This Book

• Learn how easy it can be to use text areas, property controls, and python scripts to create polished, professional Spotfire applications
• Become more informed about self-service analytics and contribute to community dialogue on best-practice approaches to the empowerment of self-service business intelligence
• Follow this step-by-step guide packed with real-world examples on how to use data and visualization techniques to build insightful and interactive analyses with Spotfire

Who This Book Is For

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.

TIBCO Spotfire – A Comprehensive Primer

---

Table of Contents

TIBCO Spotfire – A Comprehensive Primer

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Downloading the color images of this book

Errata

Piracy

Questions

1. Show Me the Data

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 7

Using an ODBC connection in Spotfire

Key data concept – data queries

Anatomy of a SQL statement

Summary

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

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

Summary

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

Using lists

Using tags

Creating analysis snapshots using bookmarks

Summary

4. The Big Wide World of Spotfire

An overview of Spotfire components and architecture

A quick guide to Administration Manager

Users

Groups and Licenses

Preferences

Using the Library Administration interface

Folder permissions

Import and Export

A quick tour of Information Designer

Data Source

Columns

Join

Filter

Procedure

Information Links

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

Running Automation Services jobs

An overview of system monitoring tools

Spotfire 6.5

Summary

5. Source Data is Never Enough

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 views

Summary

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

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

Visualizing complex multidimensional data using heat maps

Heat maps

Dendrograms

Profiling your data using parallel coordinate plots

Exporting and publishing data and visualizations

Summary

7. What's Your Location?

Creating background map layers

Key Spotfire concept: map chart layers

Key mapping concept – coordinate reference systems

Using automatic geoco...