VIL Office
XLRI Xavier School
of Management
C.H. Area(EAST)
Jamshedpur - 831001
Long Term Programs
satellitecoord@xlri.ac.in
Short Term Programs
emdp@xlri.ac.in
Long Term: +0657 665 3185
3211 /12/13/68/72/73/74/75/76
Short Term : 3119/3277
Fax : +91 657 2227814

EDP in Data Science Using R & Excel

EDP in Data Science Using R & Excel

Course Overview

Course Details

The course introduces participants to the world of data science and its techniques of application. It strips away all the distractions around data science, like codes, tools, etc., and focuses on the techniques of data science using practical cases that can be understood and appreciated by someone with an elementary knowledge of mathematics. 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.

Course Content

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:
  • Introduction to Excel
    • Working with Pivot Tables
    • Working with Functions – VLOOKUP, MATCH, INDEX, OFFSET, INDIRECT, etc.
    • Array formulas
    • Solver
  • 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
  • Market Basket Analysis
    • Implementing Apriori algorithm in Excel and R
    • Calculating Lift
  • Customer Segmentation: Cluster Analysis
    • K-means Clustering Using solver
    • Generating Insights from the Clusters
    • Implementing Spherical K-means Clustering Using Excel and R
  • Optimization Modeling
    • Simple Linear Programming
    • Minimax Formulation
    • Modeling Risk within a Linear Program
    • Implementation of Optimization Models in Excel and R
  • Classification Techniques
    • Naïve Bayesian Classifier
    • Learning Bayes Rule to Create an AI Model
  • 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
  • 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

Who Should Attend

Professionals who want to 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 an 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.

Course Pedagogy

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.

Assessment

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. 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.

Certification

Participants who successfully complete the course along with the requisite attendance criteria will be awarded a certificate of participation by XLRI.

Certificate
This course does not have any sections.

This has been one of my best learning experiences. It has got me to appreciate business management in a better way.The teaching faculty have been brilliant, the TA’s have been approachable and helpful throughout the course and I would rate this course a 10 on 10 when its gauged against other similar courses offered.I have been interacting with the students who are from the other institutes at our Hughes center and I have learnt that none of those courses have the rigor that PGCBM demands. This is something I appreciate about the PGCBM course as this has forced us to study and work hard towards achieving a good grade albeit at a cost. The cost is the toll it has taken in managing the work and personal life as the course has been heavy and requires a focused study of a good 2-3 hours every day on an average. But I believe if it was not so then there would not have been any learning. With regards to the campus component I felt it was brilliantly organized and the effort put in by the VIL team is commendable. The faculty was superb, the accommodation was excellent and the food was an absolute treat.

I thank the entire XLRI team for this and hope to be associated with the XLRI family in the years to come.
Mr. Darshan Krishnamurthy – PGCBM 26

I would like to say a BIG THANK YOU…. for all that you all did when we were on campus.I wish we as HR, can be to our employees what you were to us in that week.It was one of the most hectic week but I loved every bit of it. If another week of campus stay is announced, I will register without a thought! Everything was almost perfect. Hearing, knowing of and admiring XLRI is different from experiencing it. In one word, I lived the most inspiring week of my life in Jamshedpur! Thanks again for everything.
Ms. Anindita Dey – PGCHRM 19

I am very proud to be an alumnus of the great institution ‘XLRI’ that has produced some of the greatest leaders in various fields. To have been taught by the professors at XLRI who are great academicians and who guide many global companies to drive their strategies was indeed a sought-after experience. I am very proud to have been a part of XLRI where students are not just students but managers, strategists and leaders in the making. Being an alumnus of XLRI where values and patriotism are omnipresent even today is one of my biggest achievements.
Ms. Rudrani Nalubolu – PGCHRM-14

I am proud to say that XLRI is my alma mater, and extremely happy to have done so well in the course. The best part about the VIL courses is the quality of teaching – we interact with the finest minds in the subject, and the intellectual stimulation that comes out of classroom discussions is simply mind blowing. I will always remember this one year as one of the most valuable years of my life.
Ms. Pushpa Jagadeesan – PGCHRM-13

I have had a wonderful experience as a student of the program and have learned a lot from my professors and fellow students. There are many options available in the education market to continue your education as a professional. However, the experience, exposure and access to years of research in the field of HR cannot even come close to what one can find at XLRI. Being a part of this institution makes me stand apart in the crowd and to believe in what I stand for as an HR professional. I am proud to call myself an XLRI alumnus and it is my honor to be one.
Godfrey Mitchell – PGCHRM-12

