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 Spotfire.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Requirements
- Familiarity with data analysis concepts
Audience
- Business analysts
Course Outline
======== 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