Blog

How to choose business intelligence software: questions to ask every vendor

20 November 2026 ยท 5 min read

Can you connect directly to every one of our data sources, and what does it cost for the people who only view reports?

Business intelligence software, often called BI, pulls data from your other systems and turns it into reports and dashboards. This guide is for small and mid-sized businesses whose numbers are spread across accounting, sales, a shop or booking system and a lot of spreadsheets.

If someone on your team spends the start of every month copying figures into a spreadsheet to build the same report, BI can take over that job. But BI only shows what your data says. If the data is messy, the dashboards will be too.

What goes wrong when you buy on a demo

A BI demo is built to impress. It shows colourful charts on clean sample data that loads in a second. Your data is not like that. It sits in several systems, uses different names for the same thing, and has gaps.

The demo skips the hard part: connecting your sources, cleaning the data and agreeing what each number means. That work decides whether the tool is useful. It is also where the cost of time and outside help grows. Many teams buy BI, build a few dashboards, and then stop using it because nobody trusts the numbers.

Ask every vendor the same questions in writing, about your sources and your team, not about their sample data.

Must ask

  1. "Can you connect directly to each of our data sources, and which connections are included in the price?" List every system you use, including spreadsheets. Ask which connections are built in and which need extra tools or code.
  2. "How often does the data refresh, and can we choose the schedule?" A dashboard that updates once a day may be fine for finance, but not for a sales team watching today's orders.
  3. "Who on our team can build a report, and what skills do they need?" Ask whether a manager can build a simple report alone, or whether it needs someone who writes database queries.
  4. "How do we define a number once, such as revenue or active customer, so every report uses the same figure?" If two dashboards show two different revenue figures, people stop trusting both.
  5. "How do we control who sees which data?" Ask whether you can limit a person to their own region, team or clients, not just to a whole dashboard.
  6. "Where is our data stored and processed, and do you keep a copy of it?" Some tools copy your data into their own storage. Others read it where it sits. Know which one you are buying.
  7. "What does it cost for people who only view reports, compared with people who build them?" Most of your team will only view. Pricing for viewers changes the total a lot.

Worth asking

  1. "Can we share dashboards with people outside the company, such as clients or a board, and is that priced differently?" External sharing is often a separate feature.
  2. "Can reports be emailed on a schedule, or send an alert when a number crosses a limit?" Many people will never log in. A weekly email may be what they actually use.
  3. "How fast are dashboards with our volume of data?" Give them a rough size of your data, and ask for an answer based on that, not on a sample.
  4. "Can we still export data to a spreadsheet?" People will want to. Blocking it pushes them back to copying figures by hand.
  5. "Do dashboards work on a phone?" Ask whether they are built for small screens, or are just shrunk desktop views.
  6. "What help do you give with setup, and what does it cost?" Ask whether they help connect sources and build the first dashboards, or point you to an outside partner.

Hidden costs to look for

How to compare the answers

Put all the written answers in one table, one row per question. Then go through them in this order.

  1. Must-haves first. If a tool cannot connect to a source you depend on, stop there. A workaround here usually means ongoing manual work.
  2. Treat partial answers as partial. "Possible with our partner" or "with a custom connector" means extra cost and someone to maintain it.
  3. Match the tool to your people. If nobody on your team writes queries, weight the answers about building reports without code more heavily.
  4. Price for your size. Give every vendor the same numbers: builders, viewers, external viewers, data sources and data volume. Compare the first-year and second-year totals side by side, including any setup help.
  5. Trial with your own data. Connect two real sources and rebuild one report your team already makes by hand. Check the numbers match.

When you are ready to make a shortlist, see companies that sell business intelligence software. NeutralPick lets you ask them all the same questions for free, with no paid ranking.

Ask every BI vendor the same questions about your own data, in writing, and compare the answers side by side.

Build a checklist