Skip to main content

Data Architecture and Analytics

Office of Data Architecture and Analysis

Data architecture and analysis activities include new project implementation, custom development on a charge back basis, and operations and support of existing solutions. The Office of Data Architecture and Analysis (ODAA) can help at any point within a project in the areas of database and middlewaredata warehousing and business intelligence.

The Office of Data Architecture and Analysis (ODAA) is a unit within CIT Information Systems, and facilitates regular meetings of campus and central data analysts and reporters in an effort to share knowledge of existing systems and solutions. ODAA assists Cornell departments in the areas of business intelligence, application middleware, and data warehousing.

Data architecture and analytics offers resources that can help you engage better with enterprise systems, such as PeopleSoft, KFS, WorkDay and many others. This can involve building a data warehouse; cloudification support; or analyzing data from these systems in different ways.

For questions or project inquiries on data architecture and analysis please contact: ODAA-Questions@cornell.edu

Administrative data is a valuable asset of the university. The administrative data store effort is a way to begin to leverage this value by understanding where data is and how it’s used. The Data Analysts and Reporters SIG will use this information to identify common data needs that ODAA will work to fulfill.

ODAA plans to create a university data hub where authorized users can access data using standard APIs and/or calls to data integration tools (e.g. Boomi). Initially, the university data hub will consist of elements like CU Person with others added as common data needs are satisfied.


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?