Go to the U of M home page
Showing posts with label Dimensions. Show all posts
Showing posts with label Dimensions. Show all posts

May 23, 2011

Dimensional Enrollment Data

We have recently release a tool that allows one to create a custom pivot table for our enrollment data. This allows each of the nine dimensions, Term, Campus, College, Level, Class, Ethnic Group, Gender, FT/PT Status and Registration Status to be shown in many different ways, at the same time, on a table. This can answer common multi-dimensional questions our Official Enrollment reports cannot, for example, viewing the enrollment Gender by Ethnicity.

How this works
Under our student data page, you will see the link to the Fall Student Enrollment Pivot Reports. That link will bring you to the index page. We have provided two commonly asked reports, Gender over Ethnicity by Term, Campus, College and Ethnicity over Registration Status by Term, Campus, College, Level. On the right, you see a link to Build your own table..., this will bring you to the tool. Once there, you are able to drag and drop the dimensions to appear as a filter, column header or appear per row.

The first release of this tool used an older JavaScript library, so the drag and drop functionality was inconsistent and quirky. The old library has been replaced by the latest industry standard and should behave consistently across browsers and platforms. Mobile users will have to use the pre-build reports as the drag and drop functionality does not work on a non-traditional browser.

How do I see "All Campuses" or "All College" for a campus?
In this case, you would simply exclude the Dimension for which you want to see "All". For example, to see All Campuses enrollment by Gender and Ethnicity, pick "Term" for a filter, "Gender" for the column and "Ethnic Group" for the rows.

How does the drag and drop interface work?
A demonstration video is provided on the report page. The demo is based on the non-upgraded drag and drop framework for the HR Headcount reports, but the remains mostly relevant.

November 30, 2010

Released: HR Employee Count Tool and Student Aid Profile

HR Headcount Tool
The next iteration of our web-based reports has been released. This time the Human Resource Employee Headcount PDF was the subject of the conversion. These reports offer more flexibility than the student data in terms of presentation. We have three pre-built reports, one of which is based on the PDF as well as a tool which allows users to drag and drop dimensions to view that data to their liking, based on the concept of an Excel pivot table.

View the web-based HR Employee Headcount reports.

Student Aid Profile
We have released a new report regarding student financial aid. Some of the data included: PELL grants, work study, and loans. This data can be found on the Student Data page, under Student Aid Profile, and is available for the past two years.

More details on both of these will be coming in the next few weeks.