Class One; Text (Introduction To Data Analysis)

Class One Quiz

Class Two; Text (Introduction to Excel)

Class Two Video Part 1 (Introduction to Basic excel formula and functions)

Class Two Video Part 2

Class Two Video Part 3

Class Two Video Part 4

Class Two Quiz

Class Three: Text (Split, Transpose, Drop down list and Vlookup functions)

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 (If statement and data cleaning)

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 Video Part 6

Class Four Quiz

Class Five: Text (SORT AND FILTER, CONDITIONAL FORMATTING, PIVOT TABLE AND CHART)

Class Five Video Part 1

Class Five Video Part 2 (Sort and Filter)

Class Five Video Part 3

Class Five Video Part 4

Class Five Video Part 5

Class Five Quiz

Class Six: Text (Data Cleaning using Power Query Editor)

Class Six Video Part 1 (Power Query Editor)

Class Six Video Part 2

Class Six Video Part 3

Class Six Quiz

WEEK 2 ASSIGNMENT

Class Seven; Text (Advance part of data cleaning)

Class Seven Video Part 1 (Advance part of data cleaning)

Class Seven Video Part 2

Class Seven Video Part 3

Class Seven Video Part 4

Class Seven Quiz

Class Eight; Text (Continuation on data cleaning and Chart)

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 Video Part 7

Class Eight Video Part 8

Class Eight Quiz

Class Nine; Text (Chart and 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 Video Part 7

Class Nine Video Part 8

Class Nine Video Part 9

Class Nine Quiz

WEEK 3 ASSIGNMENT

Class Ten; Text (Formatting Dashboard, Slicers and Correlation)

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 Video Part 6

Class Ten Video Part 7

Class Ten Video Part 8

Class Ten Quiz

Class Eleven; Text (Introduction to Structured Query Language (SQL))

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 Video Part 7

Class Eleven Video Part 8

Class Eleven Quiz

Class Twelve; Text (Modifying data within database)

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 Video Part 7

Class Twelve Video Part 8

Class Twelve Quiz

WEEK 4 ASSIGNMENT

Class Sixteen: Text(CASE STATEMENT )

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 Video Part 7

Class Sixteen Video Part 8

Class Sixteen Quiz

Class Seventeen: Text(TABLE DESIGNER METHOD IN SQL)

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 Video Part 7

Class Seventeen Video Part 8

Class Seventeen Quiz

Class Eighteen: Text(Revisions on SQL class)

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 Video Part 6

WEEK 6 ASSIGNMENT

Class Nineteen; Text (INTRODUCTION TO POWER BI)

Class Nineteen Video Part 1

Class Nineteen Video Part 2

Class Nineteen Video Part 3

Class Nineteen Video Part 4

Class Nineteen Video Part 5

Class Nineteen Video Part 6

Class Nineteen Quiz

Class Twenty: Text (The query editor, shaping data, unpivot, append and merge data)

Class Twenty video Part 1

Class Twenty video Part 2

Class Twenty video Part 3

Class Twenty video Part 4

Class Twenty video Part 5

Class Twenty video Part 6

Class Twenty Quiz

Class Twenty-one; Text (Data modelling and creating chart)

Class Twenty-one Video Part 1

Class Twenty-one Video Part 2

Class Twenty-one Video Part 3

Class Twenty-one Video Part 4

Class Twenty-one Video Part 5

Class Twenty-one Video Part 6

Class Twenty-one Quiz

WEEK 7 ASSIGNMENT

Class Twenty-Two; Text (Data Analysis Expression )

Class Twenty-Two Video Part 1

Class Twenty-Two Video Part 3

Class Twenty-Two Video Part 2

Class Twenty-Two Video Part 4

Class Twenty-Two Video Part 5

Class Twenty-Two Video Part 6

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 5

Class Twenty-Three Quiz

Class Twenty-Four; Text (Correlation and Regression 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 Video Part 6

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 Video part 5

Class Twenty-five Video part Part 6

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 5

Class Twenty-six video part 6

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 Quiz

WEEK 9 ASSIGNMENT

Class Twenty-Eight: Text (Data structure)