This course builds upon the concepts developed in Spotfire Analyst Essentials I. Learn how to add data to an existing data table or add new data tables to a existing Spotfire analysis. Understand the difference between in-memory data and in-database data. Learn how to form connections to cube and relational database data sources. Manipulate existing data columns and learn about the remaining visualization types. Understand the various aggregations options and consider tools for capturing specific aspects of a dynamic analysis.

Audience: Ad-hoc users who perform analyses by loading data, configuring visualizations and applying analysis capabilities for their own use
Course Duration: 2 days
Prerequisites:

Students should take Spotfire Analyst Essentials I prior to participating in this course.

Course Outline:
  • Add Data
    • Insert Calculated Columns
    • Learn About the Expressions Dialog and Find Available Functions
    • Learn How to Bin Continuous Data into Categorical Groupings
    • Configure Custom Hierarchies
    • Search and Select Using Hierarchy Filters
    • Insert Columns or Rows from External Sources
    • Add New Data Tables to an Existing Analysis
    • Understand Column Matches
    • Configure Visualizations Based on More Than One Data Table
    • Configure Relations Between Data Tables
    • Mark & Filter Across Data Tables
    • Perform Multi-Step Data Transformations
    • Learn how to Pivot and Unpivot Data
    • Consider Differences Between In-Memory and In-Database Data
    • Connect to Cube Databases
    • Connect to Relational Databases and Establish New Relations
    • Working with In-Database Data
    • Import Relational Database Data as In-Memory Data Tables

 

  • Capture Your Analysis
    • Add and Apply Bookmarks
    • Understand Aspects Captured in a Bookmark
    • Capture or Apply Select Bookmark Aspects
    • Create and Apply Tags
    • Define Key Columns for Tags, Bookmarks and Marked Data
    • Extract Lists of Values and Apply in Other Analysis Sessions
    • Compare Lists using List Logic, Organize Lists, and Add Annotations

 

  • Other Visualizations
    • Configure and Interpret Treemaps to Analyze Hierarchical Data
    • Configure and Interpret Box Plots to Examine Data Distribution
    • Understand and Apply Comparison Circles
    • Configure and Interpret Map Charts
    • Navigate to Data of Interest in Map Charts
    • Represent Data on a Map & Position w/ Coordinates or Geocoding
    • Understand Different Map Layer Options
    • View WMS Layers in Map Charts
    • Select From Different Coordinate Reference Systems
    • Configure Zoom Visibility for Each Map Layer
    • Use a Map Chart to Display Your Data on Positions Over Any Image
    • Consider Multivariate Data
    • Configure and Interpret 3D Scatter Plots
    • Configure and Interpret Parallel Coordinate Plots
    • Configure and Interpret Heat Maps

 

  • Aggregation Options
    • Why Aggregate Data on Visualizations?
    • Understand the Purpose of Available Aggregation Categories
    • Learn How to Apply Expression Shortcuts
    • Add Error Bars to Visualizations