PC 329 Business Intelligence infrastructure deep dive in

PC 329 Business Intelligence infrastructure deep dive in Project Online and Project Server 2013

Business Intelligence

Project

Discover o. Data

http: //www. odata. org Project

https: //projectonlinedemo 329. sharepoint. com/sites/pwa/_api/Project. Data $format=json

/$metadata

• • • Sharepoint permission mode: Portfolio Viewers, Portfolio managers, Administrators Project permission mode Access project Server Reporting Service permission Depends on the tables, 100 (tasks) to 200 (issues)

• • • Start small Create your report Refine your query

Usage

$Select to reduces the number of properties $Filter to scale down the number of entries $Orderby, $Top, and $Skip to arrange the returned fields $expand $link Excel 2013 uses the Association elements to help create for pivot tables and other models.

https: //projectonlinedemo 329. sharepoint. com/sites/pwa/_api/projectdata /Tasks? $select=Task. Name, Project. Name, Task. Actual. Duration, Task. Finish. Date, Task. Percent. Completed This seems obvious, but it is often overlooked by BI users. Look back at your reports and updates the queries to only the get the data you really need.

? $select=Task. Name, Project. Name, Task. Actual. Duration, Task. Finish. Date, Task. Percent. Completed&$orderby=Task. Percent. Completed desc&$top=20 When you only care about the top

$filter=Task. Actual. Duration gt 10 $filter out inactive projects, non relevant tasks to reduce the size of your download even more. Equal, Greater than, Or ….

You can also do this programmatically guid'b 28 fc 3 ef-99 bf-e 111 -9 f 1 e-00155 d 022681')

Int month(Date. Time P 0) - $filter=month(Task. Finish. Date) bool substringof(string po, string p 1) – More functions on www. odata. org

Project Online Windows Azure OData

Gear / Sites settings Site Collection features

Project Server / Project Online Project

On Prem Online § Domain Joined § Non-Domain Joined § O 365 credentials

Before you go

• Easy to use • Use Microsoft BI stack • Pay attention to your queries • New SSIS connection scenario

Session Introduction to Microsoft Visio: A Swiss Army Knife for PMs Building Stellar Project BI Dashboards with Visio Real World Reports: Business Intelligence in Project Online and Project Server 2013 Reports That Jump Off the Screen with Microsoft Project Desktop Business Intelligence Infrastructure Deep Dive in Project Online and Project Server 2013 Session Room Time PC 245 204 C MON 11: 15 PC 222 203 B MON 5: 00 PC 248 202 AB PC 232 201 B PC 329 204 A TUE 10: 30 TUE 1: 45 WED 12: 00

http: //bit. ly/1 eo. Wq. Je http: //bit. ly/1 n 9 Bghv http: //bit. ly/1 c 2 Dh 9 V http: //bit. ly/1 dp. Nhdl http: //bit. ly/1 atok. CS

My. PC fill out evaluations & win prizes! Fill out session evaluations by logging into My. PC on your laptop or mobile device. Evaluation prizes daily! Claim your prize at the Registration Desk on Level 1. www. msprojectconference. com After the event, over 100 hours of resources; including all of the PPT decks and session videos will be available.