# Professional Data Analytics Training Certification Course , Kolkata

4.0 Ratings
25 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
24x7
Support
Free Job Preparation Week
Course Syllabus

#### Introduction to Data Analytics

• Data Analysis Introduction
• Application and Industry facts
• Understanding Data Types and Identify Business Use cases

#### Getting Started with Statistics

• Elementary Statistics (Descriptive)

#### Statistics contd.

• Data distributions and Inferential Statistics

#### Regression Analysis

• Regression Models (Linear Model and Logistic Model)

#### Excel Analytics

• Data formatting
• Filtering
• Ordering and grouping
• Expertise in Microsoft Excel to convert your data to insights

#### Excel Analytics contd.

• Using formulas and functions to perform Data analysis

#### Excel Analytics contd.

• Advanced functions for lookup and searching
• Working with Pivot Tables

#### Excel Analytics contd.

• Macros for Job Automation
• Information Protection
• Sharing and tracking

#### Getting Started with RDBMS

• Introduction to RDBMS and MySql
• Database
• Table and Column concepts and creation

#### RDBMS contd.

• Query Design
• Development and execution

#### RDBMS contd.

• Data Merging and filtering
• Table alteration
• Data import and export

#### Project 1

• Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects

#### Project 1 contd.

• Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects

#### Getting Started with R

• 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

#### R for Business Analytics contd.

• Data Visualization Through R

#### R for Business Analytics contd.

• Building Prediction models using R statistical packages

#### Tableau Desktop

• Tableau Introduction and Layout
• Understanding Tableau Connections to files and databases
• Tableau Data Types and simple calculations
• Data aggregation concept in Tableau and implications

#### Tableau Desktop contd.

• Calculations and Parameters
• Data Filters
• Tableau Graphs and Maps
• Creating Tableau Dashboard and Story board

#### Tableau Desktop contd.

• Data Blending
• Custom SQL
• Deeper look into Complex Calculations
• Creating Superimposed Graphs

#### Tableau Desktop contd.

• Tableau and R integration

#### Session 22 Project

• Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects

#### Session 23 Project

• Mentee can select project from predefined set of AcadGild projects or they can come up with their own ideas for their projects

#### Session 24 Project

• 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.
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).
Churn Prediction
Job Preparation Week
After you complete your course, our unique job preperation solution makes sure you can check out all the essentials of your job preperation checklist, right from your resume to your interview skills.
In-depth Mock Interviews
With 2 In depth mock interviews, you are at complete edge over the others.
Resume Building And Interview Questions
Resume builds the first impression and we help you build a resume that stands out.
Online Reputation Building
Helps build a strong online presence in LinkedIn, Git, Stack Overflow and many more.
Resume Sharing With Top Employers
Your resume is shared with top employers, so that you find your dream job.
30+
To Students
2500+
Hours Spent
Coding
100+
Recommendations
Given By Clients
500+
Projects Completed
By Students
Places you could land up to
Customers Feedback
FAQ's

#### What is this course all about?

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.

#### Who should do this course?

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

#### Why should I do this course?

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.

#### What are the pre-requisites for this course?

No pre-requisites but a basic knowledge of Statistics will prove to be beneficial.

#### What are the job prospects after doing this course?Do I need to do any additional course after doing this?

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.

R, RStudio

### Upcoming batches of Data Analytics with Excel, R and Tableau

 Course Name Location Start Date Course Detail Data Analytics with Excel, R and Tableau Bangalore 29 May Know More Data Analytics with Excel, R and Tableau Chennai 29 May Know More Data Analytics with Excel, R and Tableau Pune 29 May Know More Data Analytics with Excel, R and Tableau Hyderabad 29 May Know More Data Analytics with Excel, R and Tableau Delhi 29 May Know More Data Analytics with Excel, R and Tableau Mumbai 29 May Know More Data Analytics with Excel, R and Tableau Bhubaneswar 29 May Know More Data Analytics with Excel, R and Tableau San-diego 29 May Know More Data Analytics with Excel, R and Tableau San-francisco 29 May Know More Data Analytics with Excel, R and Tableau Austin 29 May Know More Data Analytics with Excel, R and Tableau Charlotte 29 May Know More Data Analytics with Excel, R and Tableau Boston 29 May Know More Data Analytics with Excel, R and Tableau Philadelphia 29 May Know More Data Analytics with Excel, R and Tableau Washington 29 May Know More Data Analytics with Excel, R and Tableau Newyork 29 May Know More