Avenue Impact
Data Analytics and Data Management Live Bootcamp May 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 Sessions
1
Join Data Analytics Live Classes
Section 2
Excel Recordings
1
01. 12 May 2025 Introduction & Understanding Excel Environment
2
02. 13 May 2025 Data Manipulation & Cleansing [Sum, Average, Count, CountA, Max, Min], Relative Referencing
3
03. 14 May 2025 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Paste Special] IF Statement
4
04. 15 May 2025 Mixed Referencing, Name Range, Structured Referencing, Sum & Sub total
5
05. 19 May 2025 Left & Right, Clean, Trim, Conditional Formatting
6
06. 20 May 2025 Sum & Subtotal, IF statement, CountIF
7
07. 21 May 2025 CountIF, SumIF, Index & Match, VLookUp, XLookUp
8
08. 22 May 2025 Index & Match, VLookUp, XLookUp, Dashboarding
9
09. 27 May 2025 Pivot Chat, Dashboarding
10
10. 28 May 2025 Dashboarding Cont.
Section 3
Power BI Recordings
1
11. 29 May 2025 Understanding Power BI Workflow, Power Query Environment, Data Model in Power BI
2
12. 2 June 2025 Process flow of PowerBI, Interface, Workflow, Power Query Editor
3
13. 3 June 2025 Fact & Dimension table, Star & Snowflakes Schema
4
14. 5 June 2025 Concept of Fact Dimension table, How to Download PowerBI, Data Manipulation & Modelling I
5
15. 09 June 2025 Data Manipulation & Modelling
6
16. 10 June 2025 Data Manipulation & Modelling II
7
17. 11 June 2025 Data Visualization, Creating Measures Using DAX
8
18. 12 June 2025 Group Work for the Excel Assignment
9
19. 16 June 2025 Plato Pizza Case Study
10
20. 17 June 2025 Plato Pizza Case Study [contd 1]
11
20. 17 June 2025 Plato Pizza Case Study [contd 2]
12
21. 18 June 2025 Plato Pizza Case Study [contd] Dashboard
13
22. 19 June 2025 Plato Pizza Case Study [contd 2] Dashboard
14
23. 23 June 2025 AVI Travel Survey Case Study
15
24. 24 June 2025 AVI Travel Survey Case Study [Contd]
16
25. 25 June 2025 IBM HR Analytics Employee Attrition & Performance Case Study
17
26. 26 June 2025 Real Estate Case Study
18
27. 30 June 2025 Real Estate Case Study [Contd] with Dashbord
19
28. 01 July 2025 Real Estate Case Study [Contd 2] with Dashbord
20
29. 02 July 2025 Real Estate Case Study [Contd 3] with Dashbord
21
30. 03 July 2025 Real Estate Case Study, Book Marking & Page Navigator
22
31. 07 July 2025 Call Centre Case Study
23
32. 08 July 2025 Call Centre Case Study [Contd]
24
33. 09 July 2025 Call Centre Case Study [Contd 2] Dashboard
25
34. 10 July 2025 Call Centre Case Study [Contd 3] Dashboard
26
35. 14 July 2025 Call Centre Case Study [Contd 4] Dashboard
27
36. 15 July 2025 Call Centre Case Study [Contd 5] Dashboard, Download PostgreSQL
Section 4
Postgre SQL
1
01. 16 July 2025 Meaning of Data, Database
2
02. 17 July 2025 Entity Relationship Diagram (ERD), DBMS, Database Creation on Postgre SQL, Importing Data into SQL
3
03. 21 July 2025 Basic SQL Syntax {Select, Distinct, Where, In, Between, And] Statements
4
04. 22 July 2025 Basic SQL Syntax [Limit, Order By Asc & Desc, Aggregate Functions, AS] Statements
5
05. 23 July 2025 Basic SQL Syntax [Group By, Having, Joins] Statements
6
06. 24 July 2025 JOINS [Inner, Left, Right, Full]
7
07. 28 July 2025 JOINS [Inner, Left, Right, Full] Contd
8
08. 29 July 2025 JOINS [Inner, Left, Right, Full] Contd 3
9
09. 30 July 2025 JOINS & CONCAT
10
10. 31 July 2025 Case Statement & Sub Queries
11
11. 04 Aug 2025 Fraudulent Transaction Case Study
12
12. 05 Aug 2025 Fraudulent Transaction Case Study [Contd]
13
13. 06 Aug 2025 An Order Insight for an E-commerce Retailers Case Study
14
14. 07 Aug 2025 An Order Insight for an E-commerce Retailers Case Study 2
15
15. 11 Aug 2025 An Order Insight for an E-commerce Retailers Case Study 3
16
16. 12 Aug 2025 An Order Insight for an E-commerce Retailers Case Study 4
17
17. 13 Aug 2025 How to Connect PowerBI to PostgreSQL
18
18. 14 Aug 2025 Sub Query
Section 5
Data Analytics Documents
1
Datasets Documents
2
Datasets Documents
Section 6

Postgre SQL

04. 22 July 2025 Basic SQL Syntax [Limit, Order By Asc & Desc, Aggregate Functions, AS] Statements

Lesson is locked. Please Buy course to proceed.

Postgre SQL 03. 21 July 2025 Basic SQL Syntax {Select, Distinct, Where, In, Between, And] Statements
Postgre SQL 05. 23 July 2025 Basic SQL Syntax [Group By, Having, Joins] Statements
error: Alert: Content selection is disabled!!