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 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 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(Transpose, Pivot and unpivot column)

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

Class Twenty Quiz