Arkx logoArkxJoin Waitlist
Feature · Analyse

Your spreadsheet on trusted data.

Analysis is where the spreadsheet earns its place — it's the interface finance actually thinks in. The problem was never the spreadsheet. It was what sat underneath: a flattened CSV from last Tuesday, copied into a workbook nobody else can trust. Analyse keeps the spreadsheet you know and puts governed, versioned tables underneath it. Same formulas, live data.

What it does

You pull a cleaned table from your datahub into a real spreadsheet — the formulas you already use, not a stripped-down imitation. SUMIFS, INDEX/MATCH, pivot tables, charts, data validation: it all works the way it does in Excel.

The difference is underneath. Instead of querying a stale file, you're querying a live table from the datahub in real time. One shared model, not Budget_v7_FINAL_final.xlsx scattered across five inboxes. And when your analysis is done, you write the result back to the datahub as a versioned table — ready to report from, or to feed the next workbook downstream.

How an analysis runs

  • Pull — bring a cleaned table from your datahub into the spreadsheet. It's live, not a copy.
  • Analyse — work the way you always have: formulas, pivots, charts, data validation. Nothing new to learn.
  • Publish — write the finished numbers back to the datahub as a versioned table, so the rest of the team builds on the same source.
  • Refresh — the workbook can rerun on its own, on a schedule, pulling the latest cleaned data and updating its outputs without anyone opening the file.

That last step is the one Excel can't do. A normal workbook is dead until someone opens it and clicks refresh. An Analyse workbook is a living node in the pipeline — it updates itself, writes back to the datahub, and keeps the lineage intact from the raw pull all the way to the number you report.