김 민석 DBA(Database Architecture)

Some companies are reluctant to display all of their customer information on the screen.

This is because there is a risk that customer information such as credit card numbers, resident registration numbers, and mobile phone numbers may be leaked.

Some of the Dynamics products offer field encryption.

However, Customer Insights does not provide field encryption.

When exporting customer profiles from Customer Insights to the campaign system, I want to export only some of the customer profile information.

Exporting all customer profile information seems inefficient.

This is because a lot of information that is not necessary for the campaign is delivered.

I want users to be able to select and export only the information they need for their campaign.

When uploading data through Power Query, it is inconvenient because there is a capacity limit.

When there is a lot of data required for customer analysis and segment classification, only some of them have to be uploaded.

And, when you change the field name in Power Query, I want the change to that field to be changed in all items.

For example, when the name of Customer_Grade is changed to Cust_Grade, it would be good if it was changed at the same time where Customer_Grade is used (Activity, Segment, etc.).

When integrating customer information, we integrate customers with some conditions.

It would be nice to have a screen where you can check the conditions under which we integrated and how many customers were integrated at once.