TIBCO Spotfire – A Comprehensive Primer
eBook - ePub

TIBCO Spotfire – A Comprehensive Primer

Michael Phillips

Share book
  1. 348 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

TIBCO Spotfire – A Comprehensive Primer

Michael Phillips

Book details
Book preview
Table of contents
Citations

About This Book

About This Book

  • Learn how easy it can be to use text areas, property controls, and python scripts to create polished, professional Spotfire applications
  • Become more informed about self-service analytics and contribute to community dialogue on best-practice approaches to the empowerment of self-service business intelligence
  • Follow this step-by-step guide packed with real-world examples on how to use data and visualization techniques to build insightful and interactive analyses with Spotfire

Who This Book Is For

If you are a business user or data professional, this book will give you a solid grounding in the use of TIBCO Spotfire. This book assumes no prior knowledge of Spotfire or even basic data and visualization concepts.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is TIBCO Spotfire – A Comprehensive Primer an online PDF/ePUB?
Yes, you can access TIBCO Spotfire – A Comprehensive Primer by Michael Phillips in PDF and/or ePUB format, as well as other popular books in Business & Business Intelligence. We have over one million books available in our catalogue for you to explore.

Information

Year
2015
ISBN
9781782176411

TIBCO Spotfire – A Comprehensive Primer


Table of Contents

TIBCO Spotfire – A Comprehensive Primer
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Show Me the Data
Adding data to Spotfire from files
Importing a Microsoft Excel spreadsheet into Spotfire
Importing a text file into Spotfire
Importing other file types into Spotfire
Key data concept – basic row/column structure of a data table
Key data concept – data types
Using the inbuilt filters in Spotfire
Key data concept – data relationships
How to link data in Spotfire
How to relate two tables
Column matching
Connecting to a database
Using ODBC
How to set up an ODBC connection in Microsoft Windows 7
Using an ODBC connection in Spotfire
Key data concept – data queries
Anatomy of a SQL statement
Summary
2. Visualize This!
Displaying information quickly in tabular form
Enriching your visualizations with color categorization
Visualizing categorical information using bar charts
Dividing a visualization across a trellis grid
Key Spotfire concept – marking
How to change the marking color
How to set the marking behavior of a visualization
Visualizing trends using line charts
Visualizing proportions using pie charts
Visualizing relationships using scatter plots
Visualizing hierarchical relationships using treemaps
Key Spotfire concept – filters
Enhancing tabular presentations using graphical tables
Summary
3. Analyze That!
Framing your analysis using text areas
Key Spotfire concept – document properties
Increasing interactivity using property controls
Providing summary information at a glance
Customizing the filter panel
Getting details of marked items
Annotating data using tags and lists
Using lists
Using tags
Creating analysis snapshots using bookmarks
Summary
4. The Big Wide World of Spotfire
An overview of Spotfire components and architecture
A quick guide to Administration Manager
Users
Groups and Licenses
Preferences
Using the Library Administration interface
Folder permissions
Import and Export
A quick tour of Information Designer
Data Source
Columns
Join
Filter
Procedure
Information Links
An overview of Spotfire Analyst (formerly Professional Client)
An overview of Spotfire Consumer (formerly web player)
An overview of Spotfire Business Author (new with Version 6.5)
Automating tasks using Automation Services
Running Automation Services jobs
An overview of system monitoring tools
Spotfire 6.5
Summary
5. Source Data is Never Enough
Creating metrics using calculated columns
Basic metric
Dynamic metric
Using the Data Panel tool
Key data concept – dimensional hierarchies
Adding dimensionality to your data by defining hierarchies
Categorizing continuous numerical data using binning functions
Slicing and dicing data using hierarchy nodes
LastPeriods
Parent
PreviousPeriod
ParallelPeriod
NavigatePeriod
Intersect
Merging data from multiple sources
Insert columns
Insert rows
Key data concept – narrow tables versus wide tables
Transforming data structure through pivots and unpivots
Unpivot
Pivot
Using Spotfire's Information Designer
Building an information link to multiple source data tables
Building an information link that writes data back to a database
Optimizing complex data manipulations using in-database analytics
Selecting data for a data connection
Creating in-database views
Summary
6. The World is Your Visualization
Applying custom expressions directly to visualization properties
Key Spotfire concept – difference between calculated columns and custom expressions
Annotating visualizations with reference lines, fitted curves, and error bars
Error bars
Defining color rules and organizing document color schemes
Slicing and dicing visualizations using hierarchy nodes
Mashing up data from different tables in a single visualization
How to create dynamic pivots using cross tables
Pivot aggregations
Cross tabulation
Visualizing categorical information and trends together in combination charts
Visualizing statistical measures using box and whisker plots
Summarizing statistical measures using summary tables
Visualizing complex multidimensional data using heat maps
Heat maps
Dendrograms
Profiling your data using parallel coordinate plots
Exporting and publishing data and visualizations
Summary
7. What's Your Location?
Creating background map layers
Key Spotfire concept: map chart layers
Key mapping concept – coordinate reference systems
Using automatic geoco...

Table of contents