28 - Microsoft Power BI Unleashes the Potential of NIEHS Dataset

Abstract Information: The Division of Extramural Research and Training within the National Institute of Environmental Health Sciences (NIEHS) uses the Grants Coding Database (GCDB) to assist strategic planning and decision making for the Institute. The database provides a place for NIEHS to track key scientific and programmatic content not found in other NIH sources whether private or public. The coding process involves extracting basic information for every competitively funded grant in QVR (Query View, Report), which is a tool that NIH staff use to review grant applications and awards. Codes are assigned based on their environmental health relevancy from the keywords in the abstract and specific aims. The GCDB includes over 4,000 awarded grants from 2011 to the present. Coding is captured to describe information related to exposures, health outcomes, the NIEHS strategic plan, target population, climate change, environmental justice, social science approaches used, and more. In order to better utilize the GCDB we developed Power BI dashboards to allow for quick portfolio analysis and program planning for the Institute. These dashboards amplify and empower staff by improving decision making, providing equal access to data and promoting team collaboration. This poster will describe the GCDB, the process used to create the Power BI dashboards, and how it is used at NIEHS.

Due to the data not being publicly available to share we cannot show the original GCDB dashboard that staff use but will instead show a similar dashboard with publicly available data from the Research Portfolio Online Reporting Tools (RePORT) and Research, Condition and Disease Categorization (RCDC) NIH systems. RePORT provides access to a variety of reporting tools, reports, data and analysis of NIH research activities. The RCDC system is utilized by the National Institutes of Health (NIH) in its reporting process to categorize funding in biomedical research for each fiscal year beginning in fiscal year 2008. The NIH reports funding to the public for 308 categories.