Home

Purpose of this Wiki

Inform instructors and IAs that are teaching the course Data Analysis.

Contribute to this Wiki

Fork the wiki repository and then create a PR.

General Course Information

• Course Overview, Methodologies, and Tasks
• Course Platforms
• How to Work With Students
• Grading and Student Progress
• Bug and Issue Reporting

Lesson Specific Guides

• Introduction to Data
• EDA with Spreadsheets
• Cleaning Data with Spreadsheets
• SQL Part 1
• SQL Part 2
• SQL Part 3
• SQL Part 4
• SQL Part 5
• How Programs Work, How to Write and Run Code, Data and Variables
• Control Flow
• Collections
• Functions
• Exploratory Data Analysis with pandas
• Cleaning Data with Pandas
• Data Manipulation
• Data Visualization with Python
• Databases with Python and pandas
• Tableau Part 1
• Tableau Part 2
• Tableau Part 3
• Tableau Part 4

Assignments

• Assignment 0 - Hello Google Sheets!
• Assignment 1 - Fintech Fun
• Assignment 2 - 9 to 5
• Assignment 3 - Call Center Cleanup
• Assignment 4 - Checkpoint 1
• Assignment 4 - Checkpoint 2
• Assignment 4 - Checkpoint 3
• Assignment 4 - Checkpoint 4