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 Four Text: Conditional formatting, Sort and Filter

Class Four Video

Class Four Quiz

Class Five Text: Data Cleaning in Power Query

Class Five Video

Class Five Quiz

Class Six Text: Pivot Table

Class Six Video

Class Six Quiz

WEEK 2 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 )

Class Twenty-Three Video

Class Twenty-Three Quiz

Class Twenty-Four Text (CREATING CHART FOR DASHBOARD )

Class Twenty-Four Video

Class Twenty-Four Quiz

Class Twenty- Five Text (DASHBARD)

Class Twenty-Five Video

Class Twenty-Five Quiz

Class Twenty-Six Text (CORRELATION ANALYSIS)

Class Twenty-Six Video

Class Twenty-Six Quiz

Class Twenty-Seven Text (Introduction to Python)

Class Twenty-Seven Video

Class Twenty -Seven Quiz

Class Twenty-Eight Text(INPUT FORMAT and OPERATORS IN PYTHON)

Class Twenty-Eight Video

Class Twenty-Eight Quiz

Class Twenty-Nine Text (IF STATEMENT)

Class Twenty-Nine Video

Class Twenty Nine Quiz

Class Thirty Text: (DATA STRUCTURE)

Class Thirty Video

Class Thirty Quiz

Class Thirty- One Text: (Dictionary)

Class Thirty-One Video

Class Thirty One Quiz

Class Thirty-two Text:(Data Manipulation and visualization )

Class Thirty two video

Class Thirty Two Quiz

GROUP PROJECTS

Personal Project