How to Excel in Analytical Decision Modeling
Article Metrics Report
Views, downloads, citations, engagementCited by
Current citation countResearch summary
This paper outlines a course in business analytics that provides a rigorous, logical, analytical, yet intuitive and practical approach to business problem solving using Microsoft Excel. The course concept, methodology and pedagogy are illustrated through a variety of business applications. The course primarily addresses problems involving optimal resource allocation (how to best utilize given resources) and risk analysis (how to analyze decisions involving uncertainty), although some Excel tools for data analysis (how to estimate model parameters) and forecasting (how to extrapolate past observations into the future) are also covered. In each area, we consider specific problems in operations, finance and marketing, build models to set them up on Excel spreadsheets, analyze and solve them using the available Excel commands, tools and add-ins, and study their economic interpretations. In this sense, the course also integrates various functional areas of business management on a common Excel platform. This practical approach to problem solving in Excel has proved to be readily accessible to managers, who usually find spreadsheets natural, intuitive, and user friendly medium for organizing information and performing “what if’ analyses, which has made them indispensable tools of modern business analysis.
Article History
How to Cite
Deshmukh, S. D.. (2016). How to Excel in Analytical Decision Modeling. International Journal of Higher Education Management, Volume 02 Issue 2.
Citation Context
APA
Deshmukh, S. D.. (2016). How to Excel in Analytical Decision Modeling. International Journal of Higher Education Management, Volume 02 Issue 2.
MLA
Deshmukh, Sudhakar D.. "How to Excel in Analytical Decision Modeling." International Journal of Higher Education Management, Volume 02 Issue 2, 2016.
Chicago
Sudhakar D. Deshmukh. "How to Excel in Analytical Decision Modeling." International Journal of Higher Education Management Volume 02 Issue 2 (18 Mar 2016).
Harvard
Deshmukh, S. D. (2016) How to Excel in Analytical Decision Modeling. International Journal of Higher Education Management, Volume 02 Issue 2