This Dashboards and Business Intelligence in Government describes how national program leaders at the Cooperative of State Research Education and Extension Services use a dashboard to quickly review the project status of grants awarded to the research, education and extension communities.
Building the Leadership Management Dashboard (LMD) at Cooperative of State Research Education and Extension Services (CSREES)
CSREES has, as its primary mission, “the responsibility for providing linkages between federal and state components of a broad-based national agricultural higher education, research and extension system designed to address national problems and needs related to agriculture, the environment, human health and well being, and communities.”
In 2006, CSREES national program leaders (NPLs) and program assistants had requested that IT build a customized, central application where they could quickly review the project status of grants awarded to the research, education and extension communities. Before this date, NPLs had to refer to several disparate reporting databases and then manually compile results in spreadsheets – many of which contained errors. More importantly, these spreadsheets didn’t provide the specific, tailored information the NPLs needed to manage their specific programs.
To address these reporting deficiencies, the LMD project team met with an NPL super user group to conduct requirements-gathering sessions. They entered the requirements (e.g., presenting program-funding summaries that “drilled down” to detailed project reports) into a database and rated them according to their level of importance.
Using Oracle Portal and rapid prototyping methods, the LMD dashboard was delivered by Jul-07 using iterative approach.
The Leadership Management Dashboard (LMD) prototype was deployed in the summer of 2007 for a few CSREES staff, with plans for full agency deployment and possibly the states within the next few years. The LMD is a personalized visual display of the most important information needed to more easily manage and lead agency investments. The LMD provides CSREES national program leaders to more easily make strategic program decisions, conduct daily program operations, and perform individual tasks such as reviewing and approving project reports. While the initial version of the LMD makes use of CRIS data, the next version, expected in the summer of 2008, will integrate and make available data from Plans of Work and Annual Reports.
It would be nice if someone could send the screenshot of this dashboard.