Professional Certification Program in Data Analyst

Course Instructor SkillArbitrage

FREE

Course Overview

Schedule of Classes

Course Curriculum

9 Subjects

EXL301 :Data Analysis with Excel

4 Exercises • 100 Learning Materials

Resources

EXL_301_Book

PDF

Class Notes

P2: Data Analysis with MS Excel

Audio

P3: Summarizing and Forecasting

Audio

P2: Data Analysis with MS Excel (Math Function)

Audio

P2: Data Analysis with MS Excel (Conditional Statement)

Audio

P3: Summarizing and Forecasting

Audio

P4: Macros and Dashboarding

Audio

Sample Superstore Database

Sample Superstore

Audio

L1: Unleashing the Power of Excel

L1_Excel_Learning Material

PDF

L1: Unleashing the Power of Excel (DPP)

Exercise

L2: Data Analysis with MS Excel

L2_Excel_Learning Material

PDF

L2: Data Analysis with MS Excel (DPP)

Exercise

L3: Summarizing and Forecasting

L3_Excel_Learning Material

PDF

L3: Summarizing and Forecasting (DPP)

Exercise

L4: Macros and Dashboarding

L4_Excel_Learning Material

PDF

L4: Macros and Dashboarding (DPP)

Exercise

SQL103 : Data Analysis with SQL

9 Exercises • 162 Learning Materials

Resources

SQL_103_Book

PDF

SQL_103_WorkBook

PDF

Lecture 1

PDF

Lecture 2

PDF

Lecture 3

PDF

Lecture 4

PDF

Lecture 5

PDF

Lecture 6

PDF

Lecture 7

PDF

Class Notes

L3: Data Filtering

ZIP

L4: Data Analysis using aggregate functions and group by

ZIP

L5: Joins and Keys

ZIP

L7: Object Oriented Programming

ZIP

Python Project

ZIP

Clauses of the MySQL

ZIP

Exception handling & L6: Regular Expressions

ZIP

L6: Regular Expressions

ZIP

L6: Subqueries and Views

ZIP

SQL Assignment

Assignment

Questions Assignment-2[SQL]

ZIP

SQL_Assignment

Assignment

L1: Introduction to SQL and Installation

L1_SQL_Learning Material

ZIP

L1 Introduction to SQL and MySQL installation (Daily Practice Problem)

Exercise

L1_SQL_DPP Solutions

application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess

L2: Data Creation and Retrieval

L2_SQL_Learning Material

ZIP

L2 Data Creation and Retrieval (Daily Practice Problem)

Exercise

L2_SQL_DPP Solutions

application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess

L3: Data Filtering

L3_SQL_Learning Material

ZIP

L3: Data Filtering (Daily Practice Problem)

Exercise

L3_SQL_DPP Solutions

application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess

L4: Data Analysis using aggregate functions and group by

L4: Data Analysis using aggregate functions and group by (Daily Practice Problem)

Exercise

L4_SQL_DPP Solutions

Audio

L4_SQL_Learning Material

ZIP

L5: Joins and Keys

L5_SQL_Learning Material

ZIP

L5: Joins and Keys (Daily Practice Problem)

Exercise

L5_SQL_DPP Solutions

Audio

L6: Subqueries and Views

L6_SQL_Learning_Material

ZIP

L6: Subqueries and Views (Daily Practice Problems)

Exercise

L7: Window/Analytical Functions

L7_SQL_Learning Material

ZIP

L7: Object Oriented Programming (DPP)

Exercise

L7_DPP_Solutions

Audio

Databases

ZIP

PY201 : Python Fundamentals

11 Exercises • 223 Learning Materials

Resources

PY_201_Book

PDF

PY_201_WorkBook

PDF

Assignment

L1: Introduction to Python and Data Science

L1 Python Learning Material

ZIP

L1: Introduction to Python and Data Science (DPP)

Exercise

L1 DPP Solutions

Audio

L1_Practice_Set

ZIP

L1_Practice_Set_Answer_Key

ZIP

L2: Working with Python Data Structures

L2_Python Learning Material

ZIP

L2: Working with Python Data Structures (DPP)

Exercise

L2_DPP_Solutions

Audio

L2_Practice_Set

ZIP

L2_practice_set_answer_key

ZIP

L3: Control Flow Statements

L3_Python_Learning_Material

ZIP

L3: Control Flow Statements (DPP)

Exercise

L3_DPP_Solutions

Audio

Practice Set

ZIP

L4: Functions in Python

L4_Python_Learning_Material

ZIP

L4: Functions in Python (DPP)

Exercise

L4_DPP_Solutions

Audio

Practice Set

ZIP

L5: File Handling in Python

L5_Python_Learning_Material

ZIP

L5: Control Flow Statements (DPP)

Exercise

L5_DPP_Solutions

Audio

Practice Set

ZIP

L6: Regular Expressions

L6_Python_Learning_Material

ZIP

L6: Regular Expressions (DPP)

Exercise

L6_DPP_Solutions

Audio

Practice Set

ZIP

L7: Object Oriented Programming

L7_Python_Learning_Material

ZIP

L7: Object Oriented Programming (DPP)

Exercise

L7_DPP_Solutions

Audio

Practice Set

ZIP

SP101 : Statistics & Probablity

5 Exercises • 75 Learning Materials

Resources

