project management in sharepoint · 2020. 5. 29. · •sharepoint information architecture...
TRANSCRIPT
![Page 1: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/1.jpg)
Project Management in SharePoint
Steve PucelikSr Premier Field Engineer - Microsoft
![Page 2: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/2.jpg)
Agenda
• Project Management Activities
• SharePoint Information Architecture
• Managing the Project
• SharePoint Search
• Power BI reporting
![Page 3: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/3.jpg)
Project Management Activity
![Page 4: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/4.jpg)
Planning is a life skill
![Page 5: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/5.jpg)
Typical Project Lifecycle
SummaryProject kickoff and setting expectations.
Assets• Project Site• Documents
SummaryMeet with stakeholders and gather requirements and build the project plan.
Assets• Documents• Tasks• Risks
SummaryBuild the solution using the requirements.
Assets• Documents• Tasks• Issues• Risks
SummaryDeliver the solution to the customer.
Assets• Documents
• Issues
• Risks
Iterative
Initiation Planning ExecutionSupport and
Close Out
![Page 6: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/6.jpg)
Project Dashboard
• One place for users and project managers to view project information
• Displays only tasks/issues assigned to you across projects
• Refiners for easily find specific projects
• All Search/content type driven
![Page 7: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/7.jpg)
Information Architecture
![Page 8: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/8.jpg)
Site Hierarchy
![Page 9: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/9.jpg)
Content Type Structure
• Created at the site collection root
• Standard Site Columns/Content types
• Used SharePoint site columns where you can
• This is CRITICAL for a targeted search experience
![Page 10: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/10.jpg)
Project site template
• Standard way of creating new project sites
• Created using standard SharePoint subsite creation process
• Project Template contains all lists/libraries/content types
• Does not carry forward branding/logos
• Typically created in the \projects site but not required
• Security can be set at the site level or inherited depending on the project sensitivity
![Page 11: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/11.jpg)
Managing the project
![Page 12: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/12.jpg)
Project Status List
• Every project has this list
• 1 item list using the ProjectStatus content type
• Project managers should update this with project demographics
• Uses the ProjectStatusContent type – critical for rolling up information using search
![Page 13: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/13.jpg)
Tasks are tasks…issues are issues…
• Manage tasks, issues and risks like you normally would.
• Documents are documents that every project has and is essential for a successful implementation.
• Keep it simple and don’t over engineer it. This is where people start to get confused and shut down.
![Page 14: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/14.jpg)
SharePoint Search
![Page 15: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/15.jpg)
Project Dashboard
• Content Search web part is your friend
• Managed Properties for the columns displayed need to be setup
• Display templates control the presentation
• Everything is content type driven.
![Page 16: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/16.jpg)
Managed Properties
• Map the crawled property to a managed property
• Use the Refinable* managed properties.
• Refiners rely on these
• Re-index the list/library if you’re properties don’t show up
![Page 17: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/17.jpg)
KQL targets the content
types
![Page 18: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/18.jpg)
Display Templates -Design
• Edit both the control and item templates in SharePoint Designer
• Managed properties drive the display values
• Publishing feature needs to be enabled to generate the .js file
• A little HTML/JavaScript and you’re done!
![Page 19: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/19.jpg)
Item Template
• Change the <title> to something more descriptive. This is what users will see when selecting an item template in the web part properties pane
• Add the managed properties from the content type• The names MUST match the managed property value in the
search schema
![Page 20: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/20.jpg)
Control Template
![Page 21: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/21.jpg)
Property Mappings
• The mappings that you specify on the Item template populate the property mapping in the web part properties
• These must match what is in the mapping properties element of the item template
![Page 22: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/22.jpg)
Refiners
• The Refinable* managed properties will be available in addition to the SharePoint reserved properties
• Review the Sample Values to make sure you have the right one
• Provide a friendly name for the Display name
![Page 23: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/23.jpg)
Power BI
![Page 24: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/24.jpg)
Project Summary
![Page 25: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/25.jpg)
Task Summary
![Page 26: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/26.jpg)
Risk Summary
![Page 27: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/27.jpg)
It’s all REST based
• Each data source has a parameter for the REST query you want to execute
• Querystring based parameters against the search API
• Query parameter is the KQL
• SelectProperties – managed properties that become “table” fields
https://<SiteCollection>/Projects/_api/search/query?querytext='contenttype:ProjectStatus'&selectproperties='Path,Filename,Title,Author,ProjectTitleOWSTEXT,ProjectStatusOWSCHCS,ProjectPriorityOWSCHCS,DeadlineOWSDATE,AssigneeOWSUSER,CurrentUpdateOWSMTXT,PercentCompleteOWSNMBR,ProjectStartDateOWSDATE,Created,LastModifiedTime,ProjectEndDateOWSDATE,WebTemplate,ProjectRequestor123OWSUSER,ProjectDescriptionOWSMTXT'&rowlimit=500
![Page 28: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/28.jpg)
Transforming the JSON Response
• All REST responses are in the JSON format.
• Within Power BI we can “tablefy” the results (get it into rows and columns)
• The resulting table can be used in our dashboards and reports
![Page 29: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/29.jpg)
Transforming the JSON Response
• End result is rows and columns
• Use this in you’re PowerBI dashboards and reports
• Power BI takes care of all the “plumbing”. All you need to do is get the REST query right
![Page 30: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/30.jpg)
Work with the results
• Focus on using the *SearchResult “table” for your dashboards and reports
• Normal PowerBI functionality applies
• Simply refresh the data sources for current results from the search index.
![Page 31: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/31.jpg)
References
• Display Templates in GitHub
• KQL Cheat Sheet
• PowerBI template for any REST query
![Page 32: Project Management in SharePoint · 2020. 5. 29. · •SharePoint Information Architecture •Managing the Project •SharePoint Search •Power BI reporting. Project Management](https://reader034.vdocuments.us/reader034/viewer/2022051920/600d18843146c76b375a1043/html5/thumbnails/32.jpg)
Questions