Carleton’s Data Warehouse

Carleton’s Data Warehouse Shedding light on our information

What is a data warehouse? A data warehouse is a system that • Gathers data from many systems • Combines it into one database • Conforms it to common standards • Restructures it for easy • Exploration • Reporting • Data mining

Flow of Data Colleague Advance Excel Report Data Warehouse SPSS Recruitment Plus Cognos BI OneCard Spreadsheets Access Survey Data

Example

Project 1 Components Data warehousing implementation projects break down into a set of basic components that are common across nearly all deployments in all institutions

Components Major project components: • Project kickoff and planning • Initial business requirements analysis • Decide on first project • Purchase and installation of back-end technologies • Development of ongoing data catalog, data policy • Modeling of initial data marts • Development of initial ETL processes • Development of initial reports • Delivery of initial data marts, reports, documentation • Training

In Practice… Data Warehouse Service • Project 1, includes DW infrastructure • Project 2 • Project 3 • Enhancements to Project 1 • Project 4

Sample Data Catalog Fields: data name, category, source, source table, source column, DW table, DW column, description, data stewards, access restrictions, update frequency, Meaning/Usage, data type, data range.

Sample Data Access Policy

Staffing and Resources Richard & Julie, ITS Administrative Computing Advisory Committee DW Data Management Group? TPPC Existing User Groups

Next Steps • We will schedule interviews with you over the next few weeks • We will send you sample interview questions ahead of time • We might also ask you for sample reports • We will take the information you give us, combine it with information from other offices, and form a master ‘Needs Analysis’ document.

Questions? Ha! Now they’ll have to add a “planet” field to the data catalog!

Carleton’s Data Warehouse