MGS 8020 - Business Intelligence
Summer Semester 2017
| Course: | MGS 8020 - Business Intelligence |
| Classroom: | Buckhead Executive Education Center 413 |
| Instructor: | Steve S. Wong |
| Phone: |
(678) 467-8199 |
| Office Hours: | By appointment |
| E-Mail: |
Please add MGS 8020 to the beginning of the subject line. |
| URL: | wongsteve.com |
Prerequisite
CSP 1,2,4,6 (CSP requirements are outlined in the course catalog – Please read)
Hardware Requirements:
Hardware: The computer should be fast enough and have enough memory (RAM) and disk space to provide satisfactory performance over the course. A tablet (except Surface Pro 3 or above) should not be used as the primary computing device. Bringing your laptop to class is highly recommended.
Operating System: A PC with Windows 7, 8 or 10 installed is required. If you're using Mac, you need to install and run Windows on your Mac.
Processor: 32 or 64 bit multi-core processor or better.
The course assumes an understanding of computers and application software as identified in the prerequisites.
Text
Business Intelligence (3rd Edition) A Managerial Approach on Analytics, Prentice Hall ISBN-13: 9780133051056 (Optional)
George, M. and others, The Lean Six Sigma Pocket Toolbook, McGraw-Hill, 2005 (Optional)
Evans and Lindsay,
Six Sigma and Process Improvement,
Thomson Learning, 2005 (Optional)
Various e-book (more details
can be found from the course schedule)
Various
Papers (more details can be found from the course schedule)
Grading
| Case Study | ||
| Case Study #1 | MasterCard Advisors - Microsoft Excel | 15% |
| Case Study #2 | InterContinental Hong Kong - Microsoft Access | 20% |
| Case Study #3 | Georgia State University - Microsoft SQL Server | 20% |
| Case Study #4 (Group) | Sony Entertainment - Tableau | 20% |
| Case Study | 75% | |
| Final Exam | 25% |
Course Objective
The objective of the Business Intelligence course it to have the student:
Develop a foundation in Business Intelligence (BI) to be used in the Business Analysis curriculum.
Understand decision makers, the decision making process and the role of BI systems in an organization.
Understand the different aspects of the Business Intelligence environment, including the Data Warehouse, Data Mart, Executive Information System, Analytical Applications, Data Mining, Visualization, etc.
Understand the keys success factors in a business intelligence and data warehouse environment.
Explain the differences in database models between an OLAP database and Business Intelligence database.
Identify dimensions and metrics for a given company and/or industry.
Design, develop and implement a desktop BI system.
Be able to create reports for business reporting purposes using different BI tools.
Develop a foundation of understanding for the Lean Six Sigma (LSS) business process improvement methodology and its relationship to BI.
iCollege / Brightspace / Desire2Learn Skills:
You are expected to be proficient in the use of iCollege and all the assignments need to be submitted via the Assignment (i.e. DropBox) in iCollege. Specifically, you should be able to read, upload, and download files; read and send e-mail messages, read and post messages on discussion boards. You are also expected to check the section site daily for any changes, updates, and announcements. A knowledge of these applications is a prerequisite for any course offered by RCB. The University offers remedial courses in any of these applications.
Attendance and Class Participation
Class attendance is expected and necessary component of class participation. In the event that you must miss class, you are still responsible for material covered, and should make arrangements with fellow classmates to remain current with the class. Assignments remain due on the designated date regardless of class attendance. This is a project-oriented class using various computer application programs which require some time commitment. More than 2 missed class periods will result in your class participation marked down one grade. Additional absences may result in a WF.
Honor Code
Plagiarism in any form is not acceptable.
While discussion with classmates regarding homework and projects is encouraged, any work submitted must be your own (except, of course, for group projects). Copying any portion of someone else’s assignment is specifically prohibited. Copying or paraphrasing any portion of someone else’s work without proper attribution in a research paper is also specifically prohibited. Evidence of plagiarism or copying on an assignment/exam will result in a grade of zero for that assignment/exam.