Goals for 2019

(DONE) 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 (e.g., ILL, HaithiTrust)
(DONE) Get more experience with Reporting Tools we will be using (DONE)
(IN PROGRESS) Each Reporting SIG member gets experience writing a report with chosen reporting tool
(NOT NEEDED) Explore non-SQL data schema options
Understand our needs for normalizing, denormalizing, summarizing, aggregating, anonymizing data
Survey Reporting SIG members on report writing needs
(IN PROGRESS) Develop repository of queries based on the prioritized list of reports
Determine how to maintain, support, and distribute repository of shared queries
(ON HOLD) Write shared documentation on the Library Reporting Database implementation, maintenance and schema (e.g., data dictionary)
(IN PROGRESS) Write shared documentation on the queries, connecting reporting tools to Library Reporting Database
(DONE - RedShift) 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

Reporting SIG