---
schema_version: "1"
id: 27c9cc66519252d7e08f6c7306607561326533f67fef9b6bb752b6db2780d214
title: Denormalized Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_dataset_denormalized.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataset_denormalized.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: feebaff96d700a5b1f9c294c6c31ef4c2e2324fa9635a751bef97bf1d2265ac5
description: The data in Salesforce objects is normalized, meaning that it’s stored efficiently in a collection of related tables to minimize redundancy, enhance consistency, and ensure data integrity. In contrast, data in datasets is denormalized, where it’s stored in an optimal format for querying. All the work required to combine the data from multiple sources is done ahead of time. The data is centralized, compressed, and ready to be analyzed.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Denormalized Data

The data in Salesforce objects is normalized, meaning that it’s stored efficiently in a collection of related tables to minimize redundancy, enhance consistency, and ensure data integrity. In contrast, data in datasets is denormalized, where it’s stored in an optimal format for querying. All the work required to combine the data from multiple sources is done ahead of time. The data is centralized, compressed, and ready to be analyzed.