Seven things you should know about Carleton’s data warehouse:
- The data warehouse is available to anyone at Carleton who works with Carleton data.
- The data warehouse is designed for analytical reporting. In contrast to typical row-and-column reports, analytical reports highlight trends over time and aggregate patterns in data, and thus help us to make data-driven, strategic decisions.
- The data warehouse is fast. It has been optimized for analysis of large amounts of data so that you can readily explore theories, and look at results.
- The data warehouse draws data from other systems on campus, like Colleague, but is not the authoritative source of any data.
- The data warehouse will work with a variety of data manipulation tools, such as Excel, Tableau, SPSS and R.
- The data warehouse has a new visualization tool option available: Power BI. We currently have licenses for faculty to view data warehouse reports via Power BI. The new faculty grade reports are being delivered to faculty in this fashion.
- The data warehouse is something that you can get training for by contacting Richard Goerwitz at rgoerwit@carleton.edu
Sample of a Power BI dashboard that interacts with the data warehouse: