
Operations research
Production plans, vehicle routes, schedules — with what limits them and what one more of each is worth.
OpenBI 0.3.79 · written in C · made in Norway
A BI engine and studio in one install. Your organization's measures live in a semantic model, so any agent — Claude, ChatGPT, Grok or your own — answers with numbers it cannot make up. No Python. No R. Nothing to pip install.
OpenBI Server · 12 kr per user per month + MVA · 30-day free trial · sold by Querex AS

51
visuals, from ledgers and Sankey diagrams to routes on a map
98
tools for agents over MCP: model, queries, reports, notebooks, versions
2,549
DAX queries checked against Power BI's own answers. 0 failures.
1
signed installer. No Python, no R, no packages to keep alive.
Built for Apple silicon. Reports, models and notebooks, with the engine running right on your Mac.
macOS 14 Sonoma or later · Free download
Reports that read like a page. Charts, maps and tables from your model, designed in place.
The world, in your data. Maps of countries, counties and routes, drawn from the model.
See your model. Tables, relationships and measures, laid out to drag and explore.
DAX, timed. Every query with its server timings, query plan and model analyzer.
Plans that decide. Operations research notebooks: routes, production plans, what-ifs.
Code first. Results next to it. DAX, SQL and C# notebooks for predictions, risk and networks.
The engine runs on Apple silicon, right on your Mac. Nothing leaves it unless you publish.
Signed with Norway Analytics' Developer ID and notarized by Apple: it opens without a warning.
Apple silicon (M1 or later), macOS 14 Sonoma or later. Signed by Norway Analytics and notarized by Apple. Live connections to Analysis Services and Power BI, and Analyze in Excel, are Windows-only for now.
Why another BI tool
They were built for people at a keyboard, one package at a time — and they are wonderful at that. But an agent doesn't need a REPL and forty dependencies. It needs one engine that answers in milliseconds, and says no when a name doesn't exist.
OpenBI's engine is written in C. DAX, SQL and Power Query run inside it, and so do the libraries that do the heavy lifting — DuckDB, OR-Tools, QuantLib, igraph, LightGBM and Typst. One engine, one model, one answer.
“The fastest dependency is the one you never installed.”
Your wingman
You're never alone. DAX, M, MDX, SQL — the syntax you used to fight is a thing of the past. Ask in words; your agent writes the query, OpenBI checks it against the model, and the answer comes back in words.
OpenBI Studio — the DAX viewConnect any agent in one line (the studio shows yours, with its own key):
claude mcp add --transport http openbi-studio http://127.0.0.1:5739/mcp \
--header "Authorization: Bearer <your studio's key>"
Other agents take the same address as JSON. The studio says when one is connected, and how many calls it made.
The agent's explanations, word for word, from the studio's explain tool on the example project.
The semantic model
Like SQL, Open Analytics Expression (OAX) is exact: a query names measures and columns that exist, or it fails. Your organization's measures, relationships, roles and calendars live in one semantic model — written once, by people who know what “revenue” means — and every agent uses the same definitions.
A replay of the example project's answers, recorded from OpenBI. The misspelt names are refused exactly as the engine refuses them.
Versions
Every change — yours or the agent's — is tracked in git and saved as versions you name. The model is text, so a change reads like a sentence, and going back is one click.
The real sequence, from the example project — the agent made the mistake on purpose.
Trust, but log
The visuals
Every picture below is OpenBI drawing the example project — captured, not mocked up. Flip the owl switch and they all turn dark, because the visuals do too.
Chart themes
Or something more serious? Nine looks, one attribute on the page — the same chart, the same data, drawn by OpenBI in each.

