Enterprise Data Warehouse Overview

SC_SummaryOverview.png
SUMMARY

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.

 

SC_Availability.png

AVAILABILITY

✓ Davidson College developers, data analysts, and other employees who have sufficient training and permissions


SC_DesignedFor.png

 

DESIGNED FOR

✓ Enterprise reporting

✓ Data analysis

✓ Power BI

 

SC_Support.png

SUPPORT

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 ti@davidson.edu if you want to request EDW access or have questions about using the EDW for reporting and analytics.

 

SC_DataSecurity.png

DATA SECURITY

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.

 

SC_Rates.png

RATES

The EDW is a custom-built service of Davidson College for its employees that comes at no charge.

 

Request Help