Skip Navigation
 

BUSN661 - Advanced Analytics II

Course Details

Course Code: BUSN661 Course ID: 4631 Credit Hours: 3 Level: Graduate

This course is designed to continue the examination of data and its use in the problem-solving process. In this course, students will integrate advanced skills in Microsoft Excel 2010 with data analysis techniques, including an introduction to big data add-ins such as PowerPivot and the use of Data Analysis Expressions (DAX) to create queries in the PowerPivot tool. (Prerequisite: BUSN660)





Prerequisites

Course Schedule

Registration Dates Course Dates Session Weeks
11/26/18 - 05/03/19 05/06/19 - 06/30/19 Spring 2019 Session I 8 Week session
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
03/25/19 - 08/30/19 09/02/19 - 10/27/19 Summer 2019 Session D 8 Week session

Current Syllabi

After successfully completing this course, you will be able to

CO‐1 Learn about various Excel functions and how to use them to carry out calculations and produce outcomes.

CO‐2 Learn about Optimization in Excel and how to use Solver add‐in to Perform calculations and produce optimization reports.

CO‐3 Summarize & describe data, and compute measures to demonstrate knowledge of descriptive statistics.

CO‐4 Learn about variable relationships and regression modeling CO‐5 Learn about PowerPivot & DAX

CO‐6 Use Data Visualization Software features within spreadsheet, statistical, and data visualization programs to display data.

This course delivered via distance learning will enable students to complete academic work in a flexible manner, completely online. Course materials and access to an online learning management system will be made available to each student. Online assignments are due by Sunday evening of the week as noted and include Forum questions (accomplished in groups through a threaded forum), examination, and individual assignments submitted for review by the Faculty Member). Assigned faculty will support the students throughout this eight‐week course.

NameGrade %
Discussion & Participation 21.00 %
Discussion 1 3.00 %
Discussion 2 3.00 %
Discussion 3 3.00 %
Discussion 4 3.00 %
Discussion 5 3.00 %
Discussion 6 3.00 %
Discussion 7 3.00 %
Final Exam 25.00 %
Final Exam Project 25.00 %
Assignments 54.00 %
Week 1 Homework 7.71 %
Week 2 Homework 7.71 %
Week 3 Homework 7.71 %
Week 4 Homework 7.71 %
Week 5 Homework 7.71 %
Week 6 Homework 7.71 %
Week 7 Homework 7.71 %

Required Course Textbooks ‐

Microsoft Excel 2010: Data Analysis and Business Modeling ISBN: 9780735643369

Author(s): Wayne L. Winston

CHAPTERS 3, 6, 7, 13, 14, 20, 25, 28, 41, 42, 43, 49, 50, 52, 53, 56, and 84

Web Sites

In addition to the required course texts, the following public domain web sites are useful. Please abide by the university’s academic honesty policy when using Internet sources as well. Note web site addresses are subject to change.

Site Name

Web Site URL/Address

American Psychological Association (APA) Style Website

www.apastyle.org

Purdue Online Writing Lab

http://owl.english.purdue.edu/owl/resource/560/01/

YouTube Video on Formatting an APA Style Paper

http://www.youtube.com/watch?v=9pbUoNa5tyY&feature

Microsoft Office Training Website

http://office.microsoft.com/en‐us/support/training‐ FX101782702.aspx

YouTube Videos on Microsoft Excel for Beginners

http://www.youtube.com/playlist?list=PL6D44A8F7E77DB8

Business Analytics Techniques

http://www.businessanalytics.com/

Book Title:Microsoft® Excel® 2013: Building Data Models with PowerPivot
ISBN:9780735676343
Publication Info:Microsoft Press/Pearson
Author:Marco Russo and Alberto Ferrari
Unit Cost:$41.39
Book Title:Microsoft Excel 2013 Data Analysis and Business Modeling
ISBN:9780735669130
Publication Info:Microsoft Press/Pearson
Author:Wayne Winston
Unit Cost:$51.39

Previous Syllabi

Not current for future courses.