Avenue Impact
3 Months (Data Analytics) Excel, PowerBI, SQL, Tableau Training [Nov 2023]
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

Get course
Available in "Two-Payment of £500 Per Month" plan Available in "One Payment of £1000" plan

Course sections

Section 1
Join Data Live Session
1
Join Data Analytics Live Classes
Section 2
Excel for Data Analytics Recordings
1
30. Oct 2023 Data Analytics Training Taster Session
2
01. 06 Nov 2023 Introduction & Understanding Excel Environment
3
02. 07 Nov 2023 Characteristics of Data Format
4
03. 08 Nov 2023 Cell Referencing [Relative Referencing & Absolute Referencing]
5
04. 09 Nov 2023 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Range & Paste Special]
6
05. 13 Nov 2023 Data Manipulation & Cleansing [Name Range, Structured Referencing, Left & Right, Clean, Trim]
7
06. 14 Nov 2023 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]
8
06. 14 Nov 2023 Consultancy Session
9
07. 15 Nov 2023 Data Manipulation & Cleansing [Sum IF, IF + AND, IF + OR, Index Match]
10
08. 16 Nov 2023 Data Manipulation & Cleansing [Index Match (Contd), Pivot Table (KPIs & Sales)]
11
09. 17 Nov 2023 Data Manipulation & Cleansing [Pivot Table with Trends (Contd)]
12
10. 20 Nov 2023 Data Manipulation & Cleansing [Dashboarding]
13
11. 08 Dec 2023 Assignment Solution
14
12. 11 Dec 2023 VLookUp, XLookUp
Section 3
Power BI Recordings
1
01. 21 Nov 2023 Download Power BI, Explanation on Excel Assignment
2
02. 22 Nov 2023 Understanding Power BI Workflow, Database Fundamentals [Primary & Foreign Keys
3
03. 23 Nov 2023 Database Fundamentals [Facts & Dimension Tables]
4
04. 24 Nov 2023 Fact & Dimension table [(Contd) Star Schema], Data Manipulation & Modelling
5
05. 27 Nov 2023 Fact & Dimension table [(Contd) Snowflakes Schema], Data Manipulation & Modelling I
6
06. 28 Nov 2023 Data Manipulation & Modelling II
7
07. 29 Nov 2023 Collaborative Session I
8
08. 30 Nov 2023 DAX & Data Visualization
9
09. 01 Dec 2023 DAX & Data Visualization [Contd]
10
10. 04 Dec 2023 Collaborative Session II
11
11. 06 Dec 2023 Dashboard, Bitcoin Case Study
12
12. 07 Dec 2023 Bitcoin Case Study [Contd]
13
13. 12 Dec 2023 Plato Pizza Case Study Solution
14
14. 13 Dec 2023 Real Estate Case Study
15
15. 14 Dec 2023 Real Estate Case Study [Contd]
16
16. 15 Dec 2023 Real Estate Dashboard
Section 4
SQL Recordings
1
01. 11 Jan 2024 How to Download Postgre SQL
2
02. 15 Jan 2024 Meaning of Data, Database, Data Warehouse, Entity Relationship Diagram (ERD), Database Creation on Postgre SQL
3
03. 16 Jan 2024 Database Creation, SQL Syntax (Select, Distinct & Where Statements)
4
04. 19 Jan 2024 Select Statement (Select Count, Order By [ASC-DESC], Top 10, Between, IN Statement, Like & iLike, Aggregation Function)
5
05. 22 Jan 2024 Group By & Having Statement, As Statement, JOIN Types (Inner, Left, Right & Full)
6
06. 23 Jan 2024 JOIN Types (Contd)
7
07. 24 Jan 2024 Case Statement, CTE Query Definition, Create or Replace Procedure
8
08. 26 Jan 2024 Connecting PowerBI to Postgre SQL, Create Database, Fraudulent Transaction Case
Section 5
Tableau Recordings
1
01. 29 Jan 2024 Tableau Download, Introduction to Tableau, Building Blocks of Tableau
2
02. 30 Jan 2024 Filters In Tableau
3
03. 31 Jan 2024 Fraudulent Transaction Case Study
4
04. 01 Feb 2024 Tableau Function & Calculated Field
5
05. 05 Feb 2024 Formatting & Dashboarding
6
06. 12 Feb 2024 Project Guide
7
07. 16 Feb 2024 How to Build Portfolio using GitHub, NovyPro & Linktree
8
08. 17 Feb 2024 Everything About Portfolio [Google Drive, GitHub, HTML 5 up, Visual Studio Code]
9
Guide for CV Review, Interview Questions & Support
Section 6
Documents and Assignments
1
Datasets Documents
Section 7
Join WhatsApp Group
1
Join Data Team's Group
Section 8
Project Case Study
1
12 Feb 2024 - Data Analytics Project Case Study

Excel for Data Analytics Recordings

07. 15 Nov 2023 Data Manipulation & Cleansing [Sum IF, IF + AND, IF + OR, Index Match]

Lesson is locked. Please Buy course to proceed.

Excel for Data Analytics Recordings 06. 14 Nov 2023 Consultancy Session
Excel for Data Analytics Recordings 08. 16 Nov 2023 Data Manipulation & Cleansing [Index Match (Contd), Pivot Table (KPIs & Sales)]
error: Alert: Content selection is disabled!!