Skip to main content
Translating IT to the end user.

Office Over Easy

Go Search
Home
  

Volition Services LLC > Office Over Easy > Categories
Documenting Business Processes Establishes SharePoint Value

Whenever I’m trying to convince someone to do something for other people, especially when it comes to asking a technical person to document their processes, I always say something like, “when you get promoted because of the success of this project, this document will be the help you wish you had to get started in this role.” I never really liked the image of getting run over by a truck that my successors used to try to convince me to write down what it is that I do. Sort of seemed like a curse or a dare to the universe that once the process was written down that I had fulfilled my purpose and it was okay to off me. What a horrible thing to wish on someone. It was as if keeping that process in my head was the only thing keeping me alive (anyone read Terry Pratchett? That was a theme from one of his books).

As much as I loved Seth Godin’s Tribes, I don’t really follow him on this indispensable theme he has in his latest book. I suppose that most people consider being indispensable a good thing. Everyone wants to feel secure and needed, right? I’m all about problem finding and niche work and knowing your value, but I don’t confuse that with the selfish act of wanting to leave a company at a deficit because of one person’s influence or knowledge. I’ve been indispensable and it’s lonely and stressful and you never get promoted because when you’re indispensable, no one is motivated to develop you out of that role. I don’t want to be insignificant but I wouldn’t wish a truckload of indispensable on anyone.

My advice when I consult companies on how to make SharePoint change the way people work is to make sure that everyone knows how to do the job one level up and one level down from them to ensure that they all know how their assignments and deliverables fit into the big picture. If they have to fill out a status report, then make sure they see how that rolls up into their annual review. If it’s a required process, then tying it back to their bonus structure is a lot easier than hounding them every week to turn it in.

Have your business analyst design a solution to:

·         Create a new report – Start with the form they are using now and see what you can do with it. Give them options and show them a side-by-side comparison of what it looks like to use a custom page layout compared to assigning an existing template with a content type. Show them what a forms library looks like to the end user. Weigh the advantages of each against the effort to change the way people work. Remember that a file storage solution doesn’t sell. Why do they have to save the same document in a new place? A change in layout reinforces the change in location.

·         Destroy the old report - After they buy into the technology proof of concept, take the opportunity to analyze what the report is used for. Are employees pouring their hearts out in bullet points while managers scroll to the bottom to see whether or not the employee is planning to take any vacation this month? Streamline it so employees are only reporting what’s being used. I haven’t met a person yet who loves reporting, so if changing the process minimizes the effort to complete the task, you won’t be able to change this process fast enough.

·         Document the process - Don’t ever guess what the business need is and don’t believe what the business says is the problem until you get everyone into a room to agree on the current process.  For best results, try to have a rough outline complete – that may come from an administrative professional who compiles everyone’s reports or a manager who approves them. Most analysts stop there. Don’t. An individual opinion is just perpetuating what’s probably wrong with the process. The next step is to get the workers into the room and go over the swim lanes with them. I typically find that the simplest task branches out depending on circumstances.

With the workers, don’t start with them submitting the report. Start with how they find the report template. Are they opening up an old one and using file save as? Are they all using the same template? Do they have to wait until they’re in the office or on the network to submit the report? What else can delay the process of getting it turned in on time? Are they waiting for other people to give them information? If so, then how are they getting that information? Is the process consistent for all managers or do some departments do things differently? What are the consequences if the report does not go out? Would anyone notice or care? While they will all agree that something is being done a certain way, most will have an opinion on how it should be done or what would make the process less painful for them. Take good notes.

·         Do something new – don’t try to solve a problem until you get buy in that it’s a problem and that they want to fix it. That’s why this is the fourth step and not the first. I see a lot of analysts ‘fix’ something and then the user looks at the trainer and says, ‘what was wrong with the way we were doing it before?’ At times like that, you don’t want the answer to be, ‘because it’s new and new is fun, right?’ No. No it’s not. Not to a process person. If you’re going to change a task that took 12 easy steps that they’ve been doing the same way for 24 years, then you better have a good reason. You better be fixing something that the user has complained about for the past 24 years. Replacing 12 easy steps with 10 hard ones isn’t helping them get back to their actual jobs any faster.

