Hi Elizabeth

I second PowerBI.  I attach Excel sheets and a simple Access DB to it.  It's easy to make simple Bar and Pie Graphs, Tree Maps, etc...  There's a calendar table that you may have to create to handle timeframes,  but there's a free desktop version with limited export functionality.

We do not get too granular here,  but I track Total_Items in Counter 5 reports at a monthly/yearly snapshot.


Randy Lancaster, ITIL
Applications Specialist

Henry Ford Hospital / Sladen Library
[log in to unmask]

-----Original Message-----
From: Code for Libraries <[log in to unmask]> On Behalf Of Brent Ferguson
Sent: Thursday, May 5, 2022 10:59 AM
To: [log in to unmask]
Subject: Re: [CODE4LIB] Useful stats

    CAUTION CYBER RISK: EXTERNAL E-Mail. Do not click links or open attachments unless you recognize the sender, expected to receive this content, and you believe it to be safe. Delete this message; or forward the email to spam@ hfhs org if suspicious.


Microsoft Power BI may be a good choice. Think of it as a web page for Excel Charts. I haven't worked with it in awhile, but I remember there were many ways to display data. I don't remember it being that difficult to use.

Brent Ferguson, MLS
Librarian, Elkhart Public Library
(574) 274-7445

From: Code for Libraries <[log in to unmask]> on behalf of Elizabeth Leonard <[log in to unmask]>
Sent: Thursday, May 5, 2022 10:13 AM
To: [log in to unmask] <[log in to unmask]>
Subject: [CODE4LIB] Useful stats

In our Annual Report, our ERL has always provided a detailed list of database /resource usage. It is a ponderous pile of figures which few actually review.

I'm looking at presenting usage data differently this year, and wondering how others may have approached this.
Total ebooks, or articles downloaded- number of logins or searches to our discovery layer...?

Any inspiration out there?



Elizabeth Leonard
Assistant Dean, Information Technologies and Collections Services University Libraries Seton Hall University
400 South Orange Avenue
South Orange, NJ 07079
Preferred pronouns: She, her, hers


CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies.

Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.