Data Analysis with SQL, Python and Spotfire Treningskurs

Last updated

Kurskode

sqlpythonspotfire

Varighet

14 timer (vanligvis 2 dag inkludert pauser)

Krav

  • Familiarity with data analysis concepts

Audience

  • Business analysts

Oversikt

I denne instruktørledede, liveopplæringen, vil deltakerne lære tre forskjellige tilnærminger for tilgang, analyse og visualisering av data. Vi starter med en introduksjon til RDMS-databaser; fokus vil være å få tilgang til og spørre om en Oracle database ved å bruke SQL språket. Deretter ser vi på strategier for tilgang til en RDMS-database programmatisk ved hjelp av Python språket. Til slutt ser vi på hvordan vi kan visualisere og presentere data grafisk ved hjelp av TIBCO Spotfire .

    Kursets format

    • Interaktiv forelesning og diskusjon.
    • Masse øvelser og trening.
    • Praktisk implementering i et live-lab-miljø.

    Machine Translated

    Kursplan

    ======== 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

    Testimonials

    ★★★★★
    ★★★★★

    Related Categories

    Relaterte kurs

    Kursrabatter

    Kursrabatter Nyhetsbrev

    We respect the privacy of your email address. We will not pass on or sell your address to others.
    You can always change your preferences or unsubscribe completely.

    Some of our clients

    is growing fast!

    We are looking to expand our presence in Norway!

    As a Business Development Manager you will:

    • expand business in Norway
    • recruit local talent (sales, agents, trainers, consultants)
    • recruit local trainers and consultants

    We offer:

    • Artificial Intelligence and Big Data systems to support your local operation
    • high-tech automation
    • continuously upgraded course catalogue and content
    • good fun in international team

    If you are interested in running a high-tech, high-quality training and consulting business.

    Apply now!

    This site in other countries/regions