Report Writing - Who does it?

I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model.  So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system?  Or something else entirely?  

We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.  

Thanks!

Kjersten Schladetzky
Program Manager, American Museum of Natural History 

Parents
  • We have one person in IT (me), who writes actual reports that need to be run via SSRS or Infomaker; but we do have a power user in the Box Office, who has access to SQL and can help out with the adhoc data queries that are one off and can provide the information. This is part of their wider Tessitura support role which includes training etc.

    Caryl

Reply
  • We have one person in IT (me), who writes actual reports that need to be run via SSRS or Infomaker; but we do have a power user in the Box Office, who has access to SQL and can help out with the adhoc data queries that are one off and can provide the information. This is part of their wider Tessitura support role which includes training etc.

    Caryl

Children
No Data