Skip main navigation

Managing Data Overview

This activity will cover managing data on the Power Platform. Assuring integrity of the data on the platform is crucial, and thus there are many tools

This activity will cover managing data on the Power Platform. Assuring the integrity of the data on the platform is crucial, and thus there are many tools and information available to us.

Sample Data

Dynamics 365 comes with sample data which can be easily added or removed via this feature. The sample data provided is there to help familiarise yourself and others with the features of Dynamics 365.

Duplicate Detection

Dynamics 365 comes with default rules to automatically detect duplicate accounts, contacts, and leads. This can be crucial in avoiding needless double-work, like multiple salespeople contacting the same lead.

Automatic detection for other types of duplicates can be created manually.

Bulk Delete

This feature can be useful for getting rid of stale data, which is no longer useful to the goals or operation of the organisation. It can also be useful when data is imported incorrectly onto Dynamics 365.

Import Data

Importing of existing data is often among the first steps an organisation must take after adopting Dynamics 365. This feature allows for simplified bulk import of data using the import wizard, or more the use of code for more complicated imports.

Export Data

Data can be exported in a range of file formats, and will generally remain the same type that they appear as in Dynamics 365; text will remain as text, time will remain time, and dates will remain date.

For more advanced exports, there is an option to export as an Excel Pivot Table.

Manage Data Storage

The storage capabilities of your organisation are set by your subscription to Dynamics 365. More can be added later if need be, by logging on to the Dynamics 365 Administration Center with Global Admin privilege.

Encrypting Data

Dynamics 365 customer engagement apps use the standard SQL cell-level encryption, is enabled by default to protect sensitive information like passwords, usernames, and contact details. This encryption cannot be turned off.

Join the discussion

At the end of the video, Mark discusses the need to be careful when deleting data off of Common Data Service. Have you or your organisation ever improperly deleted data? What protocols do you have in place to protect from deleting key data accidentally?

Use the discussion section below and let us know your thoughts. Try to respond to at least one other post and once you’re happy with your contribution, click the Mark as complete button to check the step off, then you can move to the next step.

This article is from the free online

Dynamics 365: Implementing Power Platform Integrations

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education