Data Warehouse is a repository of data from transactional systems across the university. The repository facilitates end user access to data for analysis in support of strategic and tactical decision making. The primary tools for accessing the Data Warehouse are the dynamic analysis tool delivered in Enterprise Analytics and the static reporting tool delivered in SSRS. To learn more, see What is the Data Warehouse?.
Enterprise Analytics (EA)
Enterprise Analytics is an institutional-wide financial tool displayed in the form of an Excel pivot table that can be used to support the Health Science Center's business processes where financial analysis is required. This "PowerPivot" tool combines data from multiple sources such as PeopleSoft Financials and Hyperion Planning to provide a comprehensive source of data which can be expanded to view and analyze detailed information. Enterprise Analytics is accessible from the portal (inside.uthscsa.edu) under HSC Business Applications.
EA Training & Resources
Enterprise Analytics General Information:
Enterprise Analytics is an institutional wide analysis tool which combines data from multiple sources, using the functionality of Microsoft Excel to present data in a Pivot Table format. The tool groups data into standardized conventions and transaction types. Data can be summarized at a high level or expanded to analyze at the transactional detail level.
Financial Review and Analysis:
A tool to meet financial monitoring requirements and processes to remain compliant. Used to manage operations, monitor financial performance, and attest to the accuracy and correctness of financial records.
Facilitates monthly variance analysis, reporting from budget and year-to-year comparisons.
Payroll Review and Analysis:
A comprehensive view of the payroll data to accommodate monthly financial review process requirements.
Grant Review and Analysis:
A tool to support and manage sponsored program projects, providing for the proper internal controls for compliance, using fund groups 41002 – 44999.
Department Assigned Manager
The Department Assigned Manager in PeopleSoft Financials allows departments to assign a Project Manager to a project ID for display in Enterprise Analytics templates and reports. Use of the Department Assigned Manager page is entirely optional. Access to the page is restricted to the department’s ACE. To learn more review this presentation.
SQL Server Reporting Services (SSRS) is the static reporting tool for Data Warehouse. SSRS is accessible from the portal (inside.uthscsa.edu) under HSC Business Applications > Data Warehouse. The delivered data is consistent with Enterprise Analytics. SSRS delivers a great deal of flexibility to the report consumer in an efficient interface similar to Microsoft Windows Explorer. Cascading prompts deliver the ability to see only department specific data based on user login.
SSRS Training & Resource Options
Business Software Application Support Contacts:
- HSC Business Information Systems Resource Guide - a handy guide for who to contact with questions or problems on enterprise business applications.
- Network, Connectivity, Logon - Contact the Service Desk, 210-567-7777, option 1
- Training resources may be found in Knowledge Center
- For eTalus Application requirements, curriculum vitae, and data email firstname.lastname@example.org
- For application functionality PeopleSoft, DRS, InfoView, Hyperion, Enterprise Analytics (or training resources) and questions beyond what is on this site, contact the Transition Solutions team at email@example.com or call 210-450-0090 (Monday thru Friday, 8:00am - 11:00am and 1:00pm - 3:00pm)