- Cross posting this on a few forums -
Hi everyone!
Looking for some thoughts/resources about how other organizations manage their external data?
The short background is that we want to centralize all the various 'data' about our programming that exists *outside* of Tessitura (that doesn't necessarily need to be *in* Tessitura).
For example, we hold classroom workshops and need to keep track of number of students in each workshop; the county of the school, etc. It's a bit excessive to book these one-time workshops into Tessitura, so our Education team keeps all the information in our shared drives alongside the rest of the planning for the workshop itself.
Are there any tools or tips you have for how you and/or your organization tracks and manages this type of data?
I'm considering a mix of something like a sitemap that connects to where the departments are already doing their own tracking in our shared drives plus starting some summary excel sheets to keep readily available.
As an organization we're trying to expand the 'database manager' position to be more of general data management - has anyone else done this/is this how your organization is structured?
Any suggestions are appreciated!
We have a similar program at SCT and only book the payments in Tess for the same reason you mentioned. We keep all of the details in a shared spreadsheet in Microsoft Teams/sharepoint. There's one tab that houses all of the data and then other tabs that summarize the data for reporting, as well as an invoice tab where they can enter an order number and it creates a nice invoice to send the school. I am the data operations manager at our org and I did set these up for them (with a lot of help from my husband who is much better at Excel than I am).