University of Wisconsin–Madison

UWRAP

The UW-Madison Reporting & Analytics Project (UWRAP) was created to replace Interactive Reporting (IR) tools with a new suite of solutions. The goal of UWRAP is to ensure that data and reporting needs met by the Query Library, IR web tool, and the IR desktop application will continue to be met as the IR tools are retired.

UW System Administration will be removing all access to the Query Library on March 1. UW-Madison has been working on developing new dashboards and reports to meet the data needs that have been met by the Query Library. In spring 2018, Data Management & Analytics Services (ODMAS) and Academic Planning & Institutional Research (APIR) held campus-wide information sessions and Tableau demonstrations. Recordings of those sessions are available here.

A crosswalk of Query Library reports to completed new solutions is available at http://data.wisc.edu/query-library-crosswalk

Release 1, Curriculum & Instruction

We are pleased to announce that Tableau workbooks covering Curriculum & Instruction data needs are now available. These workbooks are designed to meet data needs previously met by a of Query Library queries. A list of Query Library queries and their corresponding Tableau Workbook replacements are as follows:

Release 2, Student

We are pleased to announce that Tableau workbooks covering Student data needs are now available. These workbooks are designed to meet data needs previously met by a of Query Library queries. A list of Query Library queries and their corresponding Tableau Workbook replacements are as follows:

Query Library QueryTableau WorkbookAccess Restrictions
Average GPA by Plan or Program.bqyAverage GPAs by Academic Plan IDE Student Data - Restricted
Completed Graduate Minors by Program.bqyStudent Academic Awards IDEStudent Data - Restricted
Course ID Look-up.bqyCourse Demographics IDEStudent Data - Restricted
Course Profile - Current.bqyCourse Demographics IDEStudent Data - Restricted
Course Profile History.bqyHistorical Course Demographics IDEStudent Data - Restricted
Courses Taken by Graduate Degree Recipients.bqyCourses by Academic Awards IDEStudent Data - Internal
Cum GPA Ranking by Major.bqyUndergraduate Cumulative GPA Ranking by Academic Plan IDEStudent Data - Restricted
Current and Past Study Abroad Enrollments.bqyStudy Abroad Students IDEStudent Data - Restricted
Current Study Abroad Students by Major.bqyStudy Abroad Students IDEStudent Data - Restricted
Degrees and Honors Conferred to Undergraduates in a Major.bqyStudent Academic Awards IDEStudent Data - Restricted
GPA by Academic Group and Level.bqyStudent GPAs IDEStudent Data - Restricted
Graduate Degrees Conferred.bqyStudent Academic Awards IDEStudent Data - Restricted
Graduate Student Directory-Demographic Info by Program.bqyHistorical Student Demographics IDEStudent Data - Restricted
Graduate Students by Selected Grades.bqyStudent Course Grades IDEStudent Data - Restricted
Graduate Students by Student Group.bqyStudent Groups IDEStudent Data - Restricted
Honor Students Enrolled in Courses.bqyUndergraduate Honors Students in Courses IDEStudent Data - Restricted
International Graduate Students by School-College or Plan.bqyInternational Students IDEStudent Data - Restricted
International Undergraduate and University Special Students by School or College.bqyInternational Students IDEStudent Data - Restricted
Majors and Certificates Counts.bqyCount of Students in Academic Plans IDEStudent Data - Internal
Multiple Student Look-up by Campus Ids.bqyHistorical Student Demographics IDEStudent Data - Restricted
Number of Declared Majors.bqyCount of Students in Academic Plans IDEStudent Data - Internal
Number of Graduate and Professional Students - Historical.bqyHistorical Count of Students in Academic Plans IDEStudent Data - Internal
Past Study Abroad Students by Major or Degree(Award).bqyStudy Abroad Students IDEStudent Data - Restricted
Students by Selected Grades.bqyStudent Course Grades IDEStudent Data - Restricted
Under Enrolled Classes by Department.bqyCourse Enrollment Counts by Maximum Enrollment IDEStudent Data - Internal
Undergraduates by Major (With Student Group filter).bqyStudent Academic Plans IDEStudent Data - Restricted
Undergraduates by School or College - L and S only.bqyHistorical Student Demographics IDEStudent Data - Restricted
Undergraduates by School or College.bqyHistorical Student Demographics IDEStudent Data - Restricted
Undergraduates by Student Group.bqyStudent Groups IDEStudent 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 WorkbookAccess Restrictions
Historical Student Demographics IDEStudent Data - Restricted
Student Demographics IDEStudent Data - Restricted
Student Groups IDEStudent 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.

Release 3, Advising, Curriculum & Instruction, Student, and Human Resources

We are pleased to announce that the third and final major release of Tableau workbooks is complete. These workbooks are designed to meet data needs previously met by Query Library queries. A crosswalk of Query Library reports to completed new solutions is available at http://data.wisc.edu/query-library-crosswalk