Enterprise Data & Analytics
Enterprise Data & Analytics (EDA) supports Stony Brook University reporting and analytics tools to access information about finance, budget, academics, research, rankings, retention, faculty & staff and more
EDA Mission
Goals
Provide access to protected and curated data that is centralized
Provide an integrated view of institutional activities
Support data needs and analyses for university initiatives
Develop technologies to support data consistency, integrity, 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.
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.
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.
The EDA Team
Kim Berlin, Director of Enterprise Data & Analytics
Syed Hasnain, Assistant Director of Enterprise Data & Analytics
Andy (Yingwu) Wang, Senior Systems Engineer
Augustine Rodriguez, Senior Systems Engineer
Geng Liu, Senior Systems Engineer
Cesar Sanchez, Senior Systems Engineer