Data Analytics with R, Excel, Tableau Certification Training Course

  4.2 Ratings
  113 Learners

Did you know the current average salary of Data Analysts in the USAis $62,000? Surely Data Analytics looks like the coolest profession today and AcadGild’s Data Analytics with Tableau introduces you to RDBMS, statistical analysis, R and so much more.

Featured In
Acadgild gets ranked as one of the Top 10 Worldwide Technology Boot Camps.
Course Overview
Introduction to Business Analytics and R Programming
Get introduced to the basics, evolution, and scope of business analytics. Learn R and data manipulation, functions and data visualizations in R.
Statistics and Data Exploration
Understand the various types and applications of statistics as well as the types of data and statistics variables. Master the art of making informed decisions using summary statistics.
Random Variable and Normal Distribution and Hypothesis Testing
Learn random variables, expected value, probability distribution, standard deviation, variance and the types of distributions. Learn how to state null and alternative hypotheses, understanding Type-I and Type-II errors. Conduct one-sided hypothesis test for population.
Correlation and Regression
Apply correlation, strength of linear association, least-squares or regression line, linear regression model, Gain expertise in multiple regression, regression diagnostics and detection of collinearity: simple signs.
Model creation and selection
Learn about fitting of model, diagnostic plots, comparison of models, cross validation, variable selection, relative importance and Box-Cox transformations.
Logistic Regression
Master binary response regression model and linear regression output of proposed model. Work on the various problems with linear probability model, logistic function, logistic regression & its interpretation and the various odds ratio, goodness of fit measures and confusion matrix.
Highly Experienced
Mentors
Develop 2 real time Projects
Lifetime Access to Dashboard
24x7
Coding Support
Internationally Recognized Certification
Course Syllabus
  • Data Analysis Introduction
  • Application and Industry facts
  • Understanding Data Types and Identify Business Use cases
  • Elementary Statistics (Descriptive)
  • Data distributions and Inferential Statistics
  • Regression Models (Linear Model and Logistic Model)
  • Data formatting
  • Filtering
  • Ordering and grouping
  • Expertise in Microsoft Excel to convert your data to insights
  • Using formulas and functions to perform Data analysis
  • Advanced functions for lookup and searching
  • Working with Pivot Tables
  • Macros for Job Automation
  • Information Protection
  • Sharing and tracking
  • Introduction to RDBMS and MySql
  • Database
  • Table and Column concepts and creation
  • Query Design
  • Development and execution
  • Data Merging and filtering
  • Table alteration
  • Data import and export
  • Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects
  • Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects
  • What is R?
  • Unleashing the power of analytics Through R
  • Basic R programming
  • Data import and export
  • Using R for Data Exploration
  • Knowledge on R packages that can help to explore data
  • Data Preparation Through R
  • Data Visualization Through R
  • Building Prediction models using R statistical packages
  • Tableau Introduction and Layout
  • Understanding Tableau Connections to files and databases
  • Tableau Data Types and simple calculations
  • Data aggregation concept in Tableau and implications
  • Calculations and Parameters
  • Data Filters
  • Tableau Graphs and Maps
  • Creating Tableau Dashboard and Story board
  • Data Blending
  • Custom SQL
  • Deeper look into Complex Calculations
  • Creating Superimposed Graphs
  • Tableau and R integration
  • Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects
  • Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects
  • Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects
Projects Which Students Will Develop
Simple Regression Analysis on Fuel Economy Data
The project aims to perform Simple Regression Analysis on Fuel Economy Data.
Churn Prediction
This project is about customer churn prediction problem where starting with a small training set, we can see who has churned in the past and who has not in the past, and we need to predict which customer will churn(churn = 1) and which customer will not churn(churn = 0).
Customers Feedback
FAQ's
R is a programming language and software environment for statistical computing and graphics. R allows you to visualize data, run statistical tests, and apply Machine Learning algorithms. In this course, you will learn about the most effective data analytic techniques and gain practice by implementing them and getting them to work for you. More importantly, you'll learn about not only the theoretical underpinnings of learning but also gain the practical know-how needed to quickly and powerfully apply these techniques to new problems.
Graduate students, post graduate, and Ph.D scholars (from statistical background), entry-level software professionals, and anyone who is interested in a data analytics career
After completion of this course, one can have a solid understand of practical issues in statistical computing which includes programming in R, reading data into R, accessing R packages, writing R functions, debugging, profiling R code, and organizing and commenting R code.
  • Microsoft® Windows® 7/8/10 (32- or 64-bit)
    • 4 GB RAM(Recommended)
    • I3 or higher processor
After doing this course, one will gain good knowledge in statistics and the following:
  • Data manipulation
  • Exploratory data analysis
  • Data visualization
  • Linear models
These skills will provide a quick start for a career as data analyst/data scientist.