View Source

Resolve Derived Tables Issues
- created modified versions of derived tables, automated them to run daily, and modified queries

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

- ERM (Electronic Resource Management)  
- worked with Tom Trutt and Pete Stergion to automate process of cleaning ERM files for use with Tableau and publishing new data quarterly

Optimize our collection of queries on the cul-folio-analytics GitHub repository
- reduced dependence on derived tables
Created new queries as needed and updated the code in existing queries

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

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

Set achievable goals within reporting team by minimizing project scope creep
- yup

- 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

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
- Natalya?
PowerBI -
Metadb Data Privacy
Accomodating Losses in Reporting Staff
Wolfcon 2025 Conference
- training and presentation
- youtube links