Workfront and Tableau

[SupriyaPa]

Hi All, We are looking into Tableau to meet some of our reporting needs that Workfront cannot meet. Is anyone using Tableau for workfront data? Is there a connector involved or is it done through API updates. I cannot find lot of articles on how Tableau can be connected to Workfront. An insight into this will be very useful. Thank you all in advance Supriya Pandey PMP New York University

[SkyeHa]

@Carol-Lyn Jardine -- did you see this question? 🙂 -skye

[VickyFi]

Hi Supriya Out of interest what reports are you trying to do in Workfront that you aren't able to? I am always getting new report requests and interested in the kinds of reports others are using. Thanks Vicky Fitzgerald Telegraph Media Group Limited

[MichaelSt5]

We are trying to solve this as well - do you have time for a call to brainstorm and share ideas? Get "https://aka.ms/o0ukef">Outlook for iOS

---

This e-mail message is intended only for the use of the recipient(s) named above. This message may be privileged and confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication by mistake, please notify us immediately by e-mail and delete the original message. Thank You.

[SupriyaPa]

It is a summary of project status reports - some visuals, we are still gathering specifications. Workfront gives reports and dashboards but that is not always what appeases executive level/ I think it will be a good idea for us to start a thread to see what are the reports and dashboards that others are using. Supriya Pandey PMP New York University

[UlanaIl]

Supriya can you share a sample of a Tableau report being pulled from Workfront? Thank you!

[MichaelSt5]

For instance - we are trying to create a report in Tableau with Workfront data that shows a list of projects as rows and tasks as columns similar to the milestone report. What would be in each cell of the report grid would be who is assigned to that task on that project. Get "https://aka.ms/o0ukef">Outlook for iOS

---

This e-mail message is intended only for the use of the recipient(s) named above. This message may be privileged and confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication by mistake, please notify us immediately by e-mail and delete the original message. Thank You.

[Dr_DougWi]

I have been tinkering with Tableau reporting designs for Workfront. I have found that the data needs to be exported and then reloaded to a data source that connects with Tableau. It is not that hard, but does take some extensive design for how and what you want to see. There is no master schema for Tableau per se, resulting in having to build it in Workfront to get the data out and in Tableau to link all the tables correctly. Once the data source and structures are there in Tableau, the playground is ready. However, data refreshes are a different story, requiring a strategy for one time use on the data or an update tracking for data over time. This is all I have encountered in my exploring time so far. Maybe I will get back to the tinkering in Spring. I have a license for Tableau for school and wanted to see what it can do for data analysis. Doug Williams

[BruceSt1]

I am using Tableau for several visualizations of Workfront data that are not achievable within Workfront. As Doug mentioned there is not a direct connector from Tableau to Workfront, you need to retrieve the data from Workfront via the API and write it to a local data source that Tableau can access. Tableau can read from a large variety of sources, in my case I am simply using delimited text files. The API work - defining the data required, designing the "database", and writing the code to download and format the files - has been where the heavy lifting has been. Like Doug said, once the data is there, Tableau can do pretty much anything with it. Good luck! Bruce Starrett MXM

[Doug_Den_Hoed__AtAppStore]

Hi Bruce, For those looking to dabble with Tableau while avoiding the heavy lifting you mentioned, I invite them to consider our "http://store.atappstore.com/product/workfront-snapshot/">Workfront Snapshot solution, which exports to a Microsoft Access database format, and then connects easily to Tableau, as per this "https://www.youtube.com/watch?v=U3KUJJdpYFE">instructional video (and many others). Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[SupriyaPa]

Thank you Doug and Bruce and everyone. We have a tableau team and they will be looking into it. I wanted to understand what workfront capabilities are in terms of connector and sounds like API is the best way to go. Where can I get data dictionary on all the API? and also some information on API calls. Supriya Pandey PMP New York University

[davids25390277]

Here some API information.

[DavidCo3]

