1

30 Mar 2026 Introduction to Data Analytics & Business Intelligence

1

01. 07 Apr 2026 Introduction & Understanding Excel Environment

2

02. 08 Apr 2026 Excel Environment, Data Manipulation & Cleansing [Sum, Average, Count, CountA, Max, Min]

3

03. 09 Apr 2026 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Paste Special]

4

04. 13 Apr 2026 Name Range, Structured Referencing, Sum, Average, Trim, Text to Value & Column

5

05. 14 Apr 2026 Left & Right, Conditional Formatting, Sum & Subtotal

6

06. 15 Apr 2026 Using IF, Paste Special, [Recap on Absolute, Relative, Mixed Referencing]

7

07. 16 Apr 2026 UsingIF, Count IF, CountIFS

8

08. 20 Apr 2026 CountIFS, SumIF, SumIFS, IF+AND, IF+OR

9

09. 21 Apr 2026 VLookUp, XLookUp, Index-Match

10

10. 22 Apr 2026 Bring Tables Together for Dashboarding

11

11. 23 Apr 2026 Pivot Table, Dashboarding

12

09. 06 Oct 2025 Data Combination & Dashboarding

13

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

01. 12 May 2026 Excel Conlusion & Introduction to PowerBI

4

02. 13 May 2026 Understanding PowerBI Workflow, Power Query

5

03. 14 May 2026 Fact & Dimension Table, Star & Snowflakes Schema

6

04. 18 May 2026 Fact & Dimension Table, Star & Snowflakes Schema (Contd)

7

05. 19 May 2026 Data Manipulation & Modelling I

8

06. 20 May 2026 Data Manipulation & Modelling II

9

07. 21 May 2026 Creating Calendar Dimension Table, Data Analysis & Visualization

1

Datasets Documents

2

Datasets Documents

3

Datasets Documents