Bird
Raised Fist0
Tableaubi_tool~8 mins

Why connecting disparate data enables insights in Tableau - Dashboard Impact

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Dashboard Mode - Why connecting disparate data enables insights
Business Question

How can combining sales and customer support data help us understand customer satisfaction and sales performance together?

Sample Data
Customer IDCustomer NameRegionSales AmountSupport TicketsSupport Satisfaction Score
101Alpha CorpNorth500024.5
102Beta LLCSouth700053.8
103Gamma IncEast300014.9
104Delta CoWest450034.0
105Epsilon LtdNorth600043.5
Dashboard Components
  • KPI Card: Total Sales
    Formula: SUM([Sales Amount])
    Result: 5000 + 7000 + 3000 + 4500 + 6000 = 25500
  • KPI Card: Average Support Satisfaction
    Formula: AVG([Support Satisfaction Score])
    Result: (4.5 + 3.8 + 4.9 + 4.0 + 3.5) / 5 = 4.14
  • Bar Chart: Sales by Region
    Formula: SUM([Sales Amount]) grouped by [Region]
    Results:
    • North: 5000 + 6000 = 11000
    • South: 7000
    • East: 3000
    • West: 4500
  • Scatter Plot: Support Tickets vs Sales Amount
    Each point is a customer showing number of support tickets on X-axis and sales amount on Y-axis.
    Shows relationship between support needs and sales.
  • Table: Customer Details
    Shows Customer ID, Name, Region, Sales, Tickets, Satisfaction Score for detailed view.
Dashboard Layout
+----------------------+-----------------------+
|   Total Sales KPI     | Avg Support Satisfaction|
+----------------------+-----------------------+
|                      Bar Chart: Sales by Region          |
|                                                        |
+--------------------------------------------------------+
| Scatter Plot: Support Tickets vs Sales Amount           |
|                                                        |
+--------------------------------------------------------+
| Customer Details Table                                   |
+--------------------------------------------------------+
Interactivity

Filter by Region: Selecting a region updates all components to show data only for that region. For example, choosing 'North' filters sales, satisfaction, charts, and table to North region customers.

Hover on scatter plot points shows customer name and details.

Self Check

If you add a filter for Region = 'South', which components update?

  • Total Sales KPI shows 7000
  • Average Support Satisfaction shows 3.8
  • Bar Chart highlights South region bar
  • Scatter Plot shows only Beta LLC point
  • Customer Details Table shows only Beta LLC row
Key Result
Dashboard combining sales and support data to reveal customer satisfaction and sales insights by region.

Practice

(1/5)
1. Why is connecting different data sources in Tableau important for business insights?
easy
A. It makes the dashboard load slower.
B. It combines information to give a fuller picture of the business.
C. It hides data from users.
D. It deletes duplicate records automatically.

Solution

  1. Step 1: Understand the purpose of connecting data

    Connecting data sources allows combining different pieces of information that alone may not show the full story.

  2. Step 2: Recognize the benefit for insights

    By linking data, Tableau can show relationships and trends that help make better decisions.

  3. Final Answer:

    It combines information to give a fuller picture of the business. -> Option B

  4. Quick Check:

    Connecting data = fuller picture [OK]
Hint: Connecting data = fuller insights, not slower or hidden data [OK]
Common Mistakes:
  • Thinking connecting data slows dashboards
  • Believing it hides data
  • Assuming it deletes duplicates automatically
2. Which Tableau feature is used to link different data sources without merging their tables?
easy
A. Relationships
B. Filters
C. Calculated fields
D. Data blending

Solution

  1. Step 1: Identify Tableau features for connecting data

    Tableau uses joins, relationships, and blending to connect data sources.

  2. Step 2: Understand relationships

    Relationships link tables logically without merging them, preserving their structure and enabling flexible analysis.

  3. Final Answer:

    Relationships -> Option A

  4. Quick Check:

    Link without merging = Relationships [OK]
Hint: Relationships link data without merging tables [OK]
Common Mistakes:
  • Confusing blending with relationships
  • Thinking calculated fields link data
  • Assuming filters connect data sources
3. Given two data sources: Sales and Customers, connected by a relationship on Customer ID, what insight can Tableau show?
medium
A. Sales data duplicated for each customer
B. Only sales data without customer info
C. Customer names without sales numbers
D. Total sales amount per customer region

Solution

  1. Step 1: Understand the relationship between Sales and Customers

    The relationship on Customer ID links sales records to customer details like region.

  2. Step 2: Predict the combined insight

    Tableau can aggregate sales amounts grouped by customer region using this link.

  3. Final Answer:

    Total sales amount per customer region -> Option D

  4. Quick Check:

    Relationship enables combined sales and customer info [OK]
Hint: Relationship joins data for combined insights like sales by region [OK]
Common Mistakes:
  • Thinking only sales or only customer data shows
  • Assuming data duplicates incorrectly
  • Ignoring the relationship effect
4. You connected two data sources in Tableau but the dashboard shows no combined data. What is the likely problem?
medium
A. Filters are turned off.
B. The data sources have too many rows.
C. The relationship keys do not match between sources.
D. Calculated fields are missing.

Solution

  1. Step 1: Check the relationship keys

    If keys used to link data do not match, Tableau cannot combine the data correctly.

  2. Step 2: Rule out other causes

    Data size, filters, or calculated fields do not prevent combining if keys match.

  3. Final Answer:

    The relationship keys do not match between sources. -> Option C

  4. Quick Check:

    Mismatch keys = no combined data [OK]
Hint: Check keys match to connect data properly [OK]
Common Mistakes:
  • Blaming data size for no combined data
  • Thinking filters off cause no join
  • Assuming calculated fields are required to connect
5. You have three data sources: Orders, Products, and Suppliers. How does connecting all three in Tableau help find insights?
hard
A. It allows analysis of sales by product and supplier region together.
B. It automatically cleans all data errors.
C. It hides supplier details from the report.
D. It duplicates orders for each product.

Solution

  1. Step 1: Understand the role of each data source

    Orders show sales, Products describe items, Suppliers provide origin info.

  2. Step 2: Connect data to combine insights

    Linking all three lets Tableau show sales by product and supplier region, revealing patterns across sources.

  3. Step 3: Recognize what connecting does not do

    It does not clean errors automatically, hide data, or duplicate records incorrectly.

  4. Final Answer:

    It allows analysis of sales by product and supplier region together. -> Option A

  5. Quick Check:

    Connecting multiple sources = combined insights [OK]
Hint: Connect all to analyze combined sales and supplier info [OK]
Common Mistakes:
  • Expecting automatic data cleaning
  • Thinking data gets hidden
  • Assuming data duplicates incorrectly