Expand my Community achievements bar.

Reporting between Workfront and Jira

Avatar

Level 3
Hello, We are going to be using multiple tools to manage the different kinds of work in our organization. For example, we're moving the help desk items to ManageEngine. For projects, a shell will be created in Workfront and the daily work will be managed in Jira. All of the resource capacity and demand will be built out in Tempus. We're looking at using Power BI for pulling all the information together. Has anyone done anything similar? If so, do you have any advice? Thank you, Barb Barbara Gehling United Fire Group
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10
Hi Barbara, We have a similar scenario although with some diffferent products. We use ServiceNow for helpdesk, Workfront for PPM and are starting out with Jira for our development team soon. We already use PowerBI for Workfront-related reporting and are starting to use it for other reporting scenarios. We don't have any additional resource management solution....our preference is to try to use Workfront where possible and push for product development where it doesn't work for us. In reality we do most of our resource analysis outside Workfront in PowerBI at this point. Interested to hear what you get out of Tempus. Is your main question regarding PowerBI advice? If so - I expect you will be wanting to connect PowerBI to refresh directly from Workfront's API. There are a few tricks involved in getting this running as there is no out-of-the-box connector but we now have it running nicely. Depending on what sort of reporting you want to do, there is some cool stuff you can do with the Assignments object, using the data in the resourceContours collection and workPerDayList field. By merging the results carefully you can end up with the exact planned (contoured) hours of work per assignment per person per day. Feel free to ask any questions if you'd like to know more. Regards, David David Cornwell