Use Dynamics 365 Customer Insights - Data preparation in healthcare data solutions

The Dynamics 365 Customer Insights - Data preparation capability in healthcare data solutions connects Dynamics 365 Customer Insights - Data to your Fabric OneLake. You can use this capability to create patient or member lists for outreach. To learn more about the capability and understand how to deploy and configure it, see:

Dynamics 365 Customer Insights - Data preparation has a direct dependency on the healthcare data foundations capability. Ensure you successfully set up and execute the healthcare data foundations pipelines first.

Prerequisites

Run the Customer Insights data pipeline

  1. In your healthcare data solutions environment, open the healthcare#_msft_customer_insights data pipeline.

  2. Select the Run button.

After the pipeline runs successfully, your data becomes available for use in the Customer Insights - Data application.

Set up Customer Insights - Data

After you install and run the Dynamics 365 Customer Insights – Data preparation pipeline, head to your Customer Insights – Data environment for further configuration.

  1. Go to your Customer Insights - Data environment created in the Prerequisites step.

  2. Select Data > Data sources > + Add a data source.

  3. Select the Delta tables data source. Enter the details as instructed in the form.

    Provide the connection details to the Azure Data Lake Storage Gen2 storage account created in Prerequisites.

    A screenshot displaying the delta tables data source setup.

  4. Select Next to see a folder named all_entities. Open the folder to view all the resources available for selection.

  5. Depending on your requirement, select all or some of the entities. To select an entity, select one or more checkboxes under the Include column and specify a Primary key value.

    In the following example, the goal is to create segments around patients and their appointments. So, we select the three related entities and select Id as the primary key for each entity.

    A screenshot displaying a sample entity selection.

  6. After entity selection, select Save and wait for the data source refresh to complete.

After Customer Insights – Data ingests the data, the utilization follows the same process as any other data source. The Patient entity needs to be unified into customer profiles. If you have an alternative patient data source, the application of matching rules ensures the creation of customer profiles from all available sources.

To build a wide range of segments based on the unified patient profiles, you must set up relationships between the tables. To discover all the possible relationships, review the entity relationship diagram in Data capabilities.

Here's an example of a few relationships created from the three entities imported in the example explained in the setup steps:

A screenshot displaying the example table relationships.

Run analytics

With the data appropriately configured, you can use the analytics capabilities within Customer Insights – Data. Here are some of the analytics capabilities that you can use:

  • Enhance unified profiles with predictions, activities, and measures.

  • Create segments for marketing journeys.

    • Create and manage segments (subsets of your customer base) to target promotional campaigns, sales activities, and customer support actions.

      The following example shows a segment of all patients with appointments in the past year.

      A screenshot displaying the sample segment.

    • Segments created in Customer Insights - Data are automatically available in your connected Dynamics 365 Customer Insights – Journeys instance.