- 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!
Hey Ashleigh,
I was part of a showcase on Education data in 2018. Arts Centre Melbourme were up after me and showcased how they how they went from their "Spreadsheet of Doom" for tracking their workshops, to creating a tidy system table that is accessible to the team and contains all the date entered for easy extraction..i can dig out the presentation slides of you like.
Oh I definitely want to see that slide presentation. We have a lot of doom spreadsheets too.
It can save you a lot of hassle as with a little mapping you can reference established data in interesting ways. I'll dig it up in the morning
I'd love to see those slides as well! Echoing the Spreadsheets of Doom over here too!!