1 / 49

Presentation to Baltimore-Washington DC Metro MPUG Chapter September 22, 2009

Presentation to Baltimore-Washington DC Metro MPUG Chapter September 22, 2009. Thank You!. There are no users without you. MPUG Benefits You. What is MPUG. What is MPUG? Why did you change back to MPUG from MPA?. Users’ Group

mulan
Download Presentation

Presentation to Baltimore-Washington DC Metro MPUG Chapter September 22, 2009

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Presentation toBaltimore-Washington DC Metro MPUG ChapterSeptember 22, 2009

  2. Thank You! There are no users without you.

  3. MPUG Benefits You What is MPUG

  4. What is MPUG? Why did you change back to MPUG from MPA? Users’ Group (also users group or user group). A type of club focused on the user of a particular technology, usually (but not always) computer related.Wikipedia, http://en.wikipedia.org/wiki/Users%27_group

  5. What is MPUG? • A users' group may provide its members (and sometimes the general public as well) with one or more of the following services: • Public Lectures • A newsletter • A library of media or tools • A software archive • An online presence such as dial-up BBS or Internet website • Swap meets • Technical support • Social Events

  6. Mission To be one of the most impactful users’ groups in the world.

  7. How to Get There • Improve our benefits and support • Grow our chapter and user base to increase our collective knowledge and skills • Enjoy it “It's so great to know that we are a user group again! We are excited to bring the focus back to using the product in your job. With the organization we are re-introducing labs to our MPUG meetings”. --John Sage, Tampa Bay Chapter, MPA Chapter Leader Meeting April 2008

  8. MPUG Benefits You

  9. New and Improved Benefits • Newsletter – biweekly communication • Career Center • Dedicated to the Project Management Profession • Free for members to post or apply. Just log in with your user name and password • WebNLearns • Several Online trainings each month • Free for Members • Recordings on demand

  10. New and Improved Benefits • Searchable, Scalable SharePoint Portal • Site Developed and Evolving • Document library. Expanded daily • Collaborate with peers locally and globally online • Technical support discussion board (MPUF) and blogs • Led by MPUG moderator (s), Microsoft MVP’s

  11. MPUG Portal. A Massive Investment

  12. Upcoming Global WebNLearns • Phoenix Chapter WebNLearn: Baselining, Tracking, and Reporting - Module 3 • Using SQL Reporting Services with Project Server 2007 • Twin Cities WebNLearn: Building SharePoint Dashboards • Microsoft Project for the Beginning User - Learn From the MVP • Microsoft Project for the Intermediate User - Learn From the MVP • “More Tips and Tricks from eDale, MVP” • Microsoft Project for the Advanced User - Learn From the MVP

  13. Contact MPUG • General MPUG Information info@mpug.com • Chapter Relations Chapters@mpug.com • Event Inquiries Events@mpug.com • Newsletter Editor Editor@mpug.com • Advertising Advertise@mpug.com

  14. Reporting in MS Project and SQL Server Reporting Services Gerald Leonard PMP, MSTC, CQIA and ITIL Agenda What is SQL Server Reporting? Reporting Questions Challenges Benefits of Enterprise Reporting Reporting Lifecycle Reporting Show and Tell

  15. What is SQL Server Reporting? SQL Server Reporting Services enables organizations to transform raw and valuable enterprise data into shared information for insightful, timely decisions at a lower total cost of ownership.

  16. Reporting Questions What reports do you currently use or create? What data is important in these reports? How do you use the information on these reports? How do you (would you if you could) place parameters on these reports? How do you get reports today? What type of routine/recurring analysis do you perform? What data is used? How often do you perform this analysis? How do you get the data required? What do you do with the data once you get it?

  17. Challenges Manual Reporting from Multiple data sources Manual reports are out of date as soon as they are created. Unclear Distribution Channels Project Status Reports are usually not based on true schedule updates

  18. Benefits of Enterprise Reporting It’s Free with your installation of SQL Server 2005 and higher A centralized repository for your enterprise reporting needs Reports can be exported in different formats Reports can be distributed through email or posted on a SharePoint or Network site. Greater visibility for your Executive Management Team.

  19. Reporting Lifecycle Creating Managing Delivering Reports

  20. Reporting Show and Tell Project Center Reporting displaying Health, Schedule, Budget and Work status. Customized Weekly PM Status Report Monthly Project Review Report Additional Reports from the Report Pack Customize Time Tracking and Utilization Reports Project Reporting in Project Server 2010

  21. LOB Systems Project Server and SQL Server Environment Team members and executives Project and resource managers

  22. Project Center Reporting

  23. Schedule Status Formula

  24. Schedule Status (cont)

  25. Weekly PM Status Report

  26. How Reports are created?Business Intelligence Development Environment

  27. SQL Script in BI Development Environment

  28. Layout View

  29. Preview Pane in BI Dev

  30. Preview (Cont)

  31. Report Server Admin Site

  32. Additional Server Config.

  33. Monthly Project Review

  34. Time by Project Chart

  35. Hours by Classification Pie Charter

  36. Resource Capacity and Demand

  37. Timesheet Tracking

  38. Time by Department

  39. Project Details

  40. Project Type Details

  41. The Future of Project Server Reporting Personal BI “My Ad-Hoc Needs” Department BI “My Group’s Needs” Enterprise BI “My Company’s Needs” Project Visual Reports SQL Server Reporting Services Performance Point Services Excel Services Visio Services SQL Server 2008 R2 Self Service BI

  42. Project Server Database Architecture Transaction Reporting Draft IT Analysis HR Analysis Marketing Analysis DB SharePoint Relational Reporting Relational Metadata Edit Publish Backup/Restore Analysis DB Build Metadata Edit Publish Archive

  43. Work Management Solution

  44. Simple and Intuitive User Experience • Ribbon UI and Backstage View • Intuitive Excel-like behavior • Timeline View • Team Planner • Connect teams with SharePoint Sync Enhanced Collaborationand Reporting Simple and Intuitive User Experience Scalable and Connected Platform Unified Project and Portfolio Management

  45. Enhanced Reporting • Built on SharePoint Server 2010 • Easily create reports and dashboards • Better time and status reporting • Web-based project editing • Ribbon UI and Backstage View • Intuitive Excel-like behavior • Timeline View • Team Planner • Connect teams with SharePoint Sync Enhanced Collaborationand Reporting Simple and Intuitive User Experience Sites Sites Composites Composites Communities Communities Scalable and Connected Platform Unified Project and Portfolio Management Insights Insights Content Content Search Search

  46. Unified Project and Portfolio Environment • Built on SharePoint Server 2010 • Easily create reports and dashboards • Better time and status reporting • Web-based project editing • Single Server with end-to-end PPM capabilities • Flexible project capture and initiation • Enhance governance through workflow • Powerful portfolio selection analytics Enhanced Collaborationand Reporting Simple and Intuitive User Experience Sites Composites Communities Scalable and Connected Platform Unified Project and Portfolio Management Insights Content Search

  47. Scalable Platform • Single Server with end-to-end PPM capabilities • Flexible project capture and initiation • Enhance governance through workflow • Powerful portfolio selection analytics • Extended Interoperability • Simplified Administration • Rich Platform Services • Improved Developer Productivity Enhanced Collaborationand Reporting Simple and Intuitive User Experience Scalable and Connected Platform Unified Project and Portfolio Management

  48. Microsoft Project 2010 Product Packaging Target Audience Individual and Part-Time Project Managers Professional Project Managers IT, PMO, Engineering, R&D, Product Development, Operations

  49. Q&A

More Related