November 9 th , 2011

1. November 9th, 2011 Real World SharePoint Stories and Solutions Michelle Gilbert, Dan Platt, & Nick Giuliano

2. Agenda • Introductions • Intranet for the Legal Industry – Michelle Gilbert • Tennant Company’s New Website – Dan Platt • Break • Driving Efficiencies Through Effective Planning & Budgeting with SharePoint 2010 – Nick Giuliano • Panel Q & A

3. User Group Goal / Objectives Develop and support a local community focused on Microsoft SharePoint Technologies Educate user group members about SharePoint Technologies Transfer knowledge within the community Communicate best practices Introduce new products / solutions

4. Introductions – MNSPUG Sponsors Avtex (www.avtex.com) • Technology consulting company • Practice area focused on SharePoint Benchmark Learning (www.benchmarklearning.com) • Training on many technologies Microsoft (www.microsoft.com) WroxPress (www.wrox.com) O’Reilly (www.oreilly.com)

5. www.SharePointMN.com • Website for user group • SharePoint resource documents • SharePoint resource links • RSS Feeds • Meeting Schedule • Past User Group Presentations • info@sharepointmn.com www.sharepointmn.com

6. Social Networking • Linked In group – The most interactive… includes job postings… http://www.linkedin.com/groups?gid=1878792 • Facebook group http://www.facebook.com/home.php?#/group.php?gid=27333305456 • Twitter tags - @MNSPUG and #MNSPUG

7. Upcoming Schedule • Next Meeting December 14th9:00 AM to 11:30 AM Microsoft Technical Center - Edina Topic: Social Networking for the Enterprise Check www.SharePointMN.com for updates! • Ongoing Schedule 2nd Wednesday of every month 9:00 to 11:30 am Microsoft Technical Center - Edina

8. Local and Online Events ScarePoint Saturday – April 14th , 2012 http://www.sharepointsaturday.org/twincities/default.aspxNormandale College– Bloomington, MN Microsoft Webcast Calendar of Events http://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter SharePoint ShopTalk (Online) – Every Thursday @ 11:30 AM http://sharepointshoptalk.blogspot.com/ SharePoint Legal Users Group – 3rd Thursday @ 12:00 to 1:00 p.m. Contact - michelle.gilbert2gpmlaw.com

9. Surveys & Giveaways!

10. Presenters

11. Michelle Gilbert • Web Administrator, Gray Plant Mooty • Interests: SharePoint michelle.gilbert@gpmlaw.com

12. Quick Intro Dan Platt • Online Marketing Manager • Contact Info • Email: Dan.Platt@tennantco.com • www.linkedin.com/in/danjplatt • Twitter: @danplatt

13. Quick Intro Nick Giuliano, PMP, V-TSP • Project Manager/BA • GNet Group • Caffeine Enthusiast LinkedIn: nicholasgiuliano Twitter: @Nick_Giuliano Email: Nick.Giuliano@gnetgroup.com

14. SharePoint 2010 Intranet for the Legal Industry

15. Vision: Provide a view of organizational information that simplifies employee interaction with business systems, facilitating collaboration and business processes while improving productivity, communication, and satisfaction. • We selected SharePoint 2010 Standard as our Intranet • User count: 350 + • 3 Office locations • Host internally • Launched 1st phase in August, 2011

16. Business Goals Provide a firm wide communication tool for events and announcements. Have a personalized home page per office location. Link business tools and systems to one portal for easy access. Connect to our document management system. Create document collections for improved search. Improve communication and collaboration across practice groups which tend to operate like silos. Create robust user profiles for expertise search. Provide robust content for the administrative, committee, practice group and client team pages. Improve search results. Use discussion boards, blogs, wikis when applicable.

17. First Phase Accomplishments Goal: Provide a portal environment for general firm information sharing and communication • Announcements Web Part • Administrative Sites/Content • Practice Group Sites/Content • Firm Wide Events Calendar • New Employees Web Part • Birthday and Anniversary Calendar • Culture Corner (Classifieds, HelpDesk, Going Green) • Weather Web Part • RSS and Twitter Feeds • Link to our document management system • Collections of Documents (Business Forms Index/Policy Manual)

18. Second Phase Plan Goal: Provide a portal environment for administrative and practice group collaboration. • Activate My Sites (Allow Edit Profile) • Create more robust Secured sites • Determine valuable financial information and create dashboards • Enhance User Profiles to capture expertise, clients, sharing knowledge • Create more HR forms • Enhance our meta, keyword and taxonomies for improved search results

