Course Overview
Schedule of Classes
Course Curriculum
5 Subjects
EXL301 :Data Analysis with Excel
4 Exercises • 80 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
8 Exercises • 160 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
PDF
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 • 223 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
Jan-02-2025
SP101 : Statistics & Probablity
5 Exercises • 60 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 • 16 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
Course Instructor
/3374782-1986246-Blue_logo_1.png){kind=logo}
SkillArbitrage
192 Courses • 235475 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy