1

Join Data Analytics Live Classes

1

01. 15 July 2024 Introduction & Understanding Excel Environment

2

02. 16 July 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking

3

03. 17 July 2024 Data Manipulation & Cleansing [Sum, Name Ranges, Structure Referencing, IF, Clean, Trim, Text to Column, Left & Right, Conditional Formatting]

4

04. 18 July 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IF, Sum IF, IF + AND, IF + OR]

5

05. 19 July 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match]

6

06. 22 July 2024 Assignment Correction

7

07. 23 July 2024 Data Manipulation & Cleansing [Index & Match (Contd), Pivot Table with Trends (KPIs & Sales)]

8

08. 24 July 2024 Dashboarding, Editing Interface [VBA]

1

How to Download PowerBI for Mac Users

2

01. 25 July 2024 Understanding PowerBI Workflow, Power Query Environment, Data Model in Power BI

3

02. 26 July 2024 Database Fundamentals Primary & Foreign Keys, Facts & Dimension Tables

4

03. 29 July 2024 Fact & Dimension table (Contd), Star & Snowflakes Schema

5

04. 30 July 2024 How to Download PowerBI, Data Manipulation & Modelling I

6

05. 31 July 2024 Data Manipulation & Modelling II [Contd]

7

06. 01 Aug 2024 Data Manipulation & Modelling III

8

07. 02 Aug 2024 DAX & Data Visualization

9

08. 05 Aug 2024 Data Visualization [Dashboarding] (Contd)

10

09. 06 Aug 2024 Sales Modelling & Dashboarding

11

10. 12 Aug 2024 AVI Travel Survey Case Study

12

11. 13 Aug 2024 AVI Travel Survey Case Study [Contd] with Dashboard

13

12. 19 Aug 2024 IBM HR Case Study with Dashboard

14

13. 20 Aug 2024 IBM HR Case Study [contd] with Dashboard

15

14. 21 Aug 2024 Plato Pizza Case Study

16

15. 22 Aug 2024 Plato Pizza with Dashboard [Contd] Pt1

17

16. 23 Aug 2024 Plato Pizza with Dashboard [Contd] Pt2

18

17. 27 Aug 2024 Collaboration

19

18. 28 Aug 2024 Connecting PowerBi with Yahoo Finance to Build Dashboard

20

19. 02 Sept 2024 How to Bookmark using BITCOIN Dashboard, AVI Property Case Study

21

20. 03 Sept 2024 AVI Property Case Study [Contd]

22

21. 04 Sept 2024 AVI Property Case Study with Dashboard [Contd]

23

22. 05 Sept 2024 Designing & Visualising using AVI Property Case Study Dashboard

24

23. 06 Sept 2024 Understanding UX Unicorn, Postgre Installation

1

01. 10 Sept 2024 Meaning of Data, Database, Data Warehouse

2

02. 11 Sept 2024 Entity Relationship Diagram (ERD)

3

03. 12 Sept 2024 Creating a Database and Testimonials (Success Story)

4

04. 13 Sept 2024 Select, Distinct and Where Statement

5

05. 16 Sept 2024 Where [Comparison operators], AND, OR, NOT, Statement

6

06. 17 Sept 2024 Count, Limit, Order By [Asc & Desc], Top 10, Between, Like & iLike, IN Aggregate Functions