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.
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.
We support two business intelligence tools centrally
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: