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

14 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

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

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 • 190 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)

117 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

98 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

100 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

103 Learning Materials

PY 205 : Tree Based and Boosting Models

103 Learning Materials

DI Tools and Dashboarding

2 Exercises • 34 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 206: Time Series Analysis & Forecasting

61 Learning Materials

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 • 240454 Students