1

Join Data Analytics Live Classes

1

01. 15 July 2024 Introduction & Understanding Excel Environment

2

02. 16 July 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking

3

03. 17 July 2024 Data Manipulation & Cleansing [Sum, Name Ranges, Structure Referencing, IF, Clean, Trim, Text to Column, Left & Right, Conditional Formatting]

4

04. 18 July 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IF, Sum IF, IF + AND, IF + OR]

5

05. 19 July 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match]

6

06. 22 July 2024 Assignment Correction

7

07. 23 July 2024 Data Manipulation & Cleansing [Index & Match (Contd), Pivot Table with Trends (KPIs & Sales)]

8

08. 24 July 2024 Dashboarding, Editing Interface [VBA]

1

How to Download PowerBI for Mac Users

2

01. 25 July 2024 Understanding PowerBI Workflow, Power Query Environment, Data Model in Power BI

3

02. 26 July 2024 Database Fundamentals Primary & Foreign Keys, Facts & Dimension Tables

4

03. 29 July 2024 Fact & Dimension table (Contd), Star & Snowflakes Schema

5

04. 30 July 2024 How to Download PowerBI, Data Manipulation & Modelling I

6

05. 31 July 2024 Data Manipulation & Modelling II [Contd]

7

06. 01 Aug 2024 Data Manipulation & Modelling III

8

07. 02 Aug 2024 DAX & Data Visualization

9

08. 05 Aug 2024 Data Visualization [Dashboarding] (Contd)

10

09. 06 Aug 2024 Sales Modelling & Dashboarding

11

10. 12 Aug 2024 AVI Travel Survey Case Study

12

11. 13 Aug 2024 AVI Travel Survey Case Study [Contd] with Dashboard

13

12. 19 Aug 2024 IBM HR Case Study with Dashboard

14

13. 20 Aug 2024 IBM HR Case Study [contd] with Dashboard

15

14. 21 Aug 2024 Plato Pizza Case Study

16

15. 22 Aug 2024 Plato Pizza with Dashboard [Contd] Pt1

17

16. 23 Aug 2024 Plato Pizza with Dashboard [Contd] Pt2

18

17. 27 Aug 2024 Collaboration

19

18. 28 Aug 2024 Connecting PowerBi with Yahoo Finance to Build Dashboard

20

19. 02 Sept 2024 How to Bookmark using BITCOIN Dashboard, AVI Property Case Study

21

20. 03 Sept 2024 AVI Property Case Study [Contd]

22

21. 04 Sept 2024 AVI Property Case Study with Dashboard [Contd]

23

22. 05 Sept 2024 Designing & Visualising using AVI Property Case Study Dashboard

24

23. 06 Sept 2024 Understanding UX Unicorn, Postgre Installation

1

01. 10 Sept 2024 Meaning of Data, Database, Data Warehouse

2

02. 11 Sept 2024 Entity Relationship Diagram (ERD)

3

03. 12 Sept 2024 Creating a Database and Testimonials (Success Story)

4

04. 13 Sept 2024 Select, Distinct and Where Statement

5

05. 16 Sept 2024 Where [Comparison operators], AND, OR, NOT, Statement

6

06. 17 Sept 2024 Count, Limit, Order By [Asc & Desc], Top 10, Between, Like & iLike, IN Aggregate Functions

7

07. 20 Sept 2024 Group By, Having Clause, Where Statement, Joins

8

08. 23 Sept 2024 JOINS [Inner, Left, Right, Full]

9

09. 24 Sept 2024 JOINS [Inner, Left, Right, Full] Contd

10

10. 25 Sept 2024 Case Statement

11

26 Sept 2024 Select Distinct, Select From, Then, When, Else Statements

12

27 Sept 2024 When, Join, From, Create Database

13

13. 30 Sept 2024 Create table, Update and Insert, Drop Delete, Alter, Create view

14

14. 01 Oct 2024 Fraudulent Case Study [Tailored Analysis]

15

15. 02 Oct 2024 Fraudulent Case Study [Tailored Analysis] (Cont)

16

16. 03 Oct 2024 Snowflakes and Databricks

17

17. 07 Oct 2024 Snowflake Contd

18

18. 09 Oct 2024 Collaboration

19

19. 10 Oct 2024 Snowflakes Case Study

1

01. 23 Oct 2024 Download & Introduction Python, Jupyter Note

2

02. 24 Oct 2024 Python Fundamentals

3

03. 25 Oct 2024 Strings, Indexing & Slicing

4

04. 28 Oct 2024 Lists & Tuples

5

05. 29 Oct 2024 Data Type - Dictionary

6

06. 30 Oct 2024 Sets and Boolean

7

07. 31 Oct 2024 Boolean, If, Else-If, And & Or Statement, For Loop

8

08. 01 Nov 2024 For Loop (Contd), While Loop

9

09. 04 Nov 2024 While Loop (Contd), Break, Continue & Pass

10

10. 05 Nov 2024 Function & NUMPy

11

11. 06 Nov 2024 NUMPy (Contd)

12

12. 07 Nov 2024 Indexing & Slicing

13

13. 08 Nov 2024 Project Guide

1

14. 12 Nov 2024 Project Day 1

2

15. 13 Nov 2024 Project Day 2

3

16. 14 Nov 2024 Project Day 3

4

17. 15 Nov 2024 Project Day 4

5

18. 18 Nov 2024 Project Day 5

6

19. 19 Nov 2024 Project Day 6

7

20. 20 Nov 2024 Project Day 7

8

21. 21 Nov 2024 Project Day 8

1

Datasets Documents

2

Datasets Documents