Syllabus Schedule HOME

 

MGS 4020 Business Intelligence

Spring 2018

Dr. Satish Nargundkar

 

Tentative Schedule: Please note that changes may be necessary. The schedule will be updated online as needed.

Post all assignments to iCollege in the appropriate folders created for the assignments.

 

Date

Topic

Resources

Assignments

Monday,

Jan 8

Canceled due to inclement weather

 

 

Wednesday,

Jan 10

Introduction

BI overview

Analytics Ecosystem

Chapter 1

 

Monday,

Jan 15

MLK Day No Classes

 

 

Wednesday,

Jan 17

Canceled due to inclement weather

 

 

Descriptive Analytics

Variation and Process Improvement

 

Review: Spreadsheet design, Formulas, Functions, Pivot Tables, Charts

Chapter 2

 

 

From excelcampus.com:

Pivot Tables in Excel 1

Pivot Tables in Excel 2

Excel Dataset for Pivot

Assignment 1: Descriptive Analytics

Due Sunday, Jan 28, 11:59 PM.

 

Assignments 1 & 2 will be done in pairs, given the time reduction due to cancellations.

Monday,

Jan 22

Guest Lecture: Ashwin Kumar Georgia Pacific

 

Creating Dashboards

In Excel

Chapter 2

 

 

Dashboards in Excel

Assignment 2: Dashboard Creation

Due Sunday, Jan 28, 11:59 PM

Wednesday,

Jan 24

Data Base Management

Relational Databases

Normalization

Chapter 3

 

Normalization Example

 

Monday,

Jan 29

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. 4, 11:59 PM

Wednesday,

Jan 31

Guest Lecture: Aruna Manyam Delta Airlines

 

 

Monday,

Feb 5

Midterm Examination

 

 

Wednesday,

Feb 7

Predictive Analytics

Simple Regression

Multiple Regression

Shoe Size Data

Lung Capacity Data

Notes:

Simple Regresssion

Multiple Regression

Assignment 4:

1. Regression

2. Dataset for Assignment

Due Sunday, Feb. 11, 11:59 PM

Monday,

Feb 12

Regression Continued

Classification College Bound

Chapter 4

Team Assignment:

Classification

Due Wednesday, Feb 21, 5:30 PM.

Wednesday,

Feb 14

Classification Continued Introduction to Text Mining

Chapter 5

Monday,

Feb 19

Review, Team Assignment work.

Wednesday,

Feb 21

Guest Lecture: J. P. James

Libreum International

Team Presentations

 

Friday,

Feb 23

Final Examination

4:15 6:45 PM