Now that you have identified at least one issue, using the guidance from last month’s post. What do you do next?
Identify, Cure, Care
A 3 step process for turning your business data into a valuable and reliable business asset:
- Identifying issues (Part 1 & Part 2)
- Curing those issues reducing the chance of the same issue reoccurring
- Caring for your data to keep it in a certain state to benefit the organisation
Step 1 – Identifying, Part 2
After identifying your issues, it is best to record them. This will help prioritise, if you have discovered many issues or it will display to others what issues have already been detected avoiding any duplication of effort
A useful way to record your identified issues is in Data Quality Issues Register. The register would consist of the following information as a minimum:
- Issue # (providing issues with a numbers helps with identification as your register becomes longer and some issues may be similar or solving one issue creates another. You can refer back to the issue number as part of your description)
- Date Identified (helps understanding how long since an issue was discovered, has anything changed since identification – reorganisation, new system or process)
Status (Open, In progress, on Hold, Closed)
- Description of issue (outline the issue, to allow others viewing the register to understand what the issue is)
- Priority (Low, Medium, High)
- Reported by (name of the person who identified the issue, or stated it was causing a problem)
- Owner (who is working on / responsible for providing updates on the issue)
- Impact of issue on business (which parts of the business are impacted by the data, who creates, uses the data. See previous post on data consumers and
- Systems linked to the issue (these may not be causing the issue, just where the data is used/held)
Additional information could be collected on the respective project that identified or is working on the issue. Related issues or more details on the impact of the issue on the business based on time and finance.
Technology options for your Data Quality Register are Excel or SharePoint.
Once you have created your register and listed your issues, come back next month for what to do with your issues.
Welcome your ideas on what else could be included in a register or technology solutions to host your register.