Visualize Your ProjectPlace Data Using Power BI

 

Overview

With the Planview ProjectPlace OData data sets, you can extract and visualize your ProjectPlace data directly in Microsoft Power BI to interactively view key statistics, find out who your most active and productive team members are, and identify at-risk cards and activities across workspaces in your ProjectPlace account. You can also extend the out-of-the box dashboard and reports to get insights that are most important to you.

           

NOTE

Only account members can access ProjectPlace data via Power BI.  External members will not be able to access the data.

           

 

           

ProjectPlace OData Data Sets

ProjectPlace Power BI datasets are specifically designed to simplify the creation of reports and align the naming of data elements to match the current naming within ProjectPlace.

The following datasets are available for use with ProjectPlace OData Service 

View table descriptions for ProjectPlace OData sets for Power BI

Dataset for Workspace Managers - https://odata3.projectplace.com/pm

This dataset contains data for all workspaces that you own or are an administrator of:

  • Activities, boards, cards, and their related data
  • Workspace members and card assignments 
  • Issues and risks 
  • Estimated and reported time
  • Custom fields on cards and activities defined in your workspaces
  • Tags used on Cards or Issues/Risks in your workspaces
  • Workspace information such as Status, Department, Cost center 

You can also access information about archived workspaces. It is not enabled by default and a request needs to be submitted to Customer Support to have this data enabled. You need to be an Account Administrator to enable it for the account. Create ticket

Account Owners can submit a request to Customer Support to grant OData super user access to the dataset for workspace managers to a user. This role can only be granted to a user that already has Account Administrator privileges in the account. An OData super user will be able to generate reports based on data from all workspaces in the account, not only workspaces that this user is an owner or administrator of.

Dataset for Portfolio Managers - https://odata3.projectplace.com/portfolio

This dataset contains data about all portfolios that you own or are a stakeholder of:

  • Portfolio name
  • Workspace name and related information (e.g. department, status, milestones, etc.)
  • Status reports (i.e. all KPI data points reported on over time for that workspace)

Dataset for Account Owners and Administrators - https://odata3.projectplace.com/am

This dataset contains data related to people and workspaces in the account:

  • Information about People in the account (e.g. name, email, date they joined the account, role etc.)
  • Information about Workspaces in the account (e.g. name, head admin, date of creation, members count, last activity date etc.)
  • Link between People and workspaces and what role the user has in a specific workspace
  • Information about Requests and Custom Form Fields (e.g. name, type of request, the URL of the request, etc.)

 

Please note! When creating this template, we've set the relationship between the Activities table and the Card table to inactive, in order to make the Activities and Workspaces relationship and the Cards and Workspaces relationship active. This setting enables easy filtering of archived workspace data. Depending on how you would like to build your reports, you may want to update the relationships in the template file. Also remember that sometimes you may have activities without any cards on them yet, and there may also be cards on your boards that do not belong to any activity.

For customers who have a ProjectPlace Sandbox environment and would like to access data in this environment to create or test Power BI reports, the following URLs are available:

Sandbox in the EU datacenter:
https://odata3-sandbox-se.projectplace.com/pm
https://odata3-sandbox-se.projectplace.com/portfolio
https://odata3-sandbox-se.projectplace.com/am

Sandbox in the US datacenter:
https://odata3-sandbox-us.projectplace.com/pm
https://odata3-sandbox-us.projectplace.com/portfolio
https://odata3-sandbox-us.projectplace.com/am

 

           

           

Setting Up the ProjectPlace PowerBI Template with PVADMIN

​To set up the ProjectPlace PowerBI template for use with PVADMIN:

  1. Download the ProjectPlace PowerBI template file: projectplace_template_for_power_bi_for_desktop (V6).pbit
  2. In Planview Admin, an administrator must take the following actions to generate new OAuth2 client credentials:
    1. Click the Settings menu.
    2. On the Settings screen, click the OAuth2 credentials tab.
    3. Click Create OAuth2 credentials.
    4. On the Create new OAuth2 credentials screen, enter a Name for the credentials.
    5. Click the Application list and select the option that is appropriate for your environment, ProjectPlace Reporting Production or ProjectPlace Reporting Sandbox.
    6. Click Create OAuth2 credentials.
    7. Copy the ID and Secret into a text file; these will be used later in this procedure.
  3. In Power BI Desktop, open the template file.
  4. Click the OData URL list and select the appropriate value for your region.
  5. Click the PVAdminURL list and enter the appropriate value for your region.
  6. Enter the ClientID and ClientSecret from step 2 Planview Admin.
  7. Click Load.

 

        

clipboard_e2012ea4a6983bad0a142997aeb3a3117.png

Power BI Desktop automatically loads the predefined dimensions, models, and the relationships from the template and also the predefined visualizations

          

8. When prompted pr Authentication Type please select as shown in the image below

        

clipboard_e8d7f29ef9b6ab03164a194016157f404.png

          

Please note! When creating this template, we've set the relationship between the Activities table and the Card table to inactive, in order to make the Activities and Workspaces relationship and the Cards and Workspaces relationship active. This setting enables easy filtering of archived workspace data. Depending on how you would like to build your reports, you may want to update the relationships in the template file. Also remember that sometimes you may have activities without any cards on them yet, and there may also be cards on your boards that do not belong to any activity.

 

 

           

           

Setting Up the ProjectPlace PowerBI Template without PVADMIN

To set up the ProjectPlace PowerBI template for use without PVADMIN:

  1. Download the ProjectPlace PowerBI template file: PowerBI template for ProjectPlace (V4)
  2. In Power BI Desktop, open the template file.
  3. When Prompted, sign in and login to ProjectPlace, then click Connect.

        

clipboard_e5daaccee6aa6fbc66cf5d7658d5188d0.png

 

          

    

clipboard_ebe2f1722bdc6853c2efc2c6403970e1b.png

          

 

4. When prompted, allow Power BI to access your ProjectPlace information.

        

clipboard_edaadae656db6d5c6f99d84a1299d183a.png

          

5. Wait while the system loads the data. 

           

           

PowerBI Template Overview

The ProjectPlace PowerBI Template contains basic relationships between the data set tables and some example visualizations for Overall Progress, Card Summary, Work Distribution & Issues and Risks.

Work Progress Dashboard

This tab includes an overall view of the progress of the work by breaking the status of Cards, Activities, and Milestones across the different Workspaces. The visualizations can be filtered or sliced by Workspace, Board or Workspace Owner

            

clipboard_ef64c54c1481795fe04ad49fe2a7bfe3d.png

 

         

Card Summary Dashboard

This tab includes a detailed status of cards across workspaces analyzed by status, due date, label, board, and activity. This view also includes a burnup chart to analyze the throughput of work in time. The visualizations can be filtered or sliced by Workspace, Board, or Workspace Owner.

            

clipboard_e88005dc29c2992e61750d653d4d1ae1c.png

 

            

Work Distribution Dashboard

This tab helps in the analysis of work distribution and assignments. The treemap view allows slicing and/or visualizing the volume of cards by assignee, and additional details can also be seen in the data table. The work distribution is also broken by status and due date. The visualizations can be filtered or sliced by Workspace, Board, or Workspace Owner.

        

clipboard_e59adbb9e8e5e3b4f6d9424c41c6df396.png

 

          

           

 

  • Was this article helpful?
Leave feedback