Its been an awesome ride at XLRI.I’ve meet some wonderful friends and meet some great leaders who have helped me take critical decisions of my life.I’ve already been recognized by top companies in my sector with offers from companies as renowned as pepper fry, which i had to let go cause i had a different vision.
Currently i have got an opportunity to lead the HR team of one the companies with not only the biggest vision’s in INDIA but in the world which has a vision to save millions of life’s on a click of a button and i would owe this to XLRI for giving me the XL tag, it certainly counts. i am working as a consultant though for 3 months but the opportunity is what I have always wanted lets just hope i make this count. Cheers!!!. Thanks a ton. Its just the beginning… 
Thanks a ton, Team XL.
Archie D souza – PGCHRM-20

With great pleasure and humility I would like to share this moment of happiness with my Respected Professors and Students.On 18th February 2017, I was honored  with prestigious ‘100 most Impactful CSR Leaders ( A Global Listing)’  by World CSR.The 100 Most Impactful CSR Leaders (Global Listing) is a tribute to those who are missionaries and passionate about CSR. Those Leaders who have believed that CSR Leadership must contribute to Social change are recognized. The World CSR Day pays a tribute to such leaders who are transformation agents. By recognizing Leaders who have contributed value & made a change. Such Leaders who are impactful & believe that there is a MAD (Making A Difference) approach to their workThe approach is driven by passion & commitment towards Social Change.I am really grateful towards  XLRI and  my Great Professors for the wonderful learning that helped me develop a new vision and  better approach to my work.I am a proud student of XLRI PGCHRM -20 Batch.
Kindly convey my gratitude to all the professors and batchmates who have contributed significantly for this achievement.
Vibha Natraj – PGCHRM-20

Wonder why something happens suddenly in our life? Explore not. It’s the lord who connects the dot. Such was the amazing experience when I first came to know about XLRI course. I had a quick glimpse of all the details, and thought why cannot I join this? After working for Indian Air force, for seventeen long years, I made up my mind to be an HR person, so that I can render my long term of experience so far to the organization, where I could get an opportunity to work.
The XLRI PGCHRM -21 courses gave me an extreme outlook, to enhance my HR skills to a large extent. The journey from day one was fantastic. It created a platform for getting to know each other, from different parts of the country. Each XLRI’an had many stories to share and learning experiences. In spite of all the hurdles faced by me professionally & personally during the course completion, I made it a point to succeed in all the areas of assessment. Now, a person with many master degrees in hand, feel proud and happy to say that XLRI has great impact on my career. Now after having so much of learning experience, I had been successful in dealing with many issues in my organization.
I should definitely quote here, an HR person deals with human resources, the most challenging task. It requires really great skill and learning. And I believe, XLRI has rendered me those skills. Now when I look back, I feel my quick judgement of enrolling myself in XLRI then was really a great decision.
Sreenivas.K RH-16142 – PGCHRM-21

I found the course extremely useful for working executives like me. The course coverage was exhaustive with all contemporary issues covered at length. The course pedagogy that included quizzes, assignments, mid-term and end-term exams, ensured that along with conceptual learning we also mastered the application of such concepts in real life situations. It was indeed a privilege to learn from the hugely experienced faculty, most of whom shared deep insights from the corporate world, which made our learning more practical and useful.In order to make the programme even more useful, I would like to suggest the following:
Presently, the immersion programme at XLRI campus is for a week during the entire duration of the programme. This needs to be conducted twice (a total of two weeks) during the programme. Such ‘face-to face’ interaction with the faculty is particularly helpful in having a better grasp of such courses/topics as Labour Laws, IR&PM, Collective Bargaining, Social Research Methods, etc.
On the whole, it was a great learning and enriching experience for me as a professional. I shall continue to have fond memories of the wonderful time spent in the classroom and campus with professors and co-students alike!
Arup Kumar – 26th March, 2017

Thank you all so so much for making our stay in the campus super comfortable and a memorable one. We are back at our work stations loaded with funtastic memories and friendships to be cherished forever.
Thank you all once again.
Ms. Srimoyee Basu – PGCBM 26

Campus Component was most wonderful event and it was an experience for lifetime.I never imagined myself as a student again attending classroom lectures. This was possible because of the Campus Component. Thanks for the wonderful hospitality during our stay.
Mr. Santosh Pawaskar – PGCBM 26

Though it was a VIL platform, but I didn’t observe any lack of quality in the teaching pedagogy. Faculty was always approachable. Studying through this platform was the same as studying at college.
                                           Bhim Sain Mirg – PGCBM-19

Visiting the XLRI campus is one of the most memorable experiences of my life. I appreciate the effort you and the team invested in the 1 year VIL program and CC. Hats off to the team. 
                                       Sonia Singh – PGCHRM 18