![Page 1: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/1.jpg)
1
Planning and Tracking Projects with VSTS 2010
By Ahmed Nasr
![Page 2: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/2.jpg)
2
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 3: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/3.jpg)
3
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 4: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/4.jpg)
Project Management
• Enable our process, your process, no process• Value propositions
– Customize to your process• Excel reports• Simplified warehouse• Relational warehouse• Excel reporting
– Easier to share• Richer dashboards• MOSS support• Web parts
![Page 5: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/5.jpg)
5
Project Management, continued
• Value propositions– Rich traceability
• Hierarchy• Custom work item links• Link queryability
– Better SCRUM support• Agile workbooks• Simplified template• New guidance
– Scalable• TFS Basic• Cross project reporting
![Page 6: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/6.jpg)
6
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 7: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/7.jpg)
Demo
Scrum Planning with TFS 2010
![Page 8: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/8.jpg)
8
Updating Tasks
Multiple interfaces for updating work
items
![Page 9: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/9.jpg)
9
Updating Tasks
Team Explorer
![Page 10: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/10.jpg)
10
Updating Tasks
Iteration Backlog workbook
![Page 11: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/11.jpg)
11
Updating Tasks
Team Project portal
![Page 12: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/12.jpg)
12
Updating Tasks
![Page 13: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/13.jpg)
13
Tracking Progress
Burndown chart tracks remaining and completed
work
![Page 14: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/14.jpg)
14
Tracking Progress
![Page 15: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/15.jpg)
15
Tracking Progress
![Page 16: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/16.jpg)
16
Tracking Progress
Detailed sprint progress is tracked on
the project portal
The burndown shows the team on track…
And almost half of the tasks remain
openBut the team hasn’t closed any
of the three stories…
![Page 17: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/17.jpg)
17
Tracking Progress
The Scrummaster opens an issue to track the problem
the portal has identified
![Page 18: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/18.jpg)
18
Tracking Progress
The issue is opened and tracked in TFS
![Page 19: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/19.jpg)
19
Tracking ProgressRich set of reports
track progress
![Page 20: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/20.jpg)
20
Retrospective Capture retrospectives using the Team wiki on the
Project Portal
Sample documents are provided as a
guide
![Page 21: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/21.jpg)
21
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 22: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/22.jpg)
22
User Story
Test TaskBug
Code
Traceability for MSF Agile 5.0
Parent/ChildRelated
Tests/Tested By
Change Sets Change SetsCode Coverage
![Page 23: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/23.jpg)
23
Traceability for MSF CMMI 5.0
User Story
Test TaskBug
Code
Parent/ChildRelated
Tests/Tested By
Change Sets Change SetsCode Coverage
Requirement
Predecessor/Successor
Change RequestAffects/ Affected By
![Page 24: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/24.jpg)
24
Link Topology Types
Dependency
Network Directed Network
Tree
![Page 25: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/25.jpg)
25
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 26: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/26.jpg)
Demo
Excel Reporting
![Page 27: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/27.jpg)
27
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 28: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/28.jpg)
Dashboard: SharePoint Server
Are we making progress on running
test plans?
How are our builds doing over time?
Are we fixing bugs?What’s the quality of
our bug fixes?
![Page 29: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/29.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
Are we getting enough coverage?
How many lines of code are we churning?
![Page 30: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/30.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 31: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/31.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 32: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/32.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 33: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/33.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 34: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/34.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 35: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/35.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 36: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/36.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 37: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/37.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 38: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/38.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
Chart now shows Active and Resolved
bugs
![Page 39: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/39.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
Standard Excel chart so properties can easily
be modified
![Page 40: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/40.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 41: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/41.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
I can now publish the updates back to my
dashboard
![Page 42: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/42.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 43: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/43.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 44: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/44.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 45: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/45.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
Reload the workbook to clear Excel Services
cache so that the updates show up
immediately
![Page 46: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/46.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 47: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/47.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
![Page 48: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/48.jpg)
Dashboard: SharePoint Server
Reporting in 2010 | Custom reports | Making transparency work
My dashboard shows active and resolved bugs
now - that was easy!
![Page 49: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/49.jpg)
49
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 50: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/50.jpg)
50
Relational Reporting
Reporting against relational warehouse
is supported!
-- MDX --SELECT{ [Measures].[DateValue], [Measures].[Work Item Count]} ON COLUMNS,{ CrossJoin( [Date Range], [Work Item].[System_State].[System_State] )} ON ROWSFROM(SELECT CrossJoin( StrToSet(@AreaParam), StrToSet(@IterationParam), StrToSet(@StateParam), StrToSet(@PriorityParam), StrToSet(@SeverityParam) ) ON COLUMNS FROM [Team System])
-- SQL--SELECT history.[System_Id] AS ID, MAX(history.[System_ChangedDate]) AS Latest
FROM @Hierarchy hierarchy INNER JOIN [WorkItemHistoryView] history ON hierarchy.ID = history.[System_Id]
WHERE (history.[System_ChangedDate]< @ChangeDate)
GROUP BY history.[System_Id]
Write this…
… instead of this
![Page 51: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/51.jpg)
51
Relational Reporting
What’s supported?
• Tables in the warehouse database that have names that don’t start with ‘_’ E.g. DimWorkItem.
• There are a set of helper views – view names that don’t start with ‘v’ E.g. CurrentWorkItemView.
• All Table-Valued Functions
What’s not?
Tables starting with ‘_’ and views starting with ‘v’ are only for system use i.e. subject to change in future release
![Page 52: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/52.jpg)
52
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 53: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/53.jpg)
Tools and reportsP
ower
Learning curve
Business Intelligence
Development Studio (BIDS)
Excel
ReportBuilder
• Sharing chart in an email• Shared with team on SharePoint Server
dashboard
• RS report for sharing with team on SharePoint Foundation dashboard
• Upload to team project reporting site that you can subscribe to
Complex RS report
![Page 54: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/54.jpg)
What kind of reports can I build using these tools?
Excel
Individual current or trend charts
![Page 55: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/55.jpg)
What kind of reports can I build using these tools?
ReportBuilder
Multiple charts showing data in a single RS report
![Page 56: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/56.jpg)
What kind of reports can I build using these tools?
Business Intelligence
Development Studio (BIDS)
Complex RS reports with
custom visualization
![Page 57: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/57.jpg)
Reporting Out of the Box - Summary
DashboardsSharepoint WSSSharepoint Office Server System
ReportsCreate Excel Report from QueryAd-Hoc Excel ReportingSQL Report DesignerSQL BI Studio
Data AvailabilityData Warehouse (MDX, Excel Reporting)Relational Warehouse (SQL)Extensibility Layer to Import External Data into Warehouse
![Page 58: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/58.jpg)
58
Agenda• Project Management• Scrum Planning (Demo)• Traceability and Link Topology• Excel Reporting (Demo)• Dashboard and Ad Hoc Reporting• New Relational Reporting• What to Use• VS2010
![Page 59: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/59.jpg)
59
Visual Studio 2010
![Page 60: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/60.jpg)
60
Test Manager 2010
Manual Testing
Layer Diagram
UML Modeling
Load Testing Web Testing
Test Case ManagementIntelliTrace™
Architecture Explorer Fast Forward for Manual Testing
Logical Class Designer
Cloud Development
Office Development
Windows Development
New WPF Editor Customizable IDE
Multi-core DevelopmentSilverlight Tools
Web Development
SharePoint Development
Generate from Usage
Static Code Analysis
Database Deployment
Code Metrics
Database Unit Testing Test Data Generation
Test Impact AnalysisUI Test Automation
Code Coverage
Performance Profiling
Database Change Mgmt
![Page 61: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/61.jpg)
61
Test Manager 2010
Test Case Management
Fast Forward for Manual Testing
Manual Testing
Lab Mgmt Config.
Checkpoint Environment
Environment from TemplateVirtual Env. Setup/Tear Down
Reporting
Team Portal
Test Case ManagementBranch Visualization
Version Control
Build Automation
Gated Check-in
Agile Planning Tools
Team Explorer
Team Agents
![Page 62: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/62.jpg)
Q& A
![Page 63: Planning and Tracking Projects with VSTS 2010 By Ahmed Nasr 1](https://reader036.vdocuments.us/reader036/viewer/2022070407/56649e435503460f94b367b2/html5/thumbnails/63.jpg)
63
References
• Brian Harry’s Presentation in Teched Europe about Lap around VS2010 Project Management
• Stephanie Saad Cuthbertson Presentation in Teched Europe About Planning and Tracking