Skip to main content

Enterprise Data Services Articles

back
Show titles with any search term.
  • About

    Data Analytics and Reporting

    • Oracle Analytics Server (OAS) is a suite of business intelligence tools that enables reporting and analysis for Cornell's business areas. Dashboards and Answers (ad-hoc) queries are the main tool sets provided.  The OAS Data Visualization feature (DV) provides the additional capabilities of data visualization, data massaging, merging local data with OAS subject areas and reporting directly from local data sets.
    • Reporting and business intelligence (BI) solutions provide ways to analyze an organization's raw data, including analysis and data modeling; querying; and the implementation of...
    • Tableau is one of two high-end reporting tools provided centrally at Cornell. Oracle Analytics Server (OAS) is the other. Typically, Tableau reports are prepared by colleges...
    • Data analytics is the process of examining data sets to make decisions and extract value. The Enterprise Data Services team maintains many university data sets as “digital librarians”. Specific...

    Database Consulting and Support Services

    • 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....
    • Microsoft SQL Server is heavily used by university applications and by some data warehouses. The Enterprise Data Services team can assist with managing SQL Server databases, whether on-...
    • The open source version of MySQL is a good choice for web applications. The Enterprise Data Services team can assist with managing MySQL Server databases, whether on-premise or in AWS unless noted...
    • The Enterprise Data Services team can assist with managing Oracle databases, whether on-premise or in AWS unless noted. Proactive monitoring and alert notifications via Oracle...
    • Open source PostgreSQL is a powerful database with growing capabilities and features. It’s a good candidate to consider as an alternative to Oracle. The Enterprise Data Services team can assist...