- Get the Library Reporting Database up and running with a schema so we can build lots of reports and run them against the data
DONE
- Investigate using external data sources (outside FOLIO data) in the Library Reporting Database (e.g., ILL, HaithiTrust)
- Get more experience with Reporting Tools we will be using (DONE)
- 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 (in progress)
- 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) - DONE
- Write "concept dictionary" or "metadata dictionary" to capture library data elements/attributes in glossary form with common vocabulary for SMEs and developers