Skip to content

Efficy CRM Power BI dashboard

We bring relationships, opportunities and actions from Efficy together in a single Power BI model, alongside your revenue figures. For See Tickets, we brought ticketing and behavioural data together.

We brought together ticketing and behavioural data for See Tickets on a scalable Azure platform

We then developed recommendation models so See Tickets can reach fans with a personalised message even after the event. No CRM integration, but customer data from multiple sources brought together in one model.

Read the case study

What proportion of our opportunities actually become orders?

Efficy shows what’s in progress for each account. To find out which stage of the pipeline is stalling, which campaign brings in customers or how the forecast compares with revenue, bring that data together in your own model.

Book a meeting

Pipeline, activities and revenue tell the same story in one model

Discuss your sales figures

Conversion by stage

How many opportunities reach each stage, how long they stay there and where they drop out, by team and product group.

Activity by account manager

Meetings, calls and quotes alongside the pipeline, so you can see which activities lead to orders.

Campaigns alongside revenue

Which campaigns generated new contacts or opportunities, alongside the revenue later recorded in the accounts.

Customer data from more sources

Just as we brought together ticket and behavioural data for See Tickets, we connect Efficy with your other systems.

Agree on what counts as a won deal before you start counting

  1. Setup and access

    Which stages, fields and relationship types you use, and how the data is made available.

  2. Pipeline figures checked

    One quarter’s pipeline in the model, compared with what the sales team sees in Efficy.

  3. Expand and refresh

    Historical data, revenue from the accounting records, team-level access rights and a fixed time for loading data.

Is a separate dashboard alongside Efficy worth it?

Talk it through with us

A good fit if

You want to track conversion and pipeline over time, compare CRM data with revenue or marketing data, or someone currently prepares a monthly export for the management team.

Not a good fit if

Sales focuses on today’s figures and management doesn’t need trends or a link to revenue. In that case, the reports in Efficy are enough.

What determines the scope

How Efficy is configured in your organisation, which custom fields you have, how many other data sources are involved and who manages the model.

Can we access the data ourselves?

That depends on your setup. We’ll check with your Efficy administrator or implementation partner which route is available and explain upfront what the model needs from it.

Efficy reports, an export or your own Power BI model?

Reports in Efficy

Choose this if you mainly want to see the current position for each customer or team. Everything stays where the sales team already works.

A monthly export

Choose this if you produce one management overview each month. Whoever prepares it has to combine the data with the accounts each time.

Your own model

Choose this if you want to compare results over time or include revenue and marketing data. Our advice: start with conversion by stage.

We brought together customer data from multiple sources for ticketing and media

For See Tickets and DPG Media, we worked with customer data from multiple sources. Data Science Lab has been operating since 2016, is a Microsoft Partner and Databricks Partner, and shares knowledge at Techdays.

Book an introductory meeting

We’ll start with the sales question that’s going unanswered right now

Stef Stoelwinder

Stef Stoelwinder

Business Development

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

Which question about your pipeline would you like to answer first?

Tell us how Efficy is set up in your organisation and which other systems you use. We’ll reply by email, or we can arrange an initial conversation.

Enter a valid email address.

Let us know how we can help you.

Frequently asked questions

A scheduled data-loading step retrieves the data and prepares it for the model, so Power BI does not query the CRM directly. The route depends on your Efficy setup.

For more on where a dashboard starts, read about Power BI dashboards.

We could not find public documentation from Efficy itself. We therefore work with your administrator or implementation partner to determine how to access the data, using a dedicated account with read-only access.

We establish this before building anything.

Usually accounts, contacts, opportunities with their stage and value, activities such as meetings and quotes, and campaigns. What we need depends on your questions.

Custom fields and stages vary by company, so we map those first.

Conversion by stage, the quarterly pipeline against target, activity by account manager, revenue by campaign, and revenue per customer alongside the accounting figures.

For sales more generally, read about the sales dashboard.

Yes, if customers can be identified in both systems, for example by a customer number. If that is missing, we create a mapping table that you maintain yourselves.

This lets you see both the pipeline and invoiced revenue for each customer.

We define that in the model, for example by team or region. An account manager sees their own accounts, the sales manager sees the team's figures, and the management team sees the overall figures.

That way, the dashboard can be shared widely.

Yes. If you use SuperOffice, read about the SuperOffice Power BI dashboard. Lime CRM and PerfectView are also covered in our Power BI dashboards.

The approach is the same: first the setup, then the model.

If the reports in Efficy answer your questions. Or if stages and values are not kept up to date consistently: in that case, data quality is the first step.

We will tell you that upfront.