Build for the Questions You'll Ask Next

At least once a week, someone asks me to help them build a dashboard. They’ve got data scattered across three or four systems, nothing talks to each other, and they’re convinced a Power BI report will fix it.

It won’t.

We sit down, start mapping their data, and realize the dashboard they want requires manually stitching together sources that were never designed to connect. They’re already doing this in Excel. The dashboard just automates the duct tape.

The better move is to stop and ask a harder question. What if we built the foundation first?

Modern data platforms like Snowflake and Databricks aren’t just warehouses anymore. They handle ingestion, transformation, orchestration, and analytics natively. Built-in security and governance. Natural language interfaces. The whole stack lives in one place, and the platform-native capabilities keep expanding.

This changes the math on build vs. buy decisions. Instead of paying for six different tools that sort of work together, you invest in one platform and push it to its limits.

I saw this play out recently with a client. They came in wanting unified visibility across their lead management, manufacturing, and CRM systems. Classic dashboard request. But when we dug in, we found three siloed systems with no shared keys, manual data pulls, and business logic trapped in spreadsheets, if it existed anywhere at all.

We built a data foundation in Snowflake, connected their sources through proper pipelines, modeled the relationships once, and gave them a lightweight analytics layer on top. Now they can answer any question, not just the ones they thought to ask upfront.

That’s the shift. Dashboards answer the question you had last quarter. A solid data platform lets you ask questions you haven’t thought of yet.

And once the foundation is in place, you can move fast. Need a dbt model to transform messy source data? Minutes. Want to spin up a lightweight app that lets ops explore the data themselves? An afternoon. Tools like Claude Code make this real. The platform handles infrastructure, security, and scale. You focus on the questions that matter to your business.

So the next time someone asks for a dashboard, push back a little. Ask what problem they’re actually trying to solve. Odds are, the answer isn’t another report.