KNOWLEDGE BASE

Articles on data, automation and AI

Practical pieces for SME owners and managers. About data foundations, Power BI, integrations, automation and AI. No buzzwords, just things you can use tomorrow.

Dashboarding

Teamleader Power BI dashboard: hours, project margin and invoicing in one view

Five KPIs for a Power BI dashboard on your Teamleader projects: billability, work in progress, budget, margin and lead time. Which data you need and where it goes wrong.

16 November 2026 · 9 min readRead the article
Automation

Automating Outlook with Make.com: 5 workflows for your inbox and calendar

Much of the manual work in an SME starts in Outlook: reading an email, retyping it, forwarding it, scheduling a meeting. Make.com can take that work away. Five workflows, the setup and the pitfalls.

13 November 2026 · 9 min readRead the article
Data foundation

History in your data warehouse: how an SME keeps what its software forgets

Your software mainly shows today's position. If you later want to know what your stock, pipeline or receivables looked like a quarter ago, you have to record that history yourself. Here is how.

11 November 2026 · 8 min readRead the article
Dashboarding

Power BI integration: how to get the data from your software into Power BI

There are four ways to connect your business software to Power BI. What each route can do, how often the numbers refresh, when you need a gateway and where it usually goes wrong.

10 November 2026 · 8 min readRead the article
Automation

Make.com automation: build it yourself or have it built? How to choose

You can build a simple scenario yourself in an afternoon. If it touches your invoicing or customer data, help pays off. Here is how to choose, and what to look for when you outsource.

9 November 2026 · 7 min readRead the article
Dashboarding

A Power BI dashboard people actually use: setup, pages and pitfalls

Building a dashboard is the easy part. How to set it up so people open it every week: who it is for, which pages belong in it and where it usually goes wrong.

6 November 2026 · 8 min readRead the article
Data foundation

ETL tools for SMEs: Power Query, Make or your own pipeline?

You do not need a data platform straight away, but Power Query and Make have their limits too. Five questions show which route fits now and when it is time to move on.

5 November 2026 · 8 min readRead the article
Dashboarding

Power BI for SMEs: where do you start and what do you need?

You do not need an IT department to start with Power BI, but you do need one good question and access to your data. What you need, what it costs and how to get your first dashboard working.

4 November 2026 · 8 min readRead the article
Dashboarding

Cirqll dashboard for contracts: recurring revenue and renewals in Power BI

Your pipeline shows what might come in, your contracts show what is already agreed. A Cirqll dashboard for contracts shows how much recurring revenue you have and how much of it expires soon.

3 November 2026 · 7 min readRead the article
Automation

Make.com automation: what does it cost and how do you calculate credits?

What Make.com automation costs depends mainly on how many credits your scenarios use. Here is how to calculate that upfront, with a worked example and the pitfalls.

2 November 2026 · 8 min readRead the article
Integrations

Connecting Moneybird to Power BI: how to build a financial dashboard

A Moneybird Power BI integration in five steps: which data you need, direct or via a data layer, the KPIs that matter and where it usually goes wrong.

30 October 2026 · 7 min readRead the article
Dashboarding

Cirqll activity reporting: appointments, tasks and follow-up in Power BI

Your pipeline tells you what might come in. An activity report on Cirqll tells you whether enough work is going into it: appointments, open tasks and customers missing follow-up.

29 October 2026 · 7 min readRead the article
Data foundation

A database for SMEs: should you choose PostgreSQL, SQL Server or Fabric?

Anyone who wants their business data in one place soon faces the question of which database. The brand matters less than you think. These are the questions that do matter.

28 October 2026 · 7 min readRead the article
Dashboarding

A Cirqll dashboard for data quality: see where your CRM data falls short

Every report on Cirqll is only as good as the data underneath. A small data quality dashboard shows where things fall short, so you can clean up in a targeted way and keep it tidy afterwards.

27 October 2026 · 6 min readRead the article
Data foundation

What is a data pipeline (ETL) and how do you set one up without a large IT team?

A data pipeline automatically fetches data from your systems, makes it usable and puts it in one place. This is how it works, and how an SME sets one up without its own IT department.

26 October 2026 · 8 min readRead the article
Automation

Building a Make.com integration: how to connect your systems

How to connect two systems with Make.com: which route to choose, how to authenticate, how to map fields and how to stop the integration from quietly breaking.

23 October 2026 · 8 min readRead the article
Data foundation

Data engineering for SMEs: what it is and what you need

Data engineering sounds like something for tech companies with their own data team. Yet as an SME you already do part of it, just by hand. Here is what it is and which part you really need.

21 October 2026 · 7 min readRead the article
Data foundation

Cirqll data in your own database: how to keep your pipeline history

Cirqll shows you where your pipeline stands today. If you want to know what it looked like a quarter ago, you have to record that history yourself. A database of your own is the most practical way to do it.

20 October 2026 · 7 min readRead the article
Dashboarding

Hiring a Power BI consultant: what should an SME look for?

A Power BI consultant can get you in a few weeks where it would take you months on your own. But only if you know what you are asking for, what you get back and who manages it afterwards.

19 October 2026 · 7 min readRead the article
Data foundation

Data warehouse for SMEs: when you need one and when not

A data warehouse sounds like something for large companies. Yet as an SME you often run into exactly the problems it solves. The question is not whether, but how heavy.

16 October 2026 · 6 min readRead the article
Integrations

Cirqll integrations: which options there are and how to choose

Which routes there are to connect Cirqll to other systems, which route suits which system and a step-by-step plan to make the right choice.

15 October 2026 · 7 min readRead the article
Data foundation

From Excel to a data foundation: a 30-day plan