SP101W-Workbook-ebook(DPP's)

PDF

SP101-Course Book

PDF

Stats_and_Probability_learning_material

PDF

L1: Introduction to Statistics

L1_Stats_Learning Material

ZIP

L1: Introduction to Statistics (DPP)

Exercise

L2: Probability Theory

L2: Probability Theory (DPP)

Exercise

L3: Sampling Theory

L3_Stats_Learning Material

ZIP

L3: Sampling Theory (DPP)

Exercise

L4: Statistical Inference I

L4: Statistical Inference I (DPP)

Exercise

L5: Statistical Inference II

L5: Statistical Inference II (DPP)

Exercise

Introduction to Statistics

DI Tools and Dashboarding

2 Exercises • 37 Learning Materials

Learning Material

L1_Introduction to Tableau

PDF

L2_Data_Sourcing_and_Preparation

PDF

L3_charts and graphs

PDF

L3_charts_and_graphs_worksheets

ZIP

L4_Grouping Filtering and LOD

PDF

L4 LOD

ZIP

Sample Superstore

ZIP

Tableau Practice Questions (Superstore Dataset)

PDF

Practice Sets

Sample Superstore

ZIP

Tableau Practice Questions (Superstore Dataset)

PDF

Practice Assignment- I

ZIP

Practice Assignment - II

ZIP

Tableau Practice Questions Answers

ZIP

Assignment

Dashboarding Assignment I

Assignment

Dashboarding Assignment - II

Assignment

PY 203 : Data Cleaning and Preparation

103 Learning Materials

PY 202: Python For Data Science _ Data Viz (Pandas)

121 Learning Materials

Lecture1: Using Python Numpy Library

Practice Numpy Basic Operations Day-1

PDF

Basic Operations using Numpy.zip

ZIP

Lecture2: Linear Algebra and Numpy

Practice Linear Algebra and Numpy Operations - Day2

PDF

Linear Algebra using Numpy

ZIP

Lecture5: Extracting and Aggregating Pandas

Extracting and Aggregating using Pandas

ZIP

DPP

PDF

Lecture6: Matplotlib and seaborn

Matplotlib and Seaborn

PDF

Visualisation using Matplotlib and Seaborn

ZIP

Lecture 7: Plotly and Cuffinks

Plotly and Cufflinks

ZIP

Plotly and Cufflinks

PDF

Class Notes [6:30]

Project Session

PDF

PY 204 : Machine Learning

5 Exercises • 199 Learning Materials

Lecture 1: Modelling with Linear Regression

Simple Linear Regression

ZIP

Multiple Linear regression

ZIP

DPP

PPT

kc_house_data

Audio

Linear regression

PPT

Lecture 2: Regularisation Techniques

Regularization

ZIP

DPP

PDF

Lecture 3: Regularisation Techniques II

Regularization-2

ZIP

Regularization

PPT

practice questions regularization

PDF

Lecture 4: Modelling with Logistic Regression

Logistic regression

ZIP

Logistic Regression

PPT

DPP

PDF

Lecture 5: L5 Understanding other classification algorithm like KNN _ SVM

Understanding other classification algorithm like KNN _ SVM

PPT

Understanding other classification algorithm like KNN _ SVM

ZIP

DPP

PDF

Lecture 6: L6_ Advanced Model Evaluation Techniques

Evaluating Models _ Feature selection (classification _ Regression)

PPT

Evaluating models and feature selection sample code-3

ZIP

Naive bayes

PDF

DPP

PDF

Lecture7: Introduction to Clustering and K Means

Class 6 Introduction to Clustering and K Means

PDF

K-means

ZIP

DPP

PDF

Lecture 8: Advanced Clustering Techniques

Advanced Clustering Techniques

PDF

Hierarchical Clustering

ZIP

DPP

PDF

Class Notes[DSCAF-JUNE24]

L1: Modeling with Linear Regression

ZIP

L4: Modeling with Logisitc Regression

ZIP

L5: Understanding other classification algorithm like KNN & SVM

ZIP

L5: Understanding other classification algorithm like KNN & SVM

PDF

L5: Understanding other classification algorithm like KNN & SVM

PDF

L5: Understanding other classification algorithm like KNN & SVM

ZIP

Naive_Bayes

ZIP

Logistic Regression Assignment

Assignment

Support Vector Machine (SVM) Assignment

Assignment

Assignments

13 Exercises •

Exercises on Tableau Dashboarding and Storytelling

Weekly Exercises on Tableau Dashboarding and Storytelling

Assignment

Exercises on SQL Data Filtering

Weekly Exercises on SQL Data Filtering

Assignment

Exercises on Python Data Structures Updated

Weekly Exercises on Python Data Structures Updated

Assignment

Random Forest for Automotive Data Analytics

Weekly Exercises on Random Forest for Automotive Data Analytics

Assignment

Machine Learning for Financial Data Analytics

Weekly Exercises on Machine Learning for Financial Data Analytics

Assignment

NLP Fundamentals for Data Analytics: Social Media Text Analysis

Weekly Exercises on NLP Fundamentals for Data Analytics_ Social Media Text Analysis

Assignment

Weather Prediction Time Series Forecasting

Weekly Exercises on Weather Prediction Time Series Forecasting

Assignment

Statistics for Data Aggregation in Healthcare

Weekly Exercises on Statistics for Data Aggregation in Healthcare

Assignment

Weekly Exercises on Data Analysis & Visualization Fundamentals

Assignment

Exercises on AI-Powered Automation for Data Science Using GitHub Copilot in VS Code

Assignment

Exercises on Tableau

Assignment

Weekly Exercise on LOD in Tableau

Assignment

Weekly Exercises on Dashboarding and Advanced Data Visualization

Assignment

Course Instructor

SkillArbitrage

201 Courses • 240606 Students