Executive Programme in Data Science Using R and Excel from XLRI(CoP)


About Course

Today every business is trying to engage with data science in one form or another. Unfortunately, very few businesses have been able to even grasp the idea of what constitutes data science, let alone a useful or profitable implementation of the same. The phrase - data science triggers thoughts on related terms like business analytics, operations research, business intelligence, competitive intelligence, data analysis and modeling, etc. In addition, the latest craze doing the rounds is big data analytics. No wonder an average business manager is utterly confused about how to start introducing data science in the organization. Meanwhile, popular press keeps exhorting managers not to be late in embracing data science. The consequence is that business managers employ technical solutions without having a good idea of how data science can actually add value to their businesses. 
To preside over a successful implementation of data science in the organization the managers must have a good understanding of the basics, and it is quite impossible to get a feel of data science without getting one’s hands dirty. This course is an entirely hands-on approach to data science where participants would be working with data sets to generate insights for businesses. The tools that we will use are Excel and R. 
The objective of this course is to introduce participants to the world of data science and who have not got a foothold into the techniques. The purpose of this course is to strip away all the distractions around data science – codes, tools, etc., and teach the techniques using practical cases that can be understood and appreciated by someone with an elementary knowledge of mathematics.

Who Should Attend

 Professionals who want learn practical aspects of data handling across applicable areas like Big Data, IT Services, Marketing, eCommerce, Research etc.

 Project Managers, Business Managers and Senior Leaders who have the responsibility to manage large data analytics/big data based projects and would like to gain understanding of this domain.

 Young professionals and Managers who have little or no formal education in Business Analytics, but who now feel the need to embrace technologies which will help them generate insights from data.

 Executives with analytical aptitude who are interested in and want to learn Data Analytics through hands on practice on popular tools. 

 This programme is entirely hands-on and so it is recommended, though not a necessity that students have two devices – one to follow the lecture, and the other for hands-on practice on Excel and R. However, it is mandatory that the sole or primary device must be a laptop or desktop to facilitate hands on practice on tools.


Program Prerequisites

 Mathematics as a subject up to Class XII

 Working familiarity with MS Excel including ability to execute basic functions (eg. min, max, count, average), formatting data, create graphs, insert charts etc. 

 Familiarity with R is desirable but not mandatory. 

 Knowledge of basic programming concepts will be beneficial.

 This programme is entirely hands-on and so it is recommended, though not a necessity that students have two devices – one to follow the lecture, and the other for hands-on practice on Excel and R.


The classes for this programme will be held through LIVE lectures that will be beamed online via internet to student desktops/laptops or classrooms using Talentedge’s Direct To Device platform. The pedagogy will comprise of lectures, case studies, interactive sessions, project work and class exercises imparted by XLRI’s faculty in order to help participants gain the knowledge, understanding, and hands-on skills to immediately apply their learning in the workplace. Additionally, participants opting for Certificate of Completion will be assigned project work and an end course assessment that will be evaluated by the Faculty in addition to providing feedback.

All participants will also be granted 24X7 access to Talentedge’s Cloud Campus comprising of learning aids, study materials, reference materials, assessments, case studies and assignments etc. as per the requirement of the programme. Students can chat real time with the professors during the live class and also post all other programme related queries offline on the Cloud Campus.  


 For Indian Participants - Graduates (10+2+3) or Diploma Holders (only 10+2+3) from a recognized university (UGC/AICTE/DEC/AIU/State Government) in any discipline.

 For International Participants - Graduation or equivalent degree from any recognized University or Institution in their respective country.

 For Indian and International Participants – Interns or Working professionals.


A minimum of 70% attendance to the LIVE lectures is a prerequisite for the successful completion of this programme. There may be are periodic evaluations built in through the duration of the course. These maybe in the form of a quiz, assignment, project or other objective/subjective assessments as relevant and applicable to the programme. The evaluations are designed to ensure continuous student engagement with the course and encourage learning. Participants who successfully complete the same along with the requisite attendance criteria, an end course assessment and project work will be awarded a certificate of completion by XLRI. Participant who opt out of the evaluated exercises and meet the requisite attendance criteria will be awarded a certificate of participation by XLRI.

No mark sheet or grade sheet will be provided to the participants.

