Syllabus Schedule HOME

 

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

BI overview

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:

Pivot Tables in Excel 1

Pivot Tables in Excel 2

Excel Dataset for Pivot

 

Monday,

Jan 21

MLK Day No Classes

 

 

Wednesday,

Jan 23

Process Improvement

Overview of Lean & Six Sigma

Lean Tools

Six Sigma DMAIC Process

 

Chapter 2

Variation Spreadsheet

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

 

 

Dashboards in Excel

Assignment 2: Dashboard Creation

Due Wednesday, Jan 30, 11:59 PM

Wednesday,

Jan 30

Data Base Management

Relational Databases

Normalization

Chapter 3

 

Normalization Example

Normalization Example 2

 

Monday,

Feb 4

Creating Tables in

Microsoft Access

SQL Basics, SQL Server

 

MS Access Introduction

(multiple videos)

SQL Server Installation (Windows only)

SQL Queries - Interview

Join Types

Assignment 3:

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.

 

Link to Midterm Exam

Monday,

Feb 18

Predictive Analytics

Simple Regression

Shoe Size Data

Lung Capacity Data

Notes:

Simple Regresssion

Wednesday,

Feb 20

Regression Continued

Multiple Regression

Chapter 4

Multiple Regression

Assignment 4:

1. Regression

2. Dataset for Assignment

Due Sunday, Feb 24, 11:59 PM

Monday,

Feb 25

Classification College Bound

Wednesday,

Feb 27

Guest Lecture: J. P. James

Libreum International

 

Thursday,

Feb 28

Final Examination

4:15 6:45 PM