Data & Technology

Monday's question gets answered in Monday's meeting

Management, controllers and sales find their own answers in one shared data model, without ordering a new report and without the numbers drifting apart. We build the model and the reports in Power BI, Qlik or Tableau.

Power BIQlikSelf-service BIRow-level security

Reports that get used

Reports get used when they answer the questions that run the business. So we start with which decisions the reports should support and who will read them. Underneath sits one shared data model, and finance, sales and management work from the same numbers.

Gross margin by market, month by month
Example
Gross margin, rolling 12
ACTUALTARGET
36 %34 %32 %30 %TARGET 32.5 %JANAPRJULOCT
By market
DK38.1
SE34.6
NO31.9
FI29.4
DE27.2
Latest month
34.2 %
+2.8 pp vs prior year
ORDER INTAKE
1,284+12 %
AVG ORDER
18,400+4 %
DELIVERY PRECISION
96.8 %+1.2 pp
CUSTOMER CHURN
3.1 %−0.4 pp
The example shows gross margin over the last twelve months against target, split by market, plus four KPIs with trend lines. From there the user can dig further into the data.
“We work with Stormyran to make working with data simpler. For me the most important thing is that we can now move much faster, development goes quickly and we no longer get stuck on technical problems. Stormyran really understood what we needed.”

Henning Horn af Rantzien

COO, Playpilot

See your own data in a dashboard

We often deliver a first working dashboard within 2–4 weeks.

Who it is for

Companies starting with BI

The monthly report is made in Excel and there is no shared data model. We build the first dashboards and the model they rest on.

  • A first dashboard on the key figures
  • Connection to the finance system
  • Training for users

Companies with existing reports

You have Power BI or Qlik, but the reports have grown in different directions. We clean up, move the logic into a shared model and remove duplicates.

  • Review of existing reports
  • Shared definitions
  • Move to a new platform if needed

Groups with many users

Hundreds of users, several companies and rules about who sees what. We set up the models, permissions and maintenance so the reporting holds up.

  • Row-level security
  • Reports per company and for the group
  • Maintenance and further development

Common problems in reporting

Every new report needs a request to IT or a consultant

Different departments present different figures for the same KPI

Reports are rebuilt by hand in Excel every month

Dashboards built a few years ago that nobody opens any more

Everyone sees everything or nobody sees anything, because permissions are missing

What we build

  • Dashboards and reports in Power BI, Qlik or Tableau
  • Shared data models with definitions everyone uses
  • Self-service BI where users build their own analyses
  • Permissions that control which data each user sees
  • Migration and clean-up of existing reports
  • Training for the people who will use and maintain the reports

What you get

  • Answers in minutes when the question comes up
  • The same numbers for everyone who reads the reports
  • Users who can explore the data themselves
  • Trends that show up before they become problems
  • Reports you can maintain and extend yourselves

How it works

After the first dashboard we build in short rounds, and the reports get better while they are in use.
  1. 01

    Decisions and users

    We go through which decisions the reports should support, which KPIs drive the business and who will use them.

    From you
    Time with the people who know the business
  2. 02

    Data model

    We build a shared data model, directly on the source systems or on top of a data warehouse, with definitions everyone uses.

    From you
    Access to the data
  3. 03

    First dashboard

    A first version that users can try out and comment on.

    Time
    2–4 weeks
  4. 04

    Extension and training

    We keep building in short rounds and train the people who will use and maintain the reports.

  5. 05

    Maintenance

    We maintain the reports, or hand them over to your team with documentation.

Examples from our work

SaaS platform for the restaurant industry

Reporting from more than ten source systems

We built the Power BI reporting on an Azure data platform with TimeXtender.

Data from more than ten source systems comes together in the same model, so the reports start from the same numbers.

source systems
10+
source systems

Consumer brand

The same reports, different permissions

We set up row-level security in Azure Synapse.

Each user only sees their own data, but everyone works from the same model.

Self-service without the numbers drifting apart

With self-service BI, the business can explore the data itself instead of waiting for a new report. It works when the foundation is shared: a quality-assured data model that someone owns and that everyone builds their analyses on.

We set up the model, the permissions and the rules for who may publish what. Users get the freedom to build their own views, and everyone still works from the same numbers.

The tools you already have licences for

Power BI

The most common choice for organisations that already use Microsoft 365 and Azure.

Qlik Sense

A good fit when users want to click through the data and see how different dimensions relate.

Tableau

A good fit if you already have Tableau licences or need advanced visualisation.
Power BIQlikTableau

Latest news in Business Intelligence

Articles and news from us in this area

Orderbase: when data and logistics build together

Orderbase is our order and warehouse platform, developed by our logistics department together with our data team. It brings the order flow together in one place and updates in real time, with clear views for requesters, warehouse staff and management. Orderbase doesn't replace your ERP or your WMS. It makes them understandable and useful for everyone involved in the flow.

Read more

Consolidate the 30 Excel sheets controlling your analytics environment

Multiple versions of the same file, hard-coded lookup tables and key-person dependencies steal time and erode confidence in the numbers. Gridmap brings every mapping, registry and business rule into one auditable place, with optional rule-based AI that suggests the right value in real time.

Read more

Frequently asked questions

Contact Us

Fill out the form and we will get back to you within 24 hours.

Business Intelligence | Stormyran