BUSN661 - Advanced Analytics II

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.

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.