Class Meeting Link ZOOM
Week |
Class |
Date |
TOPIC |
MATERIALS |
DUE |
1 |
1 |
1/13 |
Course Introduction and Syllabus Introduction to Data Analytics |
PowerPoint |
|
1 |
2 |
1/15 |
Information Architecture of an Organization |
||
1 |
3 |
1/17 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins |
PowerPoint |
|
2 |
4 |
1/20 |
MLK Day – No Class |
Make sure you set up Vertabelo (see guide) and review the Relational Data Modeling deck before Wednesday Make sure to install MySQL Workbench before Friday! |
|
2 |
5 |
1/22 |
In-class exercise: ICA #1 Database Schema Instructions: Quick Guide to Vertabelo_s20 Solution (view only) |
||
2 |
6 |
1/24 |
Getting data out of RDBMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE Instructions: Quick Guide to MySQL Workbench_s20 |
PowerPoint |
|
3 |
7 |
1/27 |
In-class activity 2: Working with SQL Solution to ICA 2 |
Assignment #1 – Database Schemas Due 11:59 PM Sunday 1/26 Form to upload your pdf solution file. Solution for Assignment 1 (view only) |
|
3 |
8 |
1/29 |
Getting data out of RDBMS: Joining tables, SQL sub-selects |
PowerPoint 05 SQL Out 2 – Advanced Reference Slides on Joins |
|
3 |
9 |
1/31 |
In-class activity 3 (due 2/3): ICA #3 – SQL Part 1 Form to upload your ICA 3 Answer Sheet on Monday Solution for ICA 3 Getting data out of RDBMS: Joining tables, SQL sub-selects (Continued)
|
|
|
4 |
10 |
2/3 |
In-class exercise: Working with SQL, part 2 |
Due 11:59 PM Sunday 2/2 Answer Sheet Assignment 2 – SQL Please name your submission as LastFirstAssignment2.pdf Form to upload your pdf solution file Solution for Assignment 2 (view only)
|
|
4 |
11 |
2/5 |
Principles of Data Visualization Due 2/7 by 1 PM. ICA #4 – SQL Final Set Answer Sheet Upload your ICA 4 answer sheet here. Solution for ICA 4 |
PowerPoint |
|
4 |
12 |
2/7 |
Principles of Data Visualization (continued) |
|
|
5 |
13 |
2/10 |
In-class exercise: Data Visualization. ICA #5.1 – Data Visualization Principles ICA #5.1 – Food-Emporium_Dashboard Upload your ICA 5 Excel file here |
||
5 |
14 |
2/12 |
Semi-structured data |
PowerPoint |
Due 11:59 PM Thursday 2/13 Assignment 3: Assignment #3 – SQL Part 2 Answer Sheet Assignment 3 – SQL2 Form to upload your pdf solution file Assignment #3 – SQL Part 2 Solution (view only) |
5 |
15 |
2/14 |
Semi-structured data (continued) In-class exercise: ICA #6 – Working with Semi-Structured Data Upload your ICA 6 file here ICA 6 Solution |
||
6 |
16 |
2/17 |
Review for Exam 1 |
||
6 |
17 |
2/19 |
Optional, but recommended, attendance: Ask questions about the exam. |
||
6 |
18 |
2/21 |
Exam 1 |
||
7 |
19 |
2/24 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
PowerPoint |
|
7 |
20 |
2/26 |
Getting data out of NoSQL (Continued) |
||
7 |
21 |
2/28 |
In-class exercise: Upload your ICA 7 file here ICA #7 Solution |
||
8 |
22 |
3/2 |
Spring Break – No Class |
||
8 |
23 |
3/4 |
Spring Break – No Class |
||
8 |
24 |
3/6 |
Spring Break – No Class |
||
9 |
25 |
3/9 |
Getting data out of NoSQL: How to query nested document and array, JOIN |
PowerPoint |
|
9 |
26 |
3/11 |
Getting data out of NoSQL (Continued) |
||
9 |
27 |
3/13 |
In-class exercise: Working with NoSQL, part 2 ICA #8 – NoSQL Part 2 Answer Sheet Upload you ICA 8 file here ICA 8 Solution |
||
10 |
28 |
3/16 |
Reconciling Data: The extract, transform, load process (ETL) |
PowerPoint |
Answer Sheet Assignment #4 – NoSQL Part 1 Form to upload your solution file Assignment #4 Solution Due 11:59 PM Tuesday 3/17 |
10 |
29 |
3/18 |
Quick Guide to Tableau prep_s20
|
Reminder: ICA 8 due 11:59 PM on Thursday 3/19. See 3/13 for ICA. | |
10 |
30 |
3/20 |
|
Form to upload your solution file Solution for Assignment 5 Due 11:59 PM Monday 3/23 |
|
11 |
31 |
3/23 |
ICA #9 – ETL using Tableau Prep: ETL using Tableau Prep Builder Upload your ICA 9 file here Solution for ICA 9 |
PowerPoint | |
11 |
32 |
3/25 |
Introduction to Advanced Analytics and R
|
||
11 |
33 |
3/27 |
Exam 2 | ||
12 |
34 |
3/30 |
Install R and R Studio, see slide 12 of deck 11.
|
|
|
12 |
35 |
4/1 |
Getting to know R Studio Download and unzip: R basics |
Assignment 6 has been dropped from the schedule. |
|
12 |
36 |
4/3 |
Descriptive Statistics Review In-class exercise ICA#10: Getting familiar with R and RStudio Part 2 Upload you ICA 10 .R file here. Solution for ICA 10 |
Powerpoint |
|
13 |
37 |
4/6 |
Classification using Decision Trees |
PowerPoint |
|
13 |
38 |
4/8 |
In-class exercise: Decision trees in R ICA#12 Upload your ICA 12 file here before class on Friday. Solution for ICA 12 |
Assignment 7: Introduction to working with R. Assignment 7 Files
Due 11:59 PM Wednesday 4/8 Submit your four solution files here. Solution for Assignment 7 |
|
13 |
39 |
4/10 |
Analysis Scenario: Identifying similar customers (clustering and segmentation) |
PowerPoint |
|
14 |
40 |
4/13 |
Clustering and segmentation (continued) ICA #13 – Clustering Using R Upload your ICA 13 file here. Due by end of class 4/15 Solution for ICA 13 |
|
|
14 |
41 |
4/15 |
In-class exercise: Clustering and Segmentation in R
|
Due 11:59 PM Wednesday 4/15 Submit your solution file here. Solution for Assignment 8 |
|
14 |
42 |
4/17 |
Analysis Scenario: What products are purchased together? (Association Rules) |
PowerPoint |
|
15 |
43 |
4/20 |
Association Rules (continued) ICA #14 – Computing Confidence, Support, and Lift Upload your ICA 14 file here. Due by end of class 4/20 Solution for ICA 14 |
|
|
15 |
44 |
4/22 |
In-class exercise: Association Rule Mining in R ICA #15- Association Rules Using R Upload your ICA 15 file here. Due by end of class 4/22 Solution for ICA 15 |
Assignment #9 – Clustering Using R Due 11:59 PM Wednesday 4/22 Submit your five solution files here. Solution for Assignment 9 |
|
15 |
45 |
4/24 |
Review for Exam 3 Exam 3 Review PPT |
|
|
16 |
46 |
4/27 |
Exam 3 |