<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=717202372148975&amp;ev=PageView&amp;noscript=1">
Landing-main-Banner Mobile (2)-2

Executive Education > Open Programs > Data-Driven Decision Making with Excel & Analytics

ENQUIRE NOW

Program-Overview-BW Program-Overview-Col

PROGRAM OVERVIEW

In today’s data-driven business environment, professionals across functions must be able to interpret data, derive insights, and make faster, evidence-based decisions.

While organisations generate vast amounts of data, the real challenge lies in transforming raw data into meaningful, actionable insights.

This two-day intensive Excel & Business Analytics workshop is designed to help participants move beyond basic spreadsheet usage and build strong analytical capabilities using Excel.

Participants will learn how to:

  • Clean and structure raw business data
  • Apply advanced Excel techniques for analysis
  • Build automated MIS dashboards
  • Perform descriptive, diagnostic, and predictive analysis
  • Translate data into clear business insights

The program is highly practical, combining hands-on exercises, real-world datasets, and cross-functional business applications.

Key Highlights

start-date Black start-date Blue

Date

JUNE 2026
Duration Black Duration Blue

Duration

4 half-days- (12-13 June) &
(19-20th June)
Mode of Delivery Black Mode of Delivery Blue

Mode of Delivery

online
CERTIFICATE Black CERTIFICATE Blue

Earn a

Certificate of Completion
from SP Jain
Program Fee Black Program Fee Blue

Program Fees

INR 17,000
per participant

 

Learning Outcomes

By the end of the program, participants will be able to:

  • Use advanced Excel formulas for analysis
  • Apply analytics techniques (descriptive, diagnostic, predictive)
  • Build automated dashboards and MIS reports
  • Perform scenario modelling and simulations
  • Solve real business problems using Excel
  • Present insights effectively for decision-making

Curriculum

Module 1: Foundation for Data-Driven Decision Making
  • Introduction to Business Analytics
  • Descriptive vs Diagnostic vs Predictive Analytics
  • Role of Excel in analytics
Module 2: Advanced Data Cleaning (Excel + Power Query)
  • Handling inconsistent data
  • Data transformation techniques
  • Combining multiple datasets
  • Automating workflows
Module 3: Advanced Excel for Analytics
  • XLOOKUP, INDEX-MATCH
  • Dynamic arrays (FILTER, SORT, UNIQUE)
  • Logical functions and calculations
  • Date and time analytics
Module 4: KPI Analytics
  • Building business KPIs across functions
  • Sales, operations, finance, HR metrics
  • Practical KPI sheet creation

 

Module 5: Descriptive & Diagnostic Analytics
  • Advanced Pivot Tables
  • Variance analysis
  • Trend identification
  • Root cause analysis
Module 6: Advanced Analytics Tools
  • Forecasting techniques
  • Regression & correlation
  • Trend analysis
Module 7: Scenario Modelling
  • Goal Seek
  • Scenario Manager
  • Data tables
  • Optimization using Solver
Module 8: Data Modelling (Power Pivot Basics)
  • Data relationships
  • Introduction to DAX
  • Business modelling use cases
Module 9: Dashboarding & Storytelling
  • Dashboard design principles
  • KPI visualization
  • Interactive dashboards (Slicers, timelines)
  • Presenting insights effectively

 

Module 10: Automation in Excel
  • Macro recorder basics
  • Automating reports
  • One-click refresh dashboards
  • Exporting reports

Program Faculty


Dr Vanita Bhoola
Assistant Dean and Professor – Executive MBA and Executive Education
SP Jain School of Global Management

With an experience of 20+ years in teaching and consulting, Dr Vanita Bhoola has a Doctorate in Project Risk Management from IIM Mumbai, India (2014) and she is also an INSEAD alumnus. Dr Bhoola has handled projects and consultancy assignments with corporate clients, as diverse as Bank of America, Brigade Group, CGI, Colgate-Palmolive, Godrej Infotech, KEC International, Quality Kiosks, Mahindra & Mahindra, Pfizer, Siemens, Tata Housing and many more.

Her areas of teaching expertise include Project Management, Risk Management, Negotiation Skills, Decision Making and Business Statistics. She has published in leading international journals (e.g. Australasian Journal of Information Systems; ABDC = A), in Project Management, Risk Management, Team Dynamics and more broadly HR.

Vanita Bhoola Vanita Bhoola

 

 

HOW YOU WILL LEARN

  • Interactive discussions and participative learning
  • Engaged Learning methodologies
  • Peer interactions
  • Industry examples
  • Role plays
  • Case discussion & analysis

WHO SHOULD ATTEND?

This program is best suited for:

  • Working professionals across functions (Sales, Finance, Operations, HR, Supply Chain)
  • Managers and analysts dealing with data
  • Professionals looking to upgrade Excel skills for business analytics
  • Early to mid-career professionals seeking data-driven decision-making capabilities

Take the Next Step

For more details, or to schedule a personalised consultation, please get in touch.
We look forward to working with you to achieving your learning goals.