#### Course Description

ExcelR Solutions, steered by a team of academically qualified and technically experienced professionals in various emerging technologies, have developed a long term program on Data Science with various emerging technologies to make the students truly.

So it is time to " train while you learn"

• As part of this program, a part of the most advanced curriculum, the students will be exposed to the various live project from industry so that they can seamlessly transition to being an employee from being a student
• ExcelR with its partner firm offers internship opportunities to meritorious students in their chosen domain in Data Science
• Our dynamic curriculum is an amalgamation of the latest emerging technologies that will arm a student with more than necessary skills to succeed in the job market.

#### SEMESTER 1

• Installation
• R Studio
##### 2.Introduction to Python and IDE for python
• Installation
• IDE for Python
##### 3.Basic statistics using R and Python
• Introduction to data
• Data types
• Measuring data
• Probability
• Probability applications with examples
• Probability Distribution
• Types of Probability Distribution
• Examples of Probability Distribution
• Inferential Statistics
• Sampling Technique
• Different Types of Sampling Technique
• SRS technique
• Measure of Central Tendency
• Measure of Dispersion
• Shape Statistics
##### 4.Graphical Representation in R and Python
• Visualization
##### 5.Probability Distribution
• Continuous Probability Distribution
• Introduction to Normal Distribution
• Properties of Normal Distribution
• Standard Normal Distribution (Z dist)
• Student t-Distribution
• Chi-Square Distribution
• Poisson Distribution
• Logarithmic Distribution
• Binomial Distribution
• Sampling Variation
• Central Limit Theorem
• Normal Q-Q plot and its Interpretation
• Confidence Interval
• P-value
• Confidence level calculations
##### 6.Hypothesis Testing using Minitab, R & Python
• Introduction to Hypothesis
• Inferential statistics
• Introduction to Minitab tool
• Framing Hypothesis statement
• Type I error
• Type II error
• Methods to deal with Non-Normal data
• Types of Hypothesis testing
• Case studies using Minitab, R
• Fundamentals of Finance
• Marketing and CRM
##### 8.Principles of Lean Six Sigma
• DMAIC methodology & Minitab
• Introduction to SIX SIGMA
• Team Management
• Define Phase
• Measure Phase
• Analyze Phase
• Improve Phase
• Control Phase
• Design for Six Sigma (DFSS) Frameworks and Methodologies
• Six Sigma Green Belt certification
##### 9.Regression Analysis using R and Python
• Y as function of X
• Relation between Dependent and Independent Variable
• Evaluating the relation using Scatter plot
• Measure of Correlation – Using Correlation coefficient
• Correlation Coefficient and its Analysis
• Equation of Straight Line
• Regression model using “Ordinary Least Square”
• Coefficient of Determination
• Prerequisites of Regression
• Types of Linear Regression
• P-values and coefficients interpretation
• F-Statistic and p-value
• Methods to increase Accuracy
• Error interpretation (RMSE)
• Predicting Binary Output (Y is binary)
• Logit and Probit
• Confusion Matrix
• ROC curve
• Lift chart
• Log Likelihood
• Measure of Accuracy using Confusion Matrix
• Model Improvement Techniques
• Predicting Nominal data (> 2 category)
• Predicting Count data
• Introduction to Bias and Variance
• Lasso Regression
• Ridge Regression
• Imputation – Handling missing data
• Zero-Inflated regression – Handling excess zero’s

#### SEMESTER 2

##### 1.Data Mining using R and Python
• Supervised
• Unsupervised
• Regression Analysis
• Survival Analysis using R & Python
##### 2.Data Mining Unsupervised using R and Python
• Introduction to big data
• Clustering
• Types of Clustering
• Clustering applications and its Limitations
• Cluster Modeling using Tableau
• Dimension Reduction
• Affinity Analysis / Association Rules
• Recommendation Engine
##### 3.Data Mining Supervised using R and Python
• Classification / Pattern Mining
• Black Box
##### 4.Data Collection
• Primary data
• Secondary data
• Conduction survey’s in order to collect data
• Digital vs Traditional collection methods
• Web extraction – extracting data from social media
##### 5.Text Mining using R and Python
• Introduction to Text Mining & NLP
• Corpus / Corpora
• Documents
• Factorizing Data
• Bag of Words
• Document Term Matrix / Term Document Matrix
• Normalizing frequency using TFIDF
• Word Cloud
• N-gram word cloud
• Letter Cloud
• Positive Negative Words
• NLP
• Introduction to parts-of-speech tagging
• Perceptual map/bi-plot
• Trend tracking – topics across time
• Sentence & Word annotations
• Named entity annotations
• Content Analysis
• Lexicons
• Emotion Mining – Arcs & emotions
• Use of machine learning in text classification
##### 6.Forecasting using XLMiner, R & Python
• Introduction to Time series
• Difference between Cross-sectional data and Time series data
• Steps involved in Forecasting
• Time Series Components
• Types of Visualizations
• Autocorrelation and Standard error
• Forecasting Error
• Forecasting Methods
• Fit the best model for 100% data
• Forecast for Future values
##### 7.Contemporary Analytics
• Understanding Business before designing a strategy
• SEO Basics
• Algorithms & Backlinks
• Social Media Optimization
• Web Analytics
• Online Reputation management
• Email Marketing
• App Store Optimization
##### 8.Visualization Tools
• NodeXL
• Tableau
• Tableau Certification (optional)

#### SEMESTER 3

