Desire2Learn

Instructor Contact

Instructor Home

CS & Cyber School

Augusta University

AIST6410 Agenda

Week 0 beginning Mon Jan 9

Preliminaries & Comments

  1. Classes start Mon Jan 9
  2. Microsoft Teams: We won't use Teams for online class sessions but it is helpful for messaging, one-on-one (or one-on-a-few) meetings and office hours Q&A. So visit Participation with MS Teams and be sure you can use Teams on at least one device. It may help to include the computer you intend to use for this course to help with screen sharing and trouble-shooting via Teams.
  3. Next Mon Jan 16 is Martin Luther King holiday; no AU face-to-face classes

Read, Study, Execute

  1. Visit AIST6410 in D2L, logging in with your @augusta.edu credentials. Note: Logging into D2L for this course is how first week attendance will be checked.
  2. From the Watson Data Management text read
    1. The Preface (p. 2-4 of the pdf download)
    2. Section 1 (intro) The Managerial Perspective (p. 13-15) and Chapter 1 Managing Data (p. 16-32)
    3. Section 2 (intro) Data Modeling and SQL (p. 52-53) and Chapter 3 The Single Entity through the end of section entitled Creating a single-table database (p. 54-top of 62)
  3. TechPrac00 due Sun Jan 15  Note quick due date

Content & Presentation

  1. Instructor video: AIST6410 Spring 2023 Introduction
    1. Course processes, rules & regs
    2. Always complete the requirements in the TechPrac, not just what might be demonstrated in videos or guides
    3. Referencing parts of the Watson Data Management text.
    4. Be sure you can Access O'Reilly online texts
    5. Use the claim code you were emailed to activate your TechCats Solutions subscription: Guidance
    6. Accessing the course remote desktop for course tools
    7. TechPrac00 Overview
  2. View all chapters (50 minutes) of O'Reilly video Data Science Fundamentals for Marketing and Business Professionals. A good, non-technical overview of the field. Note that the video can be sped up and still be well understood.
  3. Instructor video: Comments about Watson Chapter 1 Managing Data | PowerPoint
  4. Creating simple SQL tables (e.g., mechanics for TechPrac00 item II)
    1. Instructor video: First steps with SQL Server Management Studio | Notes
    2. Instructor video: First steps with sqlcmd for SQL Server | Notes
    3. Instructor video: First steps with MySQL Workbench | Notes
    4. Instructor video: First steps with MySQL command line | Notes

Week 1 beginning Mon Jan 16

Preliminaries & Comments

  1. This Mon Jan 16 is Martin Luther King holiday; no AU face-to-face classes

Read, Study, Execute

  1. Read Watson Chapter 2 Information (p. 33-51 of the pdf)
  2. Finish Watson Chapter 3 beginning with Querying a single-table database (p. 62-75 of the pdf)
  3. TechPrac01 due Sun Jan 29

Content & Presentation

  1. Week 1 Overview
    1. We run in two week 'sprints' (e.g., TP01 due in two weeks, TP02 two weeks after). I will try to get several weeks ahead on course development for those who want to work through material early. I divide material between the two weeks somewhat arbitrarily so don't feel you have to stick with the ostensible schedule. Later assignments often do depend on earlier assignments.
  2. Instructor video: SQL queries of a single entity | Demo SQL (e.g., TP01.II)

Week 2 beginning Mon Jan 23

Preliminaries & Comments

Read, Study, Execute

  1. Read Watson Chapter 4 The One-to-Many Relationship (p. 76-92 of the pdf)
  2. Read web article Crow's Foot Notation
  3. TechPrac01 due Sun Jan 29

Content & Presentation

  1. Week 2 Overview
    1. Be sure you use the updated (at 4 pm Thu Jul 19) version of WatsonCh04Exer08.sql in completing TechPrac01 Item IV and that you are doing the queries from this sql file and not the exact queries listed in the text. As I mention in Instructor video: SQL queries involving one-to-many relationships supporting this task, I misinterpreted the author's design for this relation so we really don't have the opportunity to calculate profit; you will find the assigned queries don't require you to do any profit calculations.
  2. Instructor video: Visio Crow's Foot Diagrams (e.g., TP01.III)
  3. Instructor video: SQL queries involving one-to-many relationships (e.g., TP01.IV) | Demo notes

Week 3 beginning Mon Jan 30

