Welcome to the Carleton Data Warehouse

The Carleton Data Warehouse is a collection of data gatherCDW logo 2ed from various systems of record on campus and transformed so that it can be easily mined, analyzed, and reported on—enhancing our ability to understand ourselves, plan, and make decisions.  The data warehouse also has the advantage of bringing data together in one central spot, making it easier for us to report across multiple, separate data sources.

For an overview of what's in the data warehouse, see the "what's there" catalog; for help, go here.

For more information on the structure and design of the data warehouse, as well as information on accessing it, see Using the Data Warehouse

The Carleton Data Warehouse complements (but does not replace!) existing transactional systems on campus like Advance, Slate, Colleague, CS Gold, EMS, Web Help Desk, K2, and PaperCut, which are designed to support various day-to-day activities on campus, and which themselves offer a wide array of data entry, extraction, and reporting options.

Data Warehouse project status:

Subject areas currently in production include (not an exhaustive list): Admissions Yields and General Stats, Financial Aid, Position Management, Faculty Information, Academic Records, Enrollment, Faculty Workloads, Room Usage and General Space Management, Energy (Wind Turbine) Information, Financial Analysis and Budgeting; Alumni Demographics, Grants, and Employment; Giving, Printing, and Lab Computer Utilization.

Subject area(s) in development include (this list changes frequently):  Career Center Event Participation.  We are also currently revamping Admissions data.

Who to contact and for what:

  • In general, contact the Helpdesk (x5999) or Richard Goerwitz (x5526) with data warehouse questions; take a look also at the FAQ
  • For information or documentation on specific data items in the data warehouse, see the data dictionary
  • To request access, call the ITS Helpdesk and ask them to create a data warehouse access request ticket (type Software > Data Warehouse > Access Request)

Please note that all requests for data access will be handled in accordance with Carleton College's Data Management Policy.