MGS 4020 – Business Intelligence
Spring 2018 Syllabus
|
Instructor: Dr. Satish Nargundkar Office Hours: By appointment |
Website: http://nargund.com/gsu E-Mail: snargundkar@gmail.com Time: 5:30 – 8:15 PM, 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+ |
|
Team Assgnmt |
20% |
|
90-93 |
A- |
73-76 |
C |
|
Midterm Exam |
20% |
|
87-89 |
B+ |
70-72 |
C- |
|
Final Exam |
20% |
|
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.