Engineering project management: How Microsoft SharePoint and dashboards can help

Aggregating and sharing information from multiple sources helps motivate teams and deliver projects on time and budget, according to DMC Inc., at the CSIA Executive Conference.

05/09/2012


DMC Inc. offers Microsoft SharePoint consulting services. Courtesy: DMC Inc.Engineers can better control projects by using dashboards created with Microsoft SharePoint, explained Rick Rietz, Director of Consulting Services, DMC Inc., Chicago, Ill., speaking at the 2012 CSIA Executive Conference in Scottsdale, Ariz.

With more than 100 million users worldwide, Microsoft SharePoint is the dominant business platform for collaboration and document management, Rietz told attendees at the Control System Integrators Association annual meeting. However, most businesses don’t realize that SharePoint also can be a project manager’s weapon for configuration management and automatically aggregating and sharing information from multiple sources. SharePoint Dashboards motivate teams and deliver projects on time and on budget. Rietz delivered the following advice about using the browser-based project management software toolset.

Key performance indicators (KPIs) can be built into the SharePoint platform to automatically aggregate data from multiple systems.  SharePoint is also great for remote workers, because users can contribute content as the project progresses, no matter where they are.

There are many practical uses and many associated applications that can be made accessible via Android and Apple iPhone platforms.  

Functions include intranet use, document control, collaboration by inviting partners to portions of the project, development of team project collaboration sites, display of key milestones, and alerts when there are changes or when certain tasks are completed. Audit and version control can be set, along with a list of tasks, issues, documents, and contacts. Templates are available for faster project starts.

Document management functions save time, protecting against mistakes by avoiding use of outdated documents. Rather than emailing multiple versions of a document, one document can be uploaded and links sent.

Workflow is useful for structure, consistency, and efficiency of business processes.

Searching for something also is faster than navigating through a traditional folder structure. The software can index every word in every document on a network drive or within a SharePoint Portal, using a parametric filter panel for quick and easy filtering of search results (including indicators  of duplicates in the search results). Wikis, in a web page format, can be created for standard operating procedures (SOPs), with hyperlinks to related areas.

SharePoint dashboards allow management by exception, with automated processes of whatever needs tracking. Often three to five dashboards can be established for each organization or department, pulling data from multiple systems with updates every few minutes. Forecasts can be compared to results, showing red, yellow, or green, driving cultural change, improving communications, and motivating employees.

Personal KPI dashboards can be created so employees can accumulate points for incentives. Projects can show the amount of assets allocated, time, budget, and other important criteria.

SOPs and best practices can be linked, and newer employees can click in deeper for more information instantly, saving time and getting up to speed more quickly.

For very large projects, Microsoft Project software may be needed. For many projects, however, Microsoft SharePoint project tools may be enough, showing milestones and synchronizing tasks with Microsoft Outlook.

For executing the project, internally and externally available documents can be controlled by using metadata, which can force appropriate classification when a document is created. Lists for risks, issues, and defects can improve tracking and include version tracking.

Documents can be managed and workflow approved. Configuration management tools track and document changes to system features.

When starting a SharePoint portal, it’s best to begin by creating an intranet with wikis to document and share SOPs.  Next, select a select business area to improve and choose a set of KPIs. Sales departments often go first, followed by projects. Plan first, and phase in features over time. Don’t jump right in with everything. First decide if it makes more sense to organize by department or by function.

Among other CSIA system integrators using these tools are Avid Solutions, Concept Systems, MR Systems, PLCs Plus, and Stone Technologies.

As for cost, the Microsoft SharePoint Foundation version is free with Microsoft Windows Server, Rietz said. Also available, with additional functionality, are Sharepoint 2010 and SharePoint 2010 Enterprise.

- Mark T. Hoske, content manager, CFE Media, Control Engineering, Plant Engineering, and Consulting-Specifying Engineer, can be reached at mhoske(at)cfemedia.com.

www.controlsys.org

http://controleng.com/integration

www.microsoft.com/sharepoint

www.controleng.com/channels/information-control.html

www.dmcinfo.com/Services/SharePoint-Consulting-Services.aspx



No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Leaders Under 40 program features outstanding young people who are making a difference in manufacturing. View the 2013 Leaders here.
The new control room: It's got all the bells and whistles - and alarms, too; Remote maintenance; Specifying VFDs
2014 forecast issue: To serve and to manufacture - Veterans will bring skill and discipline to the plant floor if we can find a way to get them there.
2013 Top Plant: Lincoln Electric Company, Cleveland, Ohio
Case Study Database

Case Study Database

Get more exposure for your case study by uploading it to the Plant Engineering case study database, where end-users can identify relevant solutions and explore what the experts are doing to effectively implement a variety of technology and productivity related projects.

These case studies provide examples of how knowledgeable solution providers have used technology, processes and people to create effective and successful implementations in real-world situations. Case studies can be completed by filling out a simple online form where you can outline the project title, abstract, and full story in 1500 words or less; upload photos, videos and a logo.

Click here to visit the Case Study Database and upload your case study.

Bring focus to PLC programming: 5 things to avoid in putting your system together; Managing the DCS upgrade; PLM upgrade: a step-by-step approach
Balancing the bagging triangle; PID tuning improves process efficiency; Standardizing control room HMIs
Commissioning electrical systems in mission critical facilities; Anticipating the Smart Grid; Mitigating arc flash hazards in medium-voltage switchgear; Comparing generator sizing software

Annual Salary Survey

Participate in the 2013 Salary Survey

In a year when manufacturing continued to lead the economic rebound, it makes sense that plant manager bonuses rebounded. Plant Engineering’s annual Salary Survey shows both wages and bonuses rose in 2012 after a retreat the year before.

Average salary across all job titles for plant floor management rose 3.5% to $95,446, and bonus compensation jumped to $15,162, a 4.2% increase from the 2010 level and double the 2011 total, which showed a sharp drop in bonus.

2012 Salary Survey Analysis

2012 Salary Survey Results

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.