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

Categorizing continuous numerical data using binning functions

You can also create custom columns in Spotfire through binning. Chapter 1, Welcome to Spotfire, introduced the concept of binning numerical values. You can do the same for calculated columns. Create binned columns from the Data menu—just choose Add binned column. A binned column is just a way to turn a continuous set of values—usually numeric, but not always—into a set of discrete (categorical) values or bins.

Recall that the age column from the Titanic data was binned in Chapter 1, Welcome to Spotfire. Adding a binned column gives you access to a much richer way of binning a column rather than right-clicking on an axis selector and choosing Auto-bin Column. However, please remember that the calculated column will not respond to filtering (this is so important that I feel the need to repeat it...