We will demonstrate how we use Data Vault 2.0 at a university level to meet the requirements of a rapidly changing community. The North Carolina Data Dashboard is a student-lead project which hosts a wide variety of county-level and industry-by-county-level data for the region, informing users with easily digestible data displays of economic indicators. Data Vault 2.0 has created opportunities for expansive scalability in this project. We began by hosting data only for Western North Carolina, but have steadily grown to hosting data, such as labor markets, product markets, real estate and workforce demographics for the entire state. The Data Vault 2.0 Framework was critical in allowing us to implement new data series with only minor modifications. Because of this, we are now capable of scaling our databases to house nationwide economic data with relative ease.
Data Vault 2.0 was further pivotal in helping us solve a problem with a high turnover rate as students continuously join and leave the project upon graduation. New students with little database design experience are able to grasp our model due to the simplicity of the three basic structures. Furthermore, Data Vault 2.0 Methodology structures our User Guide so that our model has higher probability to mature. The process of updating and obtaining new data series is agile for new students because of the architecture. This data is then moved to our persistent-storage database where it is organized into hub, link, and satellite elements. Views are then created from these elements to form our access layer. The structure of the access area allows for the formation of views that fit the needs of Tableau. It also allows for future capability such as the support to directly connect to an in-house Tableau Server. Overall, Data
• How to implement the Data Vault 2.0 Model into a university/student-led environment.
• How to extend into new data sources with the Data Vault 2.0 Architecture.
• How Data Vault 2.0 can be used to overcome short time frames in a rapidly-changing community.
• How to use Data Vault 2.0 to tell a story.