Skip to content

PerfectView Power BI dashboard

We bring quotes, orders and contacts from PerfectView together with your accounting data in a single Power BI model. For Zuiver, we built its first data warehouse.

Zuiver worked with us to set up its first data warehouse, bringing its sources together in one place

“DSL helped us set up our very first data warehouse. […] For us, they’re a fantastic partner and one we’d recommend to other SMEs.” Richard Aznar Webster, CEO, Zuiver Interior Group.

Read the case study

How many of our quotes turn into orders, and for which customers?

PerfectView holds our contacts, quotes and actions; the revenue figures are in the accounts. To see both side by side without exporting data every month, bring them together in one model.

Book a call

From quote to invoice in one place, even for a small team

Discuss your sales figures

Quotes and likelihood of winning

How many quotes are outstanding, how many are won and how long it takes, by salesperson and product group.

Revenue by customer

Revenue from Exact Online, Twinfield or SnelStart alongside customer details and activities in PerfectView.

Activities that deliver results

Which visits, phone calls and mailings led to a quote, and which did not.

One place for your data sources

Just as we set up a data warehouse for Zuiver that brings its sources together, we bring PerfectView together with your other systems.

Start small with one question and let the model grow with your needs

  1. Question and access

    Which figures you’re missing and how the data from PerfectView can be made available.

  2. Compare the first quarter

    Quotes and orders from one quarter in the model, compared with the figures you currently compile.

  3. Expand and refresh

    Add accounting data, historical data, access rights for each employee and a fixed time for loading data.

Are we big enough to need our own dashboard?

Find out in a conversation

A good fit if

You want to see quotes, orders and revenue side by side, your figures have outgrown Excel, or someone spends hours exporting and combining data every month.

Not a good fit if

You have few quotes each month and the overview in PerfectView is enough. A quarterly spreadsheet is then quicker than building a model.

What determines the scope

How PerfectView is set up in your organisation, which accounting software you use alongside it, how much historical data you want and who will maintain the model afterwards.

Can we access the data ourselves?

PerfectView uses an API key and a secret from its settings for integrations. We confirm with PerfectView in advance which data is available this way.

Reports in PerfectView, an Excel export or your own model?

Reports in PerfectView

Choose this if a list of open quotes by salesperson answers your question.

Excel alongside the accounts

Choose this if one person puts together a report each quarter. The spreadsheet grows with every new question.

Your own model

Choose this if you want to track quotes and revenue over time. Our advice: start by comparing quotes with invoiced revenue.

We also built a first data warehouse for SMEs

Since 2016, Data Science Lab has helped companies of all sizes with their data as a Microsoft partner. We set up an initial data warehouse for Zuiver and created Power BI dashboards for Ammega.

Book an introductory meeting

The figures you currently bring together by hand are where we’ll start

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your point of contact. In our first conversation, we’ll discuss how PerfectView works in your organisation and which figures you’re missing.

Which sales question would you like to see answered first in a single overview?

Tell us which accounting software you use and what you currently combine by hand. We’ll email you back or call you for an initial conversation.

Enter a valid email address.

Let us know how we can help you.

Frequently asked questions

Through a data-loading step that retrieves the data at set times and prepares it for the model. This means Power BI does not run calculations directly on the CRM, and you can retain historical data.

To find out where a dashboard starts, read about Power BI dashboards.

We could not find public API documentation. PerfectView does support integrations using an API key and a secret from its settings. We check with PerfectView in advance which data can be retrieved this way.

We establish this before building anything.

From contacts, quotes and orders, as well as activities such as visits and mailings. For a small business, that is often enough for an initial overview.

If you use custom fields, we include those too.

Quotes and their likelihood of success by salesperson, revenue by contact alongside the accounting figures, activities by customer, and an overview of contacts who have not bought anything for a long time.

For the accounting side, read about the Exact Online Power BI dashboard.

It often is for transferring contacts and invoices. But that kind of integration is not designed for comparisons over time. For that, you need a model that brings both sources together and retains historical data.

PerfectView has integrations with Exact Online, Twinfield and SnelStart, among others.

Yes. A small model with a scheduled refresh needs little maintenance. We explain how it works so someone on your team can make changes.

If you would rather not do it yourselves, we can maintain it for you.

No. The model works with concepts such as quotes, orders and contacts; if you switch CRMs, we mainly replace the data-loading step. If you are considering Lime CRM, read about the Lime CRM Power BI dashboard.

The historical data remains available.

If you produce only a handful of quotes each month, or if quotes are often created outside PerfectView. Start by agreeing how to record the data; see data quality.

A model built on incomplete data gives a misleading picture.