- 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 use Custom tabs for this kind of thing - not sure if it's right for what you need but it can be customised by your database administrator (I believe) so that you can enter the relevant info. We use this mostly to track individual participations in non-ticketed events, it allows us to track their journey and also tp pull lists of people who have participated in certain years/activities. Also used to pull a register report and medical report before activities which is really useful.