Student Data

The Student Mart are University data available in the data warehouse, made available to authorized users for customized querying and reporting. This access is governed by Federated Authorization, ensuring users only have access to the data required to fulfill their University responsibilities.

How do I request Student Mart access?

To request access to the Student Mart, please fill out Student Mart Federated Authorization form. Please visit the Student Mart Security page for a summary of the Student Mart security principals, or the Federated Authorization Community page for step-by-step instructions and FAQs about how requests are routed.

Note: access to PeopleSoft is distinct from Student Mart and requires a separate request.

What does this access request grant?

Access to the student mart includes:

Student Mart Dashboards

A number of Tableau dashboards with student-related data are provided automatically to anyone with Student Mart access. These include:

Student Mart Tableau Data Sources

The dashboards above are built using Tableau Data Sources, which are available for users build or customize their own reports or dashboards for their units. More information to follow - stay tuned!

Cognos Student Packages

A number of Cognos Reports and Data Packages are available for current users; note that many of these are being migrated to Tableau, so new users are encouraged to explore those instead. Visit our page for more details.

Restricted Data

Special permission is required to see restricted fields: performance indicators, student demographics, student identifiers, and instructor demographics. To request access to the restricted fields, make sure you check the box for restricted data access and select restricted data along with your description of the relevant justification or business need:

Database Account for Direct SQL Query

Users who request a database account can also query the warehouse using their preferred platform to connect to the server hosting the student warehouse data. To request a database account, choose Create Account in the following option in the Federated Authorization form:

How do remove or revoke access?

The Federated Authorization used to request access can also be used to remove or revise access to an account.

 

Need help? Contact the Pitt IT Helpdesk