Labs

The video, pdf instructions, and page for each lab are listed below.

(0) Setup
No Video | Instructions | Page

(1) Google Sheets Data Prep
Video | Instructions | Page | Data – Google Sheet

(2) Simple Restaurant Visualization
Video | Instructions | Page

(3) Setting up a Dashboard
Video | Instructions | Page

(4) 311 Data Download
Video | Instructions | Page

(5) Data Structures
Video 1 / Video 2 | Instructions | Page | Dataset | Slides

(6) Data joins
Video | Instructions | Page | Dataset

(7) Calculated Fields
Video | Instructions | Page | Dataset

(8) Dashboard Design Part I: The visualizations
Video | Instructions | Page | Dataset

(9) The Dashboards
Video | Instructions | Page | Dashboard

(10) Text Analysis
Video | Instructions | Page | Dataset // Dataset Smaller| Dashboard

(11) Mapping
Video | Instructions | Page | Datasets
Census_Demographics_at_the_Neighborhood_Tabulation_Area__NTA__level \\ Zip_MedianRentalPrice_Studio_1_2 \\ Demographic_Statistics_By_Zip_Code | Dashboard

(12) Parts of a Whole
Video | Instructions | Page | Datasets:

waffleStructure // Airbnb | Dashboard

(13) Progressions Through Time
Video | Instructions | PAge | Datasets Top17FemaleSoccerGoalScorers // trumptweets2017-2018 | Dashboards Soccer // Trump’s Tweets