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
Table of Contents (18 chapters)
Free Chapter
1
Section 1: Introducing Spotfire
6
Section 2: Spotfire In Depth
12
Section 3: Databases, Scripting, and Scaling Spotfire

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

There are some important points to be aware of with external data. I'll list the main ones briefly here for quick reference:

  • The recommendations engine does not operate on external data, so you'll need to build all your visualizations manually.
  • You cannot send external data to a data function—it is far better to use data on demand and use that as a data source for a data function.
  • Filters are not created by default—you can create them on individual columns by clicking on the filter icon on a column in the data panel and creating the filter.
  • If you are using a table plot to show external data, you MUST define a primary key on the data table. This is because Spotfire needs to have a unique identifier on the data in order to be able to identify the rows in the data source.
  • You can't use box plots...