SuperOffice Power BI dashboard
We bring sales, projects and contacts from SuperOffice into a single Power BI model. For the Koninklijk Concertgebouworkest, we connected data from multiple systems.
For the Koninklijk Concertgebouworkest, we brought data from multiple systems together in one data platform
Information spanning more than 135 years was scattered across systems and archives. By connecting, structuring and standardising the data, we made it quicker to find and widely accessible across the organisation.
Which sales opportunities are stalled, and which clients have projects running behind schedule?
SuperOffice tracks each company’s sales, projects and contacts. To see how these change over time alongside revenue or hours, you put the data into your own model.
Sales, projects and contacts by company in one view
Sales opportunities by stage
How many sales opportunities are at each stage, their value and likelihood, by salesperson and period.
Projects by client
Ongoing projects from SuperOffice alongside the hours and revenue from your other systems.
Contact by company
When you last made contact and which clients haven’t heard from you in a while.
Connected sources
Just as we brought SAP, Magento and SharePoint together in one data model for Vivara, we put SuperOffice alongside your other systems.
The archives you already use are the starting point
-
Access and fields
A dedicated user with read access, and an overview of the entities and custom fields you use.
-
Comparing sales
One quarter’s sales in the model, alongside the selections the team runs in SuperOffice.
-
Expand and refresh
Add projects and other sources, set permissions by team and schedule a fixed time to load data.
Aren’t we already getting enough from SuperOffice selections?
A good fit if
You want to compare sales and projects over time, combine CRM data with revenue or hours, or someone currently makes an export every month.
Not a good fit if
SuperOffice is your only source, and its built-in selections provide the lists your team uses. In that case, an additional layer is unnecessary.
What determines the scope
Whether you use SuperOffice online or run your own installation, how many custom fields you have, and whether hours, revenue or a second CRM need to be included in the model.
What about App Store integrations?
Ready-made third-party integrations are available. They’re a good fit if you want to use their reports; if you want to combine SuperOffice with your own sources and definitions, a custom model is a better fit.
Selections in SuperOffice, a ready-made integration or your own model?
Selections in SuperOffice
Choose this if you mainly need lists, such as companies you have not contacted recently or open sales opportunities.
A ready-made integration
Choose this if the supplier’s standard reports answer your questions and SuperOffice is your only data source.
Your own model
Choose this if you want to include revenue, hours or other data sources. Our advice: start with sales by stage and by salesperson.
We brought together data from separate systems for culture and retail
We connected the systems and archives of the Koninklijk Concertgebouworkest and Vivara’s data platform. Data Science Lab has worked with data since 2016, as a partner of Microsoft and Databricks.

We’ll discuss how your team uses SuperOffice in our first conversation
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In our first conversation, we’ll discuss how SuperOffice is working for your team and which metrics you’re missing.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
What would you like to know first about your sales and projects?
Let us know whether you use SuperOffice Online or your own installation. We’ll reply by email or arrange an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
Through the SuperOffice REST API. It provides data on companies, people, projects and sales, among other things. We use OData to select fields and apply filters. We load the data at scheduled times, then build the SuperOffice Power BI model on top of it.
To see where a dashboard starts, read about Power BI dashboards.
According to SuperOffice, Online uses a SuperId token; the API also supports Basic and SoTicket authentication. We ask for a dedicated user account with read-only access.
For an older self-hosted installation, we’ll work with your administrator to see what’s possible.
For sales and projects, the main ones are Contact (the company), Person, Sale and Project, plus records of customer interactions. With OData, we retrieve only the fields the model uses.
We’ll identify custom fields together with your administrator.
Sales by stage and salesperson, sales opportunities against targets, projects by client alongside hours and revenue, and clients with no recent contact.
For more on projects specifically, read about the project dashboard.
Yes, if companies and projects can be identified in both systems, for example by a number. Where that isn’t possible, we create a mapping table that your team maintains.
That way, you can see both the relationship and the figures for each client.
Not automatically. Permissions in SuperOffice and Power BI are separate. That’s why we define who can see which companies and projects again in the model, for example by department.
We’ll agree on this with your administrator.
Yes. We bring both into the same model, with a single way of categorising stages and clients. If the other company uses PerfectView, read about the PerfectView Power BI dashboard.
We match duplicate clients using a consistent key.
If a ready-made connector from the App Store already provides the reports you need, or if sales opportunities are rarely updated. In the latter case, the starting point is data quality.
You’ll get an honest recommendation in our first conversation.