Manage your project portfolio and capacity planning in Meisterplan and find new ways to visualize your data in Google Looker Studio (formerly Google Data Studio). You can also combine your Meisterplan data with data from other solutions and take advantage of the many different analysis options. Find out more at meisterplan.com.

• Prerequisites
• Loading Meisterplan Data in Google Looker Studio
• Report Template for Google Looker Studio
• Customizing the Report Template

Prerequisites

The following prerequisites must be met to access Meisterplan data with Google Looker Studio:

• To create reports and access our report template in Google Looker Studio, you need to be signed into a Google account.
• In Meisterplan, you need to have the Access Meisterplan APIs and Connect External Applications right.

Before You Start
Due to how Google Looker Studio is designed, not every combination of Meisterplan data in Google Looker Studio is feasible or meaningful.
For example, when combining milestones and allocations, the custom dates for milestones do not match the aggregated time grid of allocations. This is because Google Looker Studio uses "flat" data models, meaning you will need to combine different tables into one big table.
If you want more flexibility, you can check out BI solutions such as PowerBI or Tableau.

Loading Meisterplan Data in Google Looker Studio

To load your Meisterplan data in Google Looker Studio, you need to use our Google Looker Studio Connector.

Google Looker Studio Connector and On Premise
The Google Looker Studio Connector cannot be used with On Premise systems.

Follow the steps below to connect Meisterplan data with Google Looker Studio:

1. Go to lookerstudio.google.com/data and select the Meisterplan Connector.
2. After you have selected the connector, click Authorise and then enter your Google account credentials:
   
3. Now you need to authorize Looker Studio to access your Meisterplan system. First, select the region that your Meisterplan system is located in:
   
   You can find the region at the beginning of your Meisterplan system's URL. It's the first two letters after "https://". Click Continue.
4. Next, enter your Meisterplan login credentials:
   
   After you have entered your Meisterplan credentials, click Authorise.
   Google Looker Studio is now connected to your Meisterplan system, and you can start loading your data.
5. First, select the data type you would like to load (the data types correspond to the Reporting API endpoints):
   
6. Next, enter further details:
   
   In the top right, click Connect.
7. You will now see the Data Source Editor with a list of all fields that have been imported with the data type selected. In the top right, click Create Report to continue:
   
   The report editor will now open and you can start creating your reports. For information on how to do so, go to the Looker Studio Help.
8. If you would like to include more Meisterplan data in your report, simply click Add Data in the toolbar above the report and repeat steps 4-6:
   

Date Range
Google Looker Studio always imports all available data of a data type regardless of the date range defined in Meisterplan. If you would like to limit the date range for your report, you can do so when building the report in Google Looker Studio.

To learn more about how to create, share and manage reports in Google Looker Studio, see the Looker Studio Help.

Report Template for Google Looker Studio

Get a complete view of your portfolio including portfolio status and resource allocations with bubble charts, diagrams and organized lists. You can always customize the report parameters to ensure the report best suits your individual needs. You can also find these templates in Meisterplan in the left sidebar under Integrations.

Meisterplan Portfolio Report Template

1. Click on the link above to access our Google Looker Studio template.
2. If you have not yet authorized your Meisterplan system for Google Looker Studio, you can find information here.
3. Refresh the Google Looker Studio template after the authorization to see your data. Without refreshing, the authorization will not be recognized throughout the template.

The template contains five views, which you can select from the left sidebar.

Custom Fields in Our Report Templates
Some of our report templates are based on custom project fields such as Stage Gate. If your Meisterplan system does not contain these fields, some report visualizations will not work. To solve this, you can replace these fields with fields from your system or remove the visualizations.

Customizing the Report Template

To customize the template, make a copy of the template. To do so, click the three dots in the upper right corner and select Make a copy. Use that copy for customization.

To learn more about how to create, share and manage reports in Google Looker Studio, see the Looker Studio Help.