Before you propose a solution, you need to know how this report fits into the department and get it back to something that motivates the employee. It doesn’t even have to be something that affects their bonus. It could be something that makes the end of the year report they have to do easier. Why solve one problem when you can solve two at the same time. Wouldn’t it be awesome if there was a check box the user could click when filling out a weekly report to have that item automatically show up on the performance review they have to do at the end of the year? As a manager, wouldn’t it make sense to have the weekly report tie back to departmental goals to ensure that everyone is focused on the work the group is being judged on? Instead of telling people to document what they’re doing, how about having them report on what you told your boss they’d get done this year? Is the weekly report different in format than the annual review? Does it have to be that way? Is there any way you can get both processes into alignment? Can you make the weekly report a monthly report instead? Is it possible to eliminate the report all together by opting instead for a weekly meeting workspace that tracks decisions and tasks? All options are on the table but make them pick one that will work. The more they stray from the familiar, the harder it is to get people to change. Think baby steps. Maybe the meeting workspace is Phase II.

·         Develop and test – You got so excited that you almost skipped this part, huh?  The truth is that it’s typically best to let a fresh set of eyes take over. The mistake I see a lot of analysts make is that they are not the best versed on the technology. Talk to your developers and other analysts to review the solution and make sure there isn’t a better way or something available that you didn’t know about. If there are two analysts than there are two solutions. Getting consensus in IT for providing consistent solutions is a big win for the business. This is not an isolated case in one department. This solution could have far reaching implications and when another department sees it and wants it then their analyst needs to know how to do it too. This is where the indispensable thing really chaps my hide. Don’t be the bottleneck in the IT organization because you want to horde a solution. It doesn’t make sense for everyone to have to wait on you to do this for them. Worse is the fact that steps are more likely to be skipped as you do more deployments. Then, the analyst starts to think that because everyone is having the same issue that they all look the same. They start to think that taking the time to get everyone in a room to document the process is a waste of time or skimp on the next step so they can hurry up and help the next group. If you hear yourself cut off a client to say things like, “I know what you need” or “We’ve seen this before in another group,” then you need to slow down. Always start with the old form. Always get buy in that it’s not working. Always document the existing process. It’s not new to you, but it’s new to them. Don’t ever forget that. Stick to your process of how to improve their process.

·         Train them on the new process – Redraw the process map and call everyone back in the room for a hands-on demonstration. In this example, you would show them how to fill out a status report and submit their annual review. Make them all do one together – from finding the form to getting it approved. Make sure the manager attends this session and make it required. This ensures that someone sat them down and told them that they had to do this report differently from now on. Users need a roll-out. Do not skip this step or there will be a painful transition of some people doing it the new way and some people still using the old form. Management needs to enforce the new process by not approving anything done the old way. Workers need to hear managers say that to them out loud. There is no excuse for not changing – we did ask you what you thought.

·         Evaluate the new process – Check back with the client after a few weeks and then six months later and each year after that. Don’t let it go another 24 years before someone is willing to fix the process to meet the needs of the business. Are they ready for that meeting workspace solution yet?

Process is the great unifier and a perfect entry point for IT into the business. It’s a great project for people who are new to the industry and it puts IT back into a position of helping people do their work more efficiently. Don’t just roll out SharePoint and wait for people to figure out how it can help them and don’t roll out training that mimics the marketing presentation the vendor gave to the CIO. Make SharePoint matter to them. Make sure it makes a difference.

Train the trainer tip: Use analogy

Listen to the podcast here.

In my train-the-trainer course, I teach people how to connect with an audience, control a crowd, and motivate the group to make an immediate and permanent change in their behavior. My favorite way to connect with an audience is to use analogy. In this example, I use something that isn't technical like doing the laundry to introduce SharePoint concepts to users for the first time. I've heard some people say that concepts like content types should not even be mentioned to the end user but since my audience of end users includes site administrators or people who may one day become a site administrator, I don't ever shy away from teaching people new vocabulary. In the long run, it will only help to empower the users to talk to the technicians and support staff using the same language. If they need a new content type added, they need to be able to say that to someone who can show them the steps. So, for me, I absolutely think that people need to know the right terms for the technology and I've had a lot of success with audiences using analogy to teach them new words.

This analogy is used as the outline for a two-hour hands-on learning class to teach site administrators how to create a library, add content types, add metadata, and create custom views in a web part. In this example, the concept of document retention is new to the users, so content types are a requirement for them (and have already been pre-defined).

1.       Site collection – Think of a site collection like your house,

2.       Libraries – and libraries are similar to the rooms in that house. Even if the room is a mess and we can’t find anything in it, we know that this shirt that we found in the living room belongs to our son, and so we put it in his room. Ownership is a logical place to begin classifying something, and

3.       Content types – content types are all the things in your house. I’m using the term ‘shirt’ as an example of a content type and my son’s room as an example of a library, but there are other rooms (or other libraries) and many other things (or content types) in your house that you put in each of those rooms – things like electronics, lamps, chairs, dishes; even pens. Do you see how giving a group of items a name like ‘shirt’ doesn’t mean that there is only one room in the house to put it in? I know it’s my son’s shirt, but is it clean or dirty? Does that piece of information about the item change where I need to store it? So, if ownership and a content type aren’t good enough to decide where this one shirt goes in the house, then I’m going to need more information.

