1

Join Data Analytics Live Classes

1

25 Nov 2024 Boot Camp Day 1

2

26 Nov 2024 Bootcamp Day 2

3

27 Nov 2024 Bootcamp Day 3

4

01. 02 Dec 2024 Introduction & Understanding Excel Environment

5

02. 03 Dec 2024 Data Manipulation & Cleansing [XLookUp, Index & Match]

6

03. 04 Dec 2024 Dashboarding, Editing Interface [VBA}

7

04. 05 Dec 2024 Dashboarding, Editing Interface [VBA} Data Visualisation

8

05. 09 Dec 2024 AVI Sales Dashboard

1

How to Download PowerBI for Mac Users

2

01. 10 Dec 2024 Understanding Power BI Workflow

3

02. 19 Dec 2024 Process Flow of Power BI, Database Fundamentals Primary & Foreign Keys

4

03. 14 Jan 2025 Introduction to PowerBI Continued

5

04. 16 Jan 2025 Fact & Dimension table (Characteristics), Star Schema

6

05. 17 Jan 2025 Data Manipulation & Modelling I

7

06. 20 Jan 2025 Data Manipulation Modelling I [Contd]

8

07. 21 Jan 2025 AVI Sales Dashboard

9

08. 23 Jan 2025 AVI Plato Pizza Case Study

10

09. 24 Jan 2025 AVI Plato Pizza Case Study (Cntd)[Modelling & Dashboard]

11

10. 27 Jan 2025 AVI Travel Survey Case Study & Dashboard

12

11. 28 Jan 2025 AVI Travel Survey Dashboard [Cntd]

13

12. 31 Jan 2025 NHS PowerBI Exercise

14

13. 03 Feb 2025 Exercise on Excel, Table and PowerBI

15

14. 04 Feb 2025 Real Estate Case Study

16

15. 06 Feb 2025 Real Estate Case Study [Contd]

17

16. 07 Feb 2025 Real Estate Case Study Dashboard

1

01. 10 Feb 2025 Postgre SQL Download, Meaning of Data, Database, Data Warehouse

2

02. 11 Feb 2025 Entity Relationship Diagram (ERD)

3

03. 12 Feb 2025 Database Creation on Postgre SQL

4

04. 13 Feb 2025 Select, Distinct, Where, Count, Limit, Order By [Asc & Desc] Statements

5

05. 14 Feb 2025 Top 10, Between, IN, Like & iLike, Aggregate Functions, Group By

6

06. 17 Feb 2025 Having Clause Statement

7

07. 18 Feb 2025 Logical Operation, Concat, (Split, Date_Part, Extract), Case Statement

8

08. 20 Feb 2025 JOINS [Inner, Left, Right, Full]

9

09. 21 Feb 2025 Sub Query

10

10. 28 Feb 2025 Scalar, Multiple Row, Correlated, Exists Sub Query's, Datatypes

11

11. 01 Mar 2025 Fraudulent Transaction Case Study [Tailored Analysis]

12

13. 03 Mar 2025 Fraudulent Transaction Case Study (Cntd), Tableau Download

1

01. 04 Mar 2025 How To Download Tableau, Introduction To Tableau

2

02. 06 Mar 2025 Building Blocks of Tableau [The WHAT], Dimensions and Measures

3

03. 07 Mar 2025 Using Marks Card to Build Chart, Filters

4

04. 10 March 2025 - Data Modelling and Data Preparation, Tableau Function 1

5

05. 11 Mar 2025 Tableau Functions [Contd]

6

06. 13 Mar 2025 Calculated Field & Tableau Function [Cntd], Formatting

7

07. 14 March 2023 Creating Dashboard in Tableau

1

Datasets Documents

2

Datasets Documents