---
schema_version: "1"
id: db64791e78b8c0189586a4319d0793a188ef69a054df103a05f73d3e42cfe06d
title: Analyze Multiple Data Model Objects Using Joins
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_direct_data_datacloud_joinui.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_direct_data_datacloud_joinui.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: dd2764c425a641c3ddea3c23c33dca02069aff8a254cacdc44487995e366110a
description: To explore and draw insights from multiple related data model object (DMO) records simultaneously, join these objects in a single dashboard query. Direct Data for Data 360 supports four types of joins on data model objects with defined relationships between them. You can also filter joined data and highlight the records that matter with conditional formatting.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Analyze Multiple Data Model Objects Using Joins

To explore and draw insights from multiple related data model object (DMO) records simultaneously, join these objects in a single dashboard query. Direct Data for Data 360 supports four types of joins on data model objects with defined relationships between them. You can also filter joined data and highlight the records that matter with conditional formatting.

Say you want to compare sales order data with product and customer’s annual income.

1. In the dashboard designer, create a query on the Sales Order DMO (1).
    
    ![Create query on a DMO in dashboard](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_create_query_dmo.png)
2. In the lens mode, click **Manage Data Sources** (2).
    
    The Manage Data Sources window displays a list of related data sources.
3. Add the related Individual and Product DMOs to the query (3).
    
    By default, the DMOs are joined using a left join.
    
    ![Create query on a DMO in dashboard](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_join_dmo_objects.png)
4. Apply your changes (4).
    
    ![Create query on a DMO in dashboard](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_join_dmo_objects.png)
5. Build your query on the joined DMOs in the dashboard lens.
    
    ![Query created on join objects](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dmo_chart.png)