|
Tracking Historical Project Activity Data using the Microsoft Business Intelligence Suite
|
Gabriel Guenette , Ubisoft
|
|
Deployment Administration & Developer
|
|
PC401
|
|
Customer
|
|
400
|
|
IT Professionals ,Developers ,Business Analysts ,Consultants
|
|
Project Server ,SQL
|
|
Business Intelligence
|
|
The session will describe a solution that enables the tracking of historical Project Server data. This information can then be used to analyze trends in the data or to highlight changes in reports from week to week automatically. The solution was developed with no programming skills using the Microsoft Business Intelligence product suite: SQL Server Integration Services is used to copy data from the Reporting Database to a custom tracking database. SQL queries and views are used to transform task level data such as project milestones so they can be reported on at the project level custom fields. SQL Reporting Services is used to generate and distribute reports. SharePoint is used to store the reports and present the reports on-demand to users. Week to week changes are identified in the reports by bolding the field value.
Users will be walked through the various components in the solution:
1) Building the SSIS package
a. Grab a copy of the current project server data from the reporting database and save a copy to a custom database
b. Track schedule milestones at the project level using a custom SQL query
2) Build the SSRS report
a. Build a report that highlights (conditionally formats) fields that have changed in the last 7 days
b. Scheduling the report to be sent automatically to users
3) Presenting the report in SharePoint
a. Present the report using SharePoint dashboards
b. Generate an HTML version of the report to improve viewing performance
|
1. Provide a solution to one of the most common end user questions - "What was that date last week?"
2. Develop a Business Intelligence solution using the full Microsoft Business Intelligence stack with no programming skills.
|
|
|