Data Management for Decision Making
| DATE | TOPICS | DECKS | HOMEWORK DUE (Draft) |
|
Wed Aug 28 |
Welcome to DM4DM! | Deck 01 |
Browse this web site. Bring to class any questions you might have. |
| PART I | RELATIONAL DATABASES | |
|
| Mon Sep 2 | SQL: accessing single tables Intro to MP1: Smallbank (A) Tools: ADS |
Deck 02 |
Review Deck 01 Prep for the orange words/cold calling using prompt #1 Read the SQL intro by the WWW Schools Read the first 5 pages of my Intro to SQL Check your email for a link to join the class Teams chat. |
| Wed Sep 4 | Data modeling with ERDs Intro to MP2: Notflix |
Deck 03 |
Review the previous deck Watch the Intro to DBs and ERDs Watch the ERD tutorial |
| Mon Sept 9 | ERD: Placing foreign keys Tool: Draw.IO |
Deck 04 |
DUE: Miniproject
MP1 (SmallBank A) Review the previous deck Watch the Draw.io tutorial if you have not done it yet |
| Wed Sept 11 | SQL: Joins | Deck 05 |
Review the previous deck Read page 6-7 of the Intro to SQL |
| Mon Sept 16 | SQL: Joins practice Intro to MP3: SmallBank (B) |
Deck 06 |
DUE: Miniproject
MP2 (single or pairs: Notflix) Review the previous deck Optional: if you so desire, connect to SmallBankDB at the beginning of class to follow the in-class practice (no time to help you connect while in class). |
| Wed Sept 18 | SQL: Nested and Union Queries, Having statement. | Deck 07 |
Review the previous deck |
| Mon Sept 23 | Business database design practice Intro to MP4: An ERD for B2B |
Deck 08 |
DUE: Miniproject
MP3 (SmallBank B) Since I forgot to post deck 07 on time, there will be no 'orange words' segment' |
| Wed Sept 25 | More business database design practice | Deck 09 |
Review the previous two decks |
| Mon Sept 30 | In class SQL Test 1 | No Deck | No AI or GenAI allowed |
| Wed Oct 2 | SQL: Tables and data creation, update and deletion | Deck 10 |
Read all remaining pages of the Intro to SQL Learn about Create Table, Alter Table, and Delete Table in W3 |
| Mon Oct 7 |
DB integration Intro to MP5: Team ERD |
Deck 11 |
Bring an extra copy of your Miniproject 4: we will discuss solutions and take notes. DUE: Miniproject MP4 (Database for B2B) |
| Wed Oct 9 |
Good DB designs: Normalization | Deck 12 |
Nothing due (you are welcome) |
| Oct 12-15: Reading Days | |||
| PART II | BUSINESS INTELLIGENCE | |
|
| Wed Oct 16 |
Good DB designs: Denormalization Intro to MP6: Pressly Ad Agency |
Deck 13 |
DUE: Miniproject
5 (Team ERD) Solutions to MP4 are posted in Teams Review the previous deck |
| Mon Oct 21 | BI: Operational DB vs. Data Warehouses | Deck 14 |
Review the previous deck |
| Wed Oct 23 | Star schema for Data Warehouses Intro to MP7: DW at REI_not |
Deck 15 |
DUE: Miniproject
6 (Pressly Ad) Review the previous deck |
| Mon Oct 28 | Building a Star schema | Deck 16 |
Nothing due (you are welcome) |
| Wed Oct 30 | Using DW for decision making: Pivot tables Intro to MP8: Acme Global |
Deck 17 |
DUE:
Miniproject 7
(DW at REI_not) Review the previous deck |
| Mon Nov 4 | Granularity. Snowflake schemas | Deck 18 |
Review the previous deck |
| Wed Nov 6 | Data wrangling Intro to MP9: Nolex, |
Deck 19 |
DUE: Miniproject
8 (Variance analysis at ACME) Review the previous deck |
| Mon Nov 11 | Transform & Load workflows Tool: Power BI |
Deck 20 |
Review the previous deck Watch: Power BI tutorial (27 min) Watch: Power query tutorial (16 min) |
| Wed Nov 13 | Intro to SQL test: WWI |
Deck 21 |
DUE:
Miniproject 9 (Data wrangling at Nolex) Review the previous deck |
| Mon Nov 18 | Interrogating DWs with SQL Intro to MP10 |
Deck 22 |
Review the two previous decks Data dictionary resources - navigating the DB |
| Wed Nov20 | SQL Test 2 |
No deck | No GenAI allowed |
| Mon Nov 25 | Tool: Power Pivot |
Deck 23 |
Review the previous deck (22) |
| Nov 27-Dec 1 Thanksgiving recess | |
||
| PART III | MANAGING DATA | |
|
| Mon Dec 2 | Data management at CapTech |
Deck24 |
Session with Cameron Snapp, Technical
Director in Data & Analytics, CapTech |
| Wed Dec 4 | WINIT fest (4 sessions) |
** DUE on Dec 8th ** Miniproject
10 (BI dashboard at WWI) Final considerations. |
|
This schedule can be modified to adapt to the class' learning needs.