Skip to content

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.

Read the case study

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.

Book a meeting

Sales, projects and contacts by company in one view

Discuss your CRM figures

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

  1. Access and fields

    A dedicated user with read access, and an overview of the entities and custom fields you use.

  2. Comparing sales

    One quarter’s sales in the model, alongside the selections the team runs in SuperOffice.

  3. 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?

Let’s discuss it

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.

Book an introductory meeting

We’ll discuss how your team uses SuperOffice in our first conversation

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef 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.

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.

Enter a valid email address.

Let us know how we can help you.

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.