Class Four; Text ( VLOOKUP, IFSTATEMENT, NESTEDIF )

Class Four Video Part 1 (VLOOKUP FUNCTION)

Class Four Video Part 2 (IFSTATEMENT AND NESTED IF)

Class Four Video Part 3 (Basic Data Cleaning Using Trim, Value, Clean and proper function)

Class Four Quiz

Class Five ; Text (Sort and Filter, Pivot Table and Chart)

Class Five Video Part 1 (Sort and Filter)

Class Five Video Part 2 (Pivot-Table and Pivot- Chart)

Class Five Quiz

Class Six; Text (Data Cleaning in Excel)

Class Six Video Part 1 (Data Cleaning)

Class Six Video Part 2 (Data Cleaning)

Class Six Video Part 3 (Data Cleaning)

Class Six Video Part 4 (Data Cleaning)

Class Six Quiz

Week 2; Assignment

Class Seven ; Text (Data Cleaning using Power Query Editor)

Class Seven Video Part 1 (Data cleaning using Power Query Editor)

Class Seven Video Part 2 (Power Query Editor)

Class Seven Video Part 3 (Power Query Editor)

Class Seven Quiz

Class Eight Text (Data Validation)

Class Eight Video Part 1 (Data Validation)

Class Eight Video part 2 (Data validation

Class Eight Quiz

Class Nine ; Text (Pivot Table and Pivot Chart)

Class Nine Video Part 1 (Pivot Table)

Class Nine Video Part 2 (Pivot Table and pivot chart)

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 Ten; Text (Data Visualization and Dashboard)

Class Ten Video Part 1 (Data Visualization)

Class Ten Video Part 2

Class Ten Video Part 3

Class Ten Video Part 4

Class Ten Quiz

Class Eleven; Text (Introduction to SQL)

Class Eleven Video Part 1 (INTRODUCTION TO SQL )

Class Eleven Video Part 2 (Creating Database in SQL)

Class Eleven Video Part 3 (Creating a table and insert information on it)

Class Eleven Quiz

Class Twelve; Text (Modify data within a database using SQL)

Class Twelve Video Part 1 (Modifying Data in SQL)

Class Twelve Video Part 2 ( Update New Column with Information)

Class Twelve Video Part 3

Class Twelve Video Part 4

Class Twelve Video Part 5

Class Twelve Quiz

Week 4 Assignment

Class Thirteen ; Text (OPERATIONS IN SQL)

Class Thirteen Video Part 1 (Operatations in SQL)

Class Thirteen Video Part 2

Class Thirteen Video Part 3

Class Thirteen Quiz

Class Fourteen; Text (Logical Operation or Operational operations and Join)

Class Fourteen Video Part 1 ( Logical Operations or Operational Operations)

Class Fourteen Video Part 2

Class Fourteen Video Part 3 (Join)

Class Fourteen Video Part 4

Class Fourteen Quiz

Class Fifteen; ,(GROUP BY STATEMENT AND HAVING STATEMENT SQL)

Class Fifteen Video Part 1 ( Types of Join and their differences)

Class Fifteen Video Part 2

Class Fifteen Video Part 3

Class Fifteen Video Part 4 (Having Statement)

Class Fifteen Quiz

Week 5 Assignment

Class Sixteen; Text (SUBQUERIES AND CASE STATEMENT )

Class Sixteen Video Part 1 (Subqueries)

Class Sixteen Video Part 2

Class Sixteen Video Part 3

Class Sixteen Quiz

Class Seventeen: Text ( Subquery and Case statement)

Class Seventeen Video Part 1

Class Seventeen Video Part 2

Class Seventeen Video Part 3

Class Seventeen Video Part 4

Class Seventeen Quiz

Class Eighteen: Text (PARTITION BY AND TEMPORARY TABLE)

Class Eighteen Video Part 1

Class Eighteen Video Part 2

Class Eighteen Video Part 3

Class Eighteen Video Part 4

Class Eighteen Quiz

Week 5 Assignment

Class Nineteen; Text (Introduction to Tableau)

Class Nineteen Video Part 1 (Introduction to Tableau)

Class Nineteen Video Part 2

Class Nineteen Video Part 3

Class Nineteen Video Part 4

Class Nineteen Video Part 5

Class Nineteen Quiz

Class Twenty : Text (Visualization and creating dashboard)

Class Twenty Video Part 1

Class Twenty Video Part 2

Class Twenty Video Part 3

Class Twenty Video Part 4

Class Twenty Quiz

Class Twenty-One : Text (CREATING BINS IN TABLEAU)

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 Quiz

Week 6 Assignment

Class Twenty-Two: Text ( Chart and Visualization )

Class Twenty-Two Video Part 1

Class Twenty-Two Video Part 2

Class Twenty-Two Video Part 3

Class Twenty-Two Video Part 4

Class Twenty-Two Quiz

Class Twenty-Three; Text ( Dashboard And Story)

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 (Introduction to Power BI )

Class Twenty-Four Video Part 1 (Introduction to Power BI )

Class Twenty-Four Video Part 2 (Connect to Different Data source)

Class Twenty - Four Quiz

Week 7 Assignment

Class Twenty - Five; Text ( Connect Data to Power BI through difference data source)

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 Quiz

Class Twenty - Six; Text (Shape data)

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 Quiz

Class Twenty - Seven: Text (Data modelling)

Class Twenty-Seven Video Part 1

Class Twenty-Seven Video Part 2

Class Twenty - Seven Quiz

Class Twenty- Eight; Text (Difference between Calculated Column and Measure)

Class Tweny-Eight Video Part 1

Class Twenty-Eight Video Part 2

Class Twenty - Eight Quiz

Week 8 Assignment

Class Twenty -Nine ;Text ( DAX OPERATORS)

Class Twenty-Nine Video Part 1

Class Twent-Nine Video Part 2

Class Twenty-Nine Video Part 3

Class Twenty - Nine Quiz

Class Thirty; Text (Data Shaping and Dashboard)

Class Thirty Video Part 1

Class Thirty Video Part 2

Class Thirty Video Part 3

Class Thirty Video Part 4

Class Thirty Video Part 5

Class Thirty Quiz

Week 9 Assignment

Class Thirty -One ; Text (Dashboard)

Class Thirty - One Video Part 1

Class Thirty - -One Video Part 2

Class Thirty - One Video Part 3

Class Thirty - One Video Part 4

Class Thirty - One Video Part 5

Class Thirty - one Quiz

Class Thirty - Two ; Text ( Data Visualization and Chart)

Class Thirty - Two Video Part 1

Class Thirty - Two Video Part 2

Class Thirty - Two Video Part 3

Class Thirty - Two Video Part 4

Class Thirty - Two Quiz

Class Thirty - Three ; Text (Correlation Analysis)

Class Thirty - Three Video Part 1

Class Thirty - -Three Video Part 2

Class Thirty - Three Video Part 3

Class Thirty - Three Quiz

CLASS THIRTY - FOUR ; TEXT (LINEAR REGRESSION IN POWERBI)

Class Thirty - Four Video Part 1

Class Thirty - Four Video Part 2

Class Thirty - Four Video Part 3

Class Thirty - Four Quiz

CLASS THIRTY - FIVE ; TEXT (Revision on Excel formula and function, conditional formatting, data cleaning)

Class Thirty - Five Video Part 1

Class Thirty -Five Video Part 2

Class Thirty - Five Video Part 3

Class Thirty - five Video Part 4

Class Thirty - Five Video Part 5

Class Thirty - Five Quiz

Class Thirty - Six Video Part 1

Class Thirty - Six Video Part 2

Class Thirty- Six Video Part 3

Class Thirty - Six Video Part 4

Class Thirty- Six Video Part 5

Week 10 Assignment

RÉSUMÉ CREATION 1

RÉSUMÉ CREATION 2

RÉSUMÉ CREATION 3

RÉSUMÉ CREATION 4

RÉSUMÉ CREATION 5

RÉSUMÉ CREATION 6

RÉSUMÉ CREATION 7

RÉSUMÉ CREATION 8

RÉSUMÉ CREATION 9

RÉSUMÉ CREATION 10

RÉSUMÉ CREATION 11

RÉSUMÉ CREATION 12

RÉSUMÉ CREATION 13

RÉSUMÉ CREATION

LINKEDIN CREATION

LINKEDIN CREATION 2

LINKEDIN CREATION 3

LINKEDIN CREATION 4

LINKEDIN CREATION 5