- Get the Library Reporting Database up and running with a schema so we can build lots of reports and run them against the data
- Investigate using external data sources (outside FOLIO data) in the Library Reporting Database
- Get more experience with Reporting Tools we will be using
- Each Reporting SIG member gets experience writing a report with chosen reporting toolÂ
- Explore non-SQL data schema options
- Understand our needs for normalizing, denormalizing, summarizing, aggregating, anonymizing data
- Survey Reporting SIG members on report writing needsÂ
- Develop repository of queries based on the prioritized list of reports
- Determine how to maintain, support, and distribute repository of shared queries
- Write shared documentation on the Library Reporting Database implementation, maintenance and schema (e.g., data dictionary)
- Write shared documentation on the queries, connecting reporting tools to Library Reporting Database
- Implement one open source database (e.g., Postgres, Monetdb) and one commercial database for larger data and/or faster queries (e.g., Vertica)
- Write "concept dictionary" or "metadata dictionary" to capture library data elements/attributes in glossary form with common vocabulary for SMEs and developers
General
Content
Integrations