logo-mooc
search-iconsearch-icon
menu-whitemenu-blue
GRATIS
Inicio / Buscador / Programación / SQL
Harvard vía Coursera
GRATIS

Data Analysis with Spreadsheets and SQL

  • money

    Cursos gratis (Auditar)

    question-mark
  • earth

    Inglés

  • folder

    Siempre Abierto

  • certificate

    Guía de Registro en Coursera

    arrow
VER CURSO arrow
Acerca de este curso

  • Working with Data in Spreadsheets
    • This week you learn the basics of spreadsheets and their usefulness in data analysis. You will also identify how to apply the OSEMN framework when working with data in spreadsheets.
  • Data Analysis with Spreadsheets
    • This week you will learn how to clean data in spreadsheets using foundational spreadsheet functions. You will also learn how to calculate summary statistics in spreadsheets as well as how to identify data trends and relationships between variables.
  • Extracting Data with SQL
    • This week you will be introduced to SQL and how it is used in spreadsheets. You will utilize basic queries and functions for handling data with SQL.
  • Data Visualization
    • This week you will learn about common chart types and how to determine the best type of chart for the dataset you want to present. You will also learn how to create these charts using both Google Sheets and Tableau.
  • Creating Dashboards
    • In the final week you will be introduced to dashboards and how to use them to report on progress within a business setting. You will also learn how to create dashboards in Tableau and use these to tell a story when presenting your data findings.