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 Quiz

Class Three; Text (Splitting, Transpose, Sort and Filter)

Class Three Video Part 1

Class Three Video Part 2

Class Three Video Part 3

Class Three Quiz

WEEK 1 ASSIGNMENT

Class Four; Text (Drop-down list, Ifstatement, Join and Remove Extra rows)

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 (VLOOKUP , Proper function, Clean Function, Value Function, Trim Function and Conditional Formatting)

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 (Pivot Table and Chart)

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 Ten ; Text (BUILDING OF DASHBOARD AND SLICERS)

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 Quiz

Class Eleven; Text ( Building Dashboard with a Slicer )

Class Eleven Video Part 1

Class Eleven Video Part 2

Class Eleven Video Part 3

Class Eleven Quiz

Class Twelve; Text (Correlation in excel)

Class Twelve Video Part 1

Class Twelve Quiz

WEEK 4 ASSIGNMENT

Class Thirteen; Text (INTRODUCTION TO SQL )

Class Thirteen Video Part 1

Class Thirteen Video Part 2

Class Thirteen Video Part 3

Class Thirteen Quiz

Class Fourteen; Text(Modify data in database)

Class Fourteen Video Part 1

Class Fourteen Video Part 2

Class Fourteen Video Part 3

Class Fourteen Quiz

Class Fifteen; Text(TABLE DESIGNER METHOD 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 Quiz

WEEK 5 ASSIGNMENT

Class Sixteen Text; (OPERATORS IN SQL)

Class Sixteen Video Part 1

Class Sixteen Video Part 2

Class Sixteen Video Part 3

Class Sixteen Video Part 4

Class Sixteen Quiz

Class Seventeen Text; (LOGICAL OPERATORS OR OPERATIONAL OPERATORS)

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; ( JOIN IN SQL)

Class Eighteen Video Part 1

Class Eighteen Video Part 2

Class Eighteen Video Part 3

Class Eighten Video Part 4

Class Eighteen Video Part 5

Class Eighteen Quiz

WEEK 6 Assignment

Class Nineteen Text; Continuation of Types of Join

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 Quiz

Class Twenty Text: (SUBQUERIES AND TEMPORARY TABLE)

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 Quiz

Class Twenty-One; Text(PARTITION BY AND CTE)

Class Twenty-One Video Part 1

Class Twenty- One Video Part 2

Class Twenty-One Video Part 3

Class Twenty- One Quiz

WEEK 7 Assignment

Class Twenty-Two: Text (INTRODUCTION TO POWERBI)

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 (Power Query Editor)

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(Transpose, Pivot and Unpivot data)

Class Twenty- Four Video Part 1

Class Twenty- Four Video Part 2

Class Twenty- Four Video Part 3

Class Twenty- Four Video Part 4

Class Twenty- Four Quiz

WEEK 8 ASSIGNMENT

Class Twenty-Five: Text (Append Query, Merge Query and Data Modelling)

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 (Data Analysis Expression )

Class Twenty-Six Video Part 1

Class Twenty-Six Video Part 2

Class Twenty-Six Video Part 3

Class Twenty- Six Quiz

Class Twenty-Seven; Text (CORRELATION ANALYSIS)

Class Twenty-seven Video Part 1

Class Twenty-seven Video Part 2

Class Twenty-seven Video Part 3

Class Twenty-Seven Quiz

WEEK 9 ASSIGNMENT

Class Twenty-eighth; Text(Assignment Correction and Dashboard)

Class Twenty-eight Video Part 1

Class Twenty-eight Video Part 2

Class Twenty-eight Video Part 3

Class Twenty-Nine; Text (Continuation of PowerBI dashboard)

Class Twenty-Nine Video Part 1

Class Twenty-Nine Video Part 2

Class Twenty-Nine Video Part 3

Class Twenty-Nine Video Part 4

Class Twenty-Nine Video Part 5

Class Twenty-Nine Quiz

Class Thirty; Text (Introduction to Tableau)

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

Class Thirty - One; Text (Calculated Field)

Class Thirty - One Video Part 1

Class Thirty - One Video Part 2

Class Thirty - One Video Part 3

Class Thirty - One Quiz

Class Thirty - Two; Text (Creating story in Tableau and key points to be consider for presentation)

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