Thursday 22nd Jun, 2017

What is BI? 

Business intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. BI applications include the activities of decision support systems, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining.

Thus BI has three components:

  • Requirements: Information System Model describing requirements
  • Storage: Data Warehouse and Data Mart describing storage of data
  • Business Analytics: Analytical Methods like Reports, OLAP, Business Forecasting, Data Mining  to analyze data


What is Business Analytics?

Business analytics is how organizations interpret data in order to make better business decisions and to optimize business processes. Analytical activities are expanding fast in businesses, government agencies and not-for-profit organizations.

Analytics involve use of data, statistical and quantitative analysis, explanatory and predictive modeling, and fact-based decision-making. Analytics may be used as input for human decisions; however, in business there are also examples of fully automated decisions that require minimal human intervention.


Decisions based on data provide a competitive edge to today’s business. Taking the cognizance of the fact that this field is growing very rapidly, many large domestic IT consultancy and service companies have already established a separate “BI” practice.


Objective of the Workshop

This program is designed to develop a thorough understanding of following Data Analysis Techniques:

  • OLAP
  • Business Forecasting
    1. Time Series Forecasting
    2. Causal Techniques (Linear Regression)
  • Data Mining (including Text Mining, Sentiment Analysis)


Target audience 

Business executives (Marketing, FInance, Operations, HR, IT, etc.) preferably with a few years of experience. IT knowledge is not required.



At the end of the workshop participants will be able to understand the concepts and how to use certain Data Analysis Techniques. Armed with the concepts, demonstration and hands-on on various tools, participants will be able to use various Data Analysis Techniques for Decision Support



The workshops will be business case centric, namely, will concentrate on the issues involved in the business, and then discuss the concepts and Data Analysis techniques that will address those issues. The workshop will be an optimal mix of classroom discussions, group discussions amongst the participants, demonstration and hands-on.

The program will have interactive sessions, including:

  • Presentation on concepts
  • Cases discussion on application
  • Paper exercises / demonstration using tool
  • Hands-on


Tools:  Excel, XLMiner, SPSS, Tableau


Learning Plan for a Two-day Workshop


Introduction to Business Analytics and Big Data Analytics

  • Objective
  • Normal and Big Data
  • Requirements
  • Data Warehouse
  • Data Analytics
  • Big Data Analytics
  • Business Analytics
  • Metrics
  • Maturity Models
  • Key Roles

Business Forecasting Overview

  • Why Forecasting
  • Categories of Forecasting
  • Qualitative
  • Time Series
  • Causal

Time Series Components

  • Trend
  • Seasonal
  • Cyclic
  • Irregular

Evaluating Methods

Time Series Techniques for Forecasting (Demonstration and Hands-On using various cases)

  • Naïve
  • Moving Average
  • Exponential Smoothing



Simple Linear Regression

  • What is Linear Regression
  • Demonstration & Hands-On: Various Cases

Multiple Linear Regression

  • What is Multiple Linear Regression
  • Demonstration & Hands-On: Various Cases

Data Mining Techniques – Classification using Decision Tree  – Case: Whom to give car loan?

  • Methodology for Supervised technique
  • Applications
  • Hands-on
  • How to evaluate classification method

Data Mining Techniques  – Market Basket Analysis –  Case: Departmental Store

  • What is Market Basket Analysis
  • Hands-on
  • Applications

Data Mining Concepts, Techniques, Applications : Big Data Analytics

  • Text Mining
  • Introduction to Sentiment Analysis, Social Network Analysis, WEB Mining

Cases by Niteen Bhagwat



Thursday, 22nd June 2017
Friday, 23rd June 2017

9:30 am to 5:30 pm



BMA Knowledge Enrichment Facility
9 Podar House, A Road, Churchgate, Mumbai 400020
4 minutes walk from Churchgate Station
View on Google Maps


Cheque / DD in favour of ‘Bombay Management Association’
BMA Members: Rs.10,000 + Rs.1,500 (plus Service Tax + Cess = 15%)= Rs.11,500/-
Non-Members: Rs.11,500 + Rs.1,725 (plus Service Tax + Cess = 15%)= Rs.13,225/-

For more details contact:

Colonel A R Khadar
M: +91 8939924315; T: Direct – +91 22 22029615; Board no. – +91 22 22047650 / 9698;