Creating Electronic-Resource Usage Dashboards Using Power BI: Presenting Statistics in One, Budget-Friendly, Interactive, Public-Facing Dashboard

Like many academic libraries, the resources at Duquesne University’s Gumberg Library quickly evolved from a collection of mostly physical items to one of predominantly electronic titles. This, in conjunction with staff reductions and changes in job responsibilities, created a need to find a new, more efficient method for collecting and presenting electronic resource (e-resource) usage statistics. Following the lead of the Systems and Scholarly Communications Department which had already created successful Power BI dashboards for other library statistics, a workflow was developed to make a dashboard for e-resource COUNTER-5 (Counting Online Usage of NeTworked Electronic Resources, version 5) usage. The presenters showed how e-resource usage collection responsibilities were delegated and sustained and how available tools (LibInsight, Excel, SharePoint, and Power BI) were applied to create an efficient process. The presenters demonstrated details of the monthly data collection process currently used for a variety of library dashboards, which included step-by-step specifics of the monthly collection of COUNTER-5 usage data.