Participants of this programme are provided the flexibility of choosing the type of certification they want to pursue right at the time of registration to the programme. 
On the payment of programme fees of Rs.70,000 + Tax and upon satisfying the requisite attendance and evaluation/certification criteria of the Executive Programme in Data Science Using Excel and R, participants will be awarded a certificate of completion issued by XLRI.
On the payment of programme fees of Rs.65,000 + Tax and upon satisfying the requisite attendance and participation criteria of the
Executive Programme in Data Science Using Excel and R, participants will be awarded a certificate of participation issued by XLRI.


XLRI is one of India’s leading management school based in Jamshedpur, Jharkhand, India. Established in 1949 as the Xavier Labor Relations Institute, by Fr. Quinn Enright, XLRI is acknowledged as India's oldest business management school. 
XLRI with its single vision of Magis, i.e., pursuit of excellence, focuses on three areas: academic excellence, personal values and social concern. XLRI spares no effort to make its curriculum world-class and deliver it in the most effective manner. It constantly scans the developments in business and in society and tries to proact to meet the challenges. Its world-class faculty with its commitment and deep sense of service delivers the curriculum very effectively. 
Consistently being acknowledged as the Best “HR Course” in Asia–Pacific, it has also been recognized for its research acumen by the London Business School and is ranked among top 5 research schools in India cutting across management and technical institutes. For more details, visit www.xlri.ac.in 
XLRI features consistently among the top 5 business schools of the country. In 2012 XLRI was ranked No. 4 among top 75 B-schools in India across Private and Government sector by Outlook India. Among other rankings, it was ranked #5 by the 2012 edition of CNBC-TV18' s Top B-Schools in India, #4 by the Business Today 50 best business schools of 2012, #3 by Business World B Schools Unplugged. 
XLRI JAMSHEDPUR IS RANKED 3RD AMONGST THE MANAGEMENT INSTITUTES IN INDIA – According to the reports published by Business Today, India Today, Outlook and The Week on India’s Best B Schools 2014.

Course Benefits

 Opportunity to earn Certificate of Completion or Certificate of Participation from XLRI 

 Hands on exposure to popular Business Analytics tools like Excel and R.

 Programme completely oriented towards imparting practical and working knowledge of tools.

 Course content and structure designed entirely by XLRI

 Lectures imparted by eminent faculty from XLRI

 Fully online program with LIVE interactive lectures that provides a “real” classroom experience in a “virtual” environment.

 In the event that students miss the LIVE lecture, he/she can request “On Demand” access to the recorded session.

 Seamless technology that can transmit lecture videos effectively at home broadband connection of 512 kbps.

 User friendly and easy to use technology interface. No complicated hardware or software installations required.

 Virtual classrooms that allow for active interactions with other fellow students and faculty

 Convenient weekend schedules. 

 Students on our virtual social learning platform are provided access to course presentations, case studies and other learning aids and reference materials as applicable for specified courses.

 Students can raise questions and doubts either real time during the live class or offline through the Cloud Campus.



Data Science Using Excel and R is organized in eight modules. The first part of the course will introduce participants to R and Excel. The second part will consist of solving real-life problems using data analytic techniques. The eight modules are:

1. Introduction to Excel

 Working with Pivot Tables

 Working with Functions – VLOOKUP, MATCH, INDEX, OFFSET, INDIRECT, etc.

 Array formulas



2. Introduction to R 

 Basic Classes of R Objects

 Working with Vectors, Matrices, Dataframes

 Advanced functions in R

 Looping in R

 Writing functions in R

 An introduction to data analytics in R


3. Market Basket Analysis

 Implementing Apriori algorithm in Excel and R

 Calculating Lift 


4. Customer Segmentation: Cluster Analysis

 K-means Clustering Using solver

 Generating Insights from the Clusters

 Implementing Spherical K-means Clustering Using Excel and R


5. Optimization Modelling 

 Simple Linear Programming

 Minimax Formulation

 Modelling Risk within a Linear Program 

 Implementation of Optimization Models in Excel and R


6. Classification Techniques

 Naïve Bayesian Classifier

 Learning Bayes Rule to Create an AI Model


7. Regression

 Training Linear Regression Models

 Statistical Significance of Models

 Evaluating Model Performance

 Logistic Regression

 Comparing Models with ROC curves

 Implementing Models using Excel and R


8. Forecasting 

 Simple Exponential Smoothing

 Holt’s Trend Corrected Exponential Smoothing

 Holt-Winter’s Method

 Prediction Intervals Using Monte Carlo Simulation

 Graphing Predictions Using Fan Cart 

 Implementing Models using Excel and R


