The Enterprise Data Warehouse, also known as the EDW, is a centralized analytical database that collects datasets from various systems (Banner, Slate, Blackbaud, etc.) for reporting and business intelligence. Data is organized into groups of tables related to each other by specific business purposes, such as financial aid awards, student academic outcomes, and departmental budget reporting.
✓ Davidson College developers, data analysts, and other employees who have sufficient training and permissions
✓ Enterprise reporting
✓ Data analysis
✓ Power BI
→ The EDW is a complex database built on Microsoft SQL Server. Most basic use cases for the EDW don’t require specific technical skill sets, but advanced applications require a working knowledge of relational databases and familiarity with writing SQL queries.
→ The T&I Data Management team provides technical support for the EDW. Please submit a ticket to firstname.lastname@example.org if you want to request EDW access or have questions about using the EDW for reporting and analytics.
The EDW includes Confidential and Restricted data. As such, access to data within the EDW is governed carefully by adding users to specific database roles, and these roles in turn are granted privileges on certain database objects like tables and views. For example, Davidson’s Planning & Institutional Research office has access to a subset of EDW tables via a role created specifically for that team.
The EDW is a custom-built service of Davidson College for its employees that comes at no charge.