| Info |
|---|
Upcoming Changes to Data Infrastructure Pitt IT Analytics is actively building a modern data lake and lakehouse (i.e. data warehouse) hosted in AWS, which should impact only users with a database account. Currently, data from the Student, Employee, and GL marts is served to the campus community from our on-premise Oracle data warehouse. Users with a database account and an appropriate VPN role can connect directly to the data warehouse to retrieve data with SQL. For more information, please visit the Analytics Modernization page. |
Data Available for All
Through the University’s Federated Authorization process, the following data sources are available for connection via Tableau data sources and dashboards, Cognos reports and query packages, and via direct SQL access.
Student Mart
Student Mart Tableau Data Sources (link to Tableau data catalog)
Student Mart Dashboards (link to Tableau dashboard catalog)
Request access to the Student Mart through Federated Authorization
Employee Mart
Employee Mart Tableau Data Sources (link to Tableau data catalog)
HR Basic Dashboard (link to tableau dashboard catalog)Analytics
Request access to the Employee Mart
General Ledger (GL) Mart
General Ledger Tableau Data Sources (Link to Tableau Data Catalog)Financial Dashboards and reports (link to Tableau dashboard catalog)COMING SOON!)
Request access to the GL Mart
Specialized Data
The following data sources are currently available as part of an existing dashboard, or via special request/use case. For more information on these data sources, please contact the Pitt IT Helpdesk.
PERIS
Concur
Insite
RMS
Suitable/Outside the Classroom Curriculum
Salesforce
Faculty Information System
Planned Changes to Data Infrastructure
Currently, data from the Student, Employee, and GL marts is served to the campus community from our on-premise Oracle data warehouse. Users with a database account and an appropriate VPN role can connect directly to the data warehouse to retrieve data with SQL.
Beginning in 2022 Pitt IT Analytics began work on a modern data lake and lakehouse (i.e. data warehouse) hosted in AWS, using AWS’s Redshift database. While the underlying database systems are changing, the structure of the marts will remain the same, allowing users who have existing queries or reports to repoint them to the new location with minimal rework.
For more information, please visit the Analytics Modernization page.
...
Access to Analytics and Reporting Tools
Tableau Desktop and Tableau Server - please visit Tableau page for information on acquiring Tableau
Cognos - Users who have requested and been granted access to the Student Mart, Employee Mart, or GL Mart listed above automatically have access to existing reports and ad hoc report creation capability in Cognos.
Oracle Analytics Cloud - please visit https://prism.pitt.edu/oracle-analytics-cloud-oac/ for information on access to OAC.