# Business Intelligence Basics: From Records to Decisions | ZINC

Source: https://www.zincdigital.co/blog/business-intelligence-basics/

ZINC / Intelligence

# Business Intelligence Basics: From Records to Decisions

October 6, 2026 / [Kirk Musick, MS, MBA](https://www.zincdigital.co/authors/kirk-musick/) / Intelligence

Pillar: [Business Intelligence](https://www.zincdigital.co/blog/category/business-intelligence/)

![Illustrated business intelligence workspace connecting commerce, search, ads and products to a decision sheet.](https://www.zincdigital.co/_astro/article-bi-basics.CcPpYlda_Z1FoAJg.webp)

- [Home](https://www.zincdigital.co/)
- [Insights](https://www.zincdigital.co/blog/)
- Business Intelligence Basics: From Records to Decisions

Written by

## [Kirk Musick, MS, MBA](https://www.zincdigital.co/authors/kirk-musick/)

CEO

Kirk Musick leads ZINC Digital. His articles cover technical SEO, measurement and the decisions behind the work.

[More from Kirk](https://www.zincdigital.co/authors/kirk-musick/)

Published

October 6, 2026

In this article

- [Start with a business question](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-0)
- [Identify the source records](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-1)
- [Define the measures and dates](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-2)
- [Build the view around the decision](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-3)
- [Assign an action and verify it](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-4)
- [Define one measure before drawing the chart](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-5)
- [Make the definition reproducible](https://www.zincdigital.co/blog/business-intelligence-basics/#article-section-6)

[Back to articles](https://www.zincdigital.co/blog/)

TL;DR

Choose a decision before choosing a dashboard. Identify the source records, agree on metric definitions and compare consistent periods. Give the resulting action an owner and a review date; keep missing data, estimates and recorded results visibly distinct.

Business intelligence turns business records into decisions people can act on. It connects sources, defines the measures and shows what changed. You need it when separate reports leave the team arguing about what a number means.

## 1. Start with a business question

Choose a decision with an owner: which products need attention, where checkout stalls or whether a campaign is producing useful demand. Write what could change after the answer.

## 2. Identify the source records

Name the system behind each measure. Store orders, search impressions and platform-attributed purchases represent different records. Preserve that distinction when connecting them.

Google's [GA4 Data API guide](https://developers.google.com/analytics/devguides/reporting/data/v1/basics) describes reports built from a specific property, dimensions, metrics and date ranges. A connection returns data; it does not decide whether the comparison makes business sense.

## 3. Define the measures and dates

Write what each metric includes, excludes and counts. Specify the time zone, period and source freshness. Distinguish recorded results from projections. Show incomplete coverage rather than treating missing records as zero.

For purchase measurement, check the [GA4 purchase specification](https://developers.google.com/analytics/devguides/collection/ga4/reference/events#purchase) and trace an order using our [event validation guide](https://www.zincdigital.co/blog/ga4-ecommerce-event-validation/). Keep those definitions available alongside the report.

![Illustrated traffic acquisition report beside channel decision cards, with values omitted.](https://www.zincdigital.co/_astro/marketing-channel-planning.DwGpV3K3_8k5CD.webp)

Connect the reporting view to the decision it needs to support.

## 4. Build the view around the decision

Put the comparison, relevant breakdown and source date where the operator can see them. Identify attribution limits and incomplete records in the view itself.

In client work, our team built reporting into a staff application alongside assignments and service-history records. The public website was a separate part of the engagement. A prospective buyer needs an explanation of the offer; an operator needs records that support the next task. Decide which person the report serves before deciding what belongs on its first screen.

For a procurement-focused example, see [ZINC Fusion v16](https://www.zincdigital.co/work/zinc-fusion-v16/), a soybean-oil forecasting platform in development. Its project overview describes market dashboards, purchasing scenarios and policy and sentiment views, with source dates, forecast horizons and data-availability context.

## 5. Assign an action and verify it

Record the observation, proposed action, owner and review date. After the change, compare the same defined measures over a suitable period. A report should help test a decision, not claim the decision worked before evidence arrives.

Decision record: question; source; metric definition; coverage dates; finding; limitation; action; owner; next check.

Start with one question through [business intelligence](https://www.zincdigital.co/services/business-intelligence/). The [channel planning guide](https://www.zincdigital.co/blog/seven-digital-channels-which-to-skip/) helps choose which marketing decisions deserve attention first.

## Define one measure before drawing the chart

Illustrative question: did the store’s net sales improve? Agree whether net sales subtract discounts and refunds, whether tax and shipping are excluded, which currency applies and whether refunds belong to their processing date or the original order cohort. Different valid definitions answer different questions.

Here is an illustrative definition and sample: net merchandise sales for an order cohort = merchandise charged after discounts minus merchandise refunds for those same orders as of the review date. Exclude tax and shipping from both sides. Use USD, the store's CT order dates and a stated refund-review cutoff. This is a cohort definition; it differs from subtracting all refunds processed today from today's new orders.

| Order | Merchandise after discounts | Merchandise refunded by cutoff | Net merchandise sales |
| --- | --- | --- | --- |
| A | $80 | $0 | $80 |
| B | $100 | $20 | $80 |
| C | $60 | $60 | $0 |
| Total | $240 | $80 | $160 |

A dashboard showing $240 has not yet applied these refunds. A dashboard showing $150 might include an unrelated $10 refund from a different order cohort. Neither discrepancy is solved by choosing the more flattering total. Trace the contributing records and use the agreed definition. Keep later refunds as dated revisions instead of pretending the earlier observation never existed.

Take a small sample of source orders and calculate the agreed measure by hand before trusting the dashboard total. Record source, grain, formula, exclusions, time zone, freshness and owner. If an order feed is missing, show the incomplete coverage rather than a zero. The acceptance test is that a second person can reproduce the result and understand what action it supports.

## Make the definition reproducible

Use one row per measure. Record the source, grain, formula, exclusions, time zone and cutoff, then reconcile a small sample independently. The specimen uses the article’s fictional $160 order-cohort example; it is not a live sales report.

[Download the metric-definition worksheet](https://www.zincdigital.co/downloads/metric-definition-check.csv). Open the CSV in your spreadsheet application, keep the specimen labelled, and add your own rows. Pending observations are work to complete, not failed or successful results.

## Sources

- [GA4 Data API guide](https://developers.google.com/analytics/devguides/reporting/data/v1/basics)developers.google.com
- [GA4 purchase specification](https://developers.google.com/analytics/devguides/collection/ga4/reference/events#purchase)developers.google.com

Keep the pieces connected

## Read next.

This article is part of the [Channels & measurement guide](https://www.zincdigital.co/blog/seven-digital-channels-which-to-skip/).

- [GA4 UTM Naming Conventions: Build a Clean Campaign Record](https://www.zincdigital.co/blog/ga4-utm-naming-conventions/)
- [Build a Research Consensus Report You Can Use](https://www.zincdigital.co/blog/research-consensus-report/)
- [AI Research Workflow: Find, Check, Decide](https://www.zincdigital.co/blog/ai-research-workflow/)

Share the article

[LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fwww.zincdigital.co%2Fblog%2Fbusiness-intelligence-basics%2F)[Facebook](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.zincdigital.co%2Fblog%2Fbusiness-intelligence-basics%2F)[X](https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.zincdigital.co%2Fblog%2Fbusiness-intelligence-basics%2F&text=Business%20Intelligence%20Basics%3A%20From%20Records%20to%20Decisions)

A question about this article? [Message Wendy](https://www.zincdigital.co/contact/#message-wendy)

### Explore Business Intelligence

[Our Business Intelligence service](https://www.zincdigital.co/services/business-intelligence/)

[More Business Intelligence articles](https://www.zincdigital.co/blog/category/business-intelligence/)

- [Apps](https://www.zincdigital.co/services/apps/)

[Return to all articles](https://www.zincdigital.co/blog/)

From insight to a briefBusiness IntelligenceStart with the decisions your reporting needs to support.

[Request a proposal](https://www.zincdigital.co/contact/?service=business-intelligence)

Keep learning

## Choose your how-to topics

Start with Business Intelligence, then choose any other subjects you want. Pick one subject or several, and change your interests at any time.

[Choose topics](https://www.zincdigital.co/subscribe/?topic=business-intelligence)
