Dec 04, 2020  
2017-2018 Catalog 
    
2017-2018 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BI 348 - Business Analytics: Data Analysis and Deci

5 Credits
Using Microsoft Excel and statistical analytic methods, learn how to convert real world large data sets into useful information for decision making. A hands on approach to learning business analytics using the latest version of Microsoft Excel to make meaning of the torrent of data that business people now handle. Descriptive and analytic statistical methods will be used, but with every case problem we will use large data sets and convert the unorganized raw data into useful information for decision making

Pre-requisite(s) BUSN 210 and BUSN 218
Program Admission Required Yes Admitted Program BAS - BUSN
Course Note Acceptance to BAS in Global Trade & Logistics required.
Fees CF

Designed to Serve Students pursuing the BAS in Global Trade & Logistics
Active Date 2015-11-18

Grading System Decimal Grade
Class Limit 28
Contact Hours: Lecture 55 Lab 0 Worksite 0 Clinical 0 Other 0
Total Contact Hours 55
Degree Distributions:
Course Outline
1. Intro to data analysis and decision making

2. Describing the distribution of a single variable

3. Finding relationships between variables

4. Probability and probability distributions

5. Normal, Binomial, Poisson and Exponential distributions

6. Decision making under uncertainty

7. Sampling and sampling distribution

8. Confidence intervals

9. Hypothesis testing

10. Regression analysis: estimating relationships

11. Regression analysis: statistical inference

12. Time series analysis and forecasting

13. Introduction to optimization modeling

14. Optimization models

15. Introduction to simulation modeling

16. Simulation models

17. Statistical process control

18. Optional: Data mining, ANOV



Student Learning Outcomes
Use descriptive and analytic statistical methods to convert unorganized raw data into useful information for decision making

Explain the different types of data that Excel can understand.

Create and setup efficient spreadsheets for calculations and data analysis

Create basic, intermediate and advanced charts to visualize quantitative data so it can be used by decision makers

Create basic, intermediate and advanced PivotTables and effectively use Power Query for importing large data sets from multiple sources



Add to Portfolio (opens a new window)