Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • (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