Перейти к содержимому

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