Understand our Fortnox data models

We offer multiple ways for you to interact with your data from Fortnox. Which one you choose depends on the tools you use and the depth of your skills.

Data models overview

Your Fortnox data is made available via Bigquery, Google’s data warehouse.
While connecting, you’ll see different folders (called “dataset”). These are explained below.

Dataset Description Suggested tool
/fortnox_api Direct reflection of the Fortnox API, field by field.
Mainly used to write custom SQL queries.
Goole Bigquery
/fortnox_stg Staged and flattened (denormalized) table, one. Goole Data Studio
Google Sheets
/fortnox_bi Facts and dimension (normalized) tables to build a star schema. Power BI
/fortnox_reports Useful data models (sql queries) to save you time. Any

/fortnox_api

Do you prefer to interact with data using SQL? Then this is the dataset for you. For futher details, we refer to our dedicated Fortnox API SQL documentation.


/fortnox_stg

Wanna get started quick and easy, with a more simple BI tool (e.g. Google Data Studio / Sheets and Microsoft Excel)? But still have all relevant data at your fingertips? Use our prepared data models (SQL queries views).

  • accounts_stg
  • budget_stg
  • financial_years_stg [query]
  • invoices_stg [query]
  • orders_stg
  • supplier_invoices_stg
  • vouchers_stg [query]

:information_source: All staged queries are subject for continuously improvement. If static result structure is critical for your use case, copy the query to your own environment or let us created a separate dataset for you.


/fortnox_bi

This dataset is mainly created with Power BI in mind. It holds fact and dimension tables which are building blocks in a star schema, used in Power BI.

dim-fact-tables

A star schema has a fact table in the middle, containing the measure you seek to measure - e.g. sales orders, phone calls etc.

The fact table can then have relationships/connections to multiple dimensions table, containing more in depth information about different attributes often used for categorising and filtering - e.g. employees, products etc.

See available fact and dim tables below and how they relates.

dim/fact vouchers budgets invoice i_rows supplier_invoice s_i_rows stockbalance
financial_years x x (x) (x)
accounts x (x) (x)
voucher_series x (x) (x)
cost_centers x x x x
projects x x x
customers x x
suppliers x x
articles x x
stockpoints x
labels
company x x x x x x x

(X) = Only available once invoice is booked.