Avenue Impact
4 Months Business Intelligence (Data Analytics) Excel, PowerBI, SQL, Tableau Training March 2024
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 Daily Data Live Training Session
1
Join Data Analytics Live Classes
Section 2
Join Weekly Interview Forum (Wednesdays)
1
Join Interview Forum - Data Analytics/ Business Intelligence
Section 3
Excel for Data Analytics Recordings
1
01. 18 Mar 2024 Introduction & Understanding Excel Environment
2
02. 22 Mar 2024 Data Manipulation & Cleansing [Left & Right, Clean, Trim, Sum, Average, Count, CountA, Max, Min, IF]
3
03. 25 Mar 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Ranges, Structure Referencing]
4
04. 28 Mar 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]
5
05. 04 Apr 2024 Data Manipulation & Cleansing [Substitute, IF + AND, IF + OR]
6
06. 05 Apr 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match (Project)]
7
07. 08 Apr 2024 Data Manipulation & Cleansing [Pivot Table with Trends(KPIs & Sales)]
8
08. 11 Apr 2024 Data Manipulation & Cleansing [Sales Trend (Contd), Dashboarding]
9
09. 12 Apr 2024 Power BI Download, Assignment Solution
Section 4
Power BI Recordings
1
01. 15 Apr 2024 Understanding Power BI Workflow, Power Query Environment, Data Model in Power BI
2
02. 16 Apr 2024 Database Fundamentals [Primary & Foreign Keys, [Facts & Dimension Tables]
3
03. 18 Apr 2024 Fact & Dimension table (Contd) Star & Snowflakes Schema, Data Manipulation & Modelling 1
4
04. 22 Apr 2024 Data Manipulation & Modelling I
5
05. 24 Apr 2024 Data Manipulation & Modelling II
6
06. 25 Apr 2024 DAX & Data Visualization
7
07. 26 Apr 2024 DAX & Data Visualization (Contd)
8
08. 29 Apr 2024 Plato Pizza Case Study Solution
9
09. 30 Apr 2024 Plato Pizza Case Study [contd]
10
10. 01 May 2024 Domino's Pizza Case Study Solution
11
11. 02 May 2024 BTC Case Study with Dashboard
12
12. 03 May 2024 Bitcoin Case Study with Dashboard [Contd]
13
13. 08 May 2024 Real Estate Case Study
14
14. 09 May 2024 Real Estate Case Study [Contd] with Dashboard
15
15. 10 May 2024 Real Estate Case Study Dashboard
Section 5
SQL Recordings
1
01. 13 May 2024 Meaning of Data, Database, Data Warehouse, Entity Relationship Diagram (ERD), Download Postgre SQL
2
02. 14 May 2024 Database Creation on Postgre SQL, Select Statement
3
03. 16 May 2024 Distinct, Where, Count, Limit, Order By [Asc & Desc] Statements
4
04. 17 May 2024 Top 10, Between, Like & iLike, IN, Aggregate Functions, Group By, Having Statement
5
05. 21 May 2024 Where, Count, Limit, Order By [Asc & Desc], IN, Like & iLike Statements
6
06. 22 May 2024 Group By & Having Clause Statement, JOINS
7
07. 23 May 2024 JOINS [Inner, Left, Right, Full], Create Table [Fraudulent Transaction]
8
08. 24 May 2024 Fraudulent Case Study [Tailored Analysis]
Section 6
Tableau Recordings
1
01. 28 May 2024 How To Download Tableau, Introduction To Tableau
2
02. 29 May 2024 Building Blocks of Tableau [The WHAT & HOW]
3
03. 31 May 2024 Data Modelling & Preparation (Data Blending, Relationship, Joins)
4
04. 04 June 2024 Tableau Function & Calculated Field 1
5
05. 05 June 2024 Tableau Function & Calculated Field 2, Dashboarding
6
06. 06 June 2024 Tableau Dashboarding [Contd]
Section 7
Python Recordings
1
01. 11 June 2024 Python Class
2
02. 12 June 2024 Download Python, Jupyter Notebook, Variables
3
03. 13 June 2024 Strings, Indexing & Slicing
4
04. 14 June 2024 Print Formatting, Concatenation, List
5
05. 17 June 2024 Project Guide
Section 8
Data Analystics Documents
1
Datasets Documents
2
Upload CV and Book 1-2-1 Review

Excel for Data Analytics Recordings

03. 25 Mar 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Ranges, Structure Referencing]

Lesson is locked. Please Buy course to proceed.

Excel for Data Analytics Recordings 02. 22 Mar 2024 Data Manipulation & Cleansing [Left & Right, Clean, Trim, Sum, Average, Count, CountA, Max, Min, IF]
Excel for Data Analytics Recordings 04. 28 Mar 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]
error: Alert: Content selection is disabled!!