Executive Program in Data Science & A.I

Course Instructor: SkillArbitrage

FREE

Course Overview

Schedule of Classes

Start Date & End Date

Jun 14 2023 - Mar 01 2024

Course Curriculum

16 Subjects

EXL301 :Data Analysis with Excel

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

PY201 : Python Fundamentals

11 Exercises • 224 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

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

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

Preparatory Session

4 Learning Materials

preparatory session python

preparatory_session_python

PDF

preparatory_session_SQL

PDF

Induction Session

Dataisgood Induction - PPT

PDF

Class Notes

Python Preparatory Session

ZIP

PY 204 : Machine Learning

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

Logistic Regression Assignment

Assignment

Support Vector Machine (SVM) Assignment

Assignment

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

131 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 207 : Natural Language Processing

101 Learning Materials

Lecture 1: Introduction to NLP

Basic Text processing

ZIP

Introduction to NLP

PDF

Introduction to NLP

PPT

Sample_tweets

Audio

Lecture 2: Feature Engineering in NLP _ Text Classification

NLP Feature engineering

PPT

NLP Feature engineering

ZIP

POS_tagging

ZIP

DPP

PDF

Lecture 3: Advaced Data Cleaning for NLP text classification

Advanced Data Cleaning for NLP text classification

PPT

Advanced_Data_Cleaning_for_NLP_text_classification

ZIP

DPP

PDF

Lecture 4 : Feature Extraction and Feature Encoding for NLP

Feature Extraction Feature encoding for NLP

PPT

Feature Extraction Feature encoding for NLP

ZIP

DPP

PDF

Lecture 5: Introduction to Word Embeddings

DPP

PDF

Advanced word embeddings used to solve NLP problems

PPT

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

NLP Introduction

ZIP

NLP - Advance Cleaning

ZIP

Word embedding

ZIP

NLP Project

ZIP

PY 208 : Deep Learning

123 Learning Materials

Lecture 1: Building blocks of Deep Learning

Day 1 content

PPT

Day 1 DPP

Audio

Lecture 2 : Understanding the components of Neural Networks

Day 2 content

PPT

DPP

Audio

Building first ANN- Day 2

ZIP

Lecture 3: Introduction to Recurrent Neural Networks

Week 2- Day 3 RNN

PPT

Week 2-Day 3 DPP

Audio

Implementation of RNN

ZIP

Lecture 4: Overview of LSTM and GRU

Week 2- Day 4 LSTM and GRU- Copy

PPT

Week 2-Day 4 DPP

Audio

Lecture 5: Introduction to Bidirectional Networks

Week 3- Day 5 Bidirectional Networks

PPT

Week 3- Day 5 DPP

Audio

Lecture 6: RNN Use Cases in the Industry

tatatest

Audio

NSE-TATAGLOBAL

Audio

Language Translation

ZIP

Stock Prices Prediction

ZIP

Lecture 7: Introduction to Convolutional Neural Networks (CNN)

Week 4- Day 7 Convolution Neural Networks

PPT

Week 4- Day 7 DPP

Audio

CNN Implementation on MNIST data

ZIP

Lecture 8: Overview of Transfer Learning

Week 4- Day 8 DPP

Audio

Transfer Learning

PDF

Lecture 9: Introduction to Transformers

Week 5- Day 9 Intro to Transformers

PPT

DPP

Audio

Implementation of Transformers

ZIP

Lecture 10: overview of Autoencoders

DPP

Audio

Week 5- Day 10 Overview of AutoEncoders

PPT

Implementation of Autoencoders

ZIP

PY 203 : Data Cleaning and Preparation

109 Learning Materials

PY 205 : Tree Based and Boosting Models

117 Learning Materials

DI Tools and Dashboarding

2 Exercises • 53 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 Recordings for Tableau

Data Cleaning

Video