iimtrichy_edukateX_324.2

Business Analytics for Beginners using Microsoft Excel

Analytics driven decisions in businesses are more informed and can be taken with conviction. We live in an era where data is readily available to obtain the best possible information.

65,000.00 (Exc GST)

₹ 76,700.00 Inc GST
Exclusive of all taxes Limited Seats
  • CategoryBusiness Analytics
  • LevelAdvance
  • Duration5 days
  • LanguageEnglish
  • Course Provider IIM Tiruchirappalli

Analytics driven decisions in businesses are more informed and can be taken with conviction. We live in an era where data is readily available to obtain the best possible information. However, the key challenge is to extract relevant information from it. Analytics represent the ability to discover and implement data-driven decisions, based on pertinent, trustworthy and timely data sources. Virtually every areas of business use analytics for decision making. This course aims at providing an introduction to fundamental building blocks of analytics that helps in managerial decision making.

Programme Objectives

Informed decision making is crucial and industry professionals cannot entirely rely on observation and experience to make a decision. Business analytics is a structured method of quantitative reasoning and analytics tools that are extensively used for decision making. Industry professionals equipped with data analytics tools and techniques enable them to engage in decision making process with authority, accuracy and integrity. This programme aims at equipping the participants with the fundamental and introductory analytics methods that can be used in business decision making. At the completion of this course, participants will be able to develop a critical appreciation and understanding of:

  1. Different types of analytics and their importance in business context for decision making
  2. Applying the appropriate analytics tools and techniques to analyze data in various business context
  3. Interpreting data analysis using analytics for business decisions

Pedagogy

Classroom discussion and case analysis with hands-on exercises through spreadsheet modeling using Microsoft Excel. The participants are required to bring laptops to the sessions with Microsoft Excel installed.

Programme Content

This programme introduces the participants to various analytics tools using Microsoft Excel through a structured approach on the following topics:

  1. Descriptive Analytics:
  2. Predictive Analytics
  3. Prescriptive Analytics
  4. Decision Analytics
  5. Evaluative Analytics

The contents across the topics include data description, data visualization, data inferences, regression analysis, optimization modeling, optimization sensitivity analysis, decision tree, analytical hierarchy process, risk modeling and Monte-Carlo simulation.

Profile of Programme Director

Dr. Godwin Tennyson has a mix of academia and industry experience of more than 20 years and has been associated with IIM Tiruchirappalli since its inception in 2011 as the founding faculty member of Operations Management and Decision Sciences area. After obtaining his doctoral degree from IIT Madras, Dr. Godwin had worked in corporate sector for nearly five years as business analytics and operations research consultant in Kantar Millward Brown Analytics (formerly Marketing and Planning Systems) and Blue Yonder (formerly JDA Software) before joining IIM Tiruchirappalli. Dr. Godwin is a Professor in Operations Management and Decision Sciences area at IIM Tiruchirappalli and has taught across all masters and doctoral programmes offered by the institute. At IIM Tiruchirappalli, Dr. Godwin is actively involved in teaching, research, institution development roles, and executive education. Dr. Godwin serves as external examiner for doctoral candidates, external member of doctoral committees, member of board of studies, member of senate, member of governing council, member of board of directors and academic auditor for various organizations, institutions and universities

Profile of Expected Participants

This programme is intended for industry professionals across all functional domains and at any level of their career who aspire to know and learn business analytics.

COURSE CODE Mode Location Start Date Availability Price  
iimtrichy_edukateX_324
Offline IIM Trichy (Chennai Campus) 03 June 2024
65,000.00
iimtrichy_edukateX_324.1
Offline IIM Trichy 13 May 2024
65,000.00
iimtrichy_edukateX_324.2
Offline IIM Trichy 27 May 2024
65,000.00
iimtrichy_edukateX_324.3
Offline IIM Trichy 03 June 2024
65,000.00
iimtrichy_edukateX_324.4
Offline IIM Trichy (Chennai Campus) 13 May 2024
65,000.00
iimtrichy_edukateX_324.5
Offline IIM Trichy (Chennai Campus) 27 May 2024
65,000.00
iimtrichy_edukateX_324.6
Offline Client location 13 May 2024
65,000.00
iimtrichy_edukateX_324.7
Offline Client location 27 May 2024
65,000.00
iimtrichy_edukateX_324.8
Offline Client location 03 June 2024
65,000.00
IIM Tiruchirappalli

IIM Tiruchirappalli is the eleventh IIM and was instituted on 4th January 2011. Tiruchirappalli is a city known for its prominence in education, spirituality, art and culture and IIM Trichy tends to benefit from this.