Enterprise Reporting is available in myUFL and provides easy access to the University of Florida financial, human resources, student, and other management data. Enterprise Reporting is available to faculty or staff who have been assigned any of the various roles which grant access to this system. Access to Query Studio is provided by the UF_ER_CRN_QUERY_STUDIO role, which can only be assigned once the required Query Studio course has been completed.
|Start a New Query||Simulation|
|Create a Tenure Status Report||Simulation|
|Create a Dept ID List||Simulation|
|Query Studio Planning Sheet|
|Query Studio Data Element Guide – Financial Package|
To register for online courses in myTraining, navigate to mytraining.hr.ufl.edu. From the myTraining Dashboard, you can search for courses using the Activity Search field in the upper left hand corner. Just type the course name, course ID or a keyword and then click Search.
After you’ve registered for training, your current enrollments display in the Training list found on the Dashboard page. To begin an online course, click the green Start button.
You can also access myTraining from myUFL using the following navigation:
Main Menu > My Self Service > Training and Development > myTraining
PST912 Reporting: Query Studio
This course introduces the Enterprise Reporting Query Studio tool. We begin with a brief overview of the Data Warehouse and then take a closer look at the various data packages. After building a familiarity with the Query Studio interface, we complete exercises to introduce and reinforce your query-building skills.
Querying at the University of Florida is both a privilege and a responsibility. For this reason, we require training before you acquire the Query Studio role.
Lists and descriptions of all UF security roles may be found on the Identity & Access Management website.
Please review the Report Catalog for the necessary security roles.
- Reporting Query Studio Classroom Handout
- Warehouse updates are noted on the Alert Notices Page.
- Shared Folder Request Form
- Reporting Services website
- Check out the Reporting Services Brochure