Here's a wall most analysts know too well. You have the data pipeline working, Python scripts pulling from Trino, CSVs landing on schedule, Power Query ready to ingest, but the final mile in Excel breaks under its own weight. The user here is doing everything right: automating the heavy lifting, structuring for repeatability, avoiding volatile formulas that snap like rubber bands. And still, the dashboard stalls on something as basic as a mixed-format row. That's not a skill gap. That's a tool gap.
The problem isn't that Excel can't handle this. It can, in theory, with enough conditional formatting rules, helper columns, and manual intervention. But "in theory" isn't a workflow. The moment a new CSV drops with an extra date column, the carefully balanced formatting collapses. You either rebuild pivot table layouts, write VBA to reapply number formats, or accept that some KPIs will display as raw decimals while others show percentages. None of those are sustainable. The user's real ask is simple: drop data, refresh, get a clean, correctly formatted matrix. That should be table stakes for any modern reporting tool, yet Excel treats it as a customization challenge.
This is where the conversation about "we don't have a dedicated BI tool" becomes instructive. Many teams default to Excel because it's already licensed, already installed, already familiar. But familiarity isn't capability. The user has already built a Python-to-CSV bridge, they're not afraid of code. What they need is a presentation layer that respects data types per row and expands columns dynamically. That's not a spreadsheet strength; it's a data-modeling strength. The fact that they're wrestling with pivot table formatting instead of building the view they want suggests the real blocker isn't technical skill, it's the tool's assumptions about how data should look.
Our take is direct: stop treating Excel as a BI tool. It's a great calculator, a flexible grid, and a familiar canvas. But for a live, mixed-format dashboard that grows with your data, it's the wrong foundation. The user's setup is already halfway to a proper solution, structured queries, automated exports, a refresh trigger. The missing piece is a tool that treats formatting as intrinsic to the data, not as a manual layer you reapply every time a column shifts. Whether that means exploring AI-native spreadsheet alternatives or pushing for a lightweight BI license, the path forward is the same: stop asking Excel to be what it isn't. Let the data drive the format, not the other way around.