Download - 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot
![Page 1: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/1.jpg)
How We Did It Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot
Sadie Van Buren
Presented to SharePoint Saturday Boston, 28 April 2012
![Page 2: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/2.jpg)
4/28/12 #SPSBOS @sadalit
Sadie Van Buren Content Architect
Working with SharePoint since beta 2003 version
50+ SharePoint implementations
Creator of the SharePoint Maturity Model
Microsoft Certified IT Pro
About
BlueMetal Architects Experts at building solutions that exactly meet the
needs of our customers by apply the right people, processes and platforms.
Focus on modernizing applications through expertise in
Creative, Social, Development and Data.
Offices in Boston, New York and Chicago.
![Page 3: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/3.jpg)
4/28/12 #SPSBOS @sadalit
Linear and Nonlinear Processes
The Challenge
The Solution
Demo
Agenda
![Page 4: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/4.jpg)
Submit request
Approve Request
Process Request
Send Materials
Submiter Signoff
![Page 5: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/5.jpg)
![Page 6: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/6.jpg)
4/28/12 #SPSBOS @sadalit
Recruiting
Cost containment
Innovation
Building a brand
Developing business strategy
Ensuring happy customers
Creating buzz
“Going Green”
Encouraging diversity
Seeking business opportunities
Increasing market share
What is a nonlinear process?
![Page 7: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/7.jpg)
Request
Review
Graphics
Copyedit
Deliver
![Page 8: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/8.jpg)
![Page 9: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/9.jpg)
Request
Review
Graphics
Copyedit
COMPLIANCE
![Page 10: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/10.jpg)
4/28/12 #SPSBOS @sadalit
Capture our process
Get us off Excel
Unify our global offices
And do it using NO CODE.
It has to look really nice,
be intuitive to use,
provide secured views by role,
send automated notifications,
and deliver powerful reporting.
The Challenge
And you can’t access the servers or Central Administration!
![Page 11: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/11.jpg)
4/28/12 #SPSBOS @sadalit
Improve efficiency by reducing manual effort
Standardize the process across global offices
Speed up response time with automated notifications
Facilitate handoff among resources
Surface request status to the requestor as well as the working team
Respond to questions with “paper trail”
Track metrics of the process
The ROI
![Page 12: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/12.jpg)
4/28/12 #SPSBOS @sadalit
SP 2010 Enterprise
with Infopath Services and PowerPivot configured.
The Prereqs
![Page 13: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/13.jpg)
4/28/12 #SPSBOS @sadalit
SP 2010 Site
InfoPath form template, site content type, site columns, & form library
SP Designer workflow
Audit list
PowerPivot data feed
Excel Services reporting
Solution Design
![Page 14: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/14.jpg)
4/28/12 #SPSBOS @sadalit
The Site
![Page 15: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/15.jpg)
4/28/12 #SPSBOS @sadalit
The Form
![Page 16: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/16.jpg)
4/28/12 #SPSBOS @sadalit
The Workflow
![Page 17: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/17.jpg)
4/28/12 #SPSBOS @sadalit
The Audit List
![Page 18: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/18.jpg)
4/28/12 #SPSBOS @sadalit
The Reports
![Page 19: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/19.jpg)
Demo
![Page 20: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/20.jpg)
4/28/12 #SPSBOS @sadalit
Maturity of This Solution - 350
![Page 21: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/21.jpg)
4/28/12 #SPSBOS @sadalit
User Profile service data connection – a.k.a. “the dreaded 5566 error”
Kerberos
Managed Metadata
File interaction – attachments can’t be shown via the icon in the form library, no easy way to transfer them to a document library
No data feed from InfoPath Form Library
File attachment upload limit – 4 MB by default
Gotchas
And potentially many more!
![Page 22: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/22.jpg)
4/28/12 #SPSBOS @sadalit
Color-coding (seen in request status on the site):
http://blog.pathtosharepoint.com/2010/04/06/tutorial-add-color-coding-to-your-sharepoint-2007-calendar-in-15-minutes/
PowerPivot add-in for Excel:
http://www.microsoft.com/en-us/bi/powerpivot.aspx
Resources
![Page 23: 20120428 How We Did It - Tracking and Reporting on a NonLinear Process with InfoPath and PowerPivot](https://reader034.vdocuments.us/reader034/viewer/2022051313/5493a0cfb47959794d8b48ba/html5/thumbnails/23.jpg)
4/28/12 #SPSBOS @sadalit
Follow Up
@sadalit
Upcoming
Join us for SharePint!
The Skellig - 240 Moody St in Waltham
Sponsored by RackSpace and BlueMetal Architects
Thank You!