1

Introduction to PowerBi

2

01. 03 Apr 2023 Introduction To Excel, Understanding Excel Environment

3

02. 04 Apr 2023 Data Manipulation & Cleansing (Basic Functions)

4

03. 05 Apr 2023 Data Manipulation & Cleansing (Relative, Absolute, & Mixed Referencing, Cell Locking, Named Range)

5

04. 06 Apr 2023 Data Manipulation & Cleansing (Structured Referencing, Left and Right)

6

05. 11 Apr 2023 Data Manipulation & Cleansing (Clean, Trim, Conditional Formatting, Sum & Subtotal)

7

06. 12 Apr 2023 Data Manipulation & Cleansing (Using IF, Sum IF, Count IF....Data Set)

8

07. 13 Apr 2023 Data Manipulation & Cleansing (Index Match)

9

08. 17 Apr 2023 Data Manipulation & Cleansing (Index Match Rev, Pivot, KPIs & Sales trend with Pivot)

10

09. 18 Apr 2023 Data Manipulation & Cleansing (KPIs & Sales trend with Pivot (Cntd), Dashboard)

11

10. 19 Apr 2023 Data Manipulation & Cleansing (Dashboard Cntd)

1

01. 20 Apr 2023 Understanding Power BI (Power BI Workflow)

2

02. 24 Apr 2023 Database Fundamental (Primary & Foreign keys, Facts & Dimension Table)

3

03. 25 Apr 2023 Data Manipulation & Modelling I

4

04. 26 Apr 2023 Data Manipulation & Modelling II

5

05. 27 Apr 2023 Data Manipulation & Modelling II (1 - 1, 1 - Many, Many - Many)

6

06. 03 May 2023 DAX & Data Visualization

7

07. 04 May 2023 Data Visualization (Contd)

8

08. 15 Jun 2023 Plato Pizza Case Study Solution

9

09. 16 Jun 2023 Forecasting using Power BI, Drillthrough

10

Project and General Guides

11

29 Jun 2023 BI April Set Project Presentation.mp4

12

19 Jul 2023 How to build Portfolio using GitHub, NovyPro and Linktree

13

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

1

01. 09 May 2023 Installation of Postgre SQL and PgAdmin 4

2

02. 10 May 2023 What's Data, Entity Relationship Diagram

3

03. 11 May 2023 What's Database, Data Warehouse, Data Lake

4

04. 15 May 2023 SQL Syntax (Select, Select Distinct, Where Statements)

5

05. 16 May 2023 SQL Syntax (Where Statement using Comparison and logical Operators, LIKE, IN, Limit, Order By)

6

06. 17 May 2023 SQL Syntax (Between, iLike-Like, Aggregate Function, Group by Statement)

7

07. 23 May 2023 SQL Syntax (Group By, Having, Concat Statements, Substring Index)

8

08. 24 May 2023 SQL Syntax (Join Statement [Inner, Left, Right, Full] )

9

09. 25 May 2023 SQL Syntax (Join Statement [Inner, Left, Right, Full] Cntd)

10

10. 30 May 2023 Connecting PBI to PostgreSQL, Creating DB & Tables using AVI-SQL Case Study

11

11. 31 May 2023 AVI-SQL Case Study (contd), SQL Synx (Substring, Length, Position & Case Statements)

12

12. 01 Jun 2023 SQL Synx (Case (Contd), AND, OR Statements)

1

01. 05 Jun 2023 Installation and Introduction to Tableau

2

02. 06 Jun 2023 Building Blocks of Tableau

3

03. 07 Jun 2023 Working with Time Series Data

4

04. 08 Jun 2023 Working with Time Series Data (Contd), Data Modelling and Preparation

5

05. 12 Jun 2023 Joins, Pivot, Tableau Function

6

06. 13 Jun 2023 Date Function, Data Type Conversion and Logical Function

7

07. 14 Jun 2023 Formatting on Tableau and Creating Dashboards

1

Datasets Documents

2

Data Analytics Project Documents

1

Data Analytics/ BI Interview Questions

2

Upload CV for Data Analyst

3

CV Development & Booking Slot Guide

4

Data Analyst Jobs

1

Salesforce Interview Questions and Answers