How to use the slide decks?
- Check the schedule in the syllabus for the dates we are covering the material in each slide deck.
- Review the slide deck prior to class.
- Take notes during class.
Here they are:
|No.||Module||Slides||In-Class Activities (ICA)
Things You Can Do with Data
|0. Course Introduction|
|2||Information Architecture of an Organization||2. Information Architecture of an Organization|
|3||Relational Data Modeling||3. Relational Data Modeling||ICA #1 – Identifying Entities (due by Fri 9/8, 11:59 pm) (ICA#1 solution key)||(right click and save as…)|
|4||SQL 1: Getting Information Out of a Database||Before start, make sure you’ve followed the guide for setting up a connection in MySQL Workbench
4. Supplement – MySQL and Workbench (review on your own)
|ICA #4 – Pen and Paper Query Exercise (due by Mon 9/25, 11:59 pm) (ICA #4 solution key)||SQL Quick Reference 1|
|5||SQL 2: Putting Information Into a Database||5. SQL 2 – In||ICA #6 – SQL Part 2 (due by Friday 10/6, 11:59 pm) (ICA #6 solution key; ICA #6 SQL statements)
||SQL Quick Reference 2|
|6||Principles of Data Visualization||6. Data Visualization||ICA #7 – Creating Infographics (will not be collected)||Files needed for ICA #7 (right click and save as):|
|7||Extract, Transform, Load (ETL)||7. ETL||No ICA|
|8||Dimensional Data Modeling||8. Dimensional Data Modeling||ICA #8 – Pivot Tables (due by Monday 10/23, 11:59 pm) (ICA #8 solution key; Salesperson Cube – key.xlsx)
|File needed for ICA #8 (right click and save as):|
|9||Advanced Data Analytics and R||9. Supplement – Basic Statistics||ICA #9: Descriptive Statistics Using R/RStudio (due by Wednesday 11/8, 11:59 pm) (ICA #9 solution key; Descriptives – Try it yourself.r)||File needed for ICA #9 (right click and save as):|
|10||Classification Using Decision Trees||10. Decision Trees||ICA #10 – Decision Trees in R (due by Friday 11/17, 11:59pm) (ICA #10 solution key)||File needed for ICA #10 (right click and save as):|
|11||Clustering||11. Clustering||ICA #11 – Clustering Using R (due by Friday 12/1, 11:59pm) (ICA #11 solution key)||File needed for ICA #11 (right click and save as):
|12||Association Rules||12. Association Rules||ICA #12.1 – Computing Confidence, Support, and Lift (will not be collected) (ICA #12.1 solution key)||File needed for ICA #12.2 (right click and save as):|