Preliminaries & Comments

  1. Read Watson Chapter 5 The Many-to-Many Relationship (p. 93-105 of the pdf)
  2. TechPrac02 due Sun Feb 12

Read, Study, Execute

Content & Presentation

  1. Week 3 Overview
    1. For AIST 6410, we will omit Watson Data Management chapters 6 and 7 (and others, moving forward). Nothing wrong with the content and a review or scan is recommended but they are a little esoteric and theoretical for our needs.
    2. Some guidance notes for TP02.III
  2. (Video) Modeling M:M DB Relationships | PowerPoint (e.g., TP02.I)
  3. Content related to TP02.II
    1. (Video) Create DBs in SSMS | Notes
    2. (Video) Aggregate SQL Query Examples | Notes

Week 4 beginning Mon Feb 6

Preliminaries & Comments

Read, Study, Execute

  1. Read Watson Chapter 8 Normalization and Other Data Modeling Methods (p.106-120 of the pdf)
  2. TechPrac02 due Sun Feb 12

Content & Presentation

  1. Week 4 Overview
  2. (Video) Data Normalization Intro | PowerPoint

Week 5 beginning Mon Feb 13

Preliminaries & Comments

Read, Study, Execute

  1. Review Watson Chapter 10 SQL (p. 192-224 of the pdf) with a focus on sections for INSERT (p. 211-212), UPDATE (p. 212-213) and DELETE (p. 213-214); another suggested reference is the W3Schools SQL Tutorial with a focus on Insert Into, Update and Delete.
  2. TechPrac03 due Sun Feb 26

Content & Presentation

  1. Week 5 Overview
    1. For some tasks in TP03 and beyond you will need your own copy of a sample SQL Server database Northwind; use guidance in Create a copy of Northwind DB to accomplish this.
  2. (Video) The Northwind DB & CRUD | Demo SQL

Week 6 beginning Mon Feb 20

Preliminaries & Comments

Read, Study, Execute

  1. Read Watson Chapter 13 XML: Managing Data Exchange (p. 262-277 of the pdf)
  2. Suggested review W3Schools tutorial on XML
  3. TechPrac03 due Sun Feb 26

Content & Presentation

  1. Week 6 Overview
  2.  (Video) XML Intro and Demo | XML Walkthru Guide

Week 7 beginning Mon Feb 27

Preliminaries & Comments

  1. Note: Tue next week (Mar 7) is midterm; not an exam but the last date to withdraw from a class without a grade penalty.
  2. Next week Mar 9 & 10 are Spring Pause; no AU face-to-face classes

Read, Study, Execute

  1. Take a peek at JSON Overview & CSV Overview (background for TP04.I)
  2. Read Watson Chapter 14 Organizational Intelligence (p. 278-297 of the pdf) Note: IMHO this chapter becomes clearer after completing TP04.II and viewing the related lecture next week
  3. TechPrac04 due Sun Mar 12

Content & Presentation

  1. (Video) JSON & CSV Primer (e.g., TP04.I)
  2. (Video) NW Customer OLAP Cube | Video Notes | NWCustomerOLAP base query SQL | NWCustomerOLAP Build SQL (e.g., TP04.II)

Week 8 beginning Mon Mar 6

Preliminaries & Comments

  1. Note: Tue this week (Mar 7) is midterm; not an exam but the last date to withdraw from a class without a grade penalty.
  2. This week Mar 9 & 10 are Spring Pause; no AU face-to-face classes

Read, Study, Execute

  1. Review The Beginner's Guide to Statistical Analysis as background, reminder and reference for the statistics we use in the course. For our TP04.IV the sections on Hypothesis Testing and t-tests are appropriate.
  2. Review How to Conduct a Two Sample t-Test in Excel (background for TP04.IV)
  3. TechPrac04 due Sun Mar 12

Content & Presentation

  1. (Video) Quick demo of Excel pivot tables & charts (e.g., TP04.III)
  2. (Video) Quick demo of Excel t-tests (e.g., TP04.IV)

    Addendum: In the video when I demonstrate the t-test for a difference in United Package's mean gross amounts from other shippers' mean gross amounts, I inadvertently still had a filter on EmployeeName from earlier practice so the analysis in the video didn't include all the records. If you try to repeat my analysis from the video, the image left below is the correct result, not the image on the right from the video. The overall conclusion -- no evidence of a difference in means -- is still correct. Kudos to Hunter Thomas for spotting this!
    scsc

