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
7
07. 20 Sept 2024 Group By, Having Clause, Where Statement, Joins
8
08. 23 Sept 2024 JOINS [Inner, Left, Right, Full]
9
09. 24 Sept 2024 JOINS [Inner, Left, Right, Full] Contd
10
10. 25 Sept 2024 Case Statement
11
26 Sept 2024 Select Distinct, Select From, Then, When, Else Statements
12
27 Sept 2024 When, Join, From, Create Database
13
13. 30 Sept 2024 Create table, Update and Insert, Drop Delete, Alter, Create view
14
14. 01 Oct 2024 Fraudulent Case Study [Tailored Analysis]
15
15. 02 Oct 2024 Fraudulent Case Study [Tailored Analysis] (Cont)
16
16. 03 Oct 2024 Snowflakes and Databricks
17
17. 07 Oct 2024 Snowflake Contd
18
18. 09 Oct 2024 Collaboration
19
19. 10 Oct 2024 Snowflakes Case Study
Section 5
Tableau Recordings
1
01. 14 Oct 2024 How To Download Tableau, Connecting Tableau to Snowflake
2
02. 15 Oct 2024 Downloading of Tableau, Introduction To Tableau, Building Blocks of Tableau [The WHAT & HOW]
3
03. 16 Oct 2024 Using Marks Card to build chart and Filters
4
04. 17 Oct 2024 Data Modelling and Preparation (Data Blending, Relationship & Joins, Pivoting of Data), Tableau Function & Calculated Field 1
5
05. 18 Oct 2024 Tableau Function & Calculated Field 2, Sales Dashbord
6
06. 21 Oct 2024 Introduction to Data Governance
7
07. 22 Oct 2024 Understanding MoSCoW
Section 6
Python Recordings
1
01. 23 Oct 2024 Download & Introduction Python, Jupyter Note
2
02. 24 Oct 2024 Python Fundamentals
3
03. 25 Oct 2024 Strings, Indexing & Slicing
4
04. 28 Oct 2024 Lists & Tuples
5
05. 29 Oct 2024 Data Type - Dictionary
6
06. 30 Oct 2024 Sets and Boolean
7
07. 31 Oct 2024 Boolean, If, Else-If, And & Or Statement, For Loop
8
08. 01 Nov 2024 For Loop (Contd), While Loop
9
09. 04 Nov 2024 While Loop (Contd), Break, Continue & Pass
10
10. 05 Nov 2024 Function & NUMPy
11
11. 06 Nov 2024 NUMPy (Contd)
12
12. 07 Nov 2024 Indexing & Slicing
13
13. 08 Nov 2024 Project Guide
Section 7
Project
1
14. 12 Nov 2024 Project Day 1
2
15. 13 Nov 2024 Project Day 2
3
16. 14 Nov 2024 Project Day 3
4
17. 15 Nov 2024 Project Day 4
5
18. 18 Nov 2024 Project Day 5
6
19. 19 Nov 2024 Project Day 6
7
20. 20 Nov 2024 Project Day 7
8
21. 21 Nov 2024 Project Day 8
Section 8
Data Analytics Documents
1
Datasets Documents
2
Datasets Documents

SQL Recordings

07. 20 Sept 2024 Group By, Having Clause, Where Statement, Joins

Lesson is locked. Please Buy course to proceed.

SQL Recordings 06. 17 Sept 2024 Count, Limit, Order By [Asc & Desc], Top 10, Between, Like & iLike, IN Aggregate Functions
SQL Recordings 08. 23 Sept 2024 JOINS [Inner, Left, Right, Full]
error: Alert: Content selection is disabled!!