Skip to main content

Data Architecture and Analytics Articles

back
Show titles with any search term.
  • Data Analytics and Business Intelligence

    • 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....
    • ODAA has formed data analysts and reporters SIG. Data analyst refers to unit staff, usually technical, who use university data to create local data solutions. Reporters refer to unit staff,...
    • Data Analytics is the process of examining data sets to make decisions and extract value. ODAA maintains many university data sets as “digital librarians”. Specific data access is requested of and...
    • Oracle Business Intelligence Enterprise Edition is the university’s enterprise reporting tool, providing the ability to develop and securely deploy interactive dashboards based on simple to...
    • Tableau is easy-to-use business intelligence software used for data analysis and data visualization. It has a simple drag and drop interface for building queries and allows the user to write...

    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. Here are some of the services ODAA can provide to manage and support SQL Server databases, same for on...
    • The open source version of MySQL is a good choice for web applications. Here are some of the services ODAA can provide to manage and support SQL Server databases, same for on premise or AWS unless...
    • ODAA can provide support to manage and support Oracle databases, whether on premise or AWS, unless noted. Proactive monitoring and alert notifications via Oracle Enterprise Manager...
    • Open source PostgreSQL is a powerful database with growing capabilities and features. It’s a good candidate to consider as an alternative to Oracle. Here are some of the services ODAA can provide...

    Examples

    • Administrative data exists in many locations (stores) throughout the university. In an effort to understand the myriad of administrative data stores, the Office of Data Architecture and Analysis...
    • Examples of ODAA developments like CU Person Table, Custom Dashboard for the Johnson Graduate school of Management, and Infrastructure, Properties and Planning.