Course Schedule & Duration

Batch Number: DS-01-0416-02
Duration of the Course: Admission Closed
Program Fee
  For Indian Residents For International Students
Certificate of Participation Rs.65,000+taxes USD 1450
Additional Service Tax applicable for Indian residents


Payment and Installment Schedule

For Participants Opting for Certificate of Participation


  For Indian Residents For International Students
Registration Fee
Rs.25,000 + tax 
to be paid online at the time of submission of the online application form.
Last Date: NA
USD 550 
to be paid online at the time of submission of the online application form.
Last Date: NA
Installment 1
Through DD/PO/Online/Direct Account transfer
On or Before: NA
USD 350
Through DD/PO/Online/Direct Account transfer
On or Before: NA
Installment 2
Through DD/PO/Online/Direct Account transfer
On or Before: NA
USD 550
Through DD/PO/Online/Direct Account transfer
On or Before: NA

Application Process

All applications for this course must be made through an Online Application Form.
In case payment is being made online through Credit Card/Debit Card, please ensure that you have the Credit Card/Debit Card with you at the time of filling out the Application Form. If you have opted to pay the Application Fee/Instalments of the Fee though Demand Draft/Pay Orders, then please ensure that the Demand Draft/Pay Orders for the applicable amount is made favoring "XLRI Jamshedpur" payable at Jamshedpur and is sent to the address provided below along with the downloaded copy of your Application Form. Please ensure that you write your Name, REGID, Course Name and Contact number at the back of your Demand Draft/Pay Order.
All Demand Draft/Pay Orders along with a downloaded copy of your Application Form must be sent to.
Student Relations Manager,
Unit Nos. 405-407, 4th Floor, Tower B,
Spaze IT Tech Park, Sector 49, 
Sohna Road, Gurgaon 122001, Haryana, INDIA.
Late Fees and Cancellation
Late Fee
The programme fee is payable in instalments as per the instalment schedule provided. In the event of late payment of Instalment 1 or Instalment 2, a Late Fee is leviable as follows.

 A Late fee of Rs.1000 + Tax will be charged to the Participant, if the instalment is paid within 7 days from the due date published on the instalment schedule.

 A Late fee of Rs.2500 + Tax will be charged to the Participant, if the instalment is paid between 8 days from the due date to within 14 days from due date as published on the instalment schedule.

 If the Fee Instalment is not received within 14 days from the due date, then the Participant shall be considered a dropout and a Rejoining Fee of Rs.5000 + tax will be charged to the Participant if the Participant wishes to continue with and complete the programme.

Cancellation Policy
Cancellation by the Participant
1. Requests for refund of fees on account of cancellation of enrolment shall be considered only if such requests are received prior to closure of registration or 15 working days before date of course commencement whichever is earlier.
2. In event that such valid requests for refund of fees are received, the application money shall be refunded after deducting a penalty of Rs. 5,000/- and applicable taxes for Indian participants & USD 125 for foreign participants.
3. In all other cases, no refund shall be made.
4. A participant may opt for rescheduling to a later batch of the same program / another program of XLRI & TE prior to commencement of the program. However, such intimation must be made by the participant at least fifteen days prior to the commencement of the program. The amounts paid by the participant shall be considered as advance payment towards the next batch / alternative program. Further, the participant shall have to pay an administrative charge of Rs. 5,000/- plus applicable taxes (Indian participants) or USD 125 (foreign participants) for facilitating such rescheduling.
Cancellation by the TALENTEDGE & XLRI
TALENTEDGE & XLRI, reserves the right to cancel courses at any time owing to reasons like insufficient enrolments, trainer indisposition or force majeure events. In the event that TALENTEDGE or XLRI cancels a scheduled course, the student will receive full fee refund for the same. All refunds will be processed within 30 days of receipt of a valid refund request.

Faculty Profile

Dr. Soumyakanti Chakraborty

Dr. Soumyakanti Chakraborty

Fellow (IIM Calcutta), B.Tech (Calcutta University)
Dr. Soumyakanti Chakraborty joined XLRI Information Systems Area in 2009. His primary teaching interests include Business Modeling, Strategies of Information and Network Industries. His key research interests include economics of information industries, cloud pricing, two sided platform businesses, combinatorial auctions, and algorithms. He has provided corporate training for reputed organizations in both the private sector and the public sector and includes organizations such as Viacom18, Madura Fabrics Limited, NHPC, NADP, WBSEDCL and other corporates.