For any BI reporting, you’d love to get your hands on the CRM data in your database. And preferably without having to know the specifics of the SuperOffice database relations. DataBridge helps you transfer and update the SuperOffice data to your database. This article offers a step-by-step guide on how to set that up, including a few example reports and DataBridge integrations to go with that.
This example uses a SQL Database. This feature is available in the Professional subscription.
We assume you have the following:
- Access to Microsoft SQL Server or Azure SQL
- Knowledge on how to access SQL Server and check data
- Access to Power BI Desktop
- Knowledge on how to import a Power BI template and publish reports.
Example 1 – Project timeline
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 integration in the next step.
- Import the integration 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 integration 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.
Example 2 – Sales insights
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 integration in the next step.
- Import the integration 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 integration 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.