Associate Vice President, Decision Support and Institutional Research Connecticut State Colleges and Universities Hartford, Connecticut, United States
Session Abstract: One of the key decisions when revamping or building a new data infrastructure is the data architecture. Many IR offices are facing the need to revamp legacy data warehouses or to create new data infrastructure after migration to new source systems (i.e., Workday, Banner SaaS). It is critical that IR professionals get involved in the process and understand key concepts to talk with IT or with consultants to ensure the new data infrastructure fulfills IR’s data needs. This session will cover key concepts and terminology used in data architecture. A brief history of data architecture will include Inmon, Kimball models, and Data Vaults. In this session we will discuss key concepts and differences between databases, DataMarts, data warehouses, data lakes, data lakehouses, and data mesh. Tools for automatization of data warehousing like RED, 3D, and Data Vault Express will be also discussed. No prior background in computer science is needed.
Keywords: data architecture, data warehouse, data infrastructure, Kimball, Data Vault, data lake, data mesh
