TIBCO Spotfire: A Comprehensive Primer

Cover
Title Page
Copyright and Credits
Dedication
About Packt
Contributors
Table of Contents
Preface
Section 1: Introducing Spotfire
Chapter 1: 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
Chapter 2: 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
Chapter 3: 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
Chapter 4: Sharing Insights and Collaborating with Others
	Bookmarks
		Advanced topic – key columns
	Annotations
	Conversations
	Summary
Section 2: Spotfire In Depth
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: 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
Chapter 10: 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
Chapter 11: 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
Chapter 12: 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
Chapter 13: 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
Index