Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation-Getting Started!
A Note from UC Davis
Course Introduction and Welcome
()
Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation-Milestone 1: Project Proposal and Data Selection/Preparation
Milestone 1 Introduction
()
The Proposal Process
()
Choose Your Client/Dataset
Import of Elon Musk Data
()
Initial Feature Exploration / Hypotheses
()
Entity Relationship Diagram (ERD) for Analysis
()
Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation-Resources
Data Models, Part 1: Thinking About Your Data
()
Data Models, Part 2: The Evolution of Data Models
()
Data Models, Part 3: Relational vs. Transactional Models
()
SQL in Notebooks
()
Import Data
()
Introduction of Data of Unknown Quality
()
Connecting to Mode Analytics
Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation-Milestone 1 Assignment
Welcome to Peer Review Assignments!
Milestone 2: Descriptive Stats & Understanding Your Data-Milestone 2: Descriptive Stats & Understanding Your Data
Milestone 2 Introduction
()
Importance of Understanding Your Data
()
Foundational Stats in SQL/Sheets
()
Pandas Teach on Stats
()
Visualization with raw graphics.io
()
Impact of Findings on Hypotheses
()
Milestone 2: Descriptive Stats & Understanding Your Data-Resources
Statistics Refresher (Optional)
()
Additional Resources
Milestone 3: Beyond Descriptive Stats (Dive Deeper/Go Broader)-Milestone 3: Beyond Descriptive Stats
Milestone 3 Introduction
()
TF-IDF for Word Frequency / Theme Analysis
()
Text Analysis of Elon Musk Tweets
()
Milestone 3: Beyond Descriptive Stats (Dive Deeper/Go Broader)-Resources
Create a New Metric
()
Analyze Results
()
Milestone 4: Presenting Your Findings (Storytelling)-Milestone 4: Presenting Your Findings (Storytelling)
Milestone 4 Introduction
()
Sample Output / Presentation
()
Milestone 4: Presenting Your Findings (Storytelling)-Resources
Resources on the Who, What, Why, and How
Resources on Audience
Dashboard and Storytelling with Data
Finding the Story
Prioritizing, Optimizing and Designing the Data Story
Tell the Story of Your Data
Module Introduction
()
Working with Text Strings
()
Working with Date and Time Strings
()
Date and Time Strings Examples
()
Case Statements
()
Views
()
Data Governance and Profiling
()
Using SQL for Data Science, Part 1
()
Using SQL for Data Science, Part 2
()
Additional SQL Resources to Explore
Milestone 4: Presenting Your Findings (Storytelling)-Summary
Course Summary
()