Data Analysis with SQL, Python and Spotfire

• Familiarity with data analysis concepts

Audience

• Business analysts

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 Spotfire. 

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

======== Day 01 ========

Introduction to RDMS (Relational Database Management System) 

• Oracle RDMS and the SQL language

How Data is Stored in an RDMS

• Tables, records and columns

Connecting to an Oracle database

• Command line vs GUI
• Logging in: server, database, credentials

Data Analysis with SQL

• 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

Introduction to Python

• Crash course on Python syntax

Connecting to an Oracle database

• Logging in: server, database, credentials

Data Analysis with Python

• Querying the database 
• Filtering, ordering, and counting data
• Advanced queries

======== Day 02 ========

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

Presentation Strategies with TIBCO Spotfire

Summary and Conclusion