Hi everyone,
Just wanted to ask the group as database managers, how do you handle requests for assistance within your organization? Lately, I've been running into a lot of last minute requests for big projects within my own organization and it's quickly becoming an issue, normally these are from people who don't use Tessitura. I've set up expectations within the organization before, that certain tasks need X amount of lead time, but it doesn't seem to be sinking in.
Do you have a request form you use for your organization? Do you have a sheet that outlines what requests you can assist with and what the wait time is for those?
Curious as to how others have handled this.
In my experience, these requests happen because the basic understanding of what is already in the pipeline is not being communicated effectively. A form is an important part of the process, but education of the process and what is both currently in the pipeline and what is coming in the future is vital.
We use a system that communicates and allows everyone to see what is happening organization-wide. You can use Excel to do this but if you have the budget, Miro is a great visualization tool to get you started. We plan by fiscal quarter and use three main categories for the visualization: Blackout, Big Projects and Ongoing Small Projects. I'll briefly explain these below.
We try to brainstorm these out two years on our Project Board by quarter.
Here is where the forms come in. We do have both a technical support desk that collects requests as well as a few forms (one for Report creation, one for Ticketed Exhibition builds and one for Promo Codes). These are evaluated by a small, cross departmental team and added to our project Planner (Microsoft Office Planner) or assigned in the support desk solution.
The point of my rambling is, the Project Board makes it easy to show anyone what is in the pipeline and what is currently being worked on - small and large. When upper management comes in with a last minute big ask, you can take a look at the board and ask which projects they would like to put on hold (as hopefully, you have on your Project Board, the projects they have asked for previously) to slot in their current request. In some cases, they will simply say that they can wait on Project X while you work on the new, urgent request. In other cases, they will quickly determine that the current urgent request isn't so urgent and you can initiate a conversation about where it fits into the Project Board.
Another benefit is that you also now have a great way to look back at all the things that were accomplished for the year/quarter/month.
hope you find this helpful. Cheers!