The Ecomm Analyst

Tableau is a serious analytics platform, and for most stores under $20M that is exactly the problem. It assumes you already have clean, modeled data sitting somewhere and an analyst who can turn it into visualizations. If you are a Shopify operator trying to see revenue by channel without opening a spreadsheet, you are paying for the wrong half of the product.

Pricing is the other issue. On Tableau’s own pricing page, the Cloud Standard edition runs $75 per Creator per month, $42 per Explorer, and $15 per Viewer, all billed annually. Every deployment needs at least one Creator, and there is no month to month option. Move up to the Enterprise edition and those become $115, $70, and $35. A five person team ends up with a four figure annual commitment before anyone has connected a data source.

Here are the alternatives I would actually look at, ranked roughly by how well they fit an e-commerce operator rather than a data team. All pricing below comes from each vendor’s own page.

1. Metabase

The closest thing to a like for like swap if what you want is genuine BI without Tableau’s licensing structure. The open source edition is free to self host. Metabase Cloud Starter is $100 per month with the first five users included and $6 per additional user per month, or $1,080 per year. Pro is $575 per month with ten users included and $12 per user beyond that.

The query builder is approachable enough that a non technical operator can answer their own questions, which is the thing Tableau promises and rarely delivers at this company size. The catch is the same as with Tableau. Metabase visualizes whatever is in your database, so you still need the data to get there. I went deeper on the tradeoffs in the Metabase alternatives roundup.

2. ThoughtMetric

Worth naming here because a lot of Tableau evaluations start with a question that is not really a BI question. If what you are trying to build is a dashboard showing spend, revenue, and ROAS by channel, you do not need a visualization platform. You need something that connects the ad platforms to your store data. ThoughtMetric, which sponsors this blog, does that connection natively rather than requiring you to model the data first, and it starts at $99 per month with every feature included at every tier and a 14 day trial. Annual billing works out to roughly $83 per month.

Be clear about the scope. This is an attribution and marketing reporting tool, not a general purpose BI platform. If you need inventory analysis, cohort modeling on arbitrary dimensions, or finance reporting, it will not replace Tableau. If you need marketing numbers, it replaces the reason most operators were looking at Tableau in the first place.

3. Power BI

The obvious cost driven alternative. Power BI Desktop is free for authoring, and Power BI Pro is $14 per user per month paid yearly, which is what you need to publish and share reports. Premium Per User is $24 per user per month and adds larger models and more frequent refreshes.

Against Tableau’s $75 Creator seat, that is a real saving, and Pro is included with Microsoft 365 E5 if your company already has it. The trap is that everyone who views a report needs a paid license too, so a fifteen person team is fifteen seats. Also worth knowing that Power BI on macOS is a genuine constraint, since the desktop authoring tool is Windows only.

4. Looker Studio

Free, which is why so many agencies build client dashboards in it. If your data already lives in Google properties, the connections are trivial and the reports are shareable with a link.

Two caveats. Non Google sources usually need a paid third party connector, and those subscriptions often cost more than the BI tool would have. And in the free tier, reports belong to the individual account that created them, which becomes a problem the day that person leaves. There is a paid Pro tier that addresses ownership and governance, billed per user per Google Cloud project. Check Google’s current pricing before you budget for it, because the per project part of that structure surprises agencies running separate projects per client.

5. Polar Analytics

Built specifically for DTC rather than adapted to it, which means the metrics are already defined and you are not building a revenue by channel view from scratch. That is the appeal against Tableau, where everything is a blank canvas.

Polar does not list pricing on its website, so a demo is required to find out what you would pay. That is a real friction point when you are trying to compare five options on a spreadsheet, and it usually means the number scales with something about your business rather than a flat seat count.

How to choose

Answer one question first. Do you have a data warehouse with modeled data in it? If yes, this is a BI tool decision and Metabase or Power BI is probably your answer on cost alone. If no, buying Tableau or any of its direct competitors means buying a tool that has nothing to visualize yet, and the pipeline work will cost you more than the licenses.

Most sub $20M operators I talk to are in the second group and did not realize it until three months into an implementation.