dots bg

Professional Certification Program in Data Analyst

Course Instructor SkillArbitrage

FREE

dots bg

Course Overview

Schedule of Classes

Course Curriculum

5 Subjects

EXL301 :Data Analysis with Excel

4 Exercises76 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 Exercises151 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 Exercises218 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 Exercises55 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 Exercises14 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

tutor image

SkillArbitrage

190 Courses   •   234238 Students