4.       Metadata – That’s why we need metadata. Metadata is how you differentiate between the same type of thing. This not only allows us to decide which library to put a document in, but it also helps us to quickly scan through each room in the house to find just what we’re looking for. For example, dirty shirts, and if your goal is to do laundry, then you may also want to separate dirty shirts by color or style. Depending on the age of your son, you may not be so inclined to do his laundry, so metadata may even define workflow. Who washes this dirty shirt?

5.       Web parts – For this exercise, let's assume that you want to find all the dirty, dark-colored T-shirts in the house. If this is a search you do often – going into each room of the house looking in various places where dirty shirts could be hiding, then you’re going to appreciate the concept of a web part. Imagine if you could hone in on all the dirty dark-colored shirts in the house without asking for anyone’s cooperation to SORT their laundry for you. Metadata makes it possible to filter out all the stuff we’re looking for and show it to you in a web part. They can keep it wherever they want to in the house (so, you may know about a dirty shirt in his locker at school but you’re web part can’t get it for you if it’s not in the house). Still, this is pretty powerful stuff. We’re saying that if all the shirts in the house have metadata associated with them, then they cannot hide from you.

 

You think that’s great? Consider this. If you classify all the documents in your site collection, you'll be able to check to see if you already have a clean, blue shirt before going out and buying a new one. If people are classifying their content, then it is not only easier to find what they are looking for but to make better decisions about the data they have. Using content types and metadata in addition to libraries and web parts allows you to be confident that you have uncovered all the documents you are looking for.

And there’s one more way that corporate documents are a lot like T-shirts in your house – trying to get your son to voluntarily throw away one of their favorites away is impossible. It’s not always the case that whoever owns the shirt is in charge of how long it is kept. Moms work like document controllers to go through the house and get rid of shirts that have outlived their usefulness or shame the entire family each time they are worn out in public. In the same way, libraries and content types in the Records Center allow your company to be in compliance with legal and regulatory requirements. These retention rules happen behind the scenes to make sure that certain documents are kept as long as required and no document is kept too long. While you may disagree that your tie-dyed Grateful Dead T-shirt is a permanent legacy of your glory days, it doesn’t make sense to keep that old shirt in search results. It’s like the shirt in the drawer that even when all other shirts are dirty, you still won’t wear it. Let it go.

If you are focusing on content management during your SharePoint implementation then remember that you are requiring everyone to change the way they are currently storing and retaining documents. Communicate the benefits and remember to use analogies like these when introducing new terms to your users.

For more SharePoint training tips and tricks, please subscribe to this blog and follow officeovereasy on Twitter.

Conference Notes: Improve SharePoint Performance
Dennis Bottjer, ASP.NET MVP, talked about proactive solutions-general tips for improving SharePoint performance. Performance is a holistic approach to design. The pieces of performance are admin, dev, and architect. You'll miss something if you come at it from one point of view. From an end user perspective - performance is their perception. This is a crucial piece of the adoption story. Get MOSS, WSS, .NET, IIS, and Windows Server in line. Know the layers of the onion and learn each layer well.

1. Kill the performance defaults in application pools.
2. Leverage warm up scripts after an IISReset and pre-JIT's.
3. Turn on compression but don't go above 9.
4. Test web parts, tables, flash, and Silverlight - each is a potential performance hit so don't overdo their use. Consider all your alternatives (e.g., user controls).
5. Offload SSL and get a hardware load balancer for networking.
6. Farm type matters - improve performance by at least separating out search and database (OK in WSS - more important in MOSS).
7. Know the limits of your content DB's.
8. More is better with site collections - transactions decrease the more you have. This is a great argument for My Sites.
9. 2000=Magic Number - sub sites, lists, users, and docs per folder.
10.  Folders in libraries can help if you're using 2000 as the magic number.  
11. Retention policies - prune and archive content.
12. Enable c:\blobCache - supports gif, jpg, js, css, swf audio and video.
13. Custom caching - thread synchronization and locking.
14. Object disposal - avoid looping.
15. Search - add index server. Schedule crawls.
16. Memory matters -  4GB's isn't gonna be enough on 64-bit. Reduce bottlenecks with SAS hard drives.
17. Shop eBay for -1 gen hardware.
18. Disable IIS logging - at least think through it if you're using another analytics solution and definately do it in dev to improve VM performance.
Conference Notes: Common Hurdles
Mark Rackley with UNFI (whole foods distributer) and SharePointHillbilly.com talked about common SharePoint hurdles for new admins and devs. He started with a review of what SharePoint Server 2007 can do - Portal, Search , Workflow, BI and Content Management. He reminded us that .NET is a layer that WSS and MOSS are built on and showed us how WSS 3.0 nests inside of MOSS Standard and then into MOSS Enterprise. His next graphic showed the Farm which holds the web application (a container for content databases). It's in those databases that your site collections reside. Central Admin sits in its own content db. Basic content db tables include AllDocs, AllUserData, AllLists. He even showed an org chart to show that AllDocs sits under AllLists.

