Basic SQL and Intermediate Spotfire Data Analysis Training

Duration

Basic SQL and Intermediate Spotfire Data Analysis Training

4 days

Overview

In this instructor-led, live training, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases.The focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO SpotfireIBCO Spotfire Analyst is a web and Windows based client application for analyzing data and creating analytic dashboards.

This instructor-led, live training (online or onsite) is aimed at business analysts who wish to learn advanced Spotfire Analyst techniques for analyzing data.

Day 1

Introduction to RDMS (Relational Database Management System)

Oracle RDMS and the SQL language

How Data is Stored in an RDMS

Tables, records and columns

Querying the database using SELECT

Filtering data with WHERE

Sorting data with ORDER BY

Querying multiple tables with Joins

Grouping Data with GROUP BY

Using aggregate functions to perform calculations on resulting data

Filtering groups with HAVING

Querying the database

Filtering, ordering, and counting data

Day 2

Intoruduction TIBCO Spotfire

Overview

Introduction to Data Visualization with TIBCO Spotfire

Connecting to a Spotfire Server

Web client vs installed client

Importing Data

Data Visualization

Bar Chart

Line Charts

Pie Chart

Filtering Data

Adding Data Table (Flat-file, database) - different options

Working with Information Links (optional, needed access to Spotfire Server and some test database)

Day 3

Data Wrangling

Filtering, Marking, Table Relationship

Visualization types (Table, Cross Table, Pie Chart, Bar Chart, Line Chart, Combination Chart, Waterflow Chart...

Calculated Columns

Property Controls, Text Area

Report Custom Styling (Corporate design)

Spotfire Library Concepts, Report sharing and access concepts

Web Player, Scheduled Updates

Wrap up

Day 4

Managing Libraries

Collaborating with Spotfire

Creating Information Links to Access Data

Performing Advanced Visualizations

Beyond the GUI - Advanced Analysis through Expressions

Creating Property Controls

Integrating Statistical Engines

Data Relationships and Predictive Modeling

Multivariate Data Analysis

Troubleshooting

Programme scope, delivery arrangements and suitability are confirmed during enquiry.