Class One; Text (Introduction To Data Analysis)

Class One Quiz

Class Two; Text (Introduction to Basic excel formula and functions)

Class Two Video Part 1

Class Two Video Part 2

Class Two Video Part 3

Class Two Video Part 4

Class Two Video Part 5

Class Two Video Part 6

Class Two Quiz

Class Three; Text (If statement, Nested If, proper, Value and Trim functions, remove extra rows)

Class Three Video Part 1

Class Three Video Part 2

Class Three Video Part 3

Class Three Video Part 4

Class Three Video Part 5

Class Three Video Part 6

Class Three Quiz

Week 1 Assignment

Class Four; Text (Sort and Filter, Pivot table and Chart)

Class Four Video Part 1

Class Four Video Part 2

Class Four Video Part 3

Class Four Video Part 4

Class Four Video Part 5

Class Four Quiz

Class Five; Text ( Data Cleaning in Excel using Power Query Editor)

Class Five Video Part 1

Class Five Video Part 2

Class Five Video Part 3

Class Five Video Part 4

Class Five Video Part 5

Class Five Video Part 6

Class Five Quiz

Class Six; Text ( Data Cleaning in Power Query Editor )

Class Six Video Part 1

Class Six Video Part 2

Class Six Video Part 3

Class Six Video Part 4

Class Six Video Part 5

Class Six Quiz

Week 2 Assignment

Class Seven; Text (Conditional column in Power Query Editor)

Class Seven Video Part 1

Class Seven Video Part 2

Class Seven Video Part 3

Class Seven Video Part 4

Class Seven Video Part 5

Class Seven Video Part 6

Class Seven Quiz

Class Eight: Text(Data Visualization in Excel)

Class Eight Video Part 1

Class Eight Video Part 2

Class Eight Video Part 3

Class Eight Video Part 4

Class Eight Video Part 5

Class Eight Video Part 6

Class Eight Quiz

Class Nine: Text (Excel Dashboard)

Class Nine Video Part 1

Class Nine Video Part 2

Class Nine Video Part 3

Class Nine Video Part 4

Class Nine Video Part 5

Class Nine Video Part 6

Class Nine Quiz

WEEK 3 Assignment

Class Ten: Text (Dashboard, Metrics and Slicer)

Class Ten Video Part 1

Class Ten Video Part 2

Class Ten Video Part 3

Class Ten Video Part 4

Class Ten Video Part 5

Class Ten Quiz

Class Eleven: Text(Statistical Analysis)

Class Eleven Video Part 1

Class Eleven Video Part 2

Class Eleven Video Part 3

Class Eleven Video Part 4

Class Eleven Video Part 5

Class Eleven Video Part 6

Class Eleven Quiz

Class Twelve; Text(Correlation and Regression Analysis)

Class Twelve Video Part 1

Class Twelve Video Part 2

Class Twelve Video Part 3

Class Twelve Video Part 4

Class Twelve Video Part 5

Class Twelve Video Part 6

Class Twelve Quiz

Week 4 Assignment

Class Thirteen; Text (Introduction Structured Query Language)

Class Thirteen Video Part 1

Class Thirteen Video Part 2

Class Thirteen Video Part 3

Class Thirteen Video Part 4

Class Thirteen Video Part 5

Class Thirteen Quiz

Class Fourteen: Text (MODIFYING DATA WITHIN DATABASE)

Class Fourteen Video Part 1

Class Fourteen Video Part 2

Class Fourteen Video Part 3

Class Fourteen Video Part 4

Class Fourteen Video Part 5

Class Fourteen Video Part 6

Class Fourteen Quiz

Class Fifteen: Text(OPERATORS IN SQL)

Class Fifteen Video Part 1

Class Fifteen Video Part 2

Class Fifteen Video Part 3

Class Fifteen Video Part 4

Class Fifteen Video Part 5

Class Fifteen Video Part 6

Class Fifteen Quiz

Week 5 Assignment

Class Sixteen Text (Join)

Class Sixteen Video Part 1

Class Sixteen Video Part 2

