With this Online Course, you can realize your ambition of becoming a Data Analytics Professional. You will receive instructor-led trainings on how to use MS Excel and R programming language for capturing, preparing, visualizing, analyzing, and presenting data.

Join the next batch of students and become a Pro in data analytics. This will position you as a candidate for high-paying career and business opportunities.

Course Duration: 4 Months

REGISTER NOW

COURSE MODULES

• Descriptive & Inferential Statistics
• Fundamentals of Microsoft Excel
• Analyzing Data using Advanced Microsoft Excel
• Overview of DBMS and SQL
• Analyzing Data using R Programming Language

Microsoft Excel is a powerful application software for spreadsheet analysis, data analytics and other purposes. R is a very robust and flexible tool for data analytics. It is open source and enjoys the benefit and support of a large community. With R, you can conveniently work on various analytical models to gain insight from data patterns.

This course is a transformational online course on Data Analytics using. The course is designed to help you:

• Understand the concept of data analytics and the phases of a data analytics process
• Understand the rudiments descriptive statistics: measures of centrality, variability and position
  
• Understand various statistical sampling methods
  
• Understand the nature, user interface, and general structure of the MS Excel software
• Understand how to effectively navigate the Excel environment and carryout lots of frequently needed operations
• Learn how to effectively capture and organize data
• Learn how to summarize data at micro level using Microsoft Excel Pivot
  
• Understand how to summarize and presenting data at macro level using various charts and graphs
  
• Learn how to use Excel to work with various business/finance functions – What if analysis, solver, etc.
• Understand how to analyze complex data (from SQL database and other data sources) using Microsoft Excel Power Pivot
• Understand data cleaning and how to clean datasets using MS Excel and R
• Understand the fundaments of R programming and the R and RStudio interface/environment
• Understand how to work with various R objects – vectors, matrices, arrays, lists, data frames, etc.
• Understand R user defined and built in functions
• Understand decision and iteration constructs in R
• Learn how to install, update and work with R packages
• Understand how to import and manipulate excel worksheets in R
• Understand how to import and manipulate data from SQL database in R
• Learn what hypothesis is and understand how to formulate hypothesis
• Understand the difference between parametric and non-parametric statistical models
• Understand forecasting and how to implement same in R and MS Excel
• Understand how to visualize data in using R
• Understand various statistical models and how to implement them with R and MS Excel – regression analysis, t-test, etc.
• Learn how to interpret and communicate the result of analysis to appropriate stakeholders
  
• Professional analytics career counselling

On successful completion of this course the student will be awarded a certificate after the final assessment.

REGISTER NOW

NOTE

This is not just an R and Microsoft Excel tutorial. It is a transformational course on Data Analytics (using R and Excel as tools) which has the potential to add value to you professionally and financially.