MGS 4020 Business
Intelligence
Spring 2019
Dr. Satish Nargundkar
Tentative Schedule: Note that changes may be necessary. The schedule will be updated as needed.
Post all assignments to iCollege in the appropriate folders created for the assignments.
|
Date |
Topic |
Resources |
Assignments |
|
Monday, Jan 14 |
Introduction Analytics Ecosystem |
Chapter 1 |
All assignments can be done with a partner. Only one person in each team needs to turn in on iCollege. |
|
Wednesday, Jan 16 |
Review: Spreadsheet design, Formulas, Functions, Pivot Tables, Charts |
From excelcampus.com: |
|
|
Monday, Jan
21 |
MLK
Day – No Classes |
|
|
|
Wednesday, Jan 23 |
Process Improvement |
Chapter 2
|
Assignment 1: Descriptive Analytics Due Sunday, Jan 27, 11:59 PM. |
|
Monday, Jan 28 |
Guest Lecture: Aruna Manyam Delta Airlines Creating Dashboards In Excel |
Chapter 2 |
Assignment 2: Dashboard Creation Due Wednesday, Jan 30, 11:59 PM |
|
Wednesday, Jan 30 |
Data Base Management Relational Databases |
Chapter 3 |
|
|
Monday, Feb 4 |
Creating Tables in Microsoft Access SQL Basics, SQL Server |
(multiple videos) SQL Server Installation (Windows only) |
Tables, Queries Due Sunday, Feb. 10, 11:59 PM |
|
Wednesday, Feb 6 |
Guest Lecture: Steve Wong Review for Midterm |
|
|
|
Monday, Feb 11 |
Midterm
Examination |
|
|
|
Wednesday, Feb 13 |
Midterm Review |
Midterm
Redo and post: Due Sunday Feb 17, 11:59 PM. |
|
|
Monday, Feb 18 |
Predictive Analytics |
Notes: |
|
|
Wednesday, Feb 20 |
Regression Continued |
Chapter 4 |
Assignment 4: 1. Regression Due Sunday, Feb 24, 11:59 PM |
|
Monday, Feb 25 |
|||
|
Wednesday, Feb 27 |
Libreum International |
|
|
|
Thursday, Feb 28 |
Final
Examination 4:15 –
6:45 PM |
|
|