All services

One number for the whole company

Business Intelligence & Dashboards. When finance, sales and operations read from different sources, the meeting goes to arguing over which figure is right. I build Power BI dashboards with a single definition of each metric, refreshed on their own, so the conversation moves from the data to the decision.

When it makes sense

  • The monthly close depends on hand-built spreadsheets.
  • Two departments bring different figures to the same meeting.
  • When someone asks about a number, the answer takes days.

What I deliver

  • Power BI dashboards for finance and operations
  • Data model and documented DAX measures
  • Metric dictionary agreed with each department
  • Scheduled refresh and role-based security
  • Training and handover to your team

What I work with

  • Power BI
  • DAX
  • SQL
  • SAP
  • ERPs

What it looks like

Examples built on synthetic data to show the shape of each deliverable. None belongs to a client.

Finance and operations dashboard

One version of the numbers, filterable by department.

Synthetic data

Filter by department
Revenue this year
$14.4 M
+1.7 % vs. budget
Gross margin
23.3 %
+1.7 pp vs. last year
Days to close
4
−6 days since January
Overdue receivables
6.7 %
−2.3 pp vs. last year

Revenue and budget, in $ thousands

Revenue by channel

From budgeted margin to actual, in $ thousands

Trimmed scale, to show the changes.

Revenue by region against target, in $ thousands

  • Central 5,630
  • North 3,340
  • East 2,490
  • West 1,770
  • South 1,215
View the data as a table
Revenue and budget, in $ thousands
Month Revenue Budget
Jan 1,030 1,030
Feb 1,005 1,030
Mar 1,070 1,070
Apr 1,110 1,090
May 1,130 1,120
Jun 1,190 1,160
Jul 1,195 1,180
Aug 1,190 1,190
Sep 1,255 1,230
Oct 1,305 1,280
Nov 1,425 1,370
Dec 1,540 1,460
From budgeted margin to actual, in $ thousands
Item $ thousands
Budget 3,160
Price 105
Volume 185
Mix -32
Costs -50
Actual 3,368
Revenue by channel
Channel Share
Retail 34 %
Wholesale 24 %
Online 31 %
Services 11 %
Revenue by region against target, in $ thousands
Region Actual Target
Central 5,630 5,500
North 3,340 3,330
East 2,490 2,500
West 1,770 1,720
South 1,215 1,160

Does your process stall on this line?

Two lines on what runs late are enough to start.

Tell me about it