Taxonomy - before you build your farms. He suggested bringing in consultants to ensure you get it right from the beginning. Their eight server farm is still not deployed because they are waiting on a governance committee. It is worth the wait! Executive support is going to be key to end user adoption.

Governance - Don't be so quick to rely on folders in libraries. Between the 260-character naming limit and fileshare recreation, it can really bite you. Metadata is best. Taxonomy and Governance diagram from Microsoft does a good job of showing above the line and below the line control. My Sites are at the bottom of the pyramid - less need to control those in relation to the effort it takes to control the portal.

Infrastructure - don't host non-SharePoint sites on Farm. Watch out for SSL - even if you don't have your cert, create it as an SSL site. You can't go back and convert it to SSL after it's been created. Wilcard certs are better than SAN so you don't have to buy a new cert when you add servers. Grant access to SSP by making admin of site collection. A locked out service account brings down the farm. You've already heard it, but it's worth repeating - don't do a basic install. For backup and DR, add a new content db to SQL backup policy. Invest in 3rd party tools (another thing worth repeating). More tips:
  • sub sites can't have features that aren't active on parent site
  • every subsite is in the same db as the parent site
  • all documents in each site collection are in one table
Security - farm is your security barrier. The firewall acts as a router to your SharePoint farm. Put internet in one farm and intranet in another to solve a lot of problems. Things like Reporting Services will break if you check all authenticated.

InfoPath - when using on your secure server. You'll fail with invalid cert if  the server does not have internet access to contact the CRL (if hosted by a third party).

Development - write to logs when writing code to help you debug your code. Get the free VHD from Microsoft and use it - only 30 days but great to have. Build your own if you can. Use trial versions and build your own farm - it's great experience. Have both a Dev and a QA farm - going from VM to farm is crazy without the QA farm - get all devs to integrate their work in this farm. Local VM's go to Integration (aka dev) farm for best results. Can't create a template from a subsite in the UI - must apend the URL - then they will be in the Custom tab if you've installed one of the Fab 40 (other workarounds to get this tab but this might explain if you see it in one place and not another). Features are best for everyone.

SharePoint Designer - great if you have to do something and you don't have access to a VM or central admin. Can't exclusively use SPD for all your workflows - you still need Visual Studio. Don't use SPD to delete default web parts. You'll break the collection. SPD will also disconnect all your workflows when you restore. For all these reasons - don't give it to your end users.

Web Part Development – know the XML file folder structure and use tools to help.

Tools – IIS 6.0 Resource Kit Tools from Microsoft.com, CKS Forms Based Authentication Solution from codeplex, Fiddler for performance tuning and web debugging, Application Pool Manager from http://www.harbar.net/articles/APM.aspx.
Conference Notes: BPOS and SharePoint
Thanks to the efforts of Mark Miller at End User SharePoint. I am one of the live bloggers in St. Louis today. Follow the feeds for St. Louis MOSS Camp and SharePoint Saturday in Atlanta here!
 
Todd Kitta with Covenant presented BPOS and SharePoint. He started by telling us that BPOS is hosted Microsoft products in Microsoft's data centers. Business Productivity Online Standard Suite is dedicated to under 5,000 seats but it will scale up to 100,000. Energizer is a very early adopter of the dedicated  technology but other companies on standard include Nokia, Philips, and Coca Cola. Within the logos, Todd Kitta pointed out that SharePoint saved the Maersk captain. Albeit, it was a customized application but he couldn't resist pointing out that Maersk is using BPOS.

Todd  said that his company is on Exchange Online and he even uses it on his iPhone. Other products include Live Meeting, Office Communication Online (OCS), and SharePoint Online Standard (SOS). Finally, all the acronyms at SharePoint conventions make sense! Benefits include Single Sign On, integration with other applications, https, data protection, availability and geo-redundancy with data centers in places like Singapore, Netherlands, and Texas. There is no central admin - while some of the functionality is replicated in the environment, it is something to consider as you weigh the needs of your organization.

The pricing comes out to $15 per user each month for a five person minimum. One participant said that something like this could  even meet the needs of families trying to stay in touch with one another. Watch out ancestry.com, BPOS is coming for you.