Excel Is Still the #1 Self-Service Analytics Tool. Here's Why That's Not a Problem Anymore.
Your company just renewed its Tableau license. Your analysts just exported the data to Excel.
This scene plays out in nearly every enterprise analytics department in the world. And yet, IT leaders keep funding BI platforms, training programs, and data governance initiatives — while business users quietly keep opening spreadsheets.
This isn't a failure. It's a signal. And understanding what it means is the key to building an analytics stack that people actually use.
What Self-Service Analytics Actually Means
Self-service analytics refers to the ability of business users — not data engineers or BI developers — to independently access, explore, and analyze data without submitting a ticket to IT.
The market has taken notice. Analysts estimate the global self-service analytics market was valued at roughly $5–6 billion in 2024, growing at a CAGR of ~16% toward a potential $17–27 billion by the early 2030s. The growth is real. But it masks a more nuanced picture on the ground.
For CTOs and IT directors, the promise of self-service is compelling: fewer bottlenecks, faster decisions, reduced dependency on data teams. The challenge is delivering on that promise without creating a mess of shadow reports and disconnected data sources.
The Landscape: A Quick Map of the Tools
There are five broad categories of tools that compete — and coexist — in the self-service space:
- Spreadsheets (Excel, Google Sheets) — The original self-service layer. Every business user already knows them.
- Modern BI platforms (Power BI, Tableau, Looker) — Visualization-first tools with strong governance features and growing AI capabilities.
- Embedded analytics (Metabase, Redash) — Lightweight, often open-source, embedded inside applications.
- Headless BI / semantic layer (dbt Metrics, Cube.dev) — Code-first approaches to defining business logic independently of visualization.
- OLAP servers (Microsoft Analysis Services, XLTable) — Traditional and modern cube-based engines that sit between databases and analytics clients.
Each category has genuine strengths. The problem is that organizations often treat them as competitors when they are more naturally complements.
The Excel Paradox
Let's be direct: Excel is not going away. Over 200 million enterprise users are licensed on Microsoft 365 globally. More than 1.3 million companies in the US alone use it. It is the most widely declared skill on LinkedIn among corporate professionals, ranging from 17% to 32% penetration depending on job function.
And yet, the standard narrative in enterprise IT is that Excel is a legacy tool — a crutch for users who haven't been properly trained on "real" analytics platforms.
This framing is wrong, and it's causing expensive mistakes.
Executives don't use Tableau to build their Monday morning model. They use Excel. That's not a training problem. That's a product-market fit signal.
Excel's persistence isn't about inertia. It's about control. A pivot table in Excel is something a finance director can manipulate in real time, in a meeting, with no dependency on a dashboard developer. The cognitive overhead is near zero. The flexibility is near infinite.
The actual problem with Excel isn't Excel. It's the data feeding it.
The Real Bottleneck: Data Access, Not the Spreadsheet
When analysts export from Snowflake or ClickHouse into a CSV and then import it into Excel, two things go wrong:
- The data is stale the moment it lands in the file.
- The analyst becomes a manual ETL pipeline — a job they weren't hired to do.
This is where the architecture conversation needs to shift. The question isn't "How do we get users off Excel?" It's "How do we give Excel a live, governed connection to real data?"
The answer exists and has for decades — it's called XMLA. It's the protocol that Microsoft built for exactly this scenario: connecting Excel PivotTables to analytical databases through a standardized interface. Analysis Services used it. Power BI uses it. And modern OLAP servers can expose it to any backend — ClickHouse, Snowflake, BigQuery, StarRocks, Databricks.
When you connect Excel to a properly modeled OLAP cube, several things change simultaneously:
- Users get live data, not exports.
- Business logic (metrics, hierarchies, access rules) lives in one place — the semantic layer.
- Finance stays in Excel. IT controls the data.
- No SQL required for end users. No BI license required per seat.
What CTOs Should Actually Be Asking
Most analytics infrastructure reviews focus on the wrong question: "Which BI tool should we standardize on?" A better set of questions:
- Where does data actually get consumed? Follow the spreadsheets, not the dashboards.
- What is the total cost of the export-import loop? Count analyst hours, not just license fees.
- Do we have a semantic layer? If business logic lives in reports rather than in a governed model, you have a governance problem regardless of which tool you use.
- Can our stack serve both technical and non-technical users from the same source of truth? If the answer is "no," you are maintaining two parallel data cultures.
- What is the adoption rate of our BI investments? If it's below 30%, the tool is not the answer.
A modern analytics stack doesn't have to choose between Excel and BI. It can serve both — provided the data layer is properly architected.
The Modern Answer: Embrace Excel, Fix the Data Layer
Here is a practical architecture that resolves the Excel paradox without forcing users to abandon tools they trust:
- Build a semantic layer on top of your analytical database. Define measures, dimensions, hierarchies, and access rules once.
- Expose that layer via XMLA so Excel connects natively — no plugins, no extensions.
- Keep BI tools for dashboards, alerts, and shared views. They're excellent at that.
- Let Excel do what Excel does: ad-hoc analysis, financial modeling, executive reporting.
The result is a stack where data governance and user freedom aren't in tension. IT owns the model. Business owns the analysis.
What About AI Chat? ChatGPT, Claude, and the "Just Ask" Trend
There's a growing narrative that AI chat interfaces will replace both Excel and BI tools entirely. Users are already asking ChatGPT for dashboards and getting back static charts. The question CTOs are asking: is this the end of structured analytics?
The honest answer is: AI chat and Excel are not competing for the same job.
AI chat interfaces excel at one thing — answering a one-off question quickly. "What was our best-performing region last quarter?" works well in a chat window. But the moment you need that answer to be repeatable, auditable, consistent across departments, and connected to data that updates daily — chat alone falls short.
Here's why:
- Data is not live. Users upload a CSV from yesterday. Tomorrow they upload a new one. The export-import loop moves from email to chat — but it's still a loop.
- No single source of truth. Every employee gets their own answer from their own data. Finance and Sales produce different numbers for the same metric.
- No audit trail. A CFO cannot sign off on a report generated by a language model without traceability.
- Security. Most enterprise data governance policies prohibit sending sensitive business data to external AI providers.
AI chat is an interface for one-off questions. Excel and BI are the environment for repeatable, governed, auditable decisions. They are not competitors — they are built for different jobs.
But here is where the picture gets more interesting — and where the real opportunity lies.
When an AI assistant connects directly to a live semantic layer via a protocol like MCP (Model Context Protocol), the equation changes entirely. Instead of answering from a stale uploaded file, an AI can query a live OLAP cube and return current, governed data — directly in the chat interface.
This means the user gets the conversational experience they want, with the data integrity the organization requires. The AI becomes a natural language interface to the same semantic layer that powers Excel PivotTables and BI dashboards — not a replacement for it.
For organizations building on a modern OLAP layer, this is not a threat. It is an additional channel — one that makes the investment in a proper semantic layer even more valuable.
Conclusion
Self-service analytics is not a tool. It's a capability. And the most effective organizations build it around how their people actually work — not around how vendors think they should work.
Excel is not the enemy of modern analytics. Ungoverned data is. Once you solve the data layer, the spreadsheet becomes a feature.
Stop trying to replace Excel. Start connecting it to something worth analyzing.
Top comments (0)