1

Join Data Analytics Live Classes

1

01. 18 Mar 2024 Introduction & Understanding Excel Environment

2

02. 22 Mar 2024 Data Manipulation & Cleansing [Left & Right, Clean, Trim, Sum, Average, Count, CountA, Max, Min, IF]

3

03. 25 Mar 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Ranges, Structure Referencing]

4

04. 28 Mar 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]

5

05. 04 Apr 2024 Data Manipulation & Cleansing [Substitute, IF + AND, IF + OR]

6

06. 05 Apr 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match (Project)]

7

07. 08 Apr 2024 Data Manipulation & Cleansing [Pivot Table with Trends(KPIs & Sales)]

8

08. 11 Apr 2024 Data Manipulation & Cleansing [Sales Trend (Contd), Dashboarding]

9

09. 12 Apr 2024 Power BI Download, Assignment Solution

1

01. 15 Apr 2024 Understanding Power BI Workflow, Power Query Environment, Data Model in Power BI

2

02. 16 Apr 2024 Database Fundamentals [Primary & Foreign Keys, [Facts & Dimension Tables]

3

03. 18 Apr 2024 Fact & Dimension table (Contd) Star & Snowflakes Schema, Data Manipulation & Modelling 1

4

04. 22 Apr 2024 Data Manipulation & Modelling I

5

05. 24 Apr 2024 Data Manipulation & Modelling II

6

06. 25 Apr 2024 DAX & Data Visualization

7

07. 26 Apr 2024 DAX & Data Visualization (Contd)

8

08. 29 Apr 2024 Plato Pizza Case Study Solution

9

09. 30 Apr 2024 Plato Pizza Case Study [contd]

10

10. 01 May 2024 Domino's Pizza Case Study Solution

11

11. 02 May 2024 BTC Case Study with Dashboard

12

12. 03 May 2024 Bitcoin Case Study with Dashboard [Contd]

13

13. 08 May 2024 Real Estate Case Study

14

14. 09 May 2024 Real Estate Case Study [Contd] with Dashboard

15

15. 10 May 2024 Real Estate Case Study Dashboard

1

01. 13 May 2024 Meaning of Data, Database, Data Warehouse, Entity Relationship Diagram (ERD), Download Postgre SQL

2

02. 14 May 2024 Database Creation on Postgre SQL, Select Statement

3

03. 16 May 2024 Distinct, Where, Count, Limit, Order By [Asc & Desc] Statements

4

04. 17 May 2024 Top 10, Between, Like & iLike, IN, Aggregate Functions, Group By, Having Statement

5

05. 21 May 2024 Where, Count, Limit, Order By [Asc & Desc], IN, Like & iLike Statements

6

06. 22 May 2024 Group By & Having Clause Statement, JOINS

7

07. 23 May 2024 JOINS [Inner, Left, Right, Full], Create Table [Fraudulent Transaction]

8

08. 24 May 2024 Fraudulent Case Study [Tailored Analysis]

1

01. 28 May 2024 How To Download Tableau, Introduction To Tableau

2

02. 29 May 2024 Building Blocks of Tableau [The WHAT & HOW]

3

03. 31 May 2024 Data Modelling & Preparation (Data Blending, Relationship, Joins)

4

04. 04 June 2024 Tableau Function & Calculated Field 1

5

05. 05 June 2024 Tableau Function & Calculated Field 2, Dashboarding

6

06. 06 June 2024 Tableau Dashboarding [Contd]

1

01. 11 June 2024 Python Class

2

02. 12 June 2024 Download Python, Jupyter Notebook, Variables

3

03. 13 June 2024 Strings, Indexing & Slicing

4

04. 14 June 2024 Print Formatting, Concatenation, List

5

05. 17 June 2024 Project Guide

1

Datasets Documents

2

Upload CV and Book 1-2-1 Review