To start BI in an SME, choose five to seven indicators that answer real decisions: cash, revenue, margin, customers, stock and payment delays. The tool, Power BI or Tableau, comes second. A useful dashboard is short, reliable and reviewed every week, not a screen crowded with charts that nobody reads.
Start from decisions, not charts
Before opening any tool, ask a simple question: what decisions does the owner make every week? Chasing customers, ordering stock, adjusting a price, hiring. Each indicator should inform one of these decisions, otherwise it just clutters the screen.
Also define every KPI precisely: formula, scope, period and source. Two people calculating revenue differently is enough to destroy all trust in the dashboard.
The KPIs to start with
An SME benefits from tracking financial and commercial health first. The indicators below can usually be built from invoicing, accounting or a simple till export. They should be compared over time: previous week, previous month or the same period last year.
Depending on the business, add specific indicators later: occupancy rate for a service, stock turnover for a retailer, quote conversion rate for a project-based business.
- Available cash and a forecast a few weeks ahead
- Revenue by product, customer and period
- Gross margin by product or service line
- Customer receivables and average payment delay
- Stock level and turnover for trading businesses
Power BI or Tableau: how to choose
Both tools can connect to files, databases and business applications and produce interactive visuals. Power BI fits naturally in Microsoft environments and often appeals through an accessible entry cost. Tableau is valued for its freedom of visual exploration. The right choice depends on team skills, budget and the existing ecosystem.
In every case, do not neglect data preparation. A clean model, with reference tables for customers, products and dates, makes dashboards faster to build and easier to maintain, whatever the tool.
Making adoption stick and avoiding pitfalls
Start with a single page validated with the owner, then enrich it. Set a weekly meeting where the dashboard is genuinely used to decide. Without that ritual, it ends up forgotten.
The usual pitfalls are well known: inconsistently entered data, too many indicators, unautomated sources that require manual updates, no named owner. Assign an owner to each indicator and plan regular data quality checks.
- One page, five to seven indicators at the start
- A named owner for each indicator
- Automatic data refresh as soon as possible
- A weekly or monthly review fixed in the calendar
Frequently asked questions
How many indicators should a first dashboard have?
Five to seven is enough. Beyond that, reading becomes hard and data quality slips. A few reliable indicators beat a crowded page.
Power BI or Tableau for an SME?
Both work. Power BI is often preferred in Microsoft environments and for its accessibility, Tableau for visual exploration. Choose based on your skills, budget and data sources.
Do I need a data warehouse to begin?
Not necessarily. Many SMEs start with exports from their invoicing or accounting. A central database becomes useful when sources multiply or volumes grow.