Overview
The Data Analytics & Reporting Team (DART) manages data in the Data Warehouse and the Repository that is used to support state and USF operational reporting.
Data Warehouse
Data Warehouse is a collection of tables, views, snapshots, and other objects designed for the purpose of state and operational reporting. Information on the main objects in the Data Warehouse can be obtained in the Data Warehouse Technical Documentation.
Some tables and views related to main tables are not included in the technical documentation. Detailed information on these and other Data Warehouse tables and views is available in the MetaMart.
Data Warehouse application, forms, and documentation:
Data Warehouse Tables and Views Available to Users (available to DWHOUSE users based DAL security)
- Data Warehouse User Entitlement and Review Process
- Data Warehouse Reports - Email Subscriptions
Standards for Development and Documentation
Read about standards for Data Warehouse database tables and views and, Applications Manager (AppWorx) process and job documentation, and repository usage.
Data Mart
Data marts provide access to subject oriented data in a data warehouse environment, such as student admissions data or data reported to the Board of Governors.
Security privileges are required to access data in USF data marts. Privileges could be one of, or any combination of, security privileges listed below:
- USF Net ID and password
- Security privileges granted to a specific mart and/or specific pages within that mart (these privileges are usually granted manually)
- Security privileges granted to a specific group, such as a data steward group
MetaMart
The MetaMart is an interactive tool that allows business and technical users to easily locate information about USF enterprise business systems metadata. To bookmark the MetaMart, use the link https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1, not the URL generated when you follow this link.
Hub Mart
Hub Mart will provide access and functionality to the data collected and extract for BOG reporting and Operational users.
Doc Mart
Doc Mart is a documentation application.
Finance Mart
Finance Mart provides access the Department Ledger reports.
Admissions Mart
Admissions Mart is a series of reports returning key indicators on the current University application pool allowing for year comparisons and providing critical data to support enrollment management decisions.
Data Marts Page
Data Marts Page contains links to enterprise data marts and other data marts.
Application Manager (AppWorx)
Applications Manager is an administrative systems automation tool with which Banner users, with the appropriate privileges, can do process-dependent scheduling.
AppWorx Documentation System (requires login)
Applications Manager (requires login)
- Production instance (AMPROD) installation
- Production instance (AMPROD) client
- Test instance (AMUAT) installation
- Test instance (AMUAT) client
- Test upgrade instance (AMUATU) installation
- Test upgrade instance (AMUATU) client
- Development instance (AMDVLP) installation
- Development instance (AMDVLP) client
- Development upgrade instance (AMDVLPU) installation
- Development upgrade instance (AMDVLPU) client
- Applications Manager policies
Report Documentation
Data Analytics & Reporting Team (DART), SVC4010, Contact Us