1. Science / Technology

10 steps to data profiling for successful data discovery: Part II

Disclaimer: This is a user generated content submitted by a member of the WriteUpCafe Community. The views and writings here reflect that of the author and not of WriteUpCafe. If you have any complaints regarding this post kindly report it to us.


In this article, we continue to the previous Part I – 10 steps to data profiling.

Step 1

Ensure that the data selected for profiling meets the regulatory threshold. To achieve this, it is important to understand the regulations governing the target data. In some cases, organizations that own the data may not have the users permission to freely use the data generated from their interaction with the organization. In today’s age where massive data is being generated online due to innovation in the eCommerce and social media industries; many governments have passed laws aimed at protecting their citizen’s data from being commercially used to exploit them. Many companies have had hefty fines imposed on them by regulators for violating these rules in their data analysis endeavor.

Remember, different data is governed by different regulations in different jurisdictions. For a business operating in several jurisdictions, they have to meet the regulations set in each jurisdiction to avoid hefty fines or possible lawsuits. To achieve a smooth data profiling process, the analyst has to harmonize the data to all meet the regulations while still remaining useful to the analysis process. Lack of harmonization can lead to incomplete data sets being available for the next step of the analysis plan. An organization should involve the legal department or someone who is familiar with the jurisdiction laws while deciding which data will be made available to the analyst. The analyst and the legal team should be in agreement on how the affected data will be accessed and utilized.

Step 2

Ensure that the target data meet privacy regulations. Consult the organization to get a list of the data they collect and the privacy requirements of that data. For instance, medical records are private in most countries, and allowing access to them can lead to a gross violation of the patient’s privacy. The analyst in this case should only request for medical findings and general patients’ details such as gender and payment method used. In the recent past, many people have successfully sued companies for violation of their privacy rights while handling the consumers’ data.

A thorough analysis of the privacy data that is going to be used and how it is going to be used should be undertaken at this stage. Any potential violations should be addressed this early before they become a legal problem for the organizations. An analyst must exercise restraint in selecting the depth of the data that they wish to use to do their analysis. While private data can significantly enrich an analysis report, it can damage the organization’s integrity in the eyes of the partners and clients. Steps to data profiling that can be taken by an analyst in order to gain important information while still protecting the privacy of personal data:

De Identification: This is the stripping of personal data that could identify an individual from the data sets being targeted.

User Access Control: This is to ensure that only authorized personnel can access with reason data that can be used to identify a person.

Step 3

Ensure that the source data identified will be available on request. Ensure that all the data identified will be available to the analyst during the data profiling stage. Any data that cannot be continuously available should be given priority to maximize the value derived from the data. Alternatively, an analyst can come up with a schedule so as to be granted access only during the time they will need the data. Remember, the data profiling plan will be heavily reliant on successful access of the target data.

Missing data or altered data is a common problem when the data analyst and the data management team fail to continually coordinate during the data analysis process. An analyst should communicate with the data management team about the data sources they have chosen when they’ll need them, and for how long. Failure to do this can lead to useful data being archived or deleted after the analyst has already identified it as source data.

Step 4

Ensure that the source data is in a usable format. Ensure that the source data files are in formats that can be used during the data profiling stage. Corrupt files or files that are not usable but are necessary should be identified so as to get repaired or for the analyst to identify another source of the same data. After identifying all the source data that will be needed, an analyst should finally ensure that the data is a usable format.

In the case of AI driven platforms such as DQLabs.ai, this is not a major hundle as it can accommodate data in countless formats. In traditional data analytics, the data format had to be changed to match the format of other data sets. This modern analytics system will also highlight the corrupt files for the analyst and recommend actions that will enrich the quality of the data.

Step 5

Create a data profiling plan. This is a plan that ensures that the data profiling process follows a logical order so as to gain the most insight into the target data. A data profiling plan borrows heavily from the priorities set on ‘step 5’ and ensures that the analyst keeps regulatory requirements in mind. The data profiling plan should take into consideration how the data being profiled was generated. For Instance, customer data entered manually is more likely to have erroneous entries and thus is likely to consume more time. By understanding how the data was generated, the analyst will have an idea of the type of errors and the quality of data they are profiling.


Before embarking on the data profiling exercise, it is important for an analyst to prepare by going through the data profiling steps listed above. This will ensure that the data that they know all the data to use, where to get it, the State it is in, and the rules governing the data. With all this in mind, an effective data profiling plan will guide the analyst to maximize the outcome of the data profiling stage. Successful data discovery will rely heavily on all the above data profiling steps, taken to prepare for an effective profiling plan. An analyst should also understand how the data selected as source data was corrected so as to know what to look for during the profiling stage.

DQLabs platform has a data profiling platform that is AI-driven and accepts data from multiple sources in different formats if necessary. The user interface is user-friendly and will allow the user to track the data profiling process and make adjustments where they feel it’s necessary. The platform algorithms will detect deep insight into the source data and increase the quality of the profiled data.


Welcome to WriteUpCafe Community

Join our community to engage with fellow bloggers and increase the visibility of your blog.
Join WriteUpCafe