Department Planning Profiles

Department Planning Profiles provide summary information for every division and department – both academic and non-academic units. Access is limited to UW-Madison employees. Data trends are provided since 2011. Links to historical data are provided below.

Department Planning Profiles provide more than 300 metrics across the following topic areas:

  • payroll – FTE and payroll dollar totals by employee category. For more detail, visit the Payroll interactive visualization
  • faculty roster counts – FTE by rank and age group. For more detail, visit the Faculty Roster interactive visualization.
  • credit allocation – includes metrics in Credits Follow the Department (CFD) and Credits Follow the Instructor (CFI) formats. For more detail, see: https://apir.wisc.edu/instruction/credit-analysis/
  • student enrollments – metrics on enrollment trends; enrollments in programs are assigned to the department that is the academic owner. For more detail, see: https://apir.wisc.edu/students/
  • degrees, certificates – metrics on degree and other award trends; awards are assigned to the department that is the academic owner of the program. For more detail, see: https://apir.wisc.edu/students/
  • budget – summary budget allocations by category and program. For more detail, visit the Budget interactive visualizations
  • expenditures – summary expenditures by expenditure category and program.
  • research awards – total research awards, with federal and non-federal disaggregation.

Assignments of Academic Programs and Subjects to Departments – see the Academic Structure. 

 

An interactive Tableau visualization for Department Planning Profiles is available here:

The Department Planning Profiles are under ongoing development and evolution.
Direct questions and feedback on the visualization to Allison La Tarte at allison.latarte@wisc.edu.

Historical Version

FY 1990 through FY 2016

Access is limited to UW-Madison employees and requires a NetID and password log in.

All Departments FY90-FY16 – Excel 2013 format; uses slicers to filter the data for unit or metric of interest.

*Credit data for Spring 2016 is not included in the file due to a data inconsistency. Refer to the current version of Department Planning Profiles to obtain this information.

Crosswalk Tables – these tables are useful in understanding the historical DPP files. They show how academic programs and subjects are associated with departments, identify which departments are credit-generating and have enrollment, identify which departments are tenure homes and their disciplinary division, and show the historical associations of departments that have been restructured over the time period of these data tables.

The Department Planning Profiles were originally developed in 1984 by the College of Letters & Science, Academic Planning and Institutional Research, and the Madison Budget Office. In the late 1990s, they were expanded to include academic departments in the other schools and colleges. Starting in 2013, Department Planning Profiles were updated to include all departments (academic and non-academic in all divisions) and to expand available data in a joint project of Academic Planning and Institutional Research, the Madison Budget Office, and the InfoAccess team (then DoIT, now ODMAS).