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
Section 4
Data Analytics Documents
1
Datasets Documents
2
Datasets Documents

Excel Recordings

06. 20 May 2025 Sum & Subtotal, IF statement, CountIF

Lesson is locked. Please Buy course to proceed.

Excel Recordings 05. 19 May 2025 Left & Right, Clean, Trim, Conditional Formatting
Excel Recordings 07. 21 May 2025 CountIF, SumIF, Index & Match, VLookUp, XLookUp
error: Alert: Content selection is disabled!!