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

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

analytic dashboard on laptop screen
Enable Access to Data

Provide access to protected and curated data that is centralized

decorative sbu icon on grid
Integrate Data

Provide an integrated view of institutional activities

team at a long board table
Support Initiatives

Support data needs and analyses for university initiatives

worker at computer
Technical Architecture

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.

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.  

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

Contact


Enterprise Data and Analytics