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 Thirteen; Text (Operators in SQL)

Class Thirteen Video Part 1 (Operators in SQL)

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 (Logical Operators and Join )

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

Class Fourteen Video Part 8

Class Fourteen Video Part 9

Class Fourteen Quiz

Class Fifteen: Text(Group by statement, Having statement and subquery)

Class Fifteen Video Part 1

Class Fifteen Video Part 2

Class Fifteen Video Par 3

Class Fifteen Quiz

WEEK 5 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