{"id":3090,"date":"2009-09-15T06:59:52","date_gmt":"2009-09-15T13:59:52","guid":{"rendered":"https:\/\/svapm.org\/?p=3090"},"modified":"2019-08-07T14:30:29","modified_gmt":"2019-08-07T21:30:29","slug":"tools-techniques-microsoft-project-best-practices-1","status":"publish","type":"post","link":"https:\/\/svapm.org\/?p=3090","title":{"rendered":"Tools &amp; Techniques \u2013 Microsoft Project Best Practices (1)"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3093 alignright\" src=\"https:\/\/svapm.org\/wp-content\/uploads\/Gantt.JPG\" alt=\"Microsoft Project Best Practices\" width=\"317\" height=\"253\" srcset=\"https:\/\/svapm.org\/wp-content\/uploads\/Gantt.JPG 317w, https:\/\/svapm.org\/wp-content\/uploads\/Gantt-300x239.jpg 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/p>\n<p>With the kick-off of Project Conference 2009 in Phoenix, AZ this week Microsoft has invited some customers and partners to get a sneak peek at Microsoft Project 2010.\u00a0 I have been managing projects and teaching classes on this tool for quite a long time and have had a chance to read about some of the latest \u2018improvements.\u2019 \u00a0Unfortunately, this new release still does not address some basic needs for project managers as they approach the tool.\u00a0 Here are some practical suggestions when using (any version of) Microsoft Project.<\/p>\n<p><strong>Understand the Challenges to Using MS Project <\/strong>\u2013 There\u2019s a reason that spreadsheets are the most commonly used software tools to manage projects.\u00a0 Spreadsheets are more intuitive and predictable than MS Project.\u00a0 MS Project is relatively easy to use when starting to coordinate tasks but it can quickly become cumbersome and unmanageable when attempting to optimize resources and control your schedule or budget.\u00a0 A streamlined approach to using the most appropriate features is highly recommended.\u00a0 I have generally found that a project manager can effectively plan and control their projects with far less than half of the tool\u2019s functionality.\u00a0 One way to streamline your approach to the tool is to minimize data entry to certain key fields (e.g. Task Name, Predecessor, Duration, Actual Start, Actual Duration and Remaining Duration to name a few).<\/p>\n<p><strong> Know the Planning Limitations <\/strong>&#8211; Microsoft Project is not a project management tool.\u00a0 Let me repeat that last sentence: Microsoft Project is not a project management tool.\u00a0 \u00a0It was developed as a schedule tracking application but has become accepted over the years as a comprehensive project management tool.\u00a0 It is not the most effective tool when it comes to brainstorming activities like project planning.\u00a0 Many project managers get challenged when they drag their teams through a planning session with nothing but a Gantt Chart.\u00a0 Gantt Charts are not very conducive to team interaction during the planning process.\u00a0 Teams often respond better and produce higher quality planning information when using affinity diagramming tools like mind maps and work breakdown structures.\u00a0 That brings up another good suggestion\u2026<\/p>\n<p><strong>Integrate a Work Breakdown Structure (WBS) <\/strong>\u2013 For all the years that Microsoft Project has been in use, there has never been a built-in WBS feature.\u00a0 This has always amazed me.\u00a0 Previous versions have attempted to integrate with Microsoft Visio to create WBS diagrams but this was never an effective feature.\u00a0 Project managers will often utilize summary tasks and subtasks (i.e. indenting tasks) in order to create a hierarchy of work within a Gantt Chart.\u00a0 This is a good start but I would go a step further and utilize an add-on tool such as WBS Chart Pro (criticaltools.com) which integrates the Work Breakdown Structure into MS Project for reporting as well as front-end planning functionality.<\/p>\n<p><strong>Improve Estimation Techniques<\/strong> \u2013 Often times the weakest link in the planning process is the quality of work and cost estimates for project activities.\u00a0 There are several things to keep in mind as you enter Duration, Work or Cost estimates into MS Project.\u00a0 First, it is your responsibility as the project manager to challenge and validate estimates you receive from various sources.\u00a0 If you have gone through enough projects, you know that you cannot assume every estimate will be accurate.\u00a0 Refer to historical data, break down components to smaller work packages and push back on those Subject Matter Experts (SMEs) until you are more confident in the quality of the estimates.\u00a0 In addition, you can use various techniques such as Delphi to gain consensus on estimates or Stochastic Modeling to leverage three-point estimates and improve the confidence in your overall schedule or budget.\u00a0 There are built-in PERT Analysis features, add-on tools (e.g. Risk+ from Deltek) and even macros for Monte Carlo simulation available to integrate three-point estimation and risk management into Microsoft Project plans.<\/p>\n<p><strong>Standardize, Share, and Optimize Your Resources<\/strong> \u2013 Entering resources in Microsoft Project is quite easy.\u00a0 Defining them properly is not.\u00a0 What I mean is that coming up with a standard naming convention for resources can be challenging.\u00a0 This is especially true when there are many different stakeholders for project data \u2013 resource managers, executives, portfolio\/program management and, of course, team members.\u00a0\u00a0 Defining a common set of resources to meet all major reporting needs is often the job for a Project Management Office (PMO).\u00a0 The PMO may also be charged with setting up a Resource Pool which can be shared across multiple projects and maintained centrally.\u00a0 Ultimately, a key project management responsibility during the planning and control portions of a project is to optimize the usage of resources such that those resources can effectively achieve the work and thereby commit to the plan.\u00a0 A good understanding of the Resource Leveling feature in MS Project allows a project manager to identify key resource bottlenecks and optimize assignments proactively to reduce schedule risk.<\/p>\n<p><strong>Know Your Limitations in Sharing Information <\/strong>\u2013 It\u2019s much easier to share information with spreadsheets than with MS Project since almost everyone has a spreadsheet application on their computer.\u00a0 Unfortunately, licensing costs make MS Project a limited deployment for most organizations.\u00a0 For the individual project manager there is a rarely leveraged discount available through academic licensing.\u00a0 Taking a professional development course or having a child in school allows for up to 90% off of the list pricing.\u00a0 It is well worth taking advantage of this discount.\u00a0 Check out online academic software resellers for more information on eligibility and pricing.<\/p>\n<p><strong>For a more in-depth look at Microsoft Project Best Practices at UCSC Extension in Silicon Valley check out the Elective Course link in the left menu for Managing Projects with Microsoft Project.<\/strong><\/p>\n<p><strong>Coming up next time, a closer look at\u2026<\/strong> Limitations in Critical Path Methodology, Compressing Schedules Effectively, Achieving Consensus and Understanding Baselines, Controlling Projects by Variance Analysis and Supporting Multiple Project Managers.<\/p>\n<p>Thanks for reading.\u00a0 Your comments are always welcome!<\/p>\n<p><strong>&#8211; Jim Park, PMP<\/strong><br \/>\nInstructor, Project and Program Management certificate program<br \/>\nUCSC Extension in Silicon Valley<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the kick-off of Project Conference 2009 in Phoenix, AZ this week Microsoft has invited some customers and partners to [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2,7,8,5,9,27],"tags":[39,234,1373,319,338,825,132,651],"class_list":["post-3090","post","type-post","status-publish","format-standard","hentry","category-leadership","category-goals","category-priorities-2","category-time-management","category-risk-management","category-training-certification","tag-best-practices","tag-estimation","tag-goals","tag-professional-development","tag-project-management-tools","tag-reddit","tag-resources","tag-wbs"],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/svapm.org\/index.php?rest_route=\/wp\/v2\/posts\/3090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/svapm.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/svapm.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/svapm.org\/index.php?rest_route=\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/svapm.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3090"}],"version-history":[{"count":1,"href":"https:\/\/svapm.org\/index.php?rest_route=\/wp\/v2\/posts\/3090\/revisions"}],"predecessor-version":[{"id":14297,"href":"https:\/\/svapm.org\/index.php?rest_route=\/wp\/v2\/posts\/3090\/revisions\/14297"}],"wp:attachment":[{"href":"https:\/\/svapm.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/svapm.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/svapm.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}