data-style="ggplot"Are you an owl?
We have a dark theme — for the studio, the reports and this page.
Financial reporting
A chart of accounts read as a parent-child tree, added up by its operators. Actual against budget and last year, variance bars, comments on figures — and out the other end, Excel with live formulas, or a typeset PDF.
The same statement as a typeset PDF · move to zoomTotals and variances as formulas, the rows as an outline, the figures exact with the scale in their number format.
Typst on the server: rules, a double rule under the total, headings on every page, comments as footnotes. PDF/A on request.
Right-click a figure to comment. Kept with the report, who and when, under the selection they were written for.
Formulas
Write formulas in TeX on any report page, and put the model's live values in them with \val{[Measure]} — they follow the page's filters. Below is the same renderer OpenBI ships. Type away.
One tool
Operations research, quantitative finance, network analysis and prediction — next to OAX, SQL and Open Query, in the same engine, on the same model. No second runtime, no extra packages.

Production plans, vehicle routes, schedules — with what limits them and what one more of each is worth.

Communities, centrality, bridges — who matters, and why.

Curves, bonds, options, FX, VaR — and QUANT.* functions right in DAX.

DAX, SQL and C# steps, versioned and approved by a person before they reach the model.

Churn, propensity, forecasts — trained on the model's history, scored with PREDICT() in DAX.
Notebooks
Forecasts with LightGBM, valuations with QuantLib, plans and routes with OR-Tools, networks with igraph — each a notebook of OAX, SQL and C# steps that runs on your own computer, beside the model. No cluster to rent, no cores billed by the hour, and your data stays where it is.




LightGBMHow much will we sell in the next 6 months? Strong: off by 2 % over the six months held back — a simple rule was off by 3 %. A person approves it before it forecasts in the model.




QuantLibWhat are the treasury's bonds worth, and what drives their risk? Market value 884.94 M, DV01 −318,623: a basis point costs 318,623. VaR 99 %, one day: 3.79 M.




OR-ToolsWhich shops does each of three vans visit, and in what order? Three vans, sixteen shops, 65.7 km in all; the longest round is 26.9 km.




igraphWhich shops buy alike, and which products tie them together? Nineteen nodes, sixty edges, two communities; Pils, IPA and Cider matter most.
It runs on the cores you already have — your laptop, or a server of your own. Nothing to rent, nothing metered.
The agent saves drafts and never approves. Someone other than a version's author approves it before it is used.
The model, its notebooks, their versions and the reports: one project folder, one git history.
Security
Fewer moving parts, fewer surprises. No interpreter to patch, no package manager pulling code at run time — one installer, signed, with its bill of materials inside.
0known vulnerabilities
1signed installer
0secrets for agents
Excel
Click Analyze in Excel and a PivotTable opens, live on the model: Excel speaks to OpenBI the way it speaks to Analysis Services. Your CUBE formula dashboards can come right back.
| A | B | C | |
|---|---|---|---|
| 1 | Example Brewery | NOK / liters | |
| 2 | |||
| 3 | Revenue | Pils | 38,164,388 |
| 4 | Liters sold · Frogner | Pils | 115,604 |
| 5 | Liters sold · Frogner | IPA | 3,674 |
| 6 |
The figures are the model's answers to those queries, through MSOLAP — the provider Excel uses.
Coming from Power BI

OpenBI under load
OpenBI peaks at 18.4 report pages a second on one 16-core server. Microsoft’s Analysis Services, on the same server, at 16.8. Neither returns an error.3
18.4
Pages a second at each engine’s peak. Longer is more.
0
One mark per step, simulated users doubling. Hollow: not measured.
Enterprise partner
Querex AS is OpenBI's Enterprise Partner. They connect an organization's databases, semantic models, files and APIs into one workflow — with the access you authorize — and put agents to work on it: from data to decisions in seconds.
Enterprise Partner
Download
OpenBI is updated often; every release is on the Releases page. Tell us who you are, show us you're not a robot, and the installer is yours.
Your download has started.
If it hasn't, download the installer. The link works for 24 hours. When you run it, Windows names the publisher: Norway Analytics.Open it, and it installs OpenBI Studio in Applications: signed by Norway Analytics, notarized by Apple. Ro!