ExcelR Jumbo PassExcelR Jumbo Pass Video   You May Have Heard About Offers, But Have You Heard Of ExcelR's JUMBO PASS? Well, Here's Your Chance To Avail The JUMBO PASS!! Watch The video

 
Data Analytics course Key Benefits

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.

"Future Ready"

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.

Things You Will Learn

SEMESTER 1

  • Installation
  • R Studio
  • Installation
  • IDE for 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
  • 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
  • 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
  • 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
  • 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
  • Link function 
  • 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

  • Supervised
  • Unsupervised
  • Regression Analysis
  • Survival Analysis using R & 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
  • Classification / Pattern Mining 
  • Black Box
  • Primary data
  • Secondary data
  • Conduction survey’s in order to collect data
  • Digital vs Traditional collection methods
  • Web extraction – extracting data from social media
  • 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
  • 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
  • Understanding Business before designing a strategy
  • SEO Basics
  • Algorithms & Backlinks
  • Social Media Optimization
  • Web Analytics
  • Online Reputation management
  • Email Marketing
  • App Store Optimization
  • NodeXL
  • Tableau
  • Tableau Certification (optional)

SEMESTER 3

  • Boosting & Bagging
  • Gradient Descent
  • Extreme Gradient Boosting (XGBM)
  • C5.0
  • Bias & Variance
  • Regularization
  • 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
  • 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
  • Introduction to Hadoop
  • Components of Hadoop
  • Hadoop Eco-system tools
  • Spark
  • 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

  • Case studies
  • POC
  • Capstone project

Contact Our Team of Experts

Why ExcelR?

FAQs

  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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)
  • 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.
  • 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.
  • 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.
  • 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).
  • 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.
  • Yes, after successfully completing the course you will be awarded a course completion certificate from ExcelR.
  • 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.

ExcelR's Global Presence

Accolades

Call Us whatsapp