EDA Mission
EDA Mission
To support and provide access to consistent, well-understood, and secured institutional data using best-in-class technologies for reporting, analytics, and self-service insight and discovery tools
Goals
Enable Access to Data
Provide access to protected and curated data that is centralized
Integrate Data
Provide an integrated view of institutional activities
Support Initiatives
Support Technical Architecture
Develop technologies that support data consistency, integrity and the capacity for growth and integration
Reporting and Analytics Tools
Enterprise Data & Analytics in the Division of Information Technology supports reporting and analytics tools to access and analyze SBU data on finance, budget, human resources and academic reports including enrollment, registrations, student financials, scheduling, and instruction.
Both require your Stony Brook NetID and Single Sign-On (SSO) access.
SBU Reporting
Provides access to detailed and flat lists suitable for exporting to Excel. There are also specialized reporting for tuition sharing, all funds financials, class capacity and other analyses.
Stony Brook Analytics
Developed using Tableau to provide high-level dashboards, visualizations, trends and university rankings.
The Data Warehouse
Enterprise Data & Analytics provides technical expertise in the development of the university enterprise data warehouse. The data warehouse models and centralizes data from multiple systems including PeopleSoft Financials, Campus Budget Module (CBM), Campus Solutions (CS), and Human Capital Management (HCM), as well as other university systems.
Adding strategic value
The data warehouse does more than just store data, it provides added strategic value in many ways to serve the analytical data needs of the institution
- The data warehouse provides an enhanced and optimized representation of data through the creation of derived fields and calculations
- Data models are designed along common attributes to enable integrations and bridge data across functional areas
- Organizational structures, such as chart of accounts, and complex business rules for derived fields are built in
Technical facts
- The data warehouse provides access to 25+ years of historic data
- It stores current and historic “frozen” snapshots curated for official reporting and trends
- Data models are refreshed nightly through automated processes
- Access to the data warehouse data is restricted and requires a legitimate educational or institutional purpose. Access to these data systems is managed with Single Sign-On (SSO) using your SBU NetID
Data Confidentiality
Stony Brook University is strongly committed to protecting personal information against unauthorized access, use, or disclosure. Access to sensitive data requires your commitment to handling the data responsibly.
Access to student records data is restricted and protected under the Family Education Rights & Privacy Act (FERPA). It is made available to appropriate campus officials only after required authorization is received by the Registrar's Office. Student information must not be transmitted by any University employee to anyone outside the University without the express written release by the student or pursuant to a lawfully subpoena/order, coordinated by the Office of University Counsel.
Relevant Resources
Stony Brook University Data Privacy
Stony Brook University Policies
The EDA Team
Kim Berlin, Director of Enterprise Data & Analytics
Syed Hasnain, Technical lead and Senior Systems Engineer
Andy (Yingwu) Wang, Senior Systems Engineer
Augustine Rodriguez, Senior Systems Engineer
Geng Liu, Senior Systems Engineer
Cesar Sanchez, Senior Systems Engineer
Contact us: doit_eda@stonybrook.edu