Tableau workbooks covering Student data needs are now available. The following table maps Query Library queries with the corresponding Tableau workbook(s) to be used in its place. In some cases, replicating the results of a Query Library query may require use of two Tableau workbooks, or a single Tableau workbook may produce the results of more than one Query Library query.
| Query Library Query | Tableau Workbook | Access Restrictions |
|---|---|---|
| Average GPA by Plan or Program.bqy | Average GPAs by Academic Plan IDE | Student Data - Restricted |
| Completed Graduate Minors by Program.bqy | Student Academic Awards IDE | Student Data - Restricted |
| Course ID Look-up.bqy | Course Demographics IDE | Student Data - Restricted |
| Course Profile - Current.bqy | Course Demographics IDE | Student Data - Restricted |
| Course Profile History.bqy | Historical Course Demographics IDE | Student Data - Restricted |
| Courses Taken by Graduate Degree Recipients.bqy | Courses by Academic Awards IDE | Student Data - Internal |
| Cum GPA Ranking by Major.bqy | Undergraduate Cumulative GPA Ranking by Academic Plan IDE | Student Data - Restricted |
| Current and Past Study Abroad Enrollments.bqy | Study Abroad Students IDE | Student Data - Restricted |
| Current Study Abroad Students by Major.bqy | Study Abroad Students IDE | Student Data - Restricted |
| Degrees and Honors Conferred to Undergraduates in a Major.bqy | Student Academic Awards IDE | Student Data - Restricted |
| GPA by Academic Group and Level.bqy | Student GPAs IDE | Student Data - Restricted |
| Graduate Degrees Conferred.bqy | Student Academic Awards IDE | Student Data - Restricted |
| Graduate Student Directory-Demographic Info by Program.bqy | Historical Student Demographics IDE | Student Data - Restricted |
| Graduate Students by Selected Grades.bqy | Student Course Grades IDE | Student Data - Restricted |
| Graduate Students by Student Group.bqy | Student Groups IDE | Student Data - Restricted |
| Honor Students Enrolled in Courses.bqy | Undergraduate Honors Students in Courses IDE | Student Data - Restricted |
| International Graduate Students by School-College or Plan.bqy | International Students IDE | Student Data - Restricted |
| International Undergraduate and University Special Students by School or College.bqy | International Students IDE | Student Data - Restricted |
| Majors and Certificates Counts.bqy | Count of Students in Academic Plans IDE | Student Data - Internal |
| Multiple Student Look-up by Campus Ids.bqy | Historical Student Demographics IDE | Student Data - Restricted |
| Number of Declared Majors.bqy | Count of Students in Academic Plans IDE | Student Data - Internal |
| Number of Graduate and Professional Students - Historical.bqy | Historical Count of Students in Academic Plans IDE | Student Data - Internal |
| Past Study Abroad Students by Major or Degree(Award).bqy | Study Abroad Students IDE | Student Data - Restricted |
| Students by Selected Grades.bqy | Student Course Grades IDE | Student Data - Restricted |
| Under Enrolled Classes by Department.bqy | Course Enrollment Counts by Maximum Enrollment IDE | Student Data - Internal |
| Undergraduates by Major (With Student Group filter).bqy | Student Academic Plans IDE | Student Data - Restricted |
| Undergraduates by School or College - L and S only.bqy | Historical Student Demographics IDE | Student Data - Restricted |
| Undergraduates by School or College.bqy | Historical Student Demographics IDE | Student Data - Restricted |
| Undergraduates by Student Group.bqy | Student Groups IDE | Student Data - Restricted |
Below are additional reports that provide demographic or student group information previously found within a variety of reports in the Query Library and are therefore not associated with any single bqy. UWRAP Release 2 is launching these as stand-alone reports that can be used in conjunction with other IDEs.
| Tableau Workbook | Access Restrictions |
|---|---|
| Historical Student Demographics IDE | Student Data - Restricted |
| Student Demographics IDE | Student Data - Restricted |
| Student Groups IDE | Student Data - Restricted |
The Access Restrictions column indicates the Access Group that has permission to access the Tableau workbook. If you click on a link and find you do not have access but believe that you should, you may request access here.