You do not have to change everything at once. With one question, four weeks and a few firm agreements you get your key numbers out of Excel and onto a solid foundation.

14 October 2026 · 7 min readRead the article
Automation

Make.com error handling: how to stop a scenario from quietly failing

How to use Make's error handlers and scenario settings to stop a workflow from quietly failing, with a worked example.

13 October 2026 · 7 min readRead the article
Automation

Automatically following up Cirqll contracts and invoicing with Make.com

How to follow up your Cirqll contracts with Make.com: which contract data you use, five follow-up actions, a worked scenario and the pitfalls.

12 October 2026 · 7 min readRead the article
Dashboarding

Lightspeed and Power BI: revenue, margin and stock per store

How to get Lightspeed Retail data into Power BI and manage revenue, margin and stock per store, with KPIs, a step-by-step plan and pitfalls.

9 October 2026 · 7 min readRead the article
Dashboarding

Cirqll sales dashboard: tracking deals and quotes in Power BI

How to set up a Cirqll sales dashboard in Power BI that shows which quotes are open, what your pipeline will realistically deliver and where deals stall.

8 October 2026 · 7 min readRead the article
Automation

Make.com workflows for SMEs: 7 scenarios that save time right away

Seven Make.com workflows that remove manual work in many SMEs straight away, worked out from trigger to error alert.

7 October 2026 · 8 min readRead the article
Integrations

Cirqll API: what you can do with it and what you need for an integration

What the Cirqll API is, which data you can read and update with it, what you use it for and what to arrange before you build an integration.

6 October 2026 · 7 min readRead the article
Dashboarding

Odoo Power BI integration: when reporting in Odoo is no longer enough

What Odoo offers in reporting, the signs that you need more, which reports Power BI adds and how to set up the integration.

5 October 2026 · 7 min readRead the article
Dashboarding

Getting more out of your Cirqll reporting with Power BI

What Cirqll shows you every day, when it is time for the next step, which reports Power BI adds and how to get started.

2 October 2026 · 7 min readRead the article
Dashboarding

Power BI Copilot: what AI does and does not do for SME reporting

Copilot in Power BI writes report pages, summaries and DAX. But it needs Fabric capacity, and it is only as good as the data model underneath.

1 October 2026 · 7 min readRead the article
Automation

Automating Cirqll: which manual tasks to remove first

A practical approach to automating Cirqll: map the manual work, prioritise it and pick the right tool for each task.

30 September 2026 · 7 min readRead the article
Dashboarding

Sales dashboard in Power BI with HubSpot or Teamleader: 5 KPIs that matter

Five sales KPIs for a Power BI dashboard on HubSpot or Teamleader, how the integration works and where it goes wrong in practice.

29 September 2026 · 8 min readRead the article
Automation

Cirqll and Make.com: 5 automations you can set up today

Five practical automations between Cirqll and Make.com, how the integration works technically and what to check before you start.

28 September 2026 · 7 min readRead the article
Dashboarding

What does Power BI cost in 2026? Calculate the licence cost for your business

Power BI Pro, Premium Per User or Fabric? Enter makers, viewers, model size and refresh rate and instantly see what you pay per month and per year.

26 September 2026 · 5 min readRead the article
Automation

Make vs n8n: how to choose an automation platform for your SME

Make and n8n can do largely the same things. The difference is in how you pay, where it runs and who maintains it.

25 September 2026 · 7 min readRead the article
Dashboarding

Connecting Cirqll to Power BI: how to build a dashboard on your Cirqll data

How to connect Cirqll to Power BI, which Cirqll data you need, which five numbers belong on your first dashboard and how to get started step by step.

24 September 2026 · 7 min readRead the article
Dashboarding

An HR dashboard with Nmbrs and Power BI: which KPIs and how to start

Six HR KPIs you can surface in Power BI from Nmbrs data, how to handle sensitive payroll data and how to start small.

24 September 2026 · 8 min readRead the article
Dashboarding

The 10 KPIs every SME dashboard needs

Ten KPIs for finance, sales and operations that belong on almost every SME dashboard, with the formula, the source and how to get started.

23 September 2026 · 7 min readRead the article
Dashboarding

Power BI licensing in 2026: Pro, Premium Per User or Fabric?

Pro, Premium Per User or Fabric capacity? What the licences cost, what you get and which choice makes sense for most SMEs.

22 September 2026 · 7 min readRead the article
AI

Agentic AI for SMEs: what can it really do?

Agentic AI sounds exciting, but it is mainly a model that can take steps within limits you define. What does that mean in practice, and what needs to be in place first?

19 September 2026 · 6 min readRead the article
Automation

Workflow automation for SMEs: 7 processes to automate first

Not every process is a good automation candidate. These seven usually are, as long as you prepare a few things first.

19 September 2026 · 6 min readRead the article
Dashboarding

Excel or Power BI? When it is time to switch

Excel is not a bad tool, but it can outgrow its role. These signals, a checklist and a migration path help you decide if switching is worth it.

19 September 2026 · 6 min readRead the article
Integrations

Connecting Power BI to your accounting software: how to approach it

Your accounting package already holds much of what you need for steering. Here is how to connect it to Power BI without surprises later.

19 September 2026 · 6 min readRead the article
Data foundation

What is a data foundation and why does your SME need one?

A data foundation sounds big, but it is mostly practical: one place where your numbers add up, with definitions everyone understands. Here is how to start.

19 September 2026 · 5 min readRead the article

IT ALL STARTS WITH A GOOD CONVERSATION.

Curious what this
means for your company?

Tell us what you are running into. We will look at a sensible first step together, without a large project.

OR SEND A MESSAGE

Ask your question via the form

By sending you agree to the processing of your details as described in the privacy notice.