BA5211

Data Analysis and Business Modeling

HBS > Employability Enhancement Courses > Data Analysis and Business Modeling
Course ID
BA5211
Level
Post Graduation
Semester
Semester II

OBJECTIVES:
• To have hands-on experience on decision modeling.

[Business models studied in theory to be practiced using Spreadsheet / Analysis Software]

S.No Exp.No Details of experiments Duration
1 1 Descriptive Statistics 4
2 2 Hypothesis – Parametric 4
3 3 Hypothesis – Non-parametric 4
4 4 Correlation & Regression 4
5 5 Forecasting 4
6 Extended experiment – 1 4
7 6 Portfolio Selection 4
8 7 Risk Analysis & Sensitivity Analysis 4
9 8 Revenue Management 4
10 Extended experiment – 2 4
11 9 Transportation & Assignment 4
12 10 Networking Models 4
14 12 Inventory Models 4
15 Extended experiments – 3 4

• Spreadsheet Software and
• Data Analysis Tools

TOTAL: 60 PERIODS

OUTCOMES:
• Knowledge of spreadsheets and data analysis software for business modeling.

REFERENCES :

  1. David M. Levine et al, “Statistics for Managers using MS Excel’ (6th Edition) Pearson, 2010
  2. David R. Anderson, et al, ‘An Introduction to Management Sciences: Quantitative approaches to Decision Making, (13th edition) South-Western College Pub, 2011.
  3. Hansa Lysander Manohar , “ Data Analysis and Business Modelling using MS Excel “,PHI Learning private Ltd, 2017.
  4. William J. Stevenson, Ceyhun Ozgur, ‘Introduction to Management Science with Spreadsheet’, Tata McGraw Hill, 2009.
  5. Wayne L. Winston, Microsoft Excel 2010: Data Analysis & Business Modeling, 3rd edition, Microsoft Press, 2011.
  6. Vikas Gupta, Comdex Business Accounting with Ms Excel, 2010 and Tally ERP 9.0 Course Kit, Wiley India, 2012
  7. Wayne L. Winston, Microsoft Excel 2010: Data Analysis & Business Modeling, 3rd edition, Microsoft Press, 2011.