Loading...

Dynamics 365 Customer Insights unification single dataset

Dynamics 365 Customer Insights unification single dataset
Dynamics 365 Customer Insights unification single dataset Marion Vertessen Tue, 07/12/2022 - 09:24
Body

Dynamics 365 Customer Insights unification single dataset

Dynamics 365 Customer Insights is a Customer Data Platform (CDP) developed by Microsoft. Its main objective is to create unified customer profiles with data in different silos. 

For instance, you have data in a CRM for your point of sales and in an e-commerce platform for your online sales. With Dynamics 365 Customer Insights, you can merge the two datasets to identify if an e-commerce customer is also a point of sales customer. 

This tool is potent, but specific applications have yet to appear. If you only have a single dataset, you cannot proceed with the unification phase. This capability will be soon available thanks to Microsoft teams . But now, we can create a customer profile only by ingesting two datasets.

Dynamics 365 Customer Insights unification single dataset

This article explains how to create these customer profiles with a single dataset. More precisely, we will ingest the dataset twice and proceed to unify these two datasets.

Data sources

Dataset 

In this article, we use an open-source datase, in Kaggle: https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce

This customer dataset,provided by Olist , is the largest department store in Brazilian marketplaces. 

With the link, you can either download the Olist customers or can use your dataset.

 

Data ingestion

First, we will ingest the dataset twice in Dynamics 365 Customer Insights with the Microsoft Power Query option. Of course, you can use another method if your data is more suitable however, here, we focus on the power query option. 

Dynamics 365 Customer Insights unification single dataset

It is essential to give a different name to the two imported dataset, even if they are identical. For instance:

  • 'OlistCustomers' for the principal dataset
  • 'OlistCustomersGhost' for the second one

With these names, you identify more easily the role of each. When you proceed with the transformation step, you must be careful to make the same changes in the two datasets.

For more information about data ingestion in Dynamics 365 Customer Insights with a power query connection, you can refer to the Microsoft doc : https://docs.microsoft.com/en-us/dynamics365/customer-insights/connect-power-query

 

Data transformation

This phase permits the creation of unified customer profiles.

Map

First, you must choose the two entities and include the fields you want. 

Then, you have to select a primary key for the two datasets. You have to select the same key for the two datasets !

Dynamics 365 Customer Insights unification single dataset

Select Save

Match

In this step, we create rules to proceed customer profiles. First, you must select the two entities and include all the records

Dynamics 365 Customer Insights unification single dataset

 

Dynamics 365 Customer Insights unification single dataset

Add rules and use a condition in 'customer_id' with exact precision.

Dynamics 365 Customer Insights unification single dataset

Save and run this step. 

Merge

Here, you can select the order of custom fields. 

Select Save and 'Run merge and downstream processes'.

Conclusion

That's it ! The customer profiles will be created with only one dataset but it may take some times. You can follow the progress of the loading in : System > Admin. 

Dynamics 365 Customer Insights unification single dataset

Image
/sites/default/files/2022-07/Dynamics%20365%20Customer%20Insights%20How%20to%20use%20a%20single%20dataset_0.png

Published on:

Learn more
Featured Articles | Dynamics Chronicles
Featured Articles | Dynamics Chronicles

Welcome to our blog, the content is entirely dedicated to Microsoft Dynamics 365, CRM, Power Platform, Common Data Service (CDS) but also Azure. Follow us !

Share post:

Related posts

Why Plugin Depth Matters in Dynamics CRM

Plugin development in Dynamics CRM is one of the most advanced and intricate components, requiring deep expertise in the platform's event pipe...

11 days ago

Debunking: Dynamics CRM Destination – How Text Lookup Works

When we want to push data to Dataverse/Dynamics CRM using SSIS – KingswaySoft, usually there are relationships (lookup) that we need to ...

1 month ago

Understanding Activity Party Types in Dynamics 365 CE

Dynamics 365 Customer Engagement features 11 unique activity party types, identified by specific integer values in the ActivityParty.Participa...

1 month ago

Debunking: KingswaySoft Dynamics CRM Source- Output Timezone

Hi! I’m back after so a long hiatus (probably I’ll write the reason for this later 🤣). As [lazy] Developers, we’re most lik...

1 month ago

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

This article explains how to create and configure a Shared Mailbox in Microsoft 365 for sending emails to users in Dynamics 365 CE. It details...

1 month ago

Enhancing Knowledge Retrieval with Microsoft Copilot Agents in Dynamics CRM and SharePoint

Studies show that 70% of employees spend unnecessary time searching for information across multiple systems, leading to productivity losses an...

4 months ago

{How to} become MCT Microsoft Certified Trainer on Microsoft Dynamics 365 Customer Engagement step by step instructions

Hello Everyone,Today i am going to share guidelines on becoming Microsoft Certified Trainer on Microsoft Dynamics 365 Customer Engagement or P...

5 months ago

Default Value vs. Current Value in Dynamics 365 CE: Key Differences

In Dynamics 365 CE (Customer Engagement), environment variables are used to manage configuration settings for solutions. When dealing with env...

5 months ago

How to Write and Understand a Dynamics CRM Plugin

 Here’s a sample plugin code in Dynamics CRM written in C#, along with a detailed explanation of each line. This plugin will update the "...

6 months ago

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Got the below error while importing Dynamics CRM Solution via Azure DevOps Pipeline. 2024-12-18T23:14:20.4630775Z ]2024-12-18T23:14:20.74...

6 months ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy