Self-Paced (Data Analytics) Excel, PowerBI, SQL, Tableau Training

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

Excel Recordings

01. 31 Jul 2023 Introduction & Understanding Excel Environment

02. 01 Aug 2023 Characteristics of Data Format

03. 02 Aug 2023 Data Cleansing & Absolute Referencing

04. 03 Aug 2023 Basic Functions, Absolute & Mixed Referencing

05. 04 Aug 2023 Named Ranges, Data Validation, Structured Referencing & Conditional Formatting

06. 07 Aug 2023 Sum & Subtotal, Using IF, Count IF and Conditional Formatting

07. 08 Aug 2023 CountIF, CountIFS, SumIF & SumIFS

08. 09 Aug 2023 Index Match & Pivot Table

09. 10 Aug 2023 Dashboarding - KPI, Sales Trend, Top 10 Products

10. 11 Aug 2023 Dashboarding (Cotnd)

11. 14 Aug 2023 VLookUp, XLookUp, Assignment Guide

Section 2

Power BI Recordings

01. 15 Aug 2023 What is Business Intelligence - Power BI vs Excel, Power BI Interface & Workflow

02. 16 Aug 2023 PowerBI Workflow (Contd), Primary & Foreign Keys, Facts and Dimension Table

03. 17 Aug 2023 Star Schema and Snowflakes Schema

04. 18 Aug 2023 Connecting PowerBI To Folder, Creating Dimension Table

How to Download PowerBI for Mac Users

05. 22 Aug 2023 Creation of Fact Table and Data Modelling 1

06. 23 Aug 2023 Data Modelling 2 & Creation of Calendar Dimension Table

07. 24 Aug 2023 Data Modelling 2 (Contd)

08. 25 Aug 2023 Data Visualization 1

09. 29 Aug 2023 Data Visualization 2

10. 30 Aug 2023 Bookmarks and BTC Case Study

11. 31 Aug 2023 Bitcoin Dashboard

12. 01 Sept 2023 Survey Dataset Case Study

13. 04 Sept 2023 AVI Travel Dashboard

14. 05 Sept 2023 Plato Pizza Case Study

15. 07 Sept 2023 Real Estate Case Study

16. 08 Sept 2023 Real Estate Case Study (Contd)

17. 11 Sept 2023 Real Estate Case Study DAX & Visuals (Contd)

18. 12 Sept 2023 Real Estate Case Study Visuals Design (Contd)

19. 13 Sept 2023 Real Estate Case Study Visuals Design (Contd), GPT Guide

Section 3

Postgre SQL Recordings

01. 14 Sept 2023 How to Download Postgre SQL

02. 15 Sept 2023 Data Meaning, Types & differences, Data Warehouse & Types

03. 18 Sept 2023 Entity Relationship Diagram

04. 19 Sept 2023 Entity Relationship Diagram (Contd)

05. 21 Sept 2023 Database Creation, SQL Syntax (Select Statement)

06. 22 Sept 2023 SQL Syntax (Select & Where Statement)

07. 25 Sept 2023 SQL Syntax (Where Statement) - AND, OR, NOT, IN, NOT IN, Combining Logical & Between Operators

08. 26 Sept 2023 SQL Syntax (Null, Is Not Null, Empty Strings, Parenthesis For Complex Condition, Wildcards)

09. 28 Sept 2023 Revision Of Like & iLike, Select (Count-Limit, Order By, Aggregation Function AS)

10. 29 Sept 2023 SQL Syntax (Group By & Having Statement)

11. 02 Oct 2023 CONCAT, DATA TYPE & JOIN (Left Join)

12. 03 Oct 2023 Left Join (Contd)

13. 04 Oct 2023 Left Join (Contd), Right Join, Inner Join

14. 05 Oct 2023 [Left Join, Right Join, Inner Join(Contd)] Full Join, Case & Else Statement

15. 06 Oct 2023 Case & Nested Case Statements (Contd), Subquery

16. 09 Oct 2023 Connecting PowerBI To PostGre SQL DB, Creating a DB, Creating a Table in DB, Copying Data To The Table In The DB

17. 10 Oct 2023 Fraudulent Transaction Case Study

Section 4

Tableau Recordings

01. 11 Oct 2023 How To Download Tableau

02. 12 Oct 2023 Introduction To Tableau, Building Blocks For Tableau

03. 13 Oct 2023 Granularity, Basic Chart in Tableau, Filters, Working with Time Series

04. 16 Oct 2023 Data Modelling & Preparation (Data Blending, Relationship, Joins, Pivoting)

05. 17 Oct 2023 Tableau Function 1

06. 18 Oct 2023 Tableau Function 2, LOD

07. 19 Oct 2023 LODs & Formatting

08. 20 Oct 2023 Dashboarding

09. 23 Oct 2023 Dashboarding 2

10. 25 Oct 2023 Everything About Portfolio (Google Drive, GitHub, HTML 5 up, Visual Studio Code)

11. 26 Oct 2023 Project Guide

Section 5

Assignments

Datasets Documents

Section 6

Join WhatsApp Group

Join Data Team's Group

Section 7

Join Project

Project Environment

Upload CV for Data Analyst

Data Analytics/ BI Interview Questions

Power BI Recordings

08. 25 Aug 2023 Data Visualization 1

Lesson is locked. Please Buy course to proceed.

Power BI Recordings 07. 24 Aug 2023 Data Modelling 2 (Contd)

Power BI Recordings 09. 29 Aug 2023 Data Visualization 2

error: Alert: Content selection is disabled!!