- (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 (in progress) 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) - DONE
- Write "concept dictionary" or "metadata dictionary" to capture library data elements/attributes in glossary form with common vocabulary for SMEs and developers