Syllabus             Schedule         HOME

 

MGS 4020 – Business Intelligence

Spring 2019 Syllabus

 

Instructor: Dr. Satish Nargundkar 
Office: 827 College of Business 

Office Hours:  By appointment 
Phone: 678-644-6838 

Website: http://nargund.com/gsu  

E-Mail: snargundkar@gmail.com
CRN:   11471 ALC 331

Time: 5:30 – 8:15 PM, MW, Minimester I

               

 

Prerequisites:

·         MGS 3100

 

Text:

1.       Business Intelligece, Analytics, and Data Science: A Managerial Perspective, by Sharda, Delen and Turban, 4th Edition, Pearson Publishing. ISBN 13:978-0-13-463328-2.

 

Attendance/Class Participation:

You are expected to attend and meaningfully participate in all classes (who knows, you may actually enjoy the class!) Assignments and projects remain due on the designated date regardless of class attendance. If you do miss a class, you are responsible for remaining current.

 

Honor Code:

It is more honorable to get any grade with your own work than to get a better grade by using someone else’s work as yours. While discussion with classmates is encouraged, any work submitted must be your own (or your group’s, for group projects). Evidence of plagiarism/cheating on an assignment/exam will result in a failing grade for that assignment/exam, or even for the course.

 

 

Grading:

 

Activity          

Percentage

 

Course Average

Grade

Course Average

Grade

Assignments (4)

40%

 

94-96, 97+

A, A+

77-79

C+

Midterm Exam

30%

 

90-93

A-

73-76

C

Final Exam

30%

 

87-89

B+

70-72

C-

 

 

 

83-86

B

60-69

D

 

 

 

80-82

B-

Less than 60

F

Total

100%

 

 

 

 

 

 

Late assignments will be penalized at a rate of 5% per day. No make up tests will be given, with the exception of a medical reason with a note from a physician. 

 

Course Assessment:

Your constructive assessment of this course plays an indispensable role in shaping education at Georgia State. Upon completing the course, please take the time to fill out the online course evaluation.

 

 

 

 

General Course Objectives:

 

Upon completion of the course, the student should:

1.       Demonstrate an understanding of the role of data and Business Intelligence systems in a business.

2.       Demonstrate an understanding of how data are stored, accessed, and analyzed in a business.

3.       Demonstrate the ability to interpret results of analysis for business decision making.

 

Specific Course Objectives:

In order to earn a grade of ‘A’ in the course, the student should, upon completion of the course, be able to:

 

1.       Define basic BI terms.

2.       Give examples of firms in the Analytics Ecosystem and the functions they perform.

3.       Perform descriptive analysis on data and interpret.

4.       Explain Mean and Variation in data and why the study of variation is important.

5.       Demonstrate competence in Excel basics.

6.       Build dashboards in Excel.

7.       Explain the role of dashboards in helping business decision making.

8.       Define the basic terms of relational databases.

9.       Convert data from a first normal to a third normal form.

10.   Distinguish between operational data and warehoused data; structured/unstructured data.

11.   Create Tables and Queries in MS Access.

12.   Write basic SQL statements like Create, Select, Join.

13.   Perform Regression Analysis and interpret the results.

14.   Use a linear regression model to classify observations.

15.   Evaluate the classification model using a Kolmogorov-Smirnov test.

16.   Interpret the KS table.

17.   Communicate results of analysis to a business audience.

 

Accommodations for students with disabilities
Georgia State University complies with Section 504 of the Rehabilitation Act and the Americans with Disabilities Act. Students with disabilities who seek academic accommodations must first take appropriate documentation to the Office of Disability Services locate in Suite 230 of the New Student Center.