GCOM 7380 - Course Schedule *
| DATE | TOPICS (may be rearranged to fit the class needs) | DECKS | HOMEWORK DUE |
|
Wed Aug 25 |
Welcome to the course! Databases and Analytics in Accounting | Deck |
Readings #1 |
| PART I | ORGANIZING BUSINESS DATA | |
|
| Mon Aug 30 | Design a simple database I |
Deck |
Read about WINIT and participation Readings #2 |
| Wed Sept 1 | Design a simple database II | Deck |
Readings #3 |
| Mon Sept 6 | Database design practice I | Deck |
Readings #4 and practice Draw IO |
| Wed Sept 8 | Database design practice II | Same as previous |
Practice with the exercises in last class' deck. Bring questions to class or ask them in Teams. This is the ERD developed in class (you need to unzip it). Warning: this is 'as-is.' |
| Mon Sept 13 | From design to implemented databases |
Deck |
Graded assignment #1 |
| PART II | STORING, SEARCHING, AND MANIPULATING BUSINESS DATA | |
|
| Wed Sept 15 | Learning SQL 1 - single table operations Tools: ADS |
Deck |
No readings for today (you are welcome) |
| Mon Sept 20 | Practice: database design for business 1 Tools: the DB Workbench |
Deck |
Readings #5 and Optional activity #6: practice queries vLab: starting up ADS |
| Wed Sept 22 | Learning SQL 2- Nested queries and joins | Deck | Readings #7 vLab: creating a notebook Data modeling case (pwd protected) Graded assignment #2 - SQL Rubric for ERD assignments |
| Mon Sept 27 | Practice: database design for business 2 | Deck |
Readings #8 |
| Wed Sept 29 | More joins practice Practice: database design for business 3 |
Deck |
Readings #9 Graded Assignment #2 - solutions Graded Assignment #3 - SQL (due Sunday) Notebook for the 29sep practice |
| Mon Oct 4 | Evaluating designs: Normalization | Deck |
Readings #10 |
| Wed Oct 6 | Learning SQL 3 - Data Definition Language | |
Readings #11 Creating the SmallBank DB - notebook Updates and Views - notebook |
| READING DAYS | |
|
|
| Wed Oct 13 | Database integration 1 See the attendance instructions in Teams |
Deck |
vLab: getting started with MySQL Workbench Graded assignment #4 - Advanced ERD Team compositions for #4 No readings for today |
| Mon Oct 18 | Database integration 2 See the attendance instructions in Teams |
|
Graded assignment #5 - SQL vLab: Creating the SmallBank DB vLab: Updates and views No readings for today |
| Wed Oct 20 | Putting it all together: operational databases |
Deck |
Readings #12 |
| PART III | THE DATA SIDE OF ANALYTICS | |
|
| Mon Oct 25 | Data quality with Power query |
Deck |
No readings for today |
| Wed Oct 27 | Pivot tables | Deck |
Readings #13 Graded Assignment #6 - Team Operational Database |
| Mon Nov 1 | Data Warehouses |
Deck |
Readings #14 Graded assignment #7:Excel Power Query (now due on Wed the 3rd) Feedback codes for the ERD assignments |
| Wed Nov 3 | Designing data warehouses |
Deck |
Readings #15 Graded Assignment #8: Pivot (now due on Fri the 6th) Zagi Blueprints |
| Mon Nov 8 | Data visualization: Tableau | Deck |
Readings #16 |
| Wed Nov 10 | Tableau II and Designing a DW |
Deck |
Readings #17 |
| Mon Nov 15 | Alternative DB technologies |
Deck |
Graded Assignment #9: Team Data Warehouse (now due on Nov, the 17th) Readings #18 |
| PART IV |
MANAGING BUSINESS DATA | |
|
| Wed Nov 17 | Security | Deck |
Readings #19 |
| Mon Nov 22 | Blockchain (Class on Zoom only - see Teams) | Deck |
Readings #20 |
| RECESS | |
|
|
| Mon Nov 29 | Data quality | Deck |
Readings #21 |
| Wed Dec 1 | Ethics and Privacy | Deck |
Graded Assignment #10: Tableau Readings #22 |
| Mon Dec 6 | Data Monetization |
|
Readings #23 Optional final project due on the 15th at midnight |
* I want to keep this schedule flexible to adapt it to the class needs. If we make good progress, we might accelerate it, if we require going over again some topics to improve understanding, we will slow it down.
Decks are posted after the class.