Applied Data Analytics Program Online Foundations Module
Introduction
This online module introduces students to the foundations of data and technical literacy. Participants will explore real publicly-available datasets, using the data analysis tools to create summaries and generate visualizations. Participants will learn the basics of project development for data analysis, database fundaments, as well as learn how to code in SQL and R. By the end of the module, participants should understand the data lifecycle and be able to communicate with technical and non-technical audiences.
Accessing Module Materials
For the main workbooks to practice and learn how to code, we will be inside the ADRF. You need to ensure you have set up your username and password as you will need access to the ADRF. It is highly encouraged you watch the Introduction Videos as they will provide information on how to use the ADRF and access the class materials.
Module Content
We will go over one unit each week. Please note the date and times for the online meetings - these are when you can ask questions and get help on the workbooks.
Data Documentation
We will be using a subset of the BLS Local Area Unemployment Statistics (LAUS) data. The documentation for the data that we will use is provided below and includes descriptions of the variables.
Much of our content in this module is aimed at using the LAUS data to recreate parts of the WORKR dashboard created by KYStats. Please feel free to explore that dashboard and their technical documentation below.
Cheat sheet
We have provided a cheat sheet linking the fundamental data operations that you will learn in the Foundations Module to a description of the purpose and use case for that operation, as well as the code to carry out each operation in both SQL and R.
Fundamental Data Operations Cheat Sheet
Additional Resources
There are many resources available on the internet to help you learn programming for data analysis. Listed below are some of the most useful ones for this course.
R Cheat sheets:
Data Wrangling with dplyr and tidyr
Base R Cheat sheet
R ggplot2 Cheat sheet
SQL Cheat sheets:
SQL: https://www.sqltutorial.org/wp-content/uploads/2016/04/SQL-cheat-sheet.pdf
Documentation and Tutorials:
dplyr: https://dplyr.tidyverse.org/
ggplot2: https://ggplot2.tidyverse.org/