1

Join Data Analytics Live Classes

1

30. Oct 2023 Data Analytics Training Taster Session

2

01. 06 Nov 2023 Introduction & Understanding Excel Environment

3

02. 07 Nov 2023 Characteristics of Data Format

4

03. 08 Nov 2023 Cell Referencing [Relative Referencing & Absolute Referencing]

5

04. 09 Nov 2023 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Range & Paste Special]

6

05. 13 Nov 2023 Data Manipulation & Cleansing [Name Range, Structured Referencing, Left & Right, Clean, Trim]

7

06. 14 Nov 2023 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]

8

06. 14 Nov 2023 Consultancy Session

9

07. 15 Nov 2023 Data Manipulation & Cleansing [Sum IF, IF + AND, IF + OR, Index Match]

10

08. 16 Nov 2023 Data Manipulation & Cleansing [Index Match (Contd), Pivot Table (KPIs & Sales)]

11

09. 17 Nov 2023 Data Manipulation & Cleansing [Pivot Table with Trends (Contd)]

12

10. 20 Nov 2023 Data Manipulation & Cleansing [Dashboarding]

13

11. 08 Dec 2023 Assignment Solution

14

12. 11 Dec 2023 VLookUp, XLookUp

1

01. 21 Nov 2023 Download Power BI, Explanation on Excel Assignment

2

02. 22 Nov 2023 Understanding Power BI Workflow, Database Fundamentals [Primary & Foreign Keys

3

03. 23 Nov 2023 Database Fundamentals [Facts & Dimension Tables]

4

04. 24 Nov 2023 Fact & Dimension table [(Contd) Star Schema], Data Manipulation & Modelling

5

05. 27 Nov 2023 Fact & Dimension table [(Contd) Snowflakes Schema], Data Manipulation & Modelling I

6

06. 28 Nov 2023 Data Manipulation & Modelling II

7

07. 29 Nov 2023 Collaborative Session I

8

08. 30 Nov 2023 DAX & Data Visualization

9

09. 01 Dec 2023 DAX & Data Visualization [Contd]

10

10. 04 Dec 2023 Collaborative Session II

11

11. 06 Dec 2023 Dashboard, Bitcoin Case Study

12

12. 07 Dec 2023 Bitcoin Case Study [Contd]

13

13. 12 Dec 2023 Plato Pizza Case Study Solution

14

14. 13 Dec 2023 Real Estate Case Study

15

15. 14 Dec 2023 Real Estate Case Study [Contd]

16

16. 15 Dec 2023 Real Estate Dashboard

1

01. 11 Jan 2024 How to Download Postgre SQL

2

02. 15 Jan 2024 Meaning of Data, Database, Data Warehouse, Entity Relationship Diagram (ERD), Database Creation on Postgre SQL

3

03. 16 Jan 2024 Database Creation, SQL Syntax (Select, Distinct & Where Statements)

4

04. 19 Jan 2024 Select Statement (Select Count, Order By [ASC-DESC], Top 10, Between, IN Statement, Like & iLike, Aggregation Function)

5

05. 22 Jan 2024 Group By & Having Statement, As Statement, JOIN Types (Inner, Left, Right & Full)

6

06. 23 Jan 2024 JOIN Types (Contd)

7

07. 24 Jan 2024 Case Statement, CTE Query Definition, Create or Replace Procedure

8

08. 26 Jan 2024 Connecting PowerBI to Postgre SQL, Create Database, Fraudulent Transaction Case

1

Datasets Documents

1

Join Data Team's Group

1

12 Feb 2024 - Data Analytics Project Case Study