TIBCO Spotfire: A Comprehensive Primer电子书

Dedication

About Packt

Why subscribe?

Packt.com

Contributors

About the authors

About the reviewer

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the color images

Conventions used

Get in touch

Reviews

Section 1: Introducing Spotfire

Welcome to Spotfire

Getting started with TIBCO Spotfire

Launching Spotfire Analyst

Logging in to TIBCO Cloud Spotfire

Downloading Spotfire Cloud Analyst

Installing the mobile apps and logging in to TIBCO Cloud

TIBCO Spotfire for macOS

Logging in to the Spotfire web clients (on-premises)

Spotfire licenses

Getting started with loading data

Importing Excel spreadsheets into Spotfire

Introduction to the data panel

The Spotfire recommendations engine

Saving Spotfire files

Saving a file in analyst clients

Saving a file in Spotfire Cloud or Business Author

Producing a useful interactive dashboard

Coloring

Proportionality with bar charts and pie charts

Drilling in to the data – details visualizations

Insights from details visualizations

Using filters

Trellising

Summary

It's All About the Data

Technical requirements

Understanding the basic row/column structure of a data table

Exploring key data types

Building a scatter plot with real-world data

Gathering population data

Gathering country and region data

Combining the data

What is a scatter plot?

Building the scatter plot using population growth versus child mortality

Working with natural hierarchies in data

Gaining insight from the scatter plot

Displaying information quickly in tabular form

Enriching visualizations with color categorization

Visualizing hierarchical data using treemaps

Summary

Impactful Dashboards!

KPI charts

Constructing a KPI chart

Coloring, sorting, and other customization of the KPI chart

Enabling end users to configure the KPI chart interactively

Framing your analysis using text areas

Spotfire custom expressions

Spotfire document properties

Spotfire property controls

Bringing it all together – interactively configuring the KPI chart

Drilling in to the KPI chart

Marking in Spotfire

Building a details visualization using marking

Deep dive – what insights can the dashboard reveal?

Publishing the dashboard to Spotfire Web

Summary

Sharing Insights and Collaborating with Others

Bookmarks

Advanced topic – key columns

Annotations

Conversations

Summary

Section 2: Spotfire In Depth

Practical Applications of Spotfire Visualizations

Bar charts

Things to watch out for with bar charts

Bar chart summary

Combination charts

Cross tables

Cross table grand totals

Grand totals – underlying values versus sum of cell values

Underlying values

Sum of cell values

Cross table summary

Scatter plots

Line ordering

Density plots

Other types of visualization with scatter plots

Scatter plot summary

Line charts

Pie charts

Box plots

How to further interpret a box plot

More box plot options

Box plot summary

Treemaps

Waterfall charts

Graphical tables

Graphical table visualization types

Graphical table summary

Taking action from KPI charts or graphical tables

Other visualization types

Summary

The Big Wide World of Spotfire

An overview of the Spotfire platform

Spotfire server

Spotfire database

Nodes and services

Spotfire Web Player(s) and Business Author

Spotfire Automation Services

Spotfire Analyst clients and mobile clients

Spotfire Statistics Services

Spotfire Web Player scalability

A quick guide to administration manager

Users

Groups and licenses

Special user groups

Preferences

Using the library administration interface

Folder permissions

Import and export

Automating tasks using Automation Services

Running Automation Services jobs

The Spotfire administration console

Analytics

Library

Users and groups

Scheduling and routing

Nodes and services

Deployments and packages

Monitoring and diagnostics

Automation Services

Summary

Source Data is Never Enough

Technical requirements

Creating metrics using calculated columns

Basic metric

Dynamic metric

Categorizing continuous numerical data using binning functions

Slicing and dicing data using hierarchy nodes

LastPeriods

PreviousPeriod

ParallelPeriod

NavigatePeriod

AllPrevious and AllNext

Previous and next

Intersect

Over methods in calculated columns versus axis expressions

Over method summary

Other calculations in Spotfire

Data manipulation – where, why, and how?

Merging (joining) data from multiple sources

Tall tables versus wide tables

Tall tables

Wide tables

Transforming data structure through pivots and unpivots

Unpivot

Pivot

Other transformations

Summary

The World is Your Visualization

Data relations (between tables)

Setting up relationships between data tables

Configuring marking and filtering between related data tables

Mashing up data from different tables in a single visualization

Comparing subsets of data

Showing/hiding items of data

Annotating visualizations with reference lines, fitted curves, and error bars

Fitted curves

Forecasting

Error bars

Visualizing categorical information and trends together in combination charts

Visualizing complex multidimensional data using heat maps

Heat maps

Dendrograms

Profiling your data using parallel coordinate plots

Summary

What's Your Location?

Map chart layers

Getting started with map charts

Coordinate reference systems

Using geocoding to position data on a map

Geocoding using a zip code

Case study – when geocoding doesn't work

Feature layers

Using a data function to assist with geocoding

Adding Web Map Service data to a map chart

Creating custom maps using Tile Map Service layers

Using the map chart for non-geographic spatial analysis

Mapping an airport

Process mapping using a map chart

TIBCO GeoAnalytics

Summary

Section 3: Databases, Scripting, and Scaling Spotfire

Information Links and Data Connectors

In-memory versus in-database analytics

Information links

Data sources

Column

Joins

Filters

Procedures

Information links

Loading data from an information link

Writing back to a database using an information link

Data connectors

Loading data from a connector

Using data on demand to retrieve raw data

Troubleshooting data on demand

Custom expressions with in-database data

Important points to note with in-database (external) data

Connection credentials for Web Player users and Automation Services jobs

Saving connections to the Spotfire library

Streaming data

Summary

Scripting, Advanced Analytics, and Extensions

Scripting in Spotfire – the why, how, and what

Automating actions using IronPython

Customizing the Spotfire user interface using JavaScript and HTML in text areas

Spotfire Developer Tools

Script trust

TIBCO Enterprise Runtime for R and open source R

Python in Spotfire

Statistica and Spotfire

Extending Spotfire

The JavaScript API

Spotfire Server APIs

Summary

Scaling the Infrastructure; Keeping Data up to Date

Context-aware load management with scheduling and routing

Some definitions

Server topology

Scaling the Spotfire Server using clustering

Spotfire Sites

Spotfire Web Player scaling

Nodes, services, and resource pools

Spotfire Web Player scalability – Scheduling & Routing

Routing rules – definitions

File

Group

User

Routing rules – practical examples

Scenario 1 – manufacturing sensor data analysis

Scenario 2 – separating critical functions and everyday operations

Verifying the example rules and schedules

Checking the schedule

Checking the routing rules for the scenarios

Triggering an update from an external system

Notes on scheduling and routing

Summary

Beyond the Horizon

Natural language search

Canvas styling and theming

Exporting from Spotfire

Visualization export

Exporting data to a file or a library

PDF export

JavaScript visualizations

Alerting in Spotfire

TIBCO Data Virtualization

TIBCO Data Science

KNIME and Spotfire

TIBCO StreamBase and Spotfire Data Streams

TIBCO Spotfire Cloud Enterprise

Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think