Class One Text: Introduction to Data Analysis

Class One Quiz

Class Two Text: Introduction To Excel

Class Two Video

Class Two Quiz

Class Three Text(Nested IF, Value and clean functions)

Class Three Video

Class Three Quiz

WEEK 1 ASSIGNMENT

Class Seven Text: DATA MANIPULATION IN EXCEL

Class Seven Video

Class Seven Quiz

Class Eight Text (DATA VISUALIZATION)

Class Eight Video

Class Eight Quiz

Class Night Text (BUILDING OF DASHBOARD AND SLICERS

Class Nine Video

Class Nine Quiz

WEEK 3 Assignment

Class Ten Text (Pivot Tables for Business Insights)

Class Ten Video

Class 10 Quiz

Class Eleven Text (Continuation on Dashboard)

Class Eleven Video

Class Eleven Quiz

Class Twelve Text (Q & A)

Class Twelve Video

WEEK 4 ASSIGNMENT

Class Thirteen Text (Introduction to SQL)

Class Thirteen Video

Class Thirteen Quiz

Class Fourteen Text (MODIFYING DATA WITHIN DATABASE)

Class Fourteen Video

Class Fourteen Quiz

Class Fifteen Text (Table designer method and Operators in SQL)

Class Fifteen Video

Class Fifteen Quiz

WEEK 5 ASSIGNMENT

Class Sixteen Text (Logical operators or operational operators)

Class Sixteen Video

Class Sixteen Quiz

Class Seventeen Text (Left, Right and full Join, Group by and Having Statement)

Class Seventeen Video

Class Seventeen Quiz

Class Eighteen Text: (Subqueries, Case Statement and Partition By)

Class Eighteen Video

Class Eighteen Quiz

WEEK 6 ASSIGNMENT

Class Nineteen Text (INTRODUCTION TO POWERBI)

Class Nineteen Video

Class Nineteen Quiz

Class Twenty Text (Pivot, Unpivot, Merge and Append Queries)

Class Twenty Video

Class Twenty Quiz

Class Twenty-one Text (Data Modelling)

Class Twenty-One Video

Class Twenty One Quiz

Class Twenty-Two Text (Optimizes queries in Power BI)

Class Twenty- Two Video

Class Twenty-Two Quiz

Class Twenty-Three Text (Data Analysis Expression )