Gracias por enviar su consulta! Uno de los miembros de nuestro equipo se pondrá en contacto con usted en breve.
Gracias por enviar su reserva! Uno de los miembros de nuestro equipo se pondrá en contacto con usted en breve.
Programa del Curso
======== 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
Requerimientos
- Familiaridad con los conceptos de análisis de datos
Audiencia
- Business Analistas
14 Horas
Testimonios (1)
Realmente disfruté las muchas prácticas y laboratorios.
Vivian Feng - Destination Canada
Curso - Data Analysis with SQL, Python and Spotfire
Traducción Automática