Course Overview
Schedule of Classes
Course Curriculum
11 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
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
Databases
ZIP
PY201 : Python Fundamentals
11 Exercises • 224 Learning Materials
Resources
PY_201_Book
PDF
PY_201_WorkBook
PDF
Assignment
Assignment
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 • 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
01:30:13
Data Visualization
Video
02:07:00
Data Visualization
Video
02:14:31
Data Filters(Data Segmentation)
Video
02:02:21
LOD Expressions
Video
02:00:25
Advance Data Visualization
Video
01:45:46
Advance Data Visualization
Video
01:41:02
Advance Data Visualization
Video
02:26:50
Project Tableau
Video
02:22:34
PY 203 : Data Cleaning and Preparation
108 Learning Materials
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 204 : Machine Learning
5 Exercises • 211 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
Logistic Regression Assignment
Assignment
Support Vector Machine (SVM) Assignment
Support Vector Machine (SVM) Assignment
Assignment
Assignments
15 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
Weekly Exercises on Data Analysis & Visualization Fundamentals
Assignment
Exercises on AI-Powered Automation for Data Science Using GitHub Copilot in VS Code
Exercises on AI-Powered Automation for Data Science Using GitHub Copilot in VS Code
Assignment
Exercises on Tableau
Exercises on Tableau
Assignment
Weekly Exercise on LOD in Tableau
Weekly Exercise on LOD in Tableau
Assignment
Weekly Exercises on Dashboarding and Advanced Data Visualization
Weekly Exercises on Dashboarding and Advanced Data Visualization
Assignment
Outreach Session
7 Learning Materials
Mission Mode
Session 1
PPT
Session 2
ZIP
Session 3
ZIP
Mastering Upwork Proposals_ A Comprehensive Guide
PDF
Session 4
ZIP
Session 5
ZIP
Session 6
ZIP
Updated Job Posts in the Market
1 Learning Materials
Updated Job Posts in the Market
Updated Job Posts in the Market
Course Instructor
/3374782-1986246-Blue_logo_1.png){kind=logo}
SkillArbitrage
230 Courses • 247572 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy