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.
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.
A sales dashboard shows revenue, pipeline, targets and discounts by customer, product and salesperson
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
-
Definitions and ownership
When an order counts as revenue, how returns and discounts are accounted for, and which salesperson is responsible for each client.
-
Connect CRM and ERP
Match clients across CRM and ERP, build the model and reconcile revenue with the finance team.
-
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?
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.

Your weekly sales meeting and the list you’re currently putting together for it are the starting point for our first conversation
Stef Stoelwinder
Business DevelopmentStef 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.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
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.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
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.
Revenue for finance, value per customer or all dashboards: what would you like to explore next?
- Power BI dashboardsAll the dashboards we build, each focused on a decision the person using it needs to make.
- Financial dashboard in Power BIRevenue, margin, cash flow and budget versus actuals for finance and senior management.
- Customer analysis using dataCustomer value and behaviour-based segments, so marketing and sales can make more targeted decisions.