Topic outline

  • Advance Spotfire

    This course provides an advanced overview of all significant aspects and considerations of Spotfire for Business Intelligence Professionals, ETL and SQL developers, data analytics and database architects, software and mainframe professionals, project managers and freshers interested in BI careers
    • Training Methodology & Objectives

      Training Methodology

      This Trainee-centered course includes the following training methodologies:-

      • Talking presentation Slides (PPT with audio)
      • Simulation & Animation
      • Exercises
      • Videos
      • Case Studies
      • Gamification (learning through games)
      • Quizzes, Pre-test & Post-test

      Course Objectives

      After completing the course, the employee will:-

      Apply and gain an advanced knowledge on Spotfire Differentiate Tableau and Spotfire as well as recognize what language Spotfire is written in
      Use Spotfire software and describe its architecture, database joins and inner join Add data table to Spotfire (excel), select the excel file from the files downloaded, preview data, rename the data table, visualize table and etc.
      Organize filters, insert visualizations, use case for inserting a calculated column and insert calculated columns Add/remove columns from table visualization, hide/customize the legend and format column at global and visualization levels
      Describe vertical bar chart, horizontal bar chart, stacked bar chart, side-by-side bar chart and 100% stacked bar chart as well; as sort the bar chart Configure the input field, add lines and curves and show label for lines and curves
      Sort in ascending order, reverse the category axis and value axis, show filtering scheme on page and choose a filtering scheme for the page Delink filter panel from a visualization, limit data using expression, edit the expression, limit data using marking and create master-detail visualizations
      Show grand total for columns and rows, color code negative values in cross table and add rule for color coding Describe graphical table, text area, line chart, combination chart, pie chart and scatter plot
      Control the N parameter using slider property control and discuss the difference in sales from quarter to quarter and previous month Identify sales for each month as a ratio of the sales for the corresponding year
      Format the value axis to show percentage, pick moving average from the aggregation drop down on the measure axis Make the moving average window dynamic by controlling the window size using a property control
      • Course Description

        This E-learning course is designed to provide participants with an advanced overview of Spotfire. It covers the difference between Tableau and Spotfire; the language Spotfire is written in; the architecture, database joins and inner joins of Spotfire; adding of data table to Spotfire; the organization of filters, insertion of visualizations and insertion of calculated columns; the addition and removal of columns from table visualization, the hiding and customization of the legend; formatting of column at a global and visualization levels; the vertical bar chart, horizontal bar chart, stacked bar chart, side-by-side bar chart and 100% stacked bar chart; sorting the bar chart; the configuration of the input field; the addition of lines and curves and the showing of label for lines and curves; the sorting of order and reversing of category axis and value axis; the showing of filtering scheme; the delinking of filter panel; and the limiting of data and editing of expression
        During this course, participants will learn the showing of grand total for columns and rows; the color coding of negative values; the addition of rule for color coding; the graphical table, text area, line chart, combination chart, pie chart and scatter plot; controlling of the N parameter; the formatting of the value axis to show percentage; picking moving average from the aggregation drop down on the measure axis; and the dynamic moving average window
        • Module 1 - What is Spotfire Used for?

          Contents:
            • Video: Do More With Spotfire
            • What is the Difference Between Tableau and Spotfire? 
            • What Language is Spotfire Written in? 
            • How Do I Use Spotfire Software? 
            • How Much Does a Spotfire License Cost? 
            • Introduction to Tibco Spotfire 
            • TIBCO Spotfire 
            • Spotfire Architecture 
            • Database Joins 
            • Inner Join 
            • Download Sample Data
            • Adding Data Table to Spotfire (Excel)
            • Choose File as the Source
            • Select the Excel File From the Files Downloaded
            • Data Preview
            • Rename the Data Table (Optional)
            • Table Visualization (Non-Aggregated Data)
            • Spotfire is an In-Memory Analytical Tool
            • Spotfire: Linked to Source
            • Refreshing the Data Tables Used in the Dashboard
            • Spotfire: Linked to Source
            • Spotfire: Embedded in Analysis
            • Linked to Source
            • Embedding Data in Analysis
            • Spotfire: Embedded in Analysis
            • Close the “Recommended Visualization” Window
            • Filter Panel
            • Organizing Filters
            • Inserting Visualizations
            • Use Case for Inserting a Calculated Column
            • Inserting Calculated Columns
            • Table Visualization
            • Adding/Removing Columns from Table Visualization
            • Hiding/Customizing the Legend
            • Column Formatting at Global Level
            • Column Formatting at Visualization Level
            • Duplicating Visualization
            • Vertical Bar Chart
            • Horizontal Bar Chart
            • Sorting the Bar Chart
            • Stacked Bar Chart 
            • Side-by-side Bar Chart
            • 100% Stacked Bar Chart
            • Showing Top 20 Customers in a Bar Chart
            • Showing Top 20 Customers in a Bar Chart (Input Driven by Text Box)
            • Configuring the Input Field
            • Adding Lines and Curves
            • Adding Lines & Curves
            • Showing Label for Lines and Curves
            • Color-by Axis: Categorical
            • Target Line Adjustment Changing the Bar Color
            • Zoom Slider
            • Showing Gridlines
            • Sorting in Ascending Order: Reversing the Category Axis
            • Reversing the Value Axis
            • Show Filtering Scheme on Page
            • Choose a Filtering Scheme for the Page
            • Delinking Filter Panel From a Visualization (no Filtering Would Apply)
            • Limiting Data Using Expression
            • Limiting Data using Expression: Editing the Expression
            • Limiting Data Using Marking: Creating Master-detail Visualizations
            • Cross Table
            • Show Grand Total for Columns & Rows
            • Color Coding Negative Values in Cross Table
            • Adding Rule for Color Coding Negative Values in Cross Table
            • Graphical Table
            • Graphical Table: Axes
            • Graphical Table: Calculated Value
            • Graphical Table: Sparkline
            • Graphical Table: Icon
            • Graphical Table: Bullet Chart
            • Text Area: Dynamic Items
            • Line Chart (Shows Trend in a Measure Over a Period of Time)
            • Line Chart (With Multiple Measures)
            • Line Chart (Tweaking the Appearance)
            • Line Chart (Changing the Date Hierarchy)
            • Combination Chart
            • Combination Chart (Changing the Appearance)
            • Pie Chart (Do not Use this Chart)
            • Pie Chart (Sorting the Slices)
            • Scatter Plot
            • Scatter Plot (Tweaking the Color Axis)
            • Scatter Plot (Adding Lines and Curves – Straight line Fit aka Linear Regression)
            • Scatter Plot (Using the Shape & Size Axes)
            • Scatter Plot (Tweaking the Size of the Markers)
            • Details-on-Demand
            • Inserting Property Controls: 1) Input Field
            • Inserting Text Area
            • Inserting Slider Property Control
            • Controlling the N Parameter Using Slider Property Control
            • Difference in Sales from Quarter to Quarter 
            • Difference in Sales From Previous Month
            • Sales for Each Month as a Ratio of the Sales For the Corresponding Year 
            • Formatting the Value Axis to Show Percentage
            • Sales for Each Month as a % of the Sales For the Corresponding Year
            • Sales for Each Month as a % of Entire Timeframe on the X Axis (Each Month’s Sales Divided by All)
            • Sales for Each Sub-category as a Ratio of Sales of All Sub-categories
            • Formatting it as %
            • Sales for Each Sub-Category as a % of Sales of all Sub-Categories
            • Money Made so Far: Running Total of Profit
            • Moving Average: For a 3 Month Window
            • Pick Moving Average from the Aggregation drop Down on the Measure Axis
            • By Default it Shows 10 Month Moving Average. Modify the Expression to Make the Window 3 Months
            • Here’s the Final Expression For moving Average
            • Making the Moving Average Window Dynamic by Controlling the Window Size Using a Property Control
            • Text Area: Property Controls
            • Text Area: Property Controls - Label
            • Text Area: Property Controls – Input Field
            • Text Area: Property Controls – Multi-line Input Field
            • Text Area: Property Controls – Single Select List Box
            • Inserting List Box Control
            • Text Area: Property Controls – Single Select List Box
            • Setting the Data Limiting Expression for the Visualization
            • Text Area: Property Controls – Multi-Select List box
            • Custom Expression Evolution
            • Text Area: Property Controls – Dropdown list (column selection) – Axis Selector
            • Set from Property
            • Creating the Boolean Property to Store the Selection Status of the Column List Property Control
            • Cherry Picking the Columns that Need to be Shown in the Dropdown List
            • Axis Selector
            • Bookmarks
            • Applying Special Bookmarks
            • Text Area: Property Controls – Iron Python Scripting
            • Inserting Action Control
            • Module Quiz
          • Module 2 - Advanced Data Visualization Using TIBCO Spotfire and SAS Using SDTM

            Contents:
              • Introduction 
              • Technique & Mechanism 
              • TIBCO Spotfire Overall View 
              • TIBCO Sportfire Development Area 
              • Preclarus Example 1: Study Summary 
              • Preclarus Example 2: Demographics 
              • Preclarus Example 3: Adverse Events 
              • Preclarus Example 4: Vital Signs 
              • Preclarus Example 5: Labs 
              • Preclarus Example 6: Subject Reports 
              • CDISC SDTM Challenges Encountered 
              • Summary 
              • Video: Create a Spotfire Dashboard
              • Module Quiz
            • Module 3 - Spotfire - A Software for Decision Support System (DSS)

              Contents:
                • Spotfire 
                • Features 
                • Core Functions 
                • Products of Spotfire
                • Application of Spotfire
                • Modle Quiz
              • Module 4 - Business Intelligence Tool: Tibco Spotfire

                Contents:
                  • Introduction 
                  • Installing The TIBCO Spotfire Client 
                  • Using Spotfire: Load Data 
                  • Using Spotfire Load Data - Data Manipulations 
                  • Using Spotfire Visualization 
                  • Using Spotfire Visualization - Visualization Properties 
                  • Using Spotfire Visualization - Page View 
                  • Using Spotfire Visualization - Visualizations 
                  • Using Spotfire: Data  Relationships Regression 
                  • Using Spotfire: Share Results 
                  • Video: Visualization Basics in Spotfire - Create Spotfire Charts
                • Module 5 - Case Study: Adopting TIBCO Spotfire in Bio-Informatics

                  Contents:
                    • Correlation Analysis (Dummy Data)
                    • Overview
                    • Custom Expressions
                    • Details Visualizations
                    • Using Multiple Data Tables
                    • Using Multiple Data Tables: Cartesian Product
                    • Multiple Data Tables: Cartesian Product
                    • Using Multiple Data Tables: Saving
                    • Column From Marked
                    • Text Area
                    • Using Tags
                    • Simple Structure Viewer
                  • Module 6 - Case Study: Dynamic Creation and/or Content Modification of Spotfire Output (DXP files) - Proposed Integration Solution with Pipeline Pilot

                    Contents:
                      • What are Spotfire Output (or DXP) files?
                      • TIBCO Spotfire Architecture 
                      • TIBCO Spotfire Developer (SDK) 
                      • TIBCO Spotfire APIs & Integration with PP 
                      • Automation Services - Terminology 
                      • Spotfire Automation Services - Architecture 
                      • Automation Services – Scheduling a Job 
                      • Solution – Develop Communication Message 
                      • Solution – Transmitting / Receiving Messages 
                      • Implementing the Solution – DXP Request Message Format 
                      • Implementing the Solution – Spotfire Related 
                      • Implementing a Solution: Pipeline Pilot Related 
                      • Proof-Of-Concept Demo 
                      • Phase-2
                      • Module Quiz
                    • Module 7 - Case Study: Unlocking the Power of Predictive Analytics

                      Contents:
                        • Achieving Sustainable Competitive Advantage 
                        • What are Predictive Analytics? 
                        • Predict & Optimize 
                        • Predictive Analytics with Spotfire 
                        • Spotfire’s Predictive Analytics Ecosystem 
                        • Predicting the Business 
                        • Demo & Case Study 
                        • Spotfire Drives Sustained Competitive Advantage 
                        • Deploy Predictive Models with TIBCO CEP 
                      • Module 8 - Case Study: TIBCO Spotfire Application Data Services

                        Contents:
                          • TIBCO Spotfire Analytics Platform 
                          • Spotfire Data Services 
                          • TIBCO Spotfire Application Data Services 
                          • TIBCO Spotfire SAP Connectivity 
                          • SAP BW Data Access Challenges 
                          • Composite SAP BW Adapter – At a Glance 
                          • Key Features
                        • Module 9 - Case Study: Spotfire Enterprise Optimization

                          Contents:
                            • Topics
                            • The Analysis Gap
                            • Better and Smarter: Top 5 Reasons
                            • The Analysis Gap
                            • Analytics and Events
                            • BI vs. Event-Driven Analytics
                            • Analytics and Events
                            • Analytics and Process
                            • Spotfire Analytics Platform
                          • Module 10 - Case Study: Spotfire Extending the Reach of R to the Enterprise

                            Contents:
                              • Extending the Reach of R to the Enterprise 
                              • Our Journey to TERR 
                              • Predictive Analytics with Spotfire 
                              • Embracing R 
                              • Enterprise Challenges for R 
                              • TIBCO Enterprise Runtime for R (TERR) 
                              • Leveraging TERR 
                              • Providing Value for Individuals Who Use R 
                              • Example 1: TERR vs. R Raw Performance 
                              • Example 2: Spotfire Forecast Tool 
                              • TERR integration with TIBCO StreamBase 
                              • TIBCO Cloud Compute Grid 
                              • Demos 
                              • Module Quiz
                            • Module 11 - Case Study: 100 Days of Spotfire - Tips and Tricks

                              Contents:
                                • Tip # 1: Add Comments Directly to Your Visualization 
                                • Tip # 2: Advance Filtering 
                                • Tip # 3: Format Legend In A Chart 
                                • Tip # 4: Customize Data Points Size 
                                • Tip # 5: Customize Color Of Data Points 
                                • Tip # 6: Adjust Color Schema 
                                • Tip # 7: Recommended Visualizations For Your Data 
                                • Tip # 8:Filter And Analyze Data by Chemical Structure 
                                • Tip # 9: Adjust Table Layout 
                                • Tip # 10: Calculate IC50 Dose Curves (1 of 2) 
                                • Tip # 11: Calculate IC50 Dose Curves (2 of 2) 
                                • Tip # 12: View Two Visualization Formats at Once 
                                • Tip # 13: View Data and Visualizations Together 
                                • Tip # 14: Real-Time Data Visualizations 
                                • Tip # 15: Calculate Avg/Min/Max 
                                • Tip # 16: Find The Best Formulation 
                                • Tip # 17: Create Log Histogram 
                                • Tip # 18: Generate And Store Reference Curve Fit 
                              • Post-Test

                                Kindly complete the post-test to assess your knowledge about the topic after the course.