##### 1.Advanced ML topics using R & Python
• Boosting & Bagging
• Extreme Gradient Boosting (XGBM)
• C5.0
• Bias & Variance
• Regularization
##### 2.Deep Learning using R & Python
• Deep feedforward networks or Multilayer perceptron’s
• Performance of Deep Learning Models
• Advanced Multilayer Perceptron
• Image Processing models: Convolutional Networks
• Sequence Modeling: Recurrent and recursive networks
##### 3.Artificial Intelligence
• Image Filtering
• Edge Detection origin f edges
• Frequency Domain
• Image sub-sampling
• Image Features Detection
• Image Feature Descriptors
• Feature Matching
• Window-based Models for Category Recognition
• Neural Network
##### 4.Big Data Hadoop and Spark
• Introduction to Hadoop
• Components of Hadoop
• Hadoop Eco-system tools
• Spark
##### 5.Agile PM program
• Agile concerns & issues
• Introduction to various agile methodologies
• Eight principles of Agile project management
• Testing concepts in DSDM Atern
• Configuration management in DSDM Atern
• Different agile project management styles
• Project development framework
• Different phases of DSDM Atern
• Agile Control
• Risk Management
• Agile Requirements
• Estimating & Measurement
• Planning Agile Projects & Planning Considerations
• Agile Quality Management
• Outline Plan
• Delivery Plan
• Deployment Plan
• Timebox Plan

#### SEMESTER 4

##### SEMESTER 4
• Case studies
• POC
• Capstone project

Contact Our Team of Experts

Why ExcelR?

FAQs

### What Is JUMBO PASS?

• The all new and exclusive JUMBO PASS is the latest initiative taken by ExcelR to offer you access to attend unlimited batches over the duration of 365 days. You will be able to attend unlimited number of classes for the course of your choice.

### What Is The Difference Between Business Analytics, Data Analytics And Data Scientist?

• Data Analytics, Business Analytics & Data Science are the same with just 3 different names. The name of the role of people working in this profession is called as Data Scientist

### What if I have no experience in Business Analytics?

• Data analytics is a profession which caught the attention of the world only since 2 years. Because of this very reason most companies are struggling to close the demand-supply gap. Hence, people who are trained and have decent exposure to the data analytics techniques are recruited immediately.

### What if I am a fresher? Can I still get a job in Business Analytics?

• There are a lot of job opportunities in various job portals for freshers. The key thing employer would be keen to know is whether you have the conceptual knowledge or not. The projects provided by ExcelR in various concepts will only reinforce your learning to make you market ready for the jobs.

### What if I forget the Business Analytics concepts after attending Business Analytics training?

• We understand that the human brain can grasp only so much. Hence, we record all the sessions and provide access to the e-learning to the trainees for the rest of their life.

### Do I need to have strong programming skills to be Business Analyst?

• Yes and No. Yes in the sense programming skills would be required & No in the sense one need not have extremely strong programming skills. However, we at ExcelR ensure that you get sufficient exposure to the statistical programming tool called ‘R’. We start right from the basics assuming you do not have any exposure towards programming.

### Why should we learn R? Can’t we learn any other tool for Business Analytics?

• R has approximately 50% market share & it is open source (free of cost). Hence, R is very lucrative in the analytics space. Almost all the jobs are asking for experience & exposure in R. Demand for other statistical tools is decreasing steadily & hence it is recommended to be futuristic and invest time in learning R.

### What are the salaries that we can expect in the profession of Business Analytics?

• Salaries range varies based on experience, industry, domain, geography & various other parameters. However, as a general thumb rule, we can apply the following formula:
•  Salary = No. of years of experience * 3 Lakhs per annum (India – INR)
•  Salary = No. of years of experience * \$1200 to \$1500 per annum (Overseas – USD)

### What Is Instructor-Led Online Training?

• Instructor-led online training is an interactive mode of training where participants and trainer will log in at the same time and live sessions will be done virtually. These sessions will provide scope for active interaction between you and the trainer.

### How Many Batches Can I Attend, If Enrolled For Training?

• ExcelR offers a blended model of learning. In this model participants, can attend classroom, instructor-led live online and e-learning (recorded sessions) with a single enrolment. A combination of these 3 will produce a synergistic impact on the learning. One can attend multiple Instructor-led live online sessions for one year from different trainers at no additional cost with the all new and exclusive JUMBO PASS.

### Is This A Live Training Or Recorded Sessions?

• The training is a live instructor-led interactive session done at a specific time where participants and trainer will log in at the same time. The same session will be also recorded and access will be provided to revise, recap or watch a missed session.

### Whom Should I Contact If I Want to Know More Information About The Training?

• You can reach out to us by visiting our website and interact with our live chat support team. Our customer service representatives will assist you with all your queries. You can also send us an email at [email protected] with your query and our Subject Matter Experts / Sales Team will clarify your queries or call us on 1800-212-2120 (Toll-Free number – India), 608-218-3798 (USA), 800 800 9706 (India), 203-514-6638 (United Kingdom), 128-520-3240 (Australia).

### What If I Miss A Live Session?

• Not a problem even if you miss a live Business Analytics session for some reason. Every session will be recorded and access will be given to all the videos on ExcelR’s state-of-the-art Learning Management System (LMS). You can watch the recorded Business Analytics sessions at your own pace and convenience.

### Will I Get A Business Analytics Course Completion Certification From ExcelR?

• Yes, after successfully completing the course you will be awarded a course completion certificate from ExcelR.

### What Are The Different Modes Of Payment Available?

• The different payment methods accepted by us are
• Cash
• Net Banking
• Cheque
• Debit Card
• Credit Card
• PayPal
• Visa
• Mastercard
• American Express
• Discover

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.