Skip to content

Sales dashboard in Power BI

We bring orders, pipeline and targets for each client and salesperson together in a single Power BI model. For Fokker Services Group, we built a dashboard for sales quotes.

Fokker Services Group employees get a complete, up-to-date view of every part with one click during the quotation process

Fokker Services Group wanted real-time insight into all relevant part data during the quotation process. We developed a central dashboard that connects its ERP system to multiple external marketplaces, bringing pricing, market and logistics data together in one view.

Read the case study

How are we tracking against target, and which deals in the pipeline will we close this quarter?

Orders are in the ERP, opportunities in the CRM and targets in the sales manager’s spreadsheet. If you bring them together each week, you only see where things stand after the fact. One model shows actuals, pipeline and targets side by side for each salesperson.

Book a meeting

A sales dashboard shows revenue, pipeline, targets and discounts by customer, product and salesperson

Discuss your sales figures

Revenue and orders by customer

Order lines from your ERP system, online shop or point of sale, broken down by customer, product, region and salesperson, using the same customer and date definitions for everyone.

Pipeline and conversion

Opportunities from your CRM by stage and salesperson, showing conversion from quote to order and expected value by quarter.

Targets against actuals

Monthly sales targets by salesperson alongside what has already been booked, so you can see who is behind halfway through the month.

Prices, discounts and quotes

Gross price, discount and net price for each order line. For Fokker Services Group, we brought pricing and market data together in one view for quotes.

First, we agree when a deal counts as revenue and which salesperson is responsible for each client

  1. Definitions and ownership

    When an order counts as revenue, how returns and discounts are accounted for, and which salesperson is responsible for each client.

  2. Connect CRM and ERP

    Match clients across CRM and ERP, build the model and reconcile revenue with the finance team.

  3. Access rights and schedule

    Each salesperson sees their own clients; the sales manager sees their region. We then set a regular refresh schedule and assign an owner.

Are the sales reports in our CRM enough, or is a dedicated sales dashboard worth it?

Talk it through

A good fit if

Orders are in the ERP or online shop and opportunities are in the CRM, so the sales manager brings them together in Excel every week to see how everyone is doing against their targets.

Not a good fit if

You sell through one system, your CRM has the reports your team actually uses, and no orders or targets come from other sources. In that case, a dashboard adds little.

What determines the scope

The number of sources, whether customers have the same ID in the CRM and ERP, whether salespeople switch regions and need their history to follow them, how many years back you want to look, and who will take over management.

Can salespeople see each other’s figures?

Only if you want them to. With row-level security, a salesperson sees their own customers and a manager sees their region. You can restrict access to columns such as purchase price and margin separately.

CRM reports, a Power BI model using CRM and ERP data, or a data warehouse with sales history?

Your CRM reports

Choose this if your main questions are about the pipeline and activities, and you don’t need orders or invoices. You don’t need to build anything, but you won’t see revenue from the ERP.

A Power BI model using CRM and ERP data

Choose this if you need to bring opportunities, orders and targets together. Our advice: start with revenue and targets by salesperson, then add the pipeline once customers are properly linked.

A data warehouse with historical data

Choose this if you want to see how the pipeline changed week by week, or if salespeople often move between regions. See how to build a data warehouse.

We’ve already built commercial insights from ERP and market data for Fokker Services Group

Data Science Lab has worked with data and AI since 2016 and is a Microsoft Partner for Fabric. We built a dashboard for Fokker Services Group’s quotation process, and Power BI dashboards and a Power BI app for Ammega.

Book an introductory meeting

Your weekly sales meeting and the list you’re currently putting together for it are the starting point for our first conversation

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your first point of contact. In our first conversation, we’ll discuss your sales meeting, your CRM and ERP, and which figure needs to be right first.

Which sales figure would you like to have ready every Monday without exporting data?

Tell us which CRM, ERP or online shop you use and who needs to see the figures. 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

A sales dashboard shows the key commercial metrics: revenue and orders by customer, product, region and salesperson; the pipeline from the CRM; targets alongside actual results; and discounts given. In Power BI, these figures are measures in a single semantic model, so sales and finance see the same numbers.

It is one of our Power BI dashboards, which we build around the decisions they support.

Usually, customer records, opportunities and stages come from the CRM; orders, invoices and cost prices from the ERP; and direct sales from the webshop or point-of-sale system. Targets are often still kept in Excel. Power BI has its own connectors for Dynamics 365 and Salesforce: Dataverse and Salesforce Objects.

We have separate pages for commonly used systems, such as Exact Online and Lightspeed Retail for point-of-sale data.

Ideally, you use a customer number that appears in both systems. If there is no shared number, we create a mapping table, based on a Chamber of Commerce registration number or debtor number, for example, and a list of customers we cannot match.

That list goes back to sales or the sales support team, who can resolve the mismatches. As long as customer records are duplicated or remain unmatched, revenue by customer or salesperson will be inaccurate.

Targets are usually set at a higher level than orders, such as by month, salesperson and product group. Microsoft describes this exact example: a target table dated on the first day of each month has monthly and product-level granularity.

In the model, you link the targets to the same date, salesperson and product tables as the orders. A measure shows what percentage of the target has been met.

If you simply overwrite the region, their past revenue moves to the new region too. Microsoft uses this example to explain a type 2 slowly changing dimension: you keep versions for each salesperson, with start and end dates, so past orders remain attributed to the old region.

Power Query cannot maintain those versions on its own. You need a layer that records changes, such as a data warehouse.

Store the discount as an amount for each order line, not as a percentage. Microsoft recommends storing the values used to calculate a ratio; you can then calculate the discount percentage in a measure.

Margins and purchase prices are often not intended for every salesperson. Object-level security lets you restrict access to those columns. Finance can find margin by segment on the financial dashboard.

With dynamic row-level security: one role with a filter on USERPRINCIPALNAME() and a table linking each user to their customers or region. Roles are additive, so a manager assigned to two regions sees both. RLS applies to users with the Viewer role in the workspace, not to Admins, Members or Contributors.

You can read how we set up workspaces and apps on our Power BI consultant page.

When all your sales are in one system, its reports give your team what they need, and nobody needs to see orders, opportunities and targets side by side. Or when customers and products have different names in every system: in that case, start with data quality.

If you want to know which customers are most valuable, read about customer analysis. If you want to forecast sales, take a look at the sales forecasting tool.