Week 9 beginning Mon Mar 13

Preliminaries & Comments

Read, Study, Execute

  1. Read the preface page from the video course Microsoft Power BI - A Complete Introduction [2022 Edition]
  2. TechPrac05 due Sun Mar 26

Content & Presentation

  1. Week 9 Overview
    1. For the next three weeks (thru the Master's Break) we will be working with Power BI (a data analysis and visualization tool from Microsoft) based on an online course available from O'Reilly. Content and assignments will primarily come from this material, as described in the Agenda and TechPracs. This is a new delivery so keep me apprised of any issues or problems you run into consuming the materials or developing the deliverables for the TechPrac assignments. As references:

      (O'Reilly) Microsoft Power BI - A Complete Introduction [2022 EDITION]: Video Course | Course Resources

  2. From the Power BI Course, complete all video modules in Chapter 1: Getting Started beginning with Welcome to This Course and ending with How to Access Course Resources
  3. From the Power BI Course, complete all video modules in Chapter 2: Getting Started beginning with Module Introduction and ending with Creating the Project Template

Week 10 beginning Mon Mar 20

Preliminaries & Comments

Read, Study, Execute

  1. TechPrac05 due Sun Mar 26

Content & Presentation

  1. From the Power BI Course, complete all video modules in Chapter 3: Data Preparation beginning with Module Introduction and ending with Wrap Up
  2. From the Power BI Course, complete all video modules in Chapter 4: Data Transformation beginning with Module Introduction and ending with Wrap Up

Week 11 beginning Mon Mar 27

Preliminaries & Comments

  1. Next week Mon Apr 3 thru Fri Apr 7 is AU Spring Break

Read, Study, Execute

  1. TechPrac06 due Sun Apr 9

Content & Presentation

  1. From the Power BI Course, complete all video modules in Chapter 5: The Data Model beginning with Module Introduction and ending with Wrap Up
  2. From the Power BI Course, complete all video modules in Chapter 6:Creating Visuals beginning with Module Introduction and ending with Wrap Up

Week 12 beginning Mon Apr 3

Preliminaries & Comments

  1. This week Mon Apr 3 thru Fri Apr 7 is AU Spring Break

Read, Study, Execute

  1. TechPrac06 due Sun Apr 9

Content & Presentation

  1. Spring Break!!

Week 13 beginning Mon Apr 10

Preliminaries & Comments

Read, Study, Execute

  1. Review Data Management Body of Knowledge (DMBoK) in light of DMBoK Quiz 1 Questions; these questions -- perhaps randomized -- will make up the D2L quiz DMBoKQ1 worth 100 points in TechPrac07
  2. TechPrac07 due Sun Apr 23

Content & Presentation

  1. Comments on the Data Management Body of Knowledge (DMBoK) and the final TechPrac's

Week 14 beginning Mon Apr 17

Preliminaries & Comments

  1. Review Data Management Body of Knowledge (DMBoK) in light of DMBoK Quiz 1 Questions; these questions -- perhaps randomized -- will make up the D2L quiz DMBoKQ1 worth 100 points in TechPrac07
  2. TechPrac07 due Sun Apr 23

Read, Study, Execute

Content & Presentation

Week 15 beginning Mon Apr 24

Preliminaries & Comments

  1. Next Wed May 3 is last class

Read, Study, Execute

  1. Review Data Management Body of Knowledge (DMBoK) in light of DMBoK Quiz 2 Questions; these questions -- perhaps randomized -- will make up the D2L quiz DMBoKQ1 worth 150 points in TechPrac08
  2. TechPrac08 due Sun May 7

Content & Presentation

Week 16 beginning Mon May 1

Preliminaries & Comments

  1. This Wed May 3 is last class

Read, Study, Execute

  1. Review Data Management Body of Knowledge (DMBoK) in light of DMBoK Quiz 2 Questions; these questions -- perhaps randomized -- will make up the D2L quiz DMBoKQ1 worth 150 points in TechPrac08
  2. TechPrac08 due Sun May 7

Content & Presentation

Week 17 beginning Mon May 8

Preliminaries & Comments

  1. Course is finished; last deliverable was due Sun May 7

Read, Study, Execute

Content & Presentation