...
Let's assume you need insights on your current projects and when the next milestone will be reached for each of them. Let's set this up!
...
Search for all projects in SuperOffice that you like to view in your report. Do not filter on the project responsible, status and type since we will have those filter options in our report later on.
Save your search results as a dynamic selection in SuperOffice and name it Projects for BI. You may save it with a different name, but in that case you need to do some extra work when you import the ready-to-go profile in the next step.
Import the profile Projects for BI (file Projects for BI.ndb) in DataBridge and enter the details as they are required. If you have chosen to select a different name for the selection, then make sure you select a project selection. If you choose a selection that is not based on projects, that will clear the already set fields and you'd need to enter those again.
Run the profile and verify that the table SOProjects is created and that it is populated with your data.
Import the provided PBIT file (Power BI Template) in Power BI Desktop and enter the details as they are required.
Verify the data and publish the report.
...
To be able to get insights in the different sales statuses we need a report that allows us to filter or zoom in on sales per user group, customer category and country. Let's go and look at the two reports that we prepared for you as an example.
...
Search for all sales in SuperOffice that you like to view in your report. Do not filter on the sales owner, company category and country since we will have those filter options in our report later on.
Save your search results as a dynamic selection in SuperOffice and name it Sales for BI. You may save it with a different name, but in that case you need to do some extra work when you import the ready-to-go profile in the next step.
Import the profile Sales for BI (file Sales for BI.ndb) in DataBridge and enter the details as they are required. If you have chosen to select a different name for the selection, then make sure you select a sale selection. If you choose a selection that is not based on sales, that will clear the already set fields and you'd need to enter those again.
Run the profile and verify that the table SOSales is created and that it is populated with your data.
Import the provided PBIT files (Power BI Template) in Power BI Desktop and enter the details as they are required.
Verify the data and publish the reports.
Downloads
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
...