3 Months (Data Analytics) Excel, PowerBI, SQL, Tableau Training [Nov 2023]

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

Get course

Available in "Two-Payment of £500 Per Month" plan Available in "One Payment of £1000" plan

Course sections

Section 1

Join Data Live Session

Join Data Analytics Live Classes

Section 2

Excel for Data Analytics Recordings

30. Oct 2023 Data Analytics Training Taster Session

01. 06 Nov 2023 Introduction & Understanding Excel Environment

02. 07 Nov 2023 Characteristics of Data Format

03. 08 Nov 2023 Cell Referencing [Relative Referencing & Absolute Referencing]

04. 09 Nov 2023 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Range & Paste Special]

05. 13 Nov 2023 Data Manipulation & Cleansing [Name Range, Structured Referencing, Left & Right, Clean, Trim]

06. 14 Nov 2023 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]

06. 14 Nov 2023 Consultancy Session

07. 15 Nov 2023 Data Manipulation & Cleansing [Sum IF, IF + AND, IF + OR, Index Match]

08. 16 Nov 2023 Data Manipulation & Cleansing [Index Match (Contd), Pivot Table (KPIs & Sales)]

09. 17 Nov 2023 Data Manipulation & Cleansing [Pivot Table with Trends (Contd)]

10. 20 Nov 2023 Data Manipulation & Cleansing [Dashboarding]

11. 08 Dec 2023 Assignment Solution

12. 11 Dec 2023 VLookUp, XLookUp

Section 3

Power BI Recordings

01. 21 Nov 2023 Download Power BI, Explanation on Excel Assignment

02. 22 Nov 2023 Understanding Power BI Workflow, Database Fundamentals [Primary & Foreign Keys

03. 23 Nov 2023 Database Fundamentals [Facts & Dimension Tables]

04. 24 Nov 2023 Fact & Dimension table [(Contd) Star Schema], Data Manipulation & Modelling

05. 27 Nov 2023 Fact & Dimension table [(Contd) Snowflakes Schema], Data Manipulation & Modelling I

06. 28 Nov 2023 Data Manipulation & Modelling II

07. 29 Nov 2023 Collaborative Session I

08. 30 Nov 2023 DAX & Data Visualization

09. 01 Dec 2023 DAX & Data Visualization [Contd]

10. 04 Dec 2023 Collaborative Session II

11. 06 Dec 2023 Dashboard, Bitcoin Case Study

12. 07 Dec 2023 Bitcoin Case Study [Contd]

13. 12 Dec 2023 Plato Pizza Case Study Solution

14. 13 Dec 2023 Real Estate Case Study

15. 14 Dec 2023 Real Estate Case Study [Contd]

16. 15 Dec 2023 Real Estate Dashboard

Section 4

SQL Recordings

01. 11 Jan 2024 How to Download Postgre SQL

02. 15 Jan 2024 Meaning of Data, Database, Data Warehouse, Entity Relationship Diagram (ERD), Database Creation on Postgre SQL

03. 16 Jan 2024 Database Creation, SQL Syntax (Select, Distinct & Where Statements)

04. 19 Jan 2024 Select Statement (Select Count, Order By [ASC-DESC], Top 10, Between, IN Statement, Like & iLike, Aggregation Function)

05. 22 Jan 2024 Group By & Having Statement, As Statement, JOIN Types (Inner, Left, Right & Full)

06. 23 Jan 2024 JOIN Types (Contd)

07. 24 Jan 2024 Case Statement, CTE Query Definition, Create or Replace Procedure

08. 26 Jan 2024 Connecting PowerBI to Postgre SQL, Create Database, Fraudulent Transaction Case

Section 5

Tableau Recordings

01. 29 Jan 2024 Tableau Download, Introduction to Tableau, Building Blocks of Tableau

02. 30 Jan 2024 Filters In Tableau

03. 31 Jan 2024 Fraudulent Transaction Case Study

04. 01 Feb 2024 Tableau Function & Calculated Field

05. 05 Feb 2024 Formatting & Dashboarding

06. 12 Feb 2024 Project Guide

07. 16 Feb 2024 How to Build Portfolio using GitHub, NovyPro & Linktree

08. 17 Feb 2024 Everything About Portfolio [Google Drive, GitHub, HTML 5 up, Visual Studio Code]

Guide for CV Review, Interview Questions & Support

Section 6

Documents and Assignments

Datasets Documents

Section 7

Join WhatsApp Group

Join Data Team's Group

Section 8

Project Case Study

12 Feb 2024 - Data Analytics Project Case Study

Excel for Data Analytics Recordings

12. 11 Dec 2023 VLookUp, XLookUp

Lesson is locked. Please Buy course to proceed.

Excel for Data Analytics Recordings 11. 08 Dec 2023 Assignment Solution

Documents and Assignments Datasets Documents

error: Alert: Content selection is disabled!!