• Replies 10 replies
  • Subscribers 338 subscribers
  • Views 64 views
  • Users 0 members are here
Related

Report Writing - Who does it?

Kjersten Schladetzky
$organization

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
  • $organization
    Hi Kjersten,

    One thing that is a boon for ad-hoc reporting is the BI-model called tabular. Starting in SQL 2012, this model is table based and can be accessed via Excel, SSRS, or through sharepoint as Power-view presentation. We've deployed it here in SMM, but as with something new, one must maintain it too.

    Troy
Reply
  • $organization
    Hi Kjersten,

    One thing that is a boon for ad-hoc reporting is the BI-model called tabular. Starting in SQL 2012, this model is table based and can be accessed via Excel, SSRS, or through sharepoint as Power-view presentation. We've deployed it here in SMM, but as with something new, one must maintain it too.

    Troy
Children
No Data