I'm actually using Microsoft Power BI with Workfront data. Like Tableau, there is no out-of-the-box Workfront connector for Power BI, however, much of the principles are the same. Most of the early reporting I have done has been based on manually exporting data to Excel from Workfront reports, then using these sheets as data sources in Power BI. However, I've progressed onto using the Workfront API as a source from which to load data into the data model in PowerBI. As everyone else has said, the majority of the complexity is in working out what data you need, getting it out of Workfront and into your data model. From there on, producing some cool visualisations is the fun and easy part! Keen to hear if there are any other Power BI users out there. I also spent a fair amount of time reviewing Tableau. Whilst the visualisations are a little more slick in Tableau, I found PowerBI much more flexible/powerful when working with data. Things that were really hard in Tableau and required extensive/complex hacks (LoD calculations in Tableau) seemed to just work in PowerBI. There are also loads of good add-on visualisations in the Power BI store for low or no cost. It also is a fair bit more cost-effective. So far, so good anways.... Cheers David Cornwell

[JamieHi]

Hi David, I'm doing *exactly* the same r.e. taking Excel exports of reports I've built in Workfront and putting them in to Power BI. I'll start turning into a grumpy analyst soon haha. How have you used the API to put data into Power BI? Do you dump it into a database and then connect that to Power BI or? 🙂 Jamie Hill JLL

[DavidCo3]

Hi Jamie, So far, I've set it up so that Power BI Desktop connects directly to Workfront's API as a web data source for each Workfront object type I want, using API queries I've written to give me the various fields I want. For each object type (projects, tasks, assignments etc) it drags down the records 2000 at a time and stores these temporarily as tables while the queries execute. At the end, it combines the tables together into one table per object type, which I can then use for my visualisations. As PowerBI doesn't support incremental load, this solution will only give you one snapshot of data as at the time you refresh the data. If trending is required you would need to implement some other solution to execute the queries and store it in a data warehouse which you would then connect PowerBI to as a data source. We will likely do this at some point. So far for trending, I have not used the API and instead save exported workfront report outputs in Excel format in a folder each day/week and then use that folder as a data source, and use a date from the file name as the snapshot date for doing trend reporting. I'm really keen to hear of your experiences with whatever you do with PowerBI, so please let me know. Cheers, David Cornwell

[KirstenHe]

Hi @David Cornwell , I'm also connecting to Power BI with Workfront's API and pulling projects based on the criteria I need. It works fine, but I haven't found a way to pull custom data - are you doing that? I have a main query that pulls all the tasks from one project (based on project ID). I turned the project ID into a parameter, parameterized my URL from the main query, and then I created a custom function that references my parameter. So, now I have a list of all projects that I want and by using the custom function, I'm able to run my main query for each project in the table by just clicking on that line. It's great because I have a list of all the projects and I can navigate to the list of each project's tasks depending on which I'm interested in. However, much of the data I want to report on is sitting in custom fields on those projects/tasks. Wondering if you've had any success or tried pulling custom data, or if you stick to Workfront standard items. Thanks! Kirsten Heikkinen Trek Bicycle Corporation

[DavidCo3]

Hi @Kirsten Heikkinen - yes, you can definitely access custom fields on any object type. Just enter it in the following format: DE:InsertYourFieldName Cheers David Cornwell

[KirstenHe]

@David Cornwell How does that look in the URL? Right now I've added &fields=* to return all the fields for a task. Thanks for the help!! Kirsten Heikkinen Trek Bicycle Corporation

[DavidCo3]

Hi @Kirsten Heikkinen , You could use the following if you wanted to add a single custom field to your existing query: &fields=*,DE:InsertYourFieldName Obviously you are using * to return all the standard fields. There is an equivalent which will return all custom fields, called parameterValues. So if you wanted all standard and custom fields on an object you can use: &fields=*,parameterValues A word of caution though....I prefer to specify the actual fields that I'm interested in. This makes your queries/refreshes faster, and will also make your data model smaller (and therefore faster / more efficient) in PowerBI. By all means, you can use the options to get all fields while you're working out what you need, but then it's a good idea to change over to specifying the fields you need. Hope this helps! p.s. I was out riding my Trek on the weekend! Regards, David Cornwell

[KirstenHe]

Thanks, @David Cornwell . This is super helpful! Happy to hear you were out riding! Any weather is biking weather 🙂 Kirsten Heikkinen Trek Bicycle Corporation