2022-11-17 Statistics Discussion Meeting notes

Meeting Goals and Expectations

• Goals

  • Library staff become familiar with benefits of SQL

  • Library staff become familiar with alternate datasource options

  • Library staff become familiar with use of Tableau report

  • Library staff will think about options for initial set of reports by the next meeting on Nov 22nd

• Expectations

  • Beginner’s mind

    • No dumb questions, please ask

  • Round table discussion

Datasources

• SQL

  • Databases used

    • PostgreSQL (direct Sierra connection)

      • Views explaination

    • Microsoft SQL (circulation retention only)

  • Example of a SQL query

• Google Sheets

Tableau

• Examples showing how we access data and build reports, charts, etc.

Home work

• Determine the top report needs for your library

  • Think about areas where alternative solutions are underserving your needs

• Prepare to present your ideas at the next meeting on Nov 22nd

  • The top ideas will get created for each library by go live

  • Other ideas will be saved to be added later in 2023