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)