Re: Acquisitions Reporting?

From: David Arredondo <00000119cd33875a-dmarc-request_at_LISTS.CLIR.ORG> Date: Fri, 26 May 2023 14:53:55 +0000 To: ACQNET_at_LISTS.CLIR.ORG

Hello Elizabeth,
I am also experimenting with setting up a similar internal dashboard and have used PowerBI in the past to do so. For a different project, I worked with our Systems Librarian and was able to automate exporting reports from Analytics to Sharepoint. I then pointed PowerBI at that report (which we would overwrite daily with new data) and created a dashboard of data visualizations that was accessible to library staff only. I plan to explore a similar process for accounting reports.

I like PowerBI because it is easy to build relationships between different reports - I've been able to combine Analytics reports with SAP reports and EBSCOnet reports to build visualizations. It does do some strange things when you are working with the data in the client vs PowerBI web.

I'd be happy to share more information if you are interested. 

David
David Arredondo (he/him)
Collection Services Librarian
Assistant Professor
University of Nebraska at Kearney
(308) 865-8992
arredondodr_at_unk.edu

-----Original Message-----
From: ACQNET Email List <ACQNET_at_LISTS.CLIR.ORG> On Behalf Of Dittman, Amy Dumouchel
Sent: Friday, May 26, 2023 7:32 AM
To: ACQNET_at_LISTS.CLIR.ORG
Subject: Re: Acquisitions Reporting?

Non-NU Email

Hi Elizabeth,
I will chime in on Gerry's suggestions regarding use of Alma Analytics paired with Excel with some details.
I have reports focused on uninvoiced renewals. This is essentially a pair of reports that I run on demand, one that looks at any continuous or standing order line types with encumbrances >$0.01, and expenditures = $0 for the current fiscal year -- I can send you screenshots if this is of Interest. I have a dependent report that looks at the last invoiced date of the PO Lines returned in the first report, I knit these together in Excel using VLOOKUP -- someone else might have a more elegant option that produces these results in a single report. 
This helps to give me a sense of which renewals are forthcoming, and which are late to be billed. Back in February, I followed up with subscription vendors for any orders that had been invoiced in the previous fiscal year between July and December, that had not yet been invoiced this fiscal year. I've re-run subsets of this report on certain funds in March and May, to continue tracking things that should have been invoiced by this time based on their billing date last fiscal year, to identify cases for follow up.
There are additionally reports I was not involved in developing that focus on the larger packages, to illustrate which are outstanding as encumbrances and which have been expended so far this fiscal year.
If this sounds like what you might be looking for, I can either send you copies of the filters I'm using, or look into saving copies of these into the shared area of Alma Analytics.
Amy

Amy Dumouchel Dittman, she/her/hers
Head of Electronic Resources and Serials Acquisitions Harvard Library ITS amy_dittman_at_harvard.edu
617-998-1656 / 625 Massachusetts Ave, Room 301 Report a problem: https://urldefense.com/v3/__https://asklib-its-harvard.libanswers.com/__;!!PvXuogZ4sRB2p-tU!Ewe3OSBecY1EdwIwimpbxBb2J3bPK5hepXwhfeaclDPQrEGiFowAlItF-kIGZXeucl7PerdW9p1rsiHIT7YtOa36qxs$  

-----Original Message-----
From: ACQNET Email List <ACQNET_at_LISTS.CLIR.ORG> On Behalf Of Walden, Gerald
Sent: Thursday, May 25, 2023 6:08 PM
To: ACQNET_at_LISTS.CLIR.ORG
Subject: Re: Acquisitions Reporting?

Elizabeth, 

At Harvard, we also use Alma as our main system, and we make extensive use of Alma Analytics reporting and dashboards to handle a lot of our acquisitions and funding information. I have spent a lot of time with the "Funds Expenditure" dimension while working on Acquisitions reporting in our Information and Technical Services department. I know that our library finance office as well as our bibliographers make use of Analytics and dashboards to track fund encumbrances, expenditures and free balances throughout the year, with particular attention on remaining balances toward the end of each fiscal year.

I don't know if BU's Alma differs substantially from Harvard's, but I find that Analytics reporting combined with some occasional exporting of data to Excel for further refinement meets most of our needs (though I cannot speak for everyone at Harvard, of course!). We also have a sort of "community of practice" of analytics users who share questions and tips on our internal lists, and on our staff wikis. If it is helpful, maybe we can find a way to share some of what we have learned more widely (and hopefully learn from others as well).

-Gerry

Gerald Walden
Metadata and Dataloads Analyst | Metadata Management & Project Strategy Harvard Library Information and Technical Services
625 Massachusetts Ave.
Cambridge, MA  02139

-----Original Message-----
From: ACQNET Email List <ACQNET_at_LISTS.CLIR.ORG> On Behalf Of Burton, John
Sent: Thursday, May 25, 2023 5:17 PM
To: ACQNET_at_LISTS.CLIR.ORG
Subject: Re: Acquisitions Reporting?

Elizabeth
We are a WMS (OCLC) library.  One of our programmers is working on an API that will pull that information from the WMS budget.  But until they are able to get it written and working for us I have been printing out the budget and entering the information in a spreadsheet that lets me track the information that you are looking to track.  I track the budget information for the main library and our art library. I can share the information with you if you would like.

John Burton
Library Specialist
Department Manager
Standing Order/Monographic Acquisitions
University of Louisville
Ekstrom Library
Technical Services and Collection Development
2301 S. 3rd Street
Louisville, KY 40292

john.burton_at_louisville.edu
502-852-8716

-----Original Message-----
From: ACQNET Email List <ACQNET_at_LISTS.CLIR.ORG> On Behalf Of Elizabeth Johnson
Sent: Thursday, May 25, 2023 3:16 PM
To: ACQNET_at_LISTS.CLIR.ORG
Subject: Acquisitions Reporting?

[You don't often get email from lizzzeb@gmail.com. Learn why this is important at https://urldefense.com/v3/__https://aka.ms/LearnAboutSenderIdentification__;!!PvXuogZ4sRB2p-tU!Ewe3OSBecY1EdwIwimpbxBb2J3bPK5hepXwhfeaclDPQrEGiFowAlItF-kIGZXeucl7PerdW9p1rsiHIT7YtMm_wWfA$  ]

CAUTION: This email originated from outside of our organization. Do not click links, open attachments, or respond unless you recognize the sender's email address and know the contents are safe.

Hello,

I work in acquisitions at Boston University, and I'm trying to build an internal reporting system that looks at expenditures, encumbrances, what we have left to pay for, specifically for renewing resources in a fiscal year, and I'm trying to explore what other libraries use! I've made a rough draft using Excel Power Query (our data is coming from Alma and Ariba SAP for non-Harrassowitz resources) but I figure it's worth asking around to see what other libraries are doing in terms of reports. Any advice or examples would be appreciated! I don't think we've really had a system here in the past, other than just listing all the resources on a spreadsheet and keeping track that way, and this is the first time I've looked into making reports.

Best,
Elizabeth

########################################################################

To unsubscribe from the ACQNET list, click the following link:
https://urldefense.com/v3/__http://lists.clir.org/cgi-bin/wa?TICKET=NzM4Njk1IGpvaG4uYnVydG9uQExPVUlTVklMTEUuRURVIEFDUU5FVBApRdbttz5m&c=SIGNOFF__;!!PvXuogZ4sRB2p-tU!Ewe3OSBecY1EdwIwimpbxBb2J3bPK5hepXwhfeaclDPQrEGiFowAlItF-kIGZXeucl7PerdW9p1rsiHIT7Yt2pzP8Zo$ 