Skip to main content

Data Architecture and Analytics

We provide services to the Cornell data community for:

  • Data Analytics and Business Intelligence
  • Data Integration and API Management
  • Database Consulting and Support Services

We work with data stored in a variety of formats, including MySQL, Microsoft SQL Server, PostGreSQL, and Oracle. 

We can help you engage better with the university's enterprise systems, including PeopleSoft, KFS, Workday and many others through commission of a data warehouse, cloudification support, or data analysis. 

Data Analytics and Business Intelligence

We can help solve your business needs with a range of services including data modeling, automated data refreshes, and business intelligence solutions. We also offer planning, development, and creation of standard reports, ranging from one-off to run-on-demand data analytics solutions that leverage big data tools.

Data Analytics

Our Data Analytics services can assist you with examining your data sets to make more informed decisions and extract increased value. We maintain many university data sets and can help with yours in formats including MySQL, MS SQL Server, PostgreSQL, and Oracle.

In addition to the benefits of centralized enterprise storage, we can support your data analytics by helping extract and package data sets, join data sets and prepare dimensional models to assist with reporting, create Hadoop clusters in Amazon Web Services (AWS), and use tools like Hive and Spark to process large data sets without traditional data modeling.

Learn more about Data Analytics services.

Business Intelligence

We support two business intelligence tools centrally

  • OBIEE (Oracle Business Intelligence Enterprise Edition)
  • Tableau

In general, OBIEE dashboards and reports are prepared by ODAA and Tableau reports are prepared by colleges and units. However, there are some exceptions in either direction, and training is available for colleges and units who would like to work with OBIEE. We can work with you to set up the best BI solution to meet your needs.

Learn more about Business Intelligence services.

Data Integration and API Management

Data integration programmatically moves data between and across systems, often using batch or overnight processes.

APIs are a means to transfer and retrieve specific and usually limited data sets. Many APIs are in use across campus but are often very specific and not shareable.
ODAA’s API management services will create and maintain a library of standard APIs that can be leveraged across campus.

The value of your data multiplies when it's connected with other sources of information or campus systems. We can help you:

  • Unlock the potential of the data you maintain.
  • Get discrete systems speaking to each other.
  • Pool your knowledge with your campus peers.
  • Make the most of vendor services by tapping API features.

Database Consulting and Support Services

In collaboration with the Cloudification service and CIT Infrastructure, we offer Database Consulting and Support Services.

This service provides a full spectrum of support, from consulting to full turnkey, for several different databases including Oracle, Microsoft SQL Server, MySQL and PostgreSQL (check back as others are added). The service supports on premise databases, the transition of databases to Amazon Web Services and the implementation of new databases in AWS.

In each of these circumstances, the ODAA team can support the four fundamental requirements of database management – backup, recovery, monitoring and performance tuning. The ODAA database team’s consulting includes recommending a database technology based on user needs and recommending options and setting up configurations for AWS non-Production and Production environments. The ODAA team is largely interchangable meaning that support is not tied to any one individual but is shared across many including 24×7 on-call when warranted.

For more information, see the pages for:

  


Service Details

Audience(s):

Regulated Data:

Not applicable or information not available.

Database and Middleware

The Managed Database service can be thought of as two separate services, one being database consulting or cloudification support and the other being database hosting in the cloud. Database consulting includes helping you in all aspects of supporting your own database. Examples of consulting activity include architecture and design recommendations; performance tuning; recommendations for high availability; recommendations for disaster recovery and backups. The database hosting in the cloud service delivers an application or warehouse environment where the middleware team manages the cloud provider and its services on behalf of the customer.

Data Warehousing

Data warehousing broadly includes building a data mart (DM); building or the use of existing tools within the DM; DM tuning; and the extract, transform and load of data to the data warehouse. Detailed descriptions of these processes are described below.

Business Intelligence

Business Intelligence is the analysis of an organizations raw data, including analysis and data modeling; querying; and the implementation of reports and dashboards. The Business intelligence team works closely with the data warehouse team to provide integrated solutions that are accurate and highly available.

Was this page helpful?

Your feedback helps improve the site.

Comments?