DSCI 210 -- Data Science
Spring 2025

My Schedule


Course Materials

  • Tableau Prep - Aggregation
    • Data: Pizza Delivery Link | Montgomery County 911 Calls: Link
    • Aggregation: Link

  • Module 4 - Strings & Dates: Folder
    • Date Functions: Link
    • String Functions: Link

  • Introduction to Tableau Prep | Folder
    • National Park Service Mortality: Source: Link
    • Snake Killings: Source: Link

  • Module 3 - Data Verbs: Folder
    • Part C - GROUP & AGGREGATE: Link
    • Part B - MUTATE: Link
    • Part A - SELECT & FILTER: Link

  • Module 2 - Aggregation: Folder
    • IF statement to convert arrival time to minutes: =IF(AND(ISNUMBER([@[Calltime Arrive]]), [@[Calltime Arrive]]<>""), [@[Calltime Arrive]]/60, "")
    • Montgomery County, MD 911 Calls - Police: Information | 2024 Calls: Link
    • CO Snowfall Tidy: CO_Snowfall_Tidy.csv
    • Part A: Aggregations in a Spreadsheet: Link

  • Module 1 - Tidy Data: Folder
    • Austin Animal Shelter: Link

    • Part C: Dates: Link
    • Part B: Data in Spreadsheets: Link
    • Part A: Clean Data: Link

  • Instructions to get Tableau Prep
    • Sign into an existing Tableau.com account, or create a new account using your school-issued email
    • Once signed in, visit the TFT Activation page to download the latest versions of Tableau Desktop and Tableau Prep Builder
    • Activate with product key: TC3B-683E-F7F0-8F9C-75BE
    • Already have a copy of Tableau Desktop installed? Update the license key in the application: Help menu ? Manage Product Keys

  • Syllabus - Spring 2025: Link

Assessments

  • Task #4: Folder; 20 pts; Due Tuesday, Feb 25
    • CDC_BirthRates.csv: Link
    • Task Questions: Link

  • Task #3: Folder; 20 pts; Due Thursday, Feb 20
    • United States Snake Killings: Link
    • Task Questions: Link

  • Task #2: Hennepin County Food Inspections; 15 pts | Folder; Due Thursday, Feb 13
    • Understanding the data: Link
    • Task Questions: Link

  • Task #1: Sibling Task; 10 pts, Due Tuesday, Jan 21
    • Data Collection: Form [Must sign into Google to submit]
    • Data: Data | Stacked Data: Link
    • Task Questions: Link