The goal is to determine potential areas where structure is causing challenges in system functionality due to inconsistency, redundancy, incorrect use or underutilization. Often these issues, in concert with a need for staff training and process refinement, cause an organization undue strain.
- Review all codes and tables
- Evaluate 50-80 Data Load Points
- Examine detailed data management history
- Interview staff on success and challenges (in person or remotely)
- Dissect select pain points based on preliminary review and staff insights
- Generate and analyze proprietary Code Prevalence of Use Reports
- Deliver written report with discussion of Data Load Points, summary of issues found and recommendations for corrections
- Meet with staff to discuss findings and consider appropriate next steps
You have to know your position to know your direction. The Database Audit provides you with confirmation of your current position and a map to greener pastures.
Consider a Database Audit if...
- You are new to an organization and just don’t know into what you’ve stepped
- Staff continue to deliver inconsistent data and reports
- Processes seem to take too long
- You are preparing for a capital campaign
- Leadership is considering a merger or acquisition
- Relationships with peer departments are strained due to information exchange challenges
(not because Phil’s blueberry muffins beat out Mary’s at the company picnic. Phil is a poor winner, and he has had t-shirts made.)