When data are used consistently, the data are used in a standardized and documented way over time, and across all units of the University, especially to be explainable, fair, accurate, and replicable.
Data consistency can be achieved by standardizing an approach to documenting reports, analytics, and statistics to ensure data can be replicated and explained. That is, when doing something such as analyzing or querying data, the formulas are documented and understandable. If there are discrepancies in data, ensure that individuals are able to explain why things are different.
Here are some tricks and tips to help you use data consistently:
- Ensure data systems being utilized are up-to-date and producing correct data.
- Document data systems being utilized and reason for utilizing these systems.
- Document any filters utilized in the data, including filters for dates/snapshots.
- Document each calculation made to the data or data variables and why.
- Document any joins done to the data and how they were defined.
- Document criteria for including and excluding variables or records in the data.
- Follow style guides and standards, as available, for the output of data.
- Define the data variables in the data. Ensure they are either vetted or will go through a vetting process prior to being published if not previously vetted.
- Document and describe how often data will be refreshed, which variables are or are not refreshed within the data, and how and how often data are vetted.
- Describe who the audience for the data are and who is allowed to have access.
- Define and explain any differences in the data if they are being counted in a new or distinctive way.
Read more about using data consistently in the Data Usage Guidelines report.