Exp 2: Demonstration of types of joins and unions | BCU Tableau Lab | MBA 4th Semester
Kishore Chandrasekhar
0:00 / 0:00
Exp 2: Demonstration of types of joins and unions | BCU Tableau Lab | MBA 4th Semester
471 просмотр · 9 дн. назад
Kishore Chandrasekhar
30 подписчиков
471 просмотр · 9 дн. назад
Experiment 02 of the Bengaluru City University (BCU) Tableau Practical Lab series for 4th Semester MBA.
In this session, we walk through the fundamentals of connecting multiple data sources, building table relationships using different types of joins (Inner, Left, Right, Full Outer), and combining data from multiple tables using the Union feature in Tableau.
Practice Dataset (Excel files: Customers, Orders, Sales_Region):
1. https://drive.google.com/file/d/1q2t3...
2. https://drive.google.com/file/d/1DLhB...
3. https://docs.google.com/spreadsheets/...
University Course: BCU 4th Semester MBA – Business Analytics Lab
⏱️ Timestamps / Chapters:
00:00 - Introduction to Unions and Joins in Tableau
02:07 - Opening Tableau Desktop and Connecting to Customer Data
02:27 - Adding Multiple Connections and Sheets (Customers & Orders)
03:00 - Creating Joins (Inner, Left, Right, Full Outer) & Row Counts
04:10 - Worksheet Overview: Dimensions vs. Measures
04:38 - Building a Bar Chart (Country vs. Order Amount)
05:15 - Analyzing Customer-Level Orders and Sorting Data
06:21 - Introduction to Union Functionality with Sales Region Data
07:34 - Connecting and Unioning Sales Region Sheets in Tableau
09:25 - Resolving Mismatched Fields and Merging Columns
10:28 - Visualizing Unioned Data and Changing Chart Types (Bar, Pie, Text Tables)
#Tableau #BengaluruCityUniversity #BCUAnalytics #DataVisualization #TableauLab #BusinessAnalytics #BCUMBA #MBAAnalytics #DataJoins #DataUnions