Avenue Impact
Become a Data Analyst – July 2024 Cohort
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 Session
1
Join Data Analytics Live Classes
Section 2
Excel Recordings
1
01. 15 July 2024 Introduction & Understanding Excel Environment
2
02. 16 July 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking
3
03. 17 July 2024 Data Manipulation & Cleansing [Sum, Name Ranges, Structure Referencing, IF, Clean, Trim, Text to Column, Left & Right, Conditional Formatting]
4
04. 18 July 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IF, Sum IF, IF + AND, IF + OR]
5
05. 19 July 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match]
6
06. 22 July 2024 Assignment Correction
7
07. 23 July 2024 Data Manipulation & Cleansing [Index & Match (Contd), Pivot Table with Trends (KPIs & Sales)]
8
08. 24 July 2024 Dashboarding, Editing Interface [VBA]
Section 3
PowerBI Recordings
1
How to Download PowerBI for Mac Users
2
01. 25 July 2024 Understanding PowerBI Workflow, Power Query Environment, Data Model in Power BI
3
02. 26 July 2024 Database Fundamentals Primary & Foreign Keys, Facts & Dimension Tables
4
03. 29 July 2024 Fact & Dimension table (Contd), Star & Snowflakes Schema
5
04. 30 July 2024 How to Download PowerBI, Data Manipulation & Modelling I
6
05. 31 July 2024 Data Manipulation & Modelling II [Contd]
7
06. 01 Aug 2024 Data Manipulation & Modelling III
8
07. 02 Aug 2024 DAX & Data Visualization
9
08. 05 Aug 2024 Data Visualization [Dashboarding] (Contd)
10
09. 06 Aug 2024 Sales Modelling & Dashboarding
11
10. 12 Aug 2024 AVI Travel Survey Case Study
12
11. 13 Aug 2024 AVI Travel Survey Case Study [Contd] with Dashboard
13
12. 19 Aug 2024 IBM HR Case Study with Dashboard
14
13. 20 Aug 2024 IBM HR Case Study [contd] with Dashboard
15
14. 21 Aug 2024 Plato Pizza Case Study
16
15. 22 Aug 2024 Plato Pizza with Dashboard [Contd] Pt1
17
16. 23 Aug 2024 Plato Pizza with Dashboard [Contd] Pt2
18
17. 27 Aug 2024 Collaboration
19
18. 28 Aug 2024 Connecting PowerBi with Yahoo Finance to Build Dashboard
20
19. 02 Sept 2024 How to Bookmark using BITCOIN Dashboard, AVI Property Case Study
21
20. 03 Sept 2024 AVI Property Case Study [Contd]
22
21. 04 Sept 2024 AVI Property Case Study with Dashboard [Contd]
23
22. 05 Sept 2024 Designing & Visualising using AVI Property Case Study Dashboard
24
23. 06 Sept 2024 Understanding UX Unicorn, Postgre Installation
Section 4
SQL Recordings
1
01. 10 Sept 2024 Meaning of Data, Database, Data Warehouse
2
02. 11 Sept 2024 Entity Relationship Diagram (ERD)
3
03. 12 Sept 2024 Creating a Database and Testimonials (Success Story)
4
04. 13 Sept 2024 Select, Distinct and Where Statement
5
05. 16 Sept 2024 Where [Comparison operators], AND, OR, NOT, Statement
6
06. 17 Sept 2024 Count, Limit, Order By [Asc & Desc], Top 10, Between, Like & iLike, IN Aggregate Functions
Section 5
Data Analytics Documents
1
Datasets Documents
2
Datasets Documents

Excel Recordings

06. 22 July 2024 Assignment Correction

Lesson is locked. Please Buy course to proceed.

Excel Recordings 05. 19 July 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match]
Excel Recordings 07. 23 July 2024 Data Manipulation & Cleansing [Index & Match (Contd), Pivot Table with Trends (KPIs & Sales)]
error: Alert: Content selection is disabled!!