Book Image

TIBCO Spotfire: A Comprehensive Primer. - Second Edition

By : Andrew Berridge, Michael Phillips

Book Image

TIBCO Spotfire: A Comprehensive Primer. - Second Edition

By: Andrew Berridge, Michael Phillips

Overview of this book

The need for agile business intelligence (BI) is growing daily, and TIBCO Spotfire® combines self-service features with essential enterprise governance and scaling capabilities to provide best-practice analytics solutions. Spotfire is easy and intuitive to use and is a rewarding environment for all BI users and analytics developers. Starting with data and visualization concepts, this book takes you on a journey through increasingly advanced topics to help you work toward becoming a professional analytics solution provider. Examples of analyzing real-world data are used to illustrate how to work with Spotfire. Once you've covered the AI-driven recommendations engine, you'll move on to understanding Spotfire's rich suite of visualizations and when, why and how you should use each of them. In later chapters, you'll work with location analytics, advanced analytics using TIBCO Enterprise Runtime for R®, how to decide whether to use in-database or in-memory analytics, and how to work with streaming (live) data in Spotfire. You'll also explore key product integrations that significantly enhance Spotfire's capabilities.This book will enable you to exploit the advantages of the Spotfire serve topology and learn how to make practical use of scheduling and routing rules. By the end of this book, you will have learned how to build and use powerful analytics dashboards and applications, perform spatial analytics, and be able to administer your Spotfire environment efficiently

Preface

Who this book is for

What this book covers

To get the most out of this book

Free Chapter

Section 1: Introducing Spotfire

Section 1: Introducing Spotfire

Welcome to Spotfire

Welcome to Spotfire

Getting started with TIBCO Spotfire

Getting started with loading data

Introduction to the data panel

Saving Spotfire files

Producing a useful interactive dashboard

It's All About the Data

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

Displaying information quickly in tabular form

Enriching visualizations with color categorization

Visualizing hierarchical data using treemaps

Impactful Dashboards!

Impactful Dashboards!

Enabling end users to configure the KPI chart interactively

Drilling in to the KPI chart

Deep dive – what insights can the dashboard reveal?

Publishing the dashboard to Spotfire Web

Sharing Insights and Collaborating with Others

Sharing Insights and Collaborating with Others

Section 2: Spotfire In Depth

Section 2: Spotfire In Depth

Practical Applications of Spotfire Visualizations

Practical Applications of Spotfire Visualizations

Combination charts

Waterfall charts

Graphical tables

Taking action from KPI charts or graphical tables

Other visualization types

The Big Wide World of Spotfire

The Big Wide World of Spotfire

An overview of the Spotfire platform

Spotfire Web Player scalability

A quick guide to administration manager

Using the library administration interface

Automating tasks using Automation Services

The Spotfire administration console

Source Data is Never Enough

Source Data is Never Enough

Technical requirements

Creating metrics using calculated columns

Categorizing continuous numerical data using binning functions

Slicing and dicing data using hierarchy nodes

Other calculations in Spotfire

Data manipulation – where, why, and how?

Merging (joining) data from multiple sources

Tall tables versus wide tables

Transforming data structure through pivots and unpivots

Other transformations

The World is Your Visualization

The World is Your Visualization

Data relations (between 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

Visualizing categorical information and trends together in combination charts

Visualizing complex multidimensional data using heat maps

Profiling your data using parallel coordinate plots

What's Your Location?

What's Your Location?

Map chart layers

Getting started with map charts

Coordinate reference systems

Using geocoding to position data on a map

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

TIBCO GeoAnalytics

Section 3: Databases, Scripting, and Scaling Spotfire

Section 3: Databases, Scripting, and Scaling Spotfire

Information Links and Data Connectors

Information Links and Data Connectors

In-memory versus in-database analytics

Information links

Data connectors

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

Scripting, Advanced Analytics, and Extensions

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

TIBCO Enterprise Runtime for R and open source R

Python in Spotfire

Statistica and Spotfire

Extending Spotfire

The JavaScript API

Spotfire Server APIs

Scaling the Infrastructure; Keeping Data up to Date

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 Web Player scaling

Triggering an update from an external system

Notes on scheduling and routing

Beyond the Horizon

Beyond the Horizon

Natural language search

Canvas styling and theming

Exporting from Spotfire

JavaScript visualizations

Alerting in Spotfire

TIBCO Data Virtualization

TIBCO Data Science

KNIME and Spotfire

TIBCO StreamBase and Spotfire Data Streams

TIBCO Spotfire Cloud Enterprise

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Deep dive – what insights can the dashboard reveal?

I expect that some stocks may be more volatile than others and some may grow better than others. Please note that, as I am writing this, I do not know what insights I am going to uncover ahead of time—you are following me live as I use the power of Spotfire to find fresh insights in the data:

Try clicking on some individual KPI tiles—notice that the line chart will update to show details for the data that corresponds to the KPI that has been clicked. The line chart shows the detailed trend of the KPI over time.
What if you want to view multiple KPI tiles at the same time? Most Spotfire visualizations support click-and-drag marking, where you mark an area on the chart to show the details underneath the area that's been marked. The KPI chart works slightly differently.

Hold the Shift key on your keyboard...