1

Join Data Analytics Live Classes

1

01. 12 May 2025 Introduction & Understanding Excel Environment

2

02. 13 May 2025 Data Manipulation & Cleansing [Sum, Average, Count, CountA, Max, Min], Relative Referencing

3

03. 14 May 2025 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Paste Special] IF Statement

4

04. 15 May 2025 Mixed Referencing, Name Range, Structured Referencing, Sum & Sub total

5

05. 19 May 2025 Left & Right, Clean, Trim, Conditional Formatting

6

06. 20 May 2025 Sum & Subtotal, IF statement, CountIF

7

07. 21 May 2025 CountIF, SumIF, Index & Match, VLookUp, XLookUp

8

08. 22 May 2025 Index & Match, VLookUp, XLookUp, Dashboarding

9

09. 27 May 2025 Pivot Chat, Dashboarding

10

10. 28 May 2025 Dashboarding Cont.

1

11. 29 May 2025 Understanding Power BI Workflow, Power Query Environment, Data Model in Power BI

2

12. 2 June 2025 Process flow of PowerBI, Interface, Workflow, Power Query Editor

3

13. 3 June 2025 Fact & Dimension table, Star & Snowflakes Schema

4

14. 5 June 2025 Concept of Fact Dimension table, How to Download PowerBI, Data Manipulation & Modelling I

5

15. 09 June 2025 Data Manipulation & Modelling

6

16. 10 June 2025 Data Manipulation & Modelling II

7

17. 11 June 2025 Data Visualization, Creating Measures Using DAX

8

18. 12 June 2025 Group Work for the Excel Assignment

9

19. 16 June 2025 Plato Pizza Case Study

10

20. 17 June 2025 Plato Pizza Case Study [contd 1]

11

20. 17 June 2025 Plato Pizza Case Study [contd 2]

12

21. 18 June 2025 Plato Pizza Case Study [contd] Dashboard

13

22. 19 June 2025 Plato Pizza Case Study [contd 2] Dashboard

14

23. 23 June 2025 AVI Travel Survey Case Study

15

24. 24 June 2025 AVI Travel Survey Case Study [Contd]

16

25. 25 June 2025 IBM HR Analytics Employee Attrition & Performance Case Study

17

26. 26 June 2025 Real Estate Case Study

18

27. 30 June 2025 Real Estate Case Study [Contd] with Dashbord