Avenue Impact
Data Analytics and Data Management Live Bootcamp Sept 2025
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
Join Live Classes
1
Join Data Analytics Live Classes
Section 2
Excel
1
08 Sept 2025 Introduction to Data Analytics & Business Intelligence
2
01. 22 Sept 2025 Introduction & Understanding Excel Environment
3
02. 23 Sept 2025 Cell Referencing [Relative, Absolute, Mixed Referencing, Name Range.
4
03. 24 Sept 2025 Data Manipulation & Cleansing [IF Statement]
5
04. 25 Sept 2025 Left & Right, Conditional Formatting, Sum & Subtotal
6
05. 29 Sept 2025 If Statements (Countif, Countif-2, Sumif, Sumif-2 & If-And)
7
06. 30 Sept 2025 If Statements Cont.
8
07. 01 Oct 2025 SumIfs & Student Lead Sessions
9
08. 02 Oct 2025 Data Combination (Vlookup & Xlookup, Index & Match)
10
09. 06 Oct 2025 Data Combination & Dashboarding
11
10. 07 Oct 2025 Dashboarding in Excel
Section 3
PowerBI
1
01. 08 Oct 2025 Installation of PowerBI & Introduction to PowerBI (Theory)
2
02. 09 Oct 2025 Introduction to PowerBI (Theory) Cont.
3
03. 13 Oct 2025 The Power Query Editor
4
04. 14 Oct 2025 Fact & Dimension table, Star & Snowflakes Schema
5
05. 15 Oct 2025 Data Manipulation & Modelling
6
06. 16 Oct 2025 Data Modelling, Analysis & Visualization 1
7
07. 20 Oct 2025 Data Modelling, Analysis & Visualization 2
8
08. 21 Oct 2025 Data Visualization, Creating Measures Using DAX
9
09. 22 Oct 2025 Creating Measures & Visualization
10
10. 23 Oct 2025 Dashboard
11
11. 27 Oct 2025 Plato Pizza Case Study
12
12. 28 Oct 2025 Plato Pizza Case Study (Cont)
13
13. 03 Nov 2025 AVI Travel Survey Case Study
14
14. 04 Nov 2025 AVI Travel Survey Case Study (Cont)
15
15. 05 Nov 2025 IBM HR Analytics Employee Attrition & Performance Case Study
16
16. 06 Nov 2025 W.H.O (Malaria) Case Study
17
17. 10 Nov 2025 Correction Of The Project
18
18. 11 Nov 2025 Redfin Real Estate PowerBI Requirements
19
19. 12 Nov 2025 Redfin Real Estate Case Study
20
20. 13 Nov 2025 Redfin Real Estate Case Study (Cont)
Section 4
SQL
1
01. 17 Nov 2025 Meaning of Data, Database
2
02. 18 Nov 2025 How to Download Postgre SQL
3
03. 19 Nov 2025 Creating Database, Schema &Table, Select Statement
4
04. 20 Nov 2025 Basic SQL Syntax (Where Statement, Count)
5
05. 24 Nov 2025 Basic SQL Syntax [Limit, Order By, Between, Like & ilike, Aggregate Functions] Statements
6
06. 25 Nov 2025 Basic SQL Syntax [Aggregate Functions, Group By, Having, As] Statements
7
07. 27 Nov 2025 JOINS [Inner, Left, Right, Full]
8
08. 01 Dec 2025 JOINS [Inner, Left, Right, Full] Cont.
9
09. 02 Dec 2025 Case Statement
10
10. 03 Dec 2025 Student Lead SQL
11
11. 04 Dec 2025 Connecting PowerBI to Postgre SQL, Sub Queries
12
12. 08 Dec 2025 Sub Queries and Joins (Cont)
13
13. 09 Dec 2025 CTEs, Views & Procedures
14
14. 10 Dec 2025 Student Lead SQL 2
Section 5
Documents
1
Datasets Documents
2
Datasets Documents

SQL

06. 25 Nov 2025 Basic SQL Syntax [Aggregate Functions, Group By, Having, As] Statements

Lesson is locked. Please Buy course to proceed.

SQL 05. 24 Nov 2025 Basic SQL Syntax [Limit, Order By, Between, Like & ilike, Aggregate Functions] Statements
SQL 07. 27 Nov 2025 JOINS [Inner, Left, Right, Full]
error: Alert: Content selection is disabled!!