Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

Do I need a data warehouse to see all my business numbers together?

Short answer

A warehouse is one copy of data from your tools, arranged for reporting. A small business needs it only when reports must combine several sources and spreadsheets no longer cope. Google describes BigQuery as a serverless platform that loads files or streams and separates storage from compute. Fix data quality first.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • Monthly numbers come from five exports and one very fragile spreadsheet.
  • Reports take hours to build and nobody checks them.
  • Numbers from the shop, ads and accounts never agree.
  • The spreadsheet is slow, crashes or hits row limits.
  • I want one dashboard, but each tool gives a different figure.

Why does this happen?

  1. Each tool reports only its own part

    Your shop knows orders, your ad account knows spend and your accounting knows money. Profit per campaign needs all three joined, and none of them can do that alone.

  2. Spreadsheets reach their limits

    Large files get slow and formulas break as sources grow, and a mistake in one cell flows into every report.

  3. Definitions differ

    Does revenue include tax, refunds, shipping? Each tool counts differently, so even a perfect copy of the data gives different totals until the definitions are agreed.

  4. A warehouse stores data for analysis

    Google describes BigQuery as a fully managed, serverless data platform for storing and analysing data with SQL, loading from files such as CSV and JSON or by streaming, with storage and compute scaled separately.

  5. Bad data makes a warehouse worse

    Duplicates, missing IDs and inconsistent names copied into a warehouse only produce wrong numbers faster.

What can I do about it today?

  1. Write the five questions you really want answeredFor example profit per product, repeat customers, cost per lead. The questions decide what data is needed.
  2. Define the key wordsRevenue, customer, order, active. Write one sentence for each and have the team agree.
  3. List where each answer's data livesWhich tools, which fields, and whether they can be exported or connected.
  4. Try the simple route firstIf two sources are enough, a well-built spreadsheet or the reporting tool you already have may do the job.
  5. Check who may see whatCustomer and payment data needs access control. Do not share exports widely.

When should I bring someone in?

  • Three or more sources must combine for a report you rely on.
  • The numbers are wrong and no one can say which source is right.
  • You want a dashboard that updates by itself.

How do I handle it?

  1. Start from the questionsI build for the five questions, not for all data in every tool.
  2. Fix identifiers and definitionsI agree with you on what counts as a customer or an order, and how records match across tools.
  3. Choose the smallest tool that worksA reporting view on an existing database or one managed warehouse, depending on volume, skills and cost of upkeep.
  4. Load in a repeatable wayScheduled loads with logs and alerts, so a failed update is visible and not silently stale.
  5. Reconcile to the booksThe first report is checked against figures your accountant already trusts.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Is a data warehouse overkill for a small business?

Often, yes. If two sources and a few thousand rows are involved, a simpler approach is better.

Do I need BigQuery specifically?

No. It is one option. The choice depends on your data, your skills and who maintains it.

Will it fix wrong numbers?

Only if definitions and data quality are fixed first. A warehouse reports what it is given.

Who looks after it afterwards?

Someone must own the loads and the access rules. I write a short handover so it does not depend on one person.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.