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.
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.
From quote to invoice in one place, even for a small team
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
-
Question and access
Which figures you’re missing and how the data from PerfectView can be made available.
-
Compare the first quarter
Quotes and orders from one quarter in the model, compared with the figures you currently compile.
-
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?
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.

The figures you currently bring together by hand are where we’ll start
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In our first conversation, we’ll discuss how PerfectView works in your organisation and which figures you’re missing.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
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.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
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.