Quillhaven Libraries
Circulation, holds, programs, and patron activity for a public library
About Quillhaven Libraries
Industry
Public Library System (Municipal)
System size
Small municipal system
Branches
7 (Central, 4 community branches, 1 bookmobile, 1 online/digital)
Active patrons
about 19,700 active of 28,000 registered
Annual circulation
about 82,000 checkouts per year
Programs
about 24 recurring program series
Quillhaven Libraries is a fictional small municipal public library system built for BI teams that want credible civic operations data without enterprise-scale clutter or a forced revenue model. The system serves a mid-sized fictional town through a central library, four neighborhood branches, a bookmobile, and an online/digital branch. Its work is measured in community service: items circulated, cardholders served, holds fulfilled, and program seats filled. Overdue fines exist but are small and intentionally minor; this is not a sales dataset.
Operating Profile
- Runs 7 service points: a Central library, four community branches, the Quillhaven Bookmobile, and the Quillhaven Online digital branch.
- Maintains a representative catalog of about 900 items across eight formats and a range of fiction and nonfiction subjects.
- Serves about 28,000 registered patrons (roughly 19,700 active) across Adult, Youth, Senior, Student, and Educator card types.
- Circulates at item-checkout grain, tracks holds at reservation grain, and tracks programs at attendee grain grouped by session.
- Uses low-PII patron records only, with no emails, phone numbers, street addresses, payment cards, or government IDs modeled.
Recent Business Events
- 1Summer reading campaigns lifted children's and youth circulation and program attendance in both modeled years.
- 2The new Westgate community branch opened mid-window and steadily built circulation and program attendance, starting later than the established branches.
- 3Digital lending held about a quarter of circulation through the online branch, and eBook and audiobook hold queues ran deeper than the physical ones.
- 4Fall storytime and school-year programming created a second attendance bump each autumn alongside steady book-club and maker-workshop series.
- 5A handful of high-demand titles carried deep hold queues and longer wait days, while the long tail barely moved and weeded titles carry none at all.
These are the operating questions this kit is optimized to answer first.
Total circulation (checkouts), renewals, and circulation per open day by branch, format, and subject
Active patrons, new registrations, and patron mix by type, home branch, and cohort
Collection turnover: checkouts per item by format and subject
Holds fulfillment rate, average wait days, queue depth, and expired/cancelled share
Program attendance, sessions, registration fill, no-show rate, and attendance by age group
Overdue and lost-item rates and the small total fines they generate
Embedded Analytical Stories
Circulation seasonality
Summer reading and the school year create visible monthly circulation bumps, strongest in children's and youth materials.
Collection turnover
A head of popular titles and high-demand formats circulates far more than the long tail, so turnover varies sharply by format and subject.
Holds fulfillment
Popular items build deep hold queues; wait days rise with queue position, and most holds end fulfilled while some expire or cancel.
Branch and channel mix
Central and the digital branch carry the most activity, the bookmobile and newest branch the least.
Programs and outreach
Storytime, book clubs, maker workshops, and summer-reading events draw different age groups by season.