Data Analytics course for beginners by Jpe

Unit 1: Programming in R
Basics of R
Conditional and loops
R packages/libraries
Data mining GUI in R
Data structures in R
Exceptions/ debugging in R
Unit 2: Data Wrangling
Reading CSV, JSON, XML, .XLSX and HTML files using R
ETL operations in R
Sorting/ merging data in R
Cleaning data
Data management using dplyr in R
Unit 3: Statistics and Probability
Descriptive statistics, random variables, and probability distribution functions
Data distributions like uniform, binomial, exponential, poisson, etc
Probability concepts, set theory and hypothesis testing
Central limit theorem, t-test, chi-square, z-test
Central limit theorem
ANOVA
Unit 4: Modeling in R
Linear regression model in R
Multiple linear regressions model
Representation of regression results
Non-linear regression models
Tree-based regression models
Decision tree-based models
Rule-based systems
Unit 5: Mining Algorithms Using R
Association analysis
Market-based analysis/ rules
Apriori algorithm
Ensemble models - random forest model, boosting model
Segmentation analysis- types of segmentation, k-means clustering, Bayesian clustering.
Feature selection/ dimension reduction- multidimensional scaling, dimension reduction, factor or
component analysis.
Axes
Covariance
Unit 6: Time Series Forecasting in R and Model Deployment
Basics of time series
Components of time series
Time series forecasting
Deploying predictive models
Using SQL server
Using external tools
Using big data tools
Integrating R with Hadoop/Spark
Unit 7: Data Wrangling using SQL and Excel
SQL queries
Integrating with R
Deployment and execution
Data modeling and formatting using Excel
Excel formulas to perform analytics
Macros for job automation
Unit 8: Data Analysis and Visualization using Tableau
Introduction to Tableau and its layout
Connecting tableau to files and databases
Data filters in Tableau
Calculation and parameters
Tableau graphs and maps
Creating Tableau dashboard
Data blending
Creating superimposed graphs
Integrating Tableau with R
Unit 9: Projects and Case Study on R, Excel, SQL and Tableau