Immediate Solutions for Everyday Business Problems

SharePoint: A Case Study in Content Organization

Original Publication Date: Tuesday, August 25, 2009
Filed Under: Case Studies, Libraries and Lists, Paul Galvin, Security, Web Parts
SharePoint User Level: General Interest

 

Case StudyOne of my company’s more unusual clients is a New York City doctor who is a leader in his particular field of medicine (eye care).  Like many doctors, he has a strong interest in research.  He wanted to do some research on a rare eye disorder that affects a relatively small number of people in the U.S. and Canada.  I don’t know the number, but it’s really too small for a large pharmaceutical company to invest its own private funds with an eye toward eventual commercial success.  I’m sure large pharma’s do some amount of research into rare diseases, but I believe that the U.S. government is probably the largest source of funding. 

Like anything, resources are scarce.  Many doctors across the country want to perform research and trials.  As a result, there’s more than a little competition for that government funding.  This is where my company and SharePoint enter the picture.

The fundamental idea is that a master organization will recruit other doctors across the country and enlist those doctors’ practices in a particular research study.  These individual practices must sign up with the master organization and then, subsequently, sign up for a particular study.  The relationships look like this:

The master organization itself is broken down into groups:

Finally, when a specific doctor’s practice signs up to participate in a study, they need to provide professionals to fulfill a variety of roles:

The above roles have very specific and highly proscribed roles that vary by study.  I won’t get into more detail here, but if you’re interested, leave a comment or email me.
And now I can answer the question, SharePoint – What’s it good for?  The answer – it’s really good for this scenario.

This intro is already longer than I expected, so I’ll summarize the vital role that SharePoint plays in the solution and dive into details in a future article (if you can’t wait, email me or leave a comment and I’ll be happy to discuss and maybe even try to do a demo).  We are leveraging a wide array of SharePoint features to support this concept:

With the exception of the forms based authentication module and a handful of InfoPath forms, this project is using nearly all out of the box SharePoint functionality.

Before I wrap up this min-case study, I want to point out something very important – no one involved with this project (aside from my company of course) has any idea that a thing called “SharePoint” is playing such a fundamental technical role.  Nearly all of my end users view this as “the web site.”  Our client values us because we’re solving their business problem.  SharePoint is a great technical blob of goodness, but done right, that’s irrelevant to end users.  They need a problem solved, not a wonderful blob of technology.

Paul Galvin, MVPPaul Galvin, Microsoft MVP – SharePoint
Web site: Paul Galvin’s SharePoint Space

Paul is a Solutions Architect currently working most closely with Microsoft Office SharePoint Server 2007. He was recently awarded Microsoft MVP – SharePoint status for his work with the SharePoint community.

Spread the word...
  • Digg
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • LinkedIn
  • Reddit

Articles in this series


Notify me of comments to this article:


Comments

2 Responses to “SharePoint: A Case Study in Content Organization”

  1. SharePoint MVP Blogs on August 25th, 2009 3:54 pm

    SharePoint – What’s It Good For? A Health Care Mini Case Study…

    [Note: this blog post is cross posted at Mark Miller’s site here: http://www.endusersharepoint.com/?p…

  2. SharePoint: A Case Study in "Ask the Expert" | End User SharePoint on September 9th, 2009 9:02 am

    [...] Last week, I wrote about one of my company’s clients and an on-going project we have to enable high quality collaboration between various eye doctors in the US and Canada performing clinical research on rare disease.  In addition to leveraging core SharePoint features to enable that collaboration, we’re also working an expense submission and approval process.  It’s complicated because we have so many actors: [...]

Leave a Reply