# CRM Data Vault Model

**URL:** https://forum.data-community.org/t/crm-data-vault-model/1033
**Category:** Data Vault 2.0
**Created:** [November 2, 2023, 5:42pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033 "2023-11-02T17:42:42Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Swaminathan](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/swaminathan/32/236_2.png) [@Swaminathan](https://forum.data-community.org/u/Swaminathan)
#### Post date: [November 2, 2023, 5:42pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/1 "2023-11-02T17:42:42Z")

</div>

Hello all  
Have been searching for sample data vault model on CRM. Similar kind of implementation is required in one of the projects. But I could not find anything useful.  
Could you please point me to some links ?

Thanks.  
Swaminathan

---

<div class="post-metadata">

### Author: ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)
#### Post date: [November 2, 2023, 9:45pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/2 "2023-11-02T21:45:58Z")

</div>

have a look at the salesforce [dm](https://developer.salesforce.com/docs/atlas.en-us.246.0.object_reference.meta/object_reference/sforce_api_objects_list.htm) instead — use that as a base to understand your DV direction but of course include a SME in your travels

---

<div class="post-metadata">

### Author: ![bmccartney](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/bmccartney/32/43_2.png) [@bmccartney](https://forum.data-community.org/u/bmccartney)
#### Post date: [November 4, 2023, 3:25pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/3 "2023-11-04T15:25:04Z")

</div>

> [@Swaminathan](#):
>
> Swaminathan

Hi Swaminathan,  
I am wondering what is the intention of your data vault. There are lots of sample data models available online, my friend David Hay has a great book [https://www.amazon.ca/Enterprise-Model-Patterns-Describing-Version/dp/1935504053](https://www.amazon.ca/Enterprise-Model-Patterns-Describing-Version/dp/1935504053) on re-using patterns for modelling data. I have used these in the past to get some conversations started. John Giles also gives some great examples of using patters in his Elephant series. What I recommend is usually having a conversation with your business leadership to determine the intentions and conceptual model of “CRM” - as there are many, many ways to accomplish CRM. Looking for what data you have (are you using Salesforce for example can go a long way to informing your data vault model. It is about your business concepts and the data that you have/need.

Hope that helps.

Bruce

---

<div class="post-metadata">

### Author: ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)
#### Post date: [November 5, 2023, 9:24pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/4 "2023-11-05T21:24:19Z")

</div>

I have a copy of David Hay’s book — it’s good

---

<div class="post-metadata">

### Author: ![bmccartney](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/bmccartney/32/43_2.png) [@bmccartney](https://forum.data-community.org/u/bmccartney)
#### Post date: [November 6, 2023, 3:15pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/5 "2023-11-06T15:15:06Z")

</div>

Agreed, I have 3 books of his, triggered by John Giles Elephant discussions 😀. David gave a keynote presentation last Friday at DAMA Canada (I did one as well) and he has a wealth of experience!

Cheers

---

<div class="post-metadata">

### Author: ![Swaminathan](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/swaminathan/32/236_2.png) [@Swaminathan](https://forum.data-community.org/u/Swaminathan)
#### Post date: [November 7, 2023, 9:13am UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/6 "2023-11-07T09:13:28Z")

</div>

Thanks @bmccartney.

We were given a task to come up with the data vault model for customer 360. Rather than coming up a design on our own, we thought of having a look at some of the design already available, so that it would help us to come up with a proper design.

I will check the book which you have referred.

Thanks again.

---

<div class="post-metadata">

### Author: ![charles](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@charles](https://forum.data-community.org/u/charles)
#### Post date: [January 12, 2024, 3:04pm UTC](https://forum.data-community.org/t/crm-data-vault-model/1033/7 "2024-01-12T15:04:01Z")

</div>

Creating a Data Vault model for a CRM system involves designing a data warehouse that can handle the complexities of CRM data, including customer interactions, sales, marketing, and support activities. Familiarize yourself with the principles of Data Vault modeling. Dan Linstedt’s book, “Building a Scalable Data Warehouse with Data Vault 2.0,” is a comprehensive resource on Data Vault modeling. Look into industry standards and best practices for CRM data modeling. Organizations such as DAMA (Data Management Association) may provide guidelines and best practices.
