Clean Your Dirty Data and Improve Data Integrity
Now that Spring has arrived, it is an excellent time to clean-up your database. Is your data clean, consistent, and accurate? Almost everyone you talk to would answer this question with an emphatic "NO" for one reason or another. Data is always degrading in any database you review because information is constantly changing. Contacts leave companies, projects progress, and opportunities move through the sales cycle.
Data integrity impacts our ability to determine business trends, success rate, and just know who and what to pursue. Misleading queries and inaccurate reports result in making wrong decisions when data is incomplete or incorrect. With an integrated ERP system everyone can help with the clean-up, but on the other hand they can sometimes add to the mess. So what do you need to keep in mind when tackling data clean-up?
Clean your dirty data by evaluating these four areas: decision points, standardization, automated clean-up, and dedicated resources. Let’s walk through an example and apply each of these four areas to project data.
- Step 1 – Decision Points: It is helpful to start by doing a search criteria to help make a decision. First, determine what fields need to be cleaned-up and what fields need to be evaluated so you can narrow down the list. Maybe we want to update the project status to determine if it should be dormant, inactive, or active. Our first criteria could be to search all projects that are active to see how many we need to evaluate. Then we need to narrow the search. Depending on what information you can search, you could do a search on when the project was opened and/or if time has been billed in the past two months. Understanding your decision points narrows down the list and reduces the number of projects that need to be evaluated.
- Step 2 – Standardization: Sometimes during the clean-up you realize there are fields or options that are not really needed. This is a great time to establish or re-establish corporate standards and expectations. Is everyone using the same definition? In our example, are you finding employees that are using inactive instead of dormant? Adding tool tips can provide a definition to help users know how to update the field.
- Step 3 – Automated Clean-up: Now that you have gone through the exercise of cleaning up the information. Think about how you can update the information periodically or better yet provide an alert to you or employees when they should update the information. Is there a specific timeframe that the status should be evaluated? Workflows can help keep the data accurate. By identifying a trigger, a workflow could alert someone to review the information or even update the status to dormant based on lack of activity.
- Step 4 – Dedicated Resources: As the saying goes, the information is only as good as the data on which is based. So dedicate the necessary resources to clean it up and better yet, maintain the data. Setting up a quality control schedule and setting expectations helps keep the data clean and manageable.
Does your firm have dirty data? For a fresh clean feeling, take the time to establish your firm’s process to clean it up! By following these four steps, your firm will improve data integrity.



In this situation, I observed people giving advice as opposed to just sharing experiences. I found it curious that contributors to the forum assumed many of the variables the person inquiring had not provided and further, the person making the inquiry hoped to find solutions without providing any background or specifics. 





Anyone that knows me, knows I love music and sing karaoke. I was learning one of Adele’s songs and listening to the lyrics: “Should I just keep chasing pavements, even if it leads nowhere?” I started thinking about the things we chase in our own life that lead nowhere. Even though this song by Adele is referring to love, it really can apply to pursuing business or ways to grow business. Does your firm have a way to analyze if the business you chase is leading anywhere? Better yet, do you know what efforts are paying off? Below are things to consider when evaluating the effectiveness of your business building strategies:

Full Sail's Director of Marketing and Business Development,
Did you know you can enter your time into Deltek Vision from your iPhone or iPad? I don’t know anyone that gets excited about filling in their timesheet, but the Deltek Vision Timesheet app allows me the ability to access my timesheet no matter where I am. For users that travel or are away from the office, it allows a convenient method to update your time on the fly. Sorry, no more excuses for those on the road.
