Professional Certification Program in Data Analyst

Course Instructor SkillArbitrage

FREE

Course Overview

Schedule of Classes

Course Curriculum

8 Subjects

EXL301 :Data Analysis with Excel

4 Exercises • 97 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

Jan-02-2025

SP101 : Statistics & Probablity

5 Exercises • 67 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

DI Tools and Dashboarding

2 Exercises • 25 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

Class Notes[DSCMO-08JUL23]

Sample - Superstore

ZIP

Ramandeep Batch

ZIP

ALPHAMART’S SALES PERFORMANCE ANALYSIS

ZIP

Data Filters(Data Segmentation)

ZIP

LOD Expressions

ZIP

Class Notes[MBA-RBS-Feb24 + MBA-RBS-MAY24]

Data visualization with tableau

ZIP

ALPHAMART’S SALES

ZIP

PY 203 : Data Cleaning and Preparation

103 Learning Materials

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

115 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 • 184 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

Course Instructor

SkillArbitrage

197 Courses • 236798 Students