- Director's Message
- About The Director
- Heritage
- Founding Fathers
- Brand XLRI
- Vision and Mission
- Board of Governors
- Leadership and Administration
- Industry Advisory Council
- Programs and Equivalence
- XLRI’s Position & Ranking
- Accreditation
- Social Initiatives
- Rural Immersion
- Social Engagement Activities
- Mandatory Disclosure
- Careers Opportunities
- Internal Committee
- Student Profile
- Batch Profile
- Our Recruiters
- Create Visibility for your Firm
- Placement Overview
- Career Transformation Series
- Placement Office Team - PGDM(GM)
- PGDM (GM) Student Committee
- Alumni Speak - PGDM (GM)
- Virtual Internship
- Professional Mentorship Programme
- Guest Lecture Series
- CXO Series
- XL Forum Series
- PGDM (GM) Annual Alumni Meet - Confluence
- Conclaves, Seminars & Panel Discussion
- FAQs
- Fr Arrupe Centre for Ecology and Sustainability
- Financial Market Centre
- Centre for Human Resource Development
- Centre for Logistics & SCM
- Centre for Peace and Justice
- XLRI JRD Tata Foundation in Business Ethics
- Centre for Gender Equality and Inclusive Leadership
- Center for Public Policy and Public Affairs
- XLRI Centre for Spirituality & Human Development
- Case Research & Simulation Development Centre
- Fr McGrath Skill Development Centre
- Centre for Learning and Teaching Innovations
- Centre for Entrepreneurship
- Centre of AI Research and Application (CARA)
- XCITE
- Centre for Experiential and Gamified Experiences (EDGE)
- Centre for Excellence in Coaching & Leadership (X-CEL)
4.0
Share this courseOperations, Production and Decision Sciences
Executive Development Programme in Data Science Using Python, R and Excel Batch-10
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.
- Start date
- 15th January, 2023
- Duration
- 6-7 months · 77 hrs
₹ INR 1,00,000 + Tax
Duration
6-7 Months(77Hrs)
Category
Operations, Production and Decision Sciences
Last Date to Apply
28th January, 2023
Program Directors
Course Details
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 Python, R and Excel. 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 modules are:
-
1. Introduction to R and Python
• Installing R, Python, Jupyter Notebook and R Studio
• Basic Data Structures in Python and R
• Writing Functions
• Use of Loops
• Basic Differences Between R and Python
2. Advanced Features in Excel
• Important Functions in Excel
• Optimization Using Solver
3. Sources of Data
• Important Data Sources
• Scrapping Data from Websites
4. Data Wrangling in R and Python
• Managing Missing Data
• Managing Outliers
• Removing Duplicate Rows
• Making Data Tidy
5. Introduction to SQL
• Introduction to SQL
• Accessing Data in R/Python using SQL Queries
6. Data Visualization
• Visualizing Data
7. Linear Algebra and Calculus
• Vectors, Matrices, and Tensors
• Differentiation
• Understanding Gradient Descent Algorithm
8. Statistics
• Types of Data
• Exploratory Data Analysis
• Sampling Distributions
• Type I and Type II Errors
9. Text Analysis
• Cleaning Text
• Text Representation
• Sentiment Analysis
10. Time Series Analysis
• Time Series Forecasting
• Forecasting using Prophet
11. Machine Learning
• Understanding the Maths of Machine Learning
• Building Machine Learning Models (Regression and Classification)
• Hyperparameter Tuning
• AutoML
12. Deep Learning
• Understanding the Maths of Deep Learning
• Building a Deep Learning Model to Predict Stock Prices
• AutoML in Deep Learning
13. Case Studies in Data Science
• Building Models in Different Functional Areas of Management
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 primary method of instruction will be through LIVE lectures that will be beamed online via Internet to student desktops/laptops or classrooms. The pedagogy will comprise lectures, case walkthroughs, and analytical exercises imparted by XLRI’s faculty. Concepts will be explained using examples drawn from the real life. All enrolled students will also be provided access to the Cloud Campus through which students may access other learning aids, reference materials and assessments, case studies, projects and assignments as appropriate. Throughout the duration of the course, students will have the flexibility to reach out to the professors, real time during the class or offline via the Cloud Campus to raise questions and clear their doubts.
Assessment
A minimum of 70% attendance to the LIVE lectures is a prerequisite for the successful completion of this program. There are periodic evaluations built in throughout the duration of the course. These maybe in the form of a quiz, assignment, project, case studies or other objective/subjective assessments. The evaluations are designed 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. Participants who are unable to clear the evaluation criteria but have the requisite attendance will be awarded a participation certificate by XLRI.
Certification
Participants who successfully complete the course along with the requisite attendance criteria will be awarded a certificate of participation by XLRI.
Programme Fee
| For Indian Participants | For International Participants | |
|---|---|---|
| Application Fee/Installment I | Rs. 35,000 + Tax At the time of Enrollment |
USD 650 |
| Installment II | INR 25000 + Tax On or Before: 28 January 2023 |
USD 500 |
| Installment III | INR 40000 + Tax On or Before 20 March 2023 |
USD 850 |
How to Register
To register for the Short Term Course, Executive Development Programme in Data Science Using Python, R and Excel of XLRI, Jamshedpur;
- Online Application - Candidates are expected to submit Online Application Forms along with the application Fees of Rs. 35000 + Tax (for Indian Participants) to register for the Short Term Courses offered by XLRI Jamshedpur in association with Talent Edge.
- Registration - Candidates are requested to register by clicking on the Register button.
- Payment - Online applicants may use their "Log in ID" and "Password" to make their payment online.
- For the Credit Card Payment , the bank charges will be borne by the participants
- Certificate will be awarded based on the financial clearance
- Last date to apply - The last date for the payment of online application fees is 14 December 2022.
- Information details - Any application with incomplete information (eg: without photograph, educational details and details related to your work experience etc.) will not be accepted. Hence your application will stand cancelled .
- Eligibility
- 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.
- Enquiry - Queries related to the course may be addressed to:
- VIL Office:
- 0657-665-3487 [email protected]
- Mr. Susanta
- 0657-665-3275
* Kindly keep the Registration ID & Password safely with you for any further correspondence with this regard.
*XLRI & Talent Edge reserves the rights to cancel the candidature of any candidate at any point during the Programme for any misconduct or misleading information.
Life at Our Campus
Programmes at XLRI combine live online learning with time on the Jamshedpur campus, a green, historic setting where participants meet faculty and peers in person, join campus sessions and build a lasting professional network.
