Joins: Inner, Left, Right, Full Join | Data With Baraa Academy

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Complete Tableau Mastery

Tableau Basics

Welcome To Tableau Mastery (3:21)
Course Materials
Course Overview (5:15)
Data Buzzwords: BIG Data, IoT, Data Science and More (8:17)
What is Business Intelligence (BI) (2:39)
The Power of Data Visualization (3:14)
Excel vs Tableau (8:40)
Best 3 Tools for Data Visualization (0:51)
What is Tableau (2:29)
Why Tableau (5:06)

Tableau Products Suite

Section Introduction | Tableau Products (0:33)
Overview Tableau Products (2:10)
Tableau Desktop, Public Desktop, Prep (7:15)
Sharing Products & Process (2:27)
Hosting Tableau: On-Prem vs IaaS vs SaaS (5:58)
Tableau Server & Cloud (2:40)
Tableau Public (2:46)
Tableau Reader & Mobile (2:19)
Tableau Server vs Cloud vs Public vs Reader vs Mobile (3:51)

Tableau Architecture

Section Introduction | Tableau Architecture (0:42)
Tableau Live vs Extract (2:22)
Tableau File Types (4:02)
Tableau Architecture: Desktop Components (7:52)
Tableau Server Processes (7:20)
Tableau Architecture: Server Components (10:43)
Tableau Architecture: Public Components & Limitations (3:30)

Prepare Your Training Environment

Download & Install Tableau (1:25)
Create Tableau Public Account (1:22)
Get Training Datasets (5:51)
Publishing Your First Viz (2:33)
Tour of the Tableau Interface (13:08)

Data Modeling & Combining Data

Section Introduction | Data Modeling & Combining Data (0:51)
Concept Of Data Modeling (6:42)
Tableau Data Modeling and Layers (Physical & Logical) (4:33)
Joins: Inner, Left, Right, Full Join (8:42)
Union (6:57)
Relationships (16:31)
Data Blending (6:46)
Joins vs Data Blending (3:41)
Joins vs Relationships (5:19)
JOIN vs UNION vs RELATION vs BLENDING (3:17)
Build Two Data Sources (11:27)

Tableau Metadata

Introduction to Tableau Metadata (0:52)
Data Types (18:52)
Geographic and Image Roles (4:42)
Dimensions and Measures (17:38)
Discrete and Continuous (14:37)
Data Types vs Dimension & Measure vs Discrete & Continuous (1:44)

Renaming & Aliases

Section Introduction | Renaming & Aliases (0:34)
Naming Conventions (10:36)
Rename Columns & Tables (10:18)
Aliases (8:41)

Organizing Your Data

Section Introduction | Organizing Data (0:42)
Hierarchies (17:54)
Groups (12:52)
Cluster Groups (9:41)
Sets (23:46)
Bins & Histograms (10:32)

Filtering & Sorting Data

Section Introduction | Filtering & Sorting Data (0:43)
Types of Filters (Concept) (11:29)
Data Source Filter (5:13)
Context Filter (5:56)
Dimension Filter (5:28)
Measure Filters (3:17)
Table Calculation Filter (3:57)
How to Apply Filter (8:02)
Values of Filters (16:15)
Customize Filters (3:00)
10x Filter Tips & Tricks (15:44)
Sorting Data (16:01)

Parameters | Dynamic Views

Concept of Parameters (2:13)
Dynamic Calculations using Parameters (5:45)
Dynamic Reference Lines using Parameters (1:37)
Dynamic Filters using Parameters (3:30)
Swap Measures/Dimensions using Parameters (9:21)
Dynamic Titles & Texts using Parameters (2:37)
Dynamic Bins & Histograms using Parameters (3:12)

Tableau Actions

Concept of Actions (2:38)
Actions: Go To URL & Go to Sheet (7:21)
Actions: Filters & Quick Actions (6:18)
Actions: Highlight (4:17)
Actions: Set (6:10)
Actions: Parameters (5:17)
Choose The Correct Trigger (1:43)

Tableau Calculations

Section Introduction | Tableau Calculation (0:41)
Introduction to Tableau Calculations (10:56)
Based Components of Calculations (8:28)
Nested Calculations (5:27)
Types of Calculations (22:59)
Number Functions | Round Functions: CEILING, FLOOR, ROUND (9:26)
String Functions | Change Cases: LOWER & UPPER (11:05)
String Functions | Remove Spaces: LTRIM, RTRIM, TRIM (11:54)
String Functions | Extract Substring: LEFT, RIGHT, MID (12:31)
String Functions | Search: STARTSWITH, ENDSWITH, CONTAINS, FIND, FINDNTH (26:08)
String Functions | CONCAT & SPLIT (15:24)
String Functions | REPLACE (6:52)
Date Functions | Extract Dateparts: DATENAME, DATEPART, DATETRUNC, DAY (30:15)
Date Functions | Add & Subtract Dates: DATEDIFF, DATEADD (12:30)
Date Functions | TODAY & NOW (6:50)
NULL Functions | ZN, IFNULL, ISNULL (13:57)
Logical Functions | IF, ELSE, ELSEIF, IIF, CASEWHEN (28:19)
Logical Operators | AND, OR, NOT (16:26)
Aggregate Functions | SUM, AVG, COUNT, COUNTD, MAX, MIN (19:29)
Aggregate Functions | ATTR Attribute Function (14:53)
LOD Expressions | Introduction to Tableau Level of Details (8:50)
LOD Expressions | FIXED (9:26)
LOD Expressions | EXCLUDE (5:31)
LOD Expressions | INCLUDE (12:57)
Table Calculations | FIRST, LAST, INDEX, RANK (21:50)
Table Calculations | Running Total (6:09)
Table Calculations | Difference (7:29)

Tableau Charts

Tableau Dashboards

Introduction To Tableau Dashboards (16:31)
Tableau Dashboard Project (10:00)

Tableau Sales & Customers Project

Project Materials
Section Introduction | Tableau Project (0:57)
Tableau Project Steps (3:16)
#1 Step | Requirements analysis (9:34)
#2 Step | Building Data Source (7:27)
#3 Step | Building Charts - Part1 (31:47)
#3 Step | Building Charts - Part2 (10:05)
#3 Step | Building Charts - Part3 (9:41)
#4 Step | Building Sales Dashboard - Part1 (9:25)
#4 Step | Building Sales Dashboard - Part2 (22:35)
#4 Step | Building Sales Dashboard - Part3 (17:23)
#5 Step | Building Customer Dashboard (21:57)

Tableau HR Project

Project Materials
Project Introduction (2:57)
Build Data Source (6:44)
Summary Dashboard | Build Charts - Part1 (25:57)
Summary Dashboard | Build Charts - Part2 (25:14)
Summary Dashboard | Sketch Mockups (10:40)
Summary Dashboard | Build Dashboard and Containers (19:45)
Summary Dashboard | Fine Tuning The Dashboard (75:20)
Detailed Dashboard | Build the Table (13:50)
Detailed Dashboard | Sketch Mockups (3:22)
Detailed Dashboard | Build the Dashboard (28:15)
Bonus - Build Background Layers using FIGMA (9:22)

THANK YOU

Congratulation & THANK YOU (0:27)

Joins: Inner, Left, Right, Full Join

Complete and Continue

Lesson Content Locked

Your session expired. Please sign in again to continue.

Login