Class Sixteen Video Part 3

Class Sixteen Video Part 4

Class Sixteen Video Part 5

Class Sixteen Video Part 6

Class Sixteen Quiz

Class Seventeen Text(Group by, Having, Case statement and Subquery)

Class Seventeen Video Part 1

Class Seventeen Video Part 2

Class Seventeen Video Part 3

Class Seventeen Video Part 4

Class Seventeen Video Part 5

Class Seventeen Video Part 6

Class Seventeen Quiz

Class Eighteen Tex:(Table Designer Method in SQL)

Class Eighteen Video Part 1

Class Eighteen Video Part 2

Class Eighteen Video Part 3

Class Eighteen Video Part 4

Class Eighteen Video Part 5

Class Eighteen Quiz

WEEK 6 ASSIGNMENT

Class Twenty-Two: Text (Data Analysis Expression)

Class Twenty-Two Video Part 1

Class Twenty-Two Video Part 2

Class Twenty-Two Video Part 3

Class Twenty-Two Video Part 5

Class Twenty-Two Video Part 4

Class Twenty-Two Video Part 6

Class Twenty-Two Video Part 7

Class Twenty-Two Quiz

Class Twenty-Three: Text (DATE AND TIME FUNCTIONS)

Class Twenty-Three Video Part 1

Class Twenty-Three Video part 2

Class Twenty-Three Video part 3

Class Twenty-Three Video part 4

Class Twenty-Three Video part 6

Class Twenty-Three Video part 5

Class Twenty-Three Quiz

Class Twenty-four: Text (CORRELATION ANALYSIS)

Class Twenty-four Video part 1

Class Twenty-four Video part 2

Class Twenty-four Video part 3

Class Twenty-four Video part 4

Class Twenty-four Video part 5

Class Twenty-Four Quiz

WEEK 8 ASSIGNMENT

Class Twenty-Five: Text(Introduction to Python)

Class Twenty-five Video part 1

Class Twenty-five Video part 2

Class Twenty-five Video part 3

Class Twenty-five Video part 4

Class Twenty-Five Quiz

Class Twenty-Six: Text(Operators in Python)

Class Twenty-Six Video part 1

Class Twenty-Six Video part 2

Class Twenty-Six Video part 3

Class Twenty-Six Video part 4

Class Twenty-Six Video part 6

Class Twenty-Six Video part 5

Class Twenty-Six Quiz

Class Twenty-Seven: Text (CONTROL FLOW)

Class Twenty-Seven Video part 1

Class Twenty-Seven Video part 2

Class Twenty-Seven Video part 3

Class Twenty-Seven Video part 4

Class Twenty-Seven Video part 5

Class Twenty-Seven Video part 6

Class Twenty-Seven Quiz

WEEK 9 ASSIGNMENT

Class Twenty-Eight: Text DATA STRUCTURE (LIST)

Class Twenty-Eight Video part 1

Class Twenty-Eight Video part 2

Class Twenty-Eight Video part 3

Class Twenty-Eight Video part 4

Class Twenty-Eight Video part 5

Class Twenty-Eight Quiz

Class Twenty-Nine: Text; DATA STRUCTURE (TUPLE, SET )

Class Twenty-Nine Video part 1

Class Twenty-Nine Video part 2

Class Twenty-Nine Video part 3

Class Twenty-Nine Video part 4

Class Twenty-Nine Quiz

Class Thirty: Text (Dictionary, Functions)

Class Thirty Video part 1

Class Thirty Video part 2

Class Thirty Video part 3

Class Thirty Video part 4

Class Thirty Quiz

Class Thirty-One; Text(Modules in python)

Class Thirty-One Video Part 1

Class Thirty-One Video Part 2

Class Thirty-One Video Part 3

Class Thirty-One Video Part 4

Class Thirty-One Video Part 5

Class Thirty-One Video Part 6

Class Thirty-One Quiz

Class Thirty-Two: Text (PANDAS)

Class Thirty-Two Video Part 1

Class Thirty-Two Video Part 2