Avenue Impact
Self-Paced (Data Analytics) Excel, PowerBI, SQL, Tableau Training
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Course sections

Section 1
Excel Recordings
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
Section 2
Power BI Recordings
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
Section 3
Postgre SQL Recordings
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
Section 4
Tableau Recordings
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
Section 5
Assignments
1
Datasets Documents
Section 6
Join WhatsApp Group
1
Join Data Team's Group
Section 7
Join Project
1
Project Environment
2
Upload CV for Data Analyst
3
Data Analytics/ BI Interview Questions

Postgre SQL Recordings

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

Lesson is locked. Please Buy course to proceed.

Postgre SQL Recordings 05. 21 Sept 2023 Database Creation, SQL Syntax (Select Statement)
Postgre SQL Recordings 07. 25 Sept 2023 SQL Syntax (Where Statement) – AND, OR, NOT, IN, NOT IN, Combining Logical & Between Operators
error: Alert: Content selection is disabled!!