Course Overview
Schedule of Classes
Course Curriculum
5 Subjects
EXL301 :Data Analysis with Excel
4 Exercises • 74 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 • 150 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
8 Exercises • 210 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 • 51 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 • 15 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
Tableau Mini Project
ZIP
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
178 Courses • 234099 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy