Avenue Impact
Data Analytics and Data Management Live Bootcamp April 2026
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

Enroll course

Course sections

Section 1
Join Live Class
1
Join Data Analytics Live Classes
Section 2
Free Data Analytics Session
1
30 Mar 2026 Introduction to Data Analytics & Business Intelligence
Section 3
Excel Recordings
1
01. 07 Apr 2026 Introduction & Understanding Excel Environment
2
02. 08 Apr 2026 Excel Environment, Data Manipulation & Cleansing [Sum, Average, Count, CountA, Max, Min]
3
03. 09 Apr 2026 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Paste Special]
4
04. 13 Apr 2026 Name Range, Structured Referencing, Sum, Average, Trim, Text to Value & Column
5
05. 14 Apr 2026 Left & Right, Conditional Formatting, Sum & Subtotal
6
06. 15 Apr 2026 Using IF, Paste Special, [Recap on Absolute, Relative, Mixed Referencing]
7
07. 16 Apr 2026 UsingIF, Count IF, CountIFS
8
08. 20 Apr 2026 CountIFS, SumIF, SumIFS, IF+AND, IF+OR
9
09. 21 Apr 2026 VLookUp, XLookUp, Index-Match
10
10. 22 Apr 2026 Bring Tables Together for Dashboarding
11
11. 23 Apr 2026 Pivot Table, Dashboarding
12
09. 06 Oct 2025 Data Combination & Dashboarding
13
10. 07 Oct 2025 Dashboarding in Excel
Section 4
PowerBI
1
01. 08 Oct 2025 Installation of PowerBI & Introduction to PowerBI (Theory)
2
02. 09 Oct 2025 Introduction to PowerBI (Theory) Cont.
3
01. 12 May 2026 Excel Conlusion & Introduction to PowerBI
4
02. 13 May 2026 Understanding PowerBI Workflow, Power Query
5
03. 14 May 2026 Fact & Dimension Table, Star & Snowflakes Schema
6
04. 18 May 2026 Fact & Dimension Table, Star & Snowflakes Schema (Contd)
7
05. 19 May 2026 Data Manipulation & Modelling I
8
06. 20 May 2026 Data Manipulation & Modelling II
9
07. 21 May 2026 Creating Calendar Dimension Table, Data Analysis & Visualization
Section 5
Datasets
1
Datasets Documents
2
Datasets Documents
3
Datasets Documents

Excel Recordings

08. 20 Apr 2026 CountIFS, SumIF, SumIFS, IF+AND, IF+OR

Lesson is locked. Please Buy course to proceed.

Excel Recordings 07. 16 Apr 2026 UsingIF, Count IF, CountIFS
Excel Recordings 09. 21 Apr 2026 VLookUp, XLookUp, Index-Match
error: Alert: Content selection is disabled!!