19. Questions??? • SharePoint Legal User Group: Began August, 2011 Meets the 3rd Thursday of every month Date: November 17th Time: 12:00 – 1:00 pm Topic: Information Architecture (4th Event) Contact: michelle.gilbert@gpmlaw.com

20. Public Facing, Global, Multi-language SharePoint Implementation

21. Who is Tennant Company? Founded: 1870 by George H. Tennant as wood products company Business: Leader in designing, manufacturing and marketing equipment and services that help create a cleaner, safer, healthier world 2010 Revenues: $668M 2010 Employees:2,800 NYSE : TNC Brands:

22. We make products like this… Scrubbers Vacuums Carpet Extractors Burnishers Sweepers Industrial & City Cleaning Coatings Industry-Leading Technology

23. For customers like these… Key Markets: • Building Service Contractors • Retail • Hospitality • Healthcare • Education • Government • Warehousing • Manufacturing • Aviation • And more…

24. The urgency to change our public website! • In 2010 we upgraded our content management tool used to manage our public website. • The tool turned out to be a clunker! Page loads spiking to 5-13 seconds Drop in lead conversions Increased maintenance Unable to share content between language sites Performance was so poor (outside the US) our global site admins could no longer make changes

25. Project Goals (Beyond performance improvements) • Leverage investment across all platforms • Implement new, automated translation process • Redesign navigation and branding • Share content globally more easily • Provide our machine manuals with search functionality • Centralize management of product content • Reduce maintenance • Integrate with other business systems

26. Project Accomplishments • 7 months (start to finish) • 300+ pages of content from scratch • 18 language variations (3 brands) • Move to new hosted environment • SharePoint learning curve

27. Success Metrics Goals Actual 1-3 Success = Extraordinary User Experience

28. Lessons learned: Tips for others • Take your time for Envisioning • Detailed UI specs (from visitors and admins point of view) • Optimize for SEO from the start • Dedicated team on both sides • Onsite at Avtex with development team weekly • Common bug tracking tool - Bontq(UAT & development teams) • Executive sponsors for support • A plan for content updates – it isn’t a one time event • Plan for the unexpected!

29. Building on our success • New enhancements • Extranet with ecommerce capabilities • Intranet

30. Questions?

31. Driving Efficiencies Through Effective Planning & Budgeting with SharePoint 2010

32. Overview • Introduction to GNet Group • Key Business Processes: Planning and Budgeting • Case Study - Wilder Foundation • Microsoft SharePoint Composites & Insights • Planning and Budgeting Architecture • Demonstration • Links and More Information

33. About GNet Group • Managed Gold Certified Partner focused on Empowering Data Driven Strategies • Leading Provider of SharePoint and Microsoft BI Solutions • Finalist for Global Business Intelligence Partner of the Year 2011 • HQ in Minneapolis/Saint Paul, local office in Dallas, offshore development center in Pune, India

34. Key Business Processes Inefficiencies are Painful • Complex Processes with Unknown Status • Multiple Sources of the Truth and Information Silos Planning and Budgeting • Spreadmarts & Excel Jedis • Version X, Edited by Y, Reviewed by Z, FINAL COPY, “USE THIS ONE”, “OLD”, “OLD_v1”

35. Microsoft Case Study • Amherst H. Wilder Foundation • Legacy budgeting system reached EoL • Wilder wanted a SharePoint-based Microsoft BI solution • GNet Group created a SharePoint solution leveraging InfoPath forms services and the SQL Server BI stack • The solution: • Reduced planning effort by 50% • Provided a reliable, single source of truth • Strategically positioned SharePoint and BI stack providing future expansion and agility

37. GNet Planning and Budgeting Solution Architecture

38. Demonstration

39. For More Information Wilder Foundation Case Study http://www.microsoft.com/casestudies/default.aspx GNet Group Website http://www.gnetgroup.com Blog http://gnetgroup.wordpress.com YouTube http://www.youtube.com/user/GNetGroup LinkedIn GNetGroup Twitter@GNetGroup Microsoft SharePoint 2010 http://sharepoint.microsoft.com Office InfoPath 2010http://office.microsoft.com/en-us/infopath/

40. Q & A Panel http://www.sharepointmn.com

41. Last But Not Least • Please Fill Out Evaluations • Drawings for Giveaways

42. Thanks for coming! http://www.sharepointmn.com