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.
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.
Read the articleAutomationAutomating 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.
Read the articleData foundationHistory 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.
Read the articleDashboardingPower 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.
Read the articleAutomationMake.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.
Read the articleDashboardingA 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.
Read the articleData foundationETL 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.
Read the articleDashboardingPower 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.
Read the articleDashboardingCirqll 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.
Read the articleAutomationMake.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.
Read the articleIntegrationsConnecting 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.
Read the articleDashboardingCirqll 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.
Read the articleData foundationA 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.
Read the articleDashboardingA 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.
Read the articleData foundationWhat 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.
Read the articleAutomationBuilding 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.
Read the articleData foundationData 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.
Read the articleData foundationCirqll 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.
Read the articleDashboardingHiring 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.
Read the articleData foundationData 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.
Read the articleIntegrationsCirqll 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.
Read the articleData foundationFrom 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.
Read the articleAutomationMake.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.
Read the articleAutomationAutomatically 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.
Read the articleDashboardingLightspeed 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.
Read the articleDashboardingCirqll 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.
Read the articleAutomationMake.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.
Read the articleIntegrationsCirqll 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.
Read the articleDashboardingOdoo 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.
Read the articleDashboardingGetting 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.
Read the articleDashboardingPower 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.
Read the articleAutomationAutomating 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.
Read the articleDashboardingSales 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.
Read the articleAutomationCirqll 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.
Read the articleDashboardingWhat 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.
Read the articleAutomationMake 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.
Read the articleDashboardingConnecting 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.
Read the articleDashboardingAn 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.
Read the articleDashboardingThe 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.
Read the articleDashboardingPower 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.
Read the articleAIAgentic 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?
Read the articleAutomationWorkflow 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.
Read the articleDashboardingExcel 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.
Read the articleIntegrationsConnecting 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.
Read the articleData foundationWhat 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.
Read the articleIT 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
