Skip to content

Connexys Power BI dashboard

We bring job openings and candidates from Bullhorn Connexys together in a single Power BI model. For Olympia, we built a model that matches candidates with job openings.

We developed an automated classification model for Olympia to match candidates and vacancies more efficiently

Every day, Olympia connects many people with suitable jobs. With a data-driven approach, Olympia aims to match candidates with suitable job openings more efficiently and accurately, providing better services to candidates and clients.

Read the case study

Which recruitment source actually leads to hires for us, and where do candidates get stuck?

Connexys records job openings, candidates and applications. If you want to compare sources against costs, compare job openings across departments or view recruitment alongside HR and budgets, you need to bring the data into your own model.

Book a call

From the first application to the signed contract, every step is in the same model

Discuss your recruitment figures

Candidates by source

Applications by channel, and what proportion progress to interview, offer and hire.

Time at each stage

How long an application spends at each stage, by job opening, recruiter and department, so you can see where things stall.

Open vacancies

Vacancies by department and location, how long they’ve been open and how many candidates are in the process for each job opening.

Candidates and vacancies connected

Just as we built a model for Olympia that matches candidates to job openings, we connect that data in your dashboard.

First the stages of your recruitment process, then the first chart

  1. Setup mapped out

    Which objects, statuses and fields Connexys uses in your organisation, and who your Salesforce administrator is.

  2. One process validated

    The funnel for a few job openings in the model, compared with what recruiters see in Connexys.

  3. Expand and maintain

    All job openings and their history, permissions by department, and a set refresh schedule with someone responsible for it.

Why use Power BI when Connexys already has reports and dashboards?

Talk it through with us

A good fit if

You want to see recruitment data alongside HR data, budgets or job board costs; compare brands or operating companies; or your recruiters currently put together a report in Excel every week.

Not a good fit if

The reports and dashboards in Connexys answer your questions, and nobody needs to compare them with other sources. In that case, your own model would add little value.

What determines the scope

How Connexys is configured in your organisation, how many custom fields and statuses you have, which other sources you want to add, and who will manage the model afterwards.

Can candidate data go into a dashboard?

Only what’s necessary. Counts by source, stage and job opening are usually enough, without names or CVs. We’ll agree with your privacy officer who can see data about individual candidates.

Reports in Connexys, an export or a Power BI model built on Salesforce?

Reports in Connexys

Choose this if you only need to look at recruitment and the standard reports are enough. Everything stays in the system recruiters already use.

An export to Excel

Choose this if you occasionally prepare a summary for management. Exporting and updating it every reporting period remains manual work.

A model built on Salesforce

Choose this if you need to view recruitment alongside HR or costs. Our advice: record statuses with dates so you can measure the time spent at each stage.

Our experience with candidate and vacancy data comes from matching for a staffing agency

Since 2016, Data Science Lab has built data platforms, models and dashboards as a Microsoft Partner and Databricks Partner. For Olympia, we developed a classification model to match candidates with job openings.

Book an introductory meeting

Your recruitment process and your recruiters’ questions are the starting point for the first conversation

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your point of contact. In the first conversation, we’ll discuss how Connexys is set up in your organisation, who administers it and which recruitment metrics you’re currently missing.

Which recruitment question would you like to answer with figures first?

Tell us how many vacancies you have open and which sources and systems you use alongside Connexys. 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

According to Bullhorn, Bullhorn Connexys is built on the Salesforce platform. Power BI has a Salesforce Objects connector that reads objects from Salesforce. For scheduled refreshes, we first put the data through a loading step, then build the Connexys Power BI model on top of it.

For guidance on which questions a dashboard should answer first, see Power BI dashboards.

According to Microsoft, the Salesforce account must have the API Enabled option switched on, and trial accounts do not have API access. Salesforce also limits the number of concurrent queries per account, so we schedule data loading outside the busy periods for other integrations.

We ask for a dedicated account with read-only access to the objects the model needs.

That depends on how your system is set up. Job openings, candidates and applications, along with their statuses and dates, form the basis, but custom fields and statuses vary by organisation. We could not find a public description of the Connexys data model.

That is why we first work with your administrator to map out which objects your organisation uses.

By recording every status change with its date, even if Connexys only shows the current status. This lets you see how long an application spends in screening, interview or offer stages, and where candidates drop out.

Without that history, you can only show the current position, not how it changed over time.

Applications and hires by source, the funnel for each job opening, time to hire by department, open positions and workload per recruiter. Often, teams also compare the cost of job boards with the results they deliver.

If you want to track employees, including absence and turnover, read about the HR dashboard in Power BI.

We include only the data needed to answer a question. For most reports, counts by source, stage and job opening are enough, without names, contact details or CV’s. If recruiters need to look at individual candidates, they do so in Connexys.

We agree access rights and retention periods with your privacy officer. For more on how we set up security, see Power BI consultant.

A dashboard shows what happened; prediction requires a model. For Olympia, we developed a classification model to match candidates with suitable job openings. That model is separate from the dashboard and needs its own arrangements for explainability and oversight.

For more on models, see machine learning.

If the reports in Connexys already answer your questions. Or if statuses and sources are not recorded consistently: in that case, data quality is the first step.

If you mainly need commercial figures for an agency, such as revenue by client, take a look at the sales dashboard.