|
Course Materials
- Python - Filter and Aggregation
- Aggregation: Link
- Advanced Filters: Link
- Python - Data, Select
- Advanced Select: Link
- Select, Filter, and Mutate: Link
- Reading in Data: Link
- Python - Basics
- Part III Lambda Expressions and Functions: Link
- Part II - Modules and Objects: Link
- Part I - Data Types, Expressions, and Statements: Link
*******************************
- Midterm: Take-home: Link
- Study Guide - Midterm (SQL): Link | Solution
- Databases:
- Baseball - Lahman: Folder
- Captial Bike: Link | Source: Source
- Flight Delays [Last update: Jan 28]: Folder
- MN Only Flight Delays [Last update: Jan 23]: Folder
- MN Schools ACT & Census: Folder
- Nursing Home Providers: Folder | Source: Link
- OECD_Employment [Last update: Jan 20]: Folder
- OECD_GDPGrowth [Last update: Jan 20]: Folder
- Pizza: Folder
- Podcasts: Folder
- US Baby Names: Folder
- USDA Farm Payments: Folder
- World Happiness: Folder
- SQL Window Functions:
- Notes - Top Baby Names by State & Year: Link
- Notes - Window Functions: Link
- SQL Joins:
- Notes - Joins (Advanced): Link
- Notes - Joins (Simple): Link
- SQL UNION / Concatenate:
- SQL Strings & Dates:
- Notes - Dates: Link
- Notes - Strings: Link
- SQL Aggregation:
- Aggregation with PIVOT: Link
- Simple Aggregation: Link
- SQL Advanced Filtering:
- SQL Basics:
- SQL Introduction:
- Download SQLite Studio: Link
- Window Functions:
- Getting Tableau Prep Builder
- 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: TCV5-44B4-3A70-58FE-C6CD
- Already have a copy of Tableau Desktop installed? Update the license key in the application: Help menu ? Manage Product Keys
- Syllabus: Link
|
Tasks / Homework
Task #4: Solution
Task #3: Solution
Task #2: Solution
Task #1: Solution
|