Analytics

Overview

This is an experimental feature that may contain bugs and, as such, is not yet universally available. Using analytics might be out of scope depending on your customer segment and payment plan. Reach out to [email protected] to inquire if this is available for your company.

Employees with the Admin or Finance role can use the analytics tool to answer questions about their Skovik data.

A few examples of questions you can answer are:

  • How much expenses do we have per month broken down by category?

  • What's the total value of pending (still not approved) expenses, per employee?

  • How long time does it take to review a report?

  • What's the average time from report submission to approval?

These are just some examples. Virtually any question that there is data for can be answered.

Data available

In the analytics tool you have access to the last 3 years of your Skovik data.

Data is updated daily, a few hours after 00:00 UTC, so you will have access to data with at most 24h delay. For more information about what data is available, please refer to the schema available in the tool.

Working with the tool

In the analytics tool you access data by writing SQL-queries (in the DuckDB dialect). DuckDB is based on PostgreSQL, with some added convenient functions: https://duckdb.org/docs/stable/sql/introduction.

There are two main ways to work with the tool, either by doing exploratory analysis or by setting up saved queries you run regularly.

Saved queries

Saved queries are available for you and your colleagues.

Scheduled queries

Saved queries can be scheduled to run weekly or monthly, with the data sent by email and available to download for 90 days. Weekly queries are run on Mondays (they will run on a snapshot containing data including the previous week) and monthly queries are run on the 1st of every month (based on a snapshot containing data including the previous month).

Last updated

Was this helpful?