Introduction to Analytics and Data Science

• Introduction to Business Analytics

Basics of R, Data Handling and Statistics

• Fundamentals of R
• Data Visualization in R
• Data Preparation and Cleaning using R
• Understanding the data using univariate statistics in R
• Hypothesis testing and ANOVA in R to guide decision making

Predictive Analytics in R

• Correlation and Linear regression
• Logistic regression
• Techniques of customer segmentation
• Time series forecasting techniques
• Decision trees & Random Forests
• Boosting Machines
• Cross Validation & Parameter Tuning
• Final Case Study

Data Analysis in SQL (via videos only)

• Introduction to SQL
• SQL Data Types & Operators
• Useful Operations in SQL
• Aggregating Data in SQL
• Writing Sub-Queries in SQL
• Common function in SQL
• Analytic Functions in SQL
• Writing DML Statements
• Writing DDL Statements
• Using Constraints in SQL
• SQL Joins
• Views in SQL

Data Visualization in Tableau (via videos only)

• Introduction to Business Intelligence & Visualization
• Introduction to Tableau
• Dive into Tableau
• Connecting Data Sources
• Tableau Generated Fields
• Data Manipulation in Tableau
• Working with Dates in Tableau
• Data Customization with Calculations
• Adding Dynamism to a View with Parameters
• Geographical Analysis & Maps
• Creating Visualizations
• Adding Statistics to Data
• Formatting & Annotation
• Dashboards & Stories

Python For Data Analytics (via videos only)

• Introduction to Python
• Iterative Operations & Functions in Python
• Data Summary; Numerical and Visual in Python
• Data Handling in Python using NumPy & Pandas