Overview of Tibco Spotfire
- Installing Spotfire: Learn an end-to-end procedure of installing Spotfire, configure, and deploy the TIBCO Spotfire
- Dealing and Visualizing the Data: Learn how to visualize the data by adding to Spotfire and connect to a database with examples
- Analysing the Data: Learn to analyse data using text areas, customize filters, tags, and lists to identify new markets
- Deployment and Automation Services: Get introduced to Spotfire architecture and various automation services to deploy to the customers
- Data Preparation: Learn to manipulate and analyse the raw data into the appropriate one for further processing
- Techniques to Visualize Data: Understand different ways to modify visualization techniques and implement them to create charts
- Location-based visualization: Understand how to create maps charts based on location and for non-geographic spatial analysis
Duration
5 Days
Prerequisite for Tibco Spotfire
Knowledge of basic DWH Concepts
Course Outline for Tibco Spotfire
Loading data into spotfire
- 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 Using an ODBC connection in Spotfire
- Key data concept – data queries
- Anatomy of a SQL statement
Visualizing Your Data into Views
- 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
Transforming source data with ETL Layer
- 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
The World is your visualization
- Applying custom expressions directly to visualization properties
- Difference between calculated columns and custom expressions
- Annotating visualizations with reference lines, fitted curves, and 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
- Heat maps
- Dendrograms
Profiling your data using parallel coordinate plots
Exporting and publishing data and visualizations
Location based analytics
- Creating background map layers
- Key Spotfire concept: map chart layers
- Key mapping concept – coordinate reference systems
- Using automatic geocoding to accurately position locations from your data on a map
- Geocoding
- Coordinate columns
- Incorporating and using a feature layer Geographic drill-down
- Using the map chart for non-geographic spatial analysis
Scripting with Python
- Introduction to iron Python
- Control Structures
- Libraries
- Lists
- Functions
- Object orientations
- Over view of the SpotFire API
- Creating Scripts
- Referencing and Manipulating the Primary Elements in an
- Analysis File
- How to manipulate visualization properties
- Manipulating Data already loaded in Spotfire
- How to add data to an analysis
Tibco Enterprise Runtime for R
- How to Use TERR Tools
- TERR Tools – Details on Engine
- TERR Tools – Details on Package Management
- Configure R Studio to use TERR
- Run the TIBCO Enterprise Runtime for R console
- Package management in TIBCO Enterprise Runtime for R
- Command line options for TIBCO Enterprise Runtime for R
- Move data between TIBCO Enterprise Runtime for R and open-source R
- Accessing TIBCO Enterprise Runtime for R directly from Spotfire