1

Join Data Analytics Live Classes

1

08 Sept 2025 Introduction to Data Analytics & Business Intelligence

2

01. 22 Sept 2025 Introduction & Understanding Excel Environment

3

02. 23 Sept 2025 Cell Referencing [Relative, Absolute, Mixed Referencing, Name Range.

4

03. 24 Sept 2025 Data Manipulation & Cleansing [IF Statement]

5

04. 25 Sept 2025 Left & Right, Conditional Formatting, Sum & Subtotal

6

05. 29 Sept 2025 If Statements (Countif, Countif-2, Sumif, Sumif-2 & If-And)

7

06. 30 Sept 2025 If Statements Cont.

8

07. 01 Oct 2025 SumIfs & Student Lead Sessions

9

08. 02 Oct 2025 Data Combination (Vlookup & Xlookup, Index & Match)

10

09. 06 Oct 2025 Data Combination & Dashboarding

11

10. 07 Oct 2025 Dashboarding in Excel

1

01. 08 Oct 2025 Installation of PowerBI & Introduction to PowerBI (Theory)

2

02. 09 Oct 2025 Introduction to PowerBI (Theory) Cont.

3

03. 13 Oct 2025 The Power Query Editor

4

04. 14 Oct 2025 Fact & Dimension table, Star & Snowflakes Schema

5

05. 15 Oct 2025 Data Manipulation & Modelling

6

06. 16 Oct 2025 Data Modelling, Analysis & Visualization 1

7

07. 20 Oct 2025 Data Modelling, Analysis & Visualization 2

8

08. 21 Oct 2025 Data Visualization, Creating Measures Using DAX

9

09. 22 Oct 2025 Creating Measures & Visualization

10

10. 23 Oct 2025 Dashboard

11

11. 27 Oct 2025 Plato Pizza Case Study

12

12. 28 Oct 2025 Plato Pizza Case Study (Cont)

13

13. 03 Nov 2025 AVI Travel Survey Case Study

14

14. 04 Nov 2025 AVI Travel Survey Case Study (Cont)

15

15. 05 Nov 2025 IBM HR Analytics Employee Attrition & Performance Case Study

16

16. 06 Nov 2025 W.H.O (Malaria) Case Study

17

17. 10 Nov 2025 Correction Of The Project

18

18. 11 Nov 2025 Redfin Real Estate PowerBI Requirements

19

19. 12 Nov 2025 Redfin Real Estate Case Study

20

20. 13 Nov 2025 Redfin Real Estate Case Study (Cont)

1

01. 17 Nov 2025 Meaning of Data, Database

2

02. 18 Nov 2025 How to Download Postgre SQL

3

03. 19 Nov 2025 Creating Database, Schema &Table, Select Statement

4

04. 20 Nov 2025 Basic SQL Syntax (Where Statement, Count)

5

05. 24 Nov 2025 Basic SQL Syntax [Limit, Order By, Between, Like & ilike, Aggregate Functions] Statements

6

06. 25 Nov 2025 Basic SQL Syntax [Aggregate Functions, Group By, Having, As] Statements

7

07. 27 Nov 2025 JOINS [Inner, Left, Right, Full]

8

08. 01 Dec 2025 JOINS [Inner, Left, Right, Full] Cont.

9

09. 02 Dec 2025 Case Statement

10

10. 03 Dec 2025 Student Lead SQL

11

11. 04 Dec 2025 Connecting PowerBI to Postgre SQL, Sub Queries

12

12. 08 Dec 2025 Sub Queries and Joins (Cont)

13

13. 09 Dec 2025 CTEs, Views & Procedures

14

14. 10 Dec 2025 Student Lead SQL 2

15

15. 11 Dec 2025 Fraudulent Transaction Case Study

16

16. 15 Dec 2025 Student Lead Session

17

17. 16 Dec 2025 Data Governance

18

18. 17 Dec 2025 Cloud Computing for Data Analysis Using Snowflake

19

19. 18 Dec 2025 Cloud Computing for Data Analysis Using Snowflake (Cont)

20

20. 22 Dec 2025 Snowflake (Case Study)

21

21. 05 Jan 2026 Snowflake (Retail Dashboard Case Study)

1

01. 06 Jan 2026 Introduction To Tableau

2

02. 07 Jan 2026 Introduction To Tableau (Cont)

3

03. 08 Jan 2026 Building Blocks of Tableau (Dimensions & Measures, Pills, Discrete & Continuous Values, Aggrigations & Granularity, Show me Tab)

4

04. 12 Jan 2026 Building Blocks of Tableau (Cont) & Basic Chart in Tableau

5

05. 13 Jan 2026 Data Modelling and Preparation [Relationship, Join, Pivot Table], Tableau Function & Calculated Fields

6

06. 14 Jan 2026 Tableau Function & Calculated Fields [Cont], Formatting

7

07. 15 Jan 2026 Student Lead

8

08. 19 Jan 2026 Dashboard in Tableau

9

09. 20 Jan 2026 Dashboard in Tableau (Cont)

1

13 Feb 2026 Project Collaboration Day 1 (Education Case Study)

2

16 Feb 2026 Project Collaboration Day 1 (Nestle Product Case Study)

3

19 Feb 2026 Project Day 2 (Education)

4

20 Feb 2026 Project Day 3 (Education)

5

23 Feb 2026 Project Day 4 (Education)

6

24 feb 2026 Project Day 2 (Nestle)

7

25 feb 2026 Project Day 3 (Nestle)

8

Guide on CV review and PrepNHire 3 Mar 2026

1

Datasets Documents

2

Datasets Documents

1

Data Project Environment