Transcript Data Warehouse Powerpoint Slideshow

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
Recruitment
Plus
SPSS
OneCard
Spreadsheets
Survey Data
Data
Warehouse
Cognos BI
Access
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!