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

Excel

07. 01 Oct 2025 SumIfs & Student Lead Sessions

Lesson is locked. Please Buy course to proceed.

Excel 06. 30 Sept 2025 If Statements Cont.
Excel 08. 02 Oct 2025 Data Combination (Vlookup & Xlookup, Index & Match)
error: Alert: Content selection is disabled!!