utDataStoR

The utDataStoR package provides a centralized repository of standardized SQL queries and data collections, ensuring that university analysts have access to the same accurate code, while also being user-friendly to facilitate efficient and consistent report generation. Additionally, it enhances security by centralizing data management, facilitates cross-campus initiatives by providing a unified data source for collaborative projects, and plays a crucial role in data governance and supporting the Utah Tech University’s mission by ensuring data integrity and compliance. Its intuitive design makes it easy to use, allowing analysts to quickly adopt and leverage its features without extensive training, and it can also accept recommendations for changes, which must be reviewed and approved by data governance to ensure continued alignment with university standards.

Deliverables

• Comprehensive Vignettes: Detailed guides explaining data points, metrics, and naming conventions to ensure clarity and consistency across all analyses.

• Centralized Repository: A secure and organized housing of standardized SQL queries, providing a reliable source for all data retrieval needs.

• Display Functions: R functions designed to display standardized SQL queries, allowing users to easily review and understand the queries being used.

• Query Generation Functions: R functions that generate standardized SQL queries for end users, streamlining the process of data extraction and ensuring uniformity in data handling.

Installation

You can install the current version of utDataStoR from GitHub with:

install.packages("devtools")

devtools::install_github("ut-effectiveness/utDataStoR", build_vignettes = TRUE)