Reporting Team Goals and Accomplishments

Test and Develop Reports for Reporting App for Metadb
- wrote and published new query for Acquisitions staff to use to manage orders
- determined permission settings not meeting our needs, so submitted https://folio-org.atlassian.net/browse/UILDP-178 for a new Reporting App User role, scheduled to be released in Trillium
- working on proposal to develop functionality to create user roles that map to github repository directories link
Explore New Data Sources for Library Analytics
- worked with Tom Trutt and Pete Stergion to automate process of cleaning ERM (Electronic Resource Management) files for use with Tableau and publishing new data quarterly
- worked with Pete Stergion and reference staff to connect to SpringShare API and provide a new Tableau dashboard on Reference Interactions

Optimize our collection of queries on the cul-folio-analytics GitHub repository
- reduced dependence on derived tables by revising queries to use JSON code extracts
- created modified versions of derived tables and automated them to run daily
- Created new queries as needed and updated the code in existing queries
- updated queries to reflect updates to Metadb tables after Ramsons

Improved report automation, e.g. test Temporal application
- waiting on software developer

Consider new reporting applications over DBeaver EE
- agreed this is still the best tool for our team to use to create and manage code for report queries, derived tables, and dashboards

- Worked with Mike Gorrell from Index Data on data extraction project for Metadb version 1.4
- Review hosting team tickets
- Derived Table updates for each FOLIO software release
- Work with hosting team to optimize data synchronization efficiency (reducing number of tables) for Metadb

Review and refine supported reports and dashboards with small groups of stakeholders
- schedule reviews with stakeholder groups in early 2026

Offer CUL Reporting User Group meetings
- offered meetings on these topics in 2025
  - Wolfcon 2025 updates

Co-convene Reporting SIG Meetings
- worked with Reporting SIG co-convener to arrange topics and host weekly Reporting SIG meetings for the FOLIO community throughout 2025

Create standard testing procedures for queries (e.g., verify that it matches data in FOLIO apps); identify certain queries that can identify possible problems; use metadb log; keep records of problems found

Create standard testing procedures to verify accuracy of data and reasonableness before and after each reporting database update; (e.g., do record counts fall within expected parameters?); identify certain queries that could be used as test cases before and after an upgrade, coming from various functional areas
Test, support, learn more about the Lists App
- created and shared 3 lists for Acquisitions staff to use: duplicate holdings, pending orders, and purchase order line notes
PowerBI
- set up infrastructure
Metadb Data Privacy
Accomodating Losses in Reporting Staff
- covering work for Nancy Bolduc and Linda Miller
Wolfcon 2025 Conference
- training and presentation
- youtube links

Page tree