Avenue Impact
Data Analytics and Data Management Live Bootcamp
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
Live Session
1
Join Data Analytics Live Classes
Section 2
Excel Recordings
1
25 Nov 2024 Boot Camp Day 1
2
26 Nov 2024 Bootcamp Day 2
3
27 Nov 2024 Bootcamp Day 3
4
01. 02 Dec 2024 Introduction & Understanding Excel Environment
5
02. 03 Dec 2024 Data Manipulation & Cleansing [XLookUp, Index & Match]
6
03. 04 Dec 2024 Dashboarding, Editing Interface [VBA}
7
04. 05 Dec 2024 Dashboarding, Editing Interface [VBA} Data Visualisation
8
05. 09 Dec 2024 AVI Sales Dashboard
Section 3
Power BI Recordings
1
How to Download PowerBI for Mac Users
2
01. 10 Dec 2024 Understanding Power BI Workflow
3
02. 19 Dec 2024 Process Flow of Power BI, Database Fundamentals Primary & Foreign Keys
4
03. 14 Jan 2025 Introduction to PowerBI Continued
5
04. 16 Jan 2025 Fact & Dimension table (Characteristics), Star Schema
6
05. 17 Jan 2025 Data Manipulation & Modelling I
7
06. 20 Jan 2025 Data Manipulation Modelling I [Contd]
8
07. 21 Jan 2025 AVI Sales Dashboard
9
08. 23 Jan 2025 AVI Plato Pizza Case Study
10
09. 24 Jan 2025 AVI Plato Pizza Case Study (Cntd)[Modelling & Dashboard]
11
10. 27 Jan 2025 AVI Travel Survey Case Study & Dashboard
12
11. 28 Jan 2025 AVI Travel Survey Dashboard [Cntd]
13
12. 31 Jan 2025 NHS PowerBI Exercise
14
13. 03 Feb 2025 Exercise on Excel, Table and PowerBI
15
14. 04 Feb 2025 Real Estate Case Study
16
15. 06 Feb 2025 Real Estate Case Study [Contd]
17
16. 07 Feb 2025 Real Estate Case Study Dashboard
Section 4
Postgre SQL Recordings
1
01. 10 Feb 2025 Postgre SQL Download, Meaning of Data, Database, Data Warehouse
2
02. 11 Feb 2025 Entity Relationship Diagram (ERD)
3
03. 12 Feb 2025 Database Creation on Postgre SQL
4
04. 13 Feb 2025 Select, Distinct, Where, Count, Limit, Order By [Asc & Desc] Statements
5
05. 14 Feb 2025 Top 10, Between, IN, Like & iLike, Aggregate Functions, Group By
6
06. 17 Feb 2025 Having Clause Statement
7
07. 18 Feb 2025 Logical Operation, Concat, (Split, Date_Part, Extract), Case Statement
8
08. 20 Feb 2025 JOINS [Inner, Left, Right, Full]
9
09. 21 Feb 2025 Sub Query
10
10. 28 Feb 2025 Scalar, Multiple Row, Correlated, Exists Sub Query's, Datatypes
11
11. 01 Mar 2025 Fraudulent Transaction Case Study [Tailored Analysis]
12
13. 03 Mar 2025 Fraudulent Transaction Case Study (Cntd), Tableau Download
Section 5
Tableau Recordings
1
01. 04 Mar 2025 How To Download Tableau, Introduction To Tableau
2
02. 06 Mar 2025 Building Blocks of Tableau [The WHAT], Dimensions and Measures
3
03. 07 Mar 2025 Using Marks Card to Build Chart, Filters
4
04. 10 March 2025 - Data Modelling and Data Preparation, Tableau Function 1
5
05. 11 Mar 2025 Tableau Functions [Contd]
6
06. 13 Mar 2025 Calculated Field & Tableau Function [Cntd], Formatting
7
07. 14 March 2023 Creating Dashboard in Tableau
Section 6
Python Recordings
1
01. 17 Mar 2025 Download Python, Jupyter Note
2
02. 18 Mar 2025 Data Type and Basic Arithmetic in Python
3
03. 20 Mar 2025 Indexing & Slicing
4
04. 21 Mar 2025 List, Tuples and Dictionary
5
05. 24 Mar 2025 Boolean Operator, If, Elif, Else, AND & OR Statements
6
06. 25 Mar 2025 For & While Loop
7
07. 27 Mar 2025 Break, Continue & Pass
8
08. 28 Mar 2025 Snowflakes
9
09. 31 Mar 2025 Introduction to Data Governance
10
10. 01 Apr 2025 Team Collaboration
11
11. 03 Apr 2025 Team Collaboration 1 [Education for All (Case Study)]
Section 7
Data Analytics Documents
1
Datasets Documents
2
Datasets Documents

Postgre SQL Recordings

09. 21 Feb 2025 Sub Query

Lesson is locked. Please Buy course to proceed.

Postgre SQL Recordings 08. 20 Feb 2025 JOINS [Inner, Left, Right, Full]
Postgre SQL Recordings 10. 28 Feb 2025 Scalar, Multiple Row, Correlated, Exists Sub Query’s, Datatypes
error: Alert: Content selection is disabled!!