1

01. 31 Jul 2023 Introduction & Understanding Excel Environment

2

02. 01 Aug 2023 Characteristics of Data Format

3

03. 02 Aug 2023 Data Cleansing & Absolute Referencing

4

04. 03 Aug 2023 Basic Functions, Absolute & Mixed Referencing

5

05. 04 Aug 2023 Named Ranges, Data Validation, Structured Referencing & Conditional Formatting

6

06. 07 Aug 2023 Sum & Subtotal, Using IF, Count IF and Conditional Formatting

7

07. 08 Aug 2023 CountIF, CountIFS, SumIF & SumIFS

8

08. 09 Aug 2023 Index Match & Pivot Table

9

09. 10 Aug 2023 Dashboarding - KPI, Sales Trend, Top 10 Products

10

10. 11 Aug 2023 Dashboarding (Cotnd)

11

11. 14 Aug 2023 VLookUp, XLookUp, Assignment Guide

1

01. 15 Aug 2023 What is Business Intelligence - Power BI vs Excel, Power BI Interface & Workflow

2

02. 16 Aug 2023 PowerBI Workflow (Contd), Primary & Foreign Keys, Facts and Dimension Table

3

03. 17 Aug 2023 Star Schema and Snowflakes Schema

4

04. 18 Aug 2023 Connecting PowerBI To Folder, Creating Dimension Table

5

How to Download PowerBI for Mac Users

6

05. 22 Aug 2023 Creation of Fact Table and Data Modelling 1

7

06. 23 Aug 2023 Data Modelling 2 & Creation of Calendar Dimension Table

8

07. 24 Aug 2023 Data Modelling 2 (Contd)

9

08. 25 Aug 2023 Data Visualization 1

10

09. 29 Aug 2023 Data Visualization 2

11

10. 30 Aug 2023 Bookmarks and BTC Case Study

12

11. 31 Aug 2023 Bitcoin Dashboard

13

12. 01 Sept 2023 Survey Dataset Case Study

14

13. 04 Sept 2023 AVI Travel Dashboard

15

14. 05 Sept 2023 Plato Pizza Case Study

16

15. 07 Sept 2023 Real Estate Case Study

17

16. 08 Sept 2023 Real Estate Case Study (Contd)

18

17. 11 Sept 2023 Real Estate Case Study DAX & Visuals (Contd)

19

18. 12 Sept 2023 Real Estate Case Study Visuals Design (Contd)

20

19. 13 Sept 2023 Real Estate Case Study Visuals Design (Contd), GPT Guide

1

01. 14 Sept 2023 How to Download Postgre SQL

2

02. 15 Sept 2023 Data Meaning, Types & differences, Data Warehouse & Types

3

03. 18 Sept 2023 Entity Relationship Diagram

4

04. 19 Sept 2023 Entity Relationship Diagram (Contd)

5

05. 21 Sept 2023 Database Creation, SQL Syntax (Select Statement)

6

06. 22 Sept 2023 SQL Syntax (Select & Where Statement)

7

07. 25 Sept 2023 SQL Syntax (Where Statement) - AND, OR, NOT, IN, NOT IN, Combining Logical & Between Operators

8

08. 26 Sept 2023 SQL Syntax (Null, Is Not Null, Empty Strings, Parenthesis For Complex Condition, Wildcards)

9

09. 28 Sept 2023 Revision Of Like & iLike, Select (Count-Limit, Order By, Aggregation Function AS)

10

10. 29 Sept 2023 SQL Syntax (Group By & Having Statement)

11

11. 02 Oct 2023 CONCAT, DATA TYPE & JOIN (Left Join)

12

12. 03 Oct 2023 Left Join (Contd)

13

13. 04 Oct 2023 Left Join (Contd), Right Join, Inner Join

14

14. 05 Oct 2023 [Left Join, Right Join, Inner Join(Contd)] Full Join, Case & Else Statement

15

15. 06 Oct 2023 Case & Nested Case Statements (Contd), Subquery

16

16. 09 Oct 2023 Connecting PowerBI To PostGre SQL DB, Creating a DB, Creating a Table in DB, Copying Data To The Table In The DB

17

17. 10 Oct 2023 Fraudulent Transaction Case Study

1

01. 11 Oct 2023 How To Download Tableau

2

02. 12 Oct 2023 Introduction To Tableau, Building Blocks For Tableau

3

03. 13 Oct 2023 Granularity, Basic Chart in Tableau, Filters, Working with Time Series

4

04. 16 Oct 2023 Data Modelling & Preparation (Data Blending, Relationship, Joins, Pivoting)

5

05. 17 Oct 2023 Tableau Function 1

6

06. 18 Oct 2023 Tableau Function 2, LOD

7

07. 19 Oct 2023 LODs & Formatting

8

08. 20 Oct 2023 Dashboarding

9

09. 23 Oct 2023 Dashboarding 2

10

10. 25 Oct 2023 Everything About Portfolio (Google Drive, GitHub, HTML 5 up, Visual Studio Code)

11

11. 26 Oct 2023 Project Guide

1

Datasets Documents

1

Project Environment

2

Upload CV for Data Analyst

3

Data Analytics/ BI Interview Questions