Data Analysis with Spreadsheets and SQL

This module provides an introduction to the program and covers the fundamental aspects of working with data in spreadsheets. Students will learn about the OSEMN framework, the use of spreadsheets in data analysis, and common spreadsheet tools. The module also includes practical exercises and quizzes to reinforce learning.

In this module, learners will delve deeper into data analysis with spreadsheets. Topics covered include accessing and labeling data, cleaning and formatting data, using functions, evaluating correlations, and visualizing data using Google Sheets. Practical exercises and quizzes are incorporated to enhance understanding and skill development.

This module focuses on extracting data with SQL. Students will learn about the importance of SQL, writing foundational SQL statements, using SQL in Google Sheets, and various SQL functions. The module includes extensive practice sessions and quizzes to enhance proficiency in using SQL for data extraction.

Module 4 is dedicated to data visualization, covering different tools for data visualization, common chart types, and practical training in using Google Sheets and Tableau for creating various visualizations. Learners will gain valuable insights into the significance of visualization in communicating data effectively.

The final module emphasizes creating dashboards, exploring the power of dashboards, designing and building dashboards in Tableau, and the art of storytelling with data visualizations. Practical exercises and quizzes are integrated to reinforce learning and skill application.