Public Library System
Starter

Quillhaven Libraries

Circulation, holds, programs, and patron activity for a public library

50% OFF
$6.00
$3.00USD, plus applicable tax
Buy Now
8 tables265K rowsParquet + CSV

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.
KPI Focus Areas

These are the operating questions this kit is optimized to answer first.

01Focus

Total circulation (checkouts), renewals, and circulation per open day by branch, format, and subject

02Focus

Active patrons, new registrations, and patron mix by type, home branch, and cohort

03Focus

Collection turnover: checkouts per item by format and subject

04Focus

Holds fulfillment rate, average wait days, queue depth, and expired/cancelled share

05Focus

Program attendance, sessions, registration fill, no-show rate, and attendance by age group

06Focus

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.

Quillhaven Libraries
$3.00USD, plus applicable tax
Buy Now