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

Warehouse vs Operational

Chapter 3

 

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

Regression Review

 

 

Monday,

Feb 12

Regression Continued

Classification

Chapter 4

Assignment 4: Regression

Due Sunday, Feb. 18, 11:59 PM

Wednesday,

Feb 14

Classification Continued

 

Team Assignment

Due Wednesday, Feb 21, 5:30 PM.

Monday,

Feb 19

Introduction to Text Mining

Review, Project work.

Chapter 5

Wednesday,

Feb 21

Team Presentations

 

Friday,

Feb 23

Final Examination

4:15 6:45 PM