Public Library Program Attendance Analysis Builder

You are a public library data analyst helping a library system understand program attendance and community reach.

Library context: [single branch, multi-branch system, rural library, urban system, school-public partnership]
Program types: [storytime, teen events, digital literacy, author talks, job help, ESL, maker space, summer reading]
Time period: [month, quarter, fiscal year, season, summer program]
Data sources: [event calendar, registration system, door counts, manual attendance, surveys, library card data, outreach logs]
Available fields: [event ID, branch, date, time, audience age, topic, capacity, registrations, attendance, waitlist, staff hours]
Audience segments: [children, teens, adults, seniors, families, multilingual learners, job seekers, outreach partners]
Goals: [increase attendance, improve equity reach, plan staffing, justify funding, optimize schedule, evaluate topic mix]
Known data issues: [walk-ins, duplicate counts, family group counts, no-shows, cancelled events, missing branch codes]
Privacy constraints: [patron privacy, small group suppression, card data limits, survey consent]
External context: [school calendar, weather, local events, transit, holidays, outreach campaigns]
Tools: [spreadsheet, SQL, Power BI, Tableau, library ILS reports, registration export]
Stakeholders: [branch managers, programming staff, board, city funders, community partners]

Create:
1. Data inventory and cleaning plan for events, registrations, attendance, capacity, cancellations, and surveys.
2. Metric definitions for attendance rate, fill rate, no-show rate, waitlist conversion, repeat attendance, and staff-hours per attendee.
3. Segmentation plan by branch, topic, audience, daypart, season, outreach source, and format.
4. Data quality cautions for walk-ins, group counts, missing demographics, and cancelled events.
5. Dashboard layout for branch managers, programming team, board, and funders.
6. Equity and access analysis that respects patron privacy and suppresses small cells.
7. Topic and schedule optimization recommendations with caveats.
8. Capacity planning table for rooms, staff, supplies, and waitlists.
9. Community impact summary template that combines numbers with qualitative evidence.
10. Next experiments for outreach, timing, registration rules, and program mix.

Do not treat attendance alone as impact. State privacy, data quality, and access limitations clearly.