Across the Table Build. Grow. Thrive.

AI & Technology Business Job 17 · Episode 17 Free Business Insights

Power BI vs Tableau vs ThoughtSpot

Dashboards and analysis — and the honest answer about whether your business needs any of this yet

About 6 min read

Download Knowledge Brief (PDF) .pdf · 115 KB

Illustrative figures are not actual client results.

The job these three do

Every business wants to "see its numbers". These three are the tools that promise it.

Here is the thing nobody selling them says: all three assume your data is already somewhere tidy and connected. If your numbers live in your books, a spreadsheet and your head, none of these will help until that changes.

This article is as much about whether to start as which to pick.

The step before any of these

These are reporting tools, not tidying tools. Getting your data into one clean place is the real work — and it is most of the work. A small business with clean books and a spreadsheet often has everything it needs without buying anything here.

Who each one is

Power BI — the Microsoft one. Microsoft’s business intelligence and dashboards. Best for Microsoft-centered reporting. Watch out: Data modeling is the real work.

Power BI is the natural choice if your business already runs on Microsoft. The honest warning in your own data says it: modelling the data is the real work, not building the chart.

Tableau — the serious analysis one. Deep visual analytics and exploration. Best for Teams doing serious analysis. Watch out: Needs skilled hands.

Tableau is for teams doing genuinely deep analysis and it needs skilled hands. Three stars for small business, which is accurate.

ThoughtSpot — the plain-question one. Ask questions of your data in plain language. Best for Non-analysts who need answers themselves. Watch out: Requires a modeled data source.

ThoughtSpot lets people ask questions in plain words rather than building reports. Appealing — but it still needs a properly modelled data source underneath, so it does not remove the hard part.

How they compare

Power BITableauThoughtSpot
Best forMicrosoft businessesDeep visualizationAI and search analytics
EaseIntermediateIntermediate / AdvancedIntermediate
Small-business fit★★★★☆★★★☆☆★★★☆☆
Advanced fit★★★★★★★★★★★★★★★
Its main jobBI and reportingVisual analysisAsk questions of data
Choose this ifYou’re Microsoft-heavyAnalytics sophistication mattersYou want conversational analytics
PricePer user/month.Per user/month.By consumption.

Read the small-business fit row carefully: four stars, three, three. This is the first card in the series where the honest answer for many readers is "not yet".

How a business actually uses each one

A business on Microsoft with tidy data. Power BI. Sales, costs and hours in one dashboard the owner actually opens on a Monday.

A company with an analyst. Tableau. It rewards skill, and without someone who has that skill it mostly produces expensive charts nobody reads.

A team whose questions keep changing. ThoughtSpot, so people get answers without queueing for a report. Only works once someone has modelled the underlying data properly.

What it costs

Power BI and Tableau are per user per month. ThoughtSpot is priced by usage.

The subscription is not the main cost. The main cost is the person who connects and models your data, and that cost exists whichever of the three you choose.

Where this sits in your stack

The business owner doesn’t simply need another dashboard. They need answers. Instead of “Revenue: $500,000”, ask “why did revenue decline 11% in Arizona last quarter?” HubSpot brings the sales data, QuickBooks the financial data, marketing the campaign data, HR the workforce data and customer service the service data. All of it feeds business intelligence — and then an AI assistant helps interpret, investigate and communicate approved information.

HubSpot — sales data
QuickBooks — financial data
Email platform — campaign data
JuntosHR — workforce data
Zendesk / Intercom — service data

The CEO decision

Is your data already in one clean place? If not, that is the project, not this.
Who will build and maintain the reports? Without a named person this does not happen.
What decision would a dashboard change? If you cannot name one, you are buying a screen rather than an answer.
Would a spreadsheet do for now? For many small businesses, honestly, yes.

Apply it to your business

Write down the three numbers you would check every Monday if they were easy to see. Just three.

Now work out where each one lives today and how long it takes to find. If it is under ten minutes a week, build the habit with a spreadsheet and skip this card entirely. If it takes hours, you have a real case — and the first step is still tidying the data, not buying a tool.

Your quick review

☐ What three numbers would I check every Monday?
☐ Where does each one live right now?
☐ How long does it take me to find them today?
☐ Is my data in one clean place?
☐ Who would build and maintain the reports?
☐ What decision would actually change as a result?

Additional resources

Power BI — www.microsoft.com/en-us/power-platform/products/power-bi — Microsoft-centered reporting.
Tableau — www.tableau.com — Teams doing serious analysis.
ThoughtSpot — www.thoughtspot.com — Non-analysts who need answers themselves.
Across the Table AI Assessment — acrossthetable.biz/#assessment

Continue learning

This is Business Job 17 of twenty. Episode 18 is Handle Contracts — Spellbook, Harvey and CoCounsel.

Episode 13, on bookkeeping, is the prerequisite for this one: clean books are where trustworthy numbers come from.

Read and connect with Across the Table

Across the Table website: https://acrossthetable.biz/

The Scaling Edge newsletter: https://acrossthetablebiz.substack.com/

All Knowledge Articles