Business intelligence (BI) is the process and the tools that turn raw data from a business's systems into metrics you can make decisions with. In an online store, the data comes from the store platform, the payment processor, inventory and costs, and each one tells only part of the story. A BI tool brings them together, calculates metrics such as revenue, gross profit and average order value, and shows them in charts and reports you can filter by period, store or product. The goal is simple: know what is really happening in the business without opening five systems and copying numbers into a spreadsheet.
What is business intelligence
Business intelligence answers business questions from exact data rather than gut feeling. It calculates and shows what happened, and lets you break any number down by store, period or product.
What a BI system is made of
- Data sources. Orders, customers, products, stock and costs, from every store and channel.
- Combining and cleaning. Matching the same customer or product across systems and putting everything into one structure.
- Metrics. Defined calculations, such as revenue, gross profit and profit margin.
- Display. Dashboards, charts and tables, filterable by date and other dimensions.
BI metrics for an online store
- Revenue and order count. By day, week or month, and by store if you have more than one.
- Gross profit and margin. What is left after product cost, not just what was sold.
- Average order value. Shows whether customers buy more or less each time.
- New vs returning customers. Shows whether growth comes from new customers or leans on existing ones.
- Stock value. How much money sits on the shelves, and in which categories.
Example: gross profit and average order value
Say that in one month a store sold $100,000 across 400 orders, and the cost of the goods sold (COGS) was $60,000.
- Gross profit = revenue minus cost of goods = 100,000 − 60,000 = $40,000.
- Gross margin = gross profit divided by revenue = 40,000 ÷ 100,000 = 40%.
- Average order value (AOV) = revenue divided by number of orders = 100,000 ÷ 400 = $250.
The value of BI shows when you break these numbers down: if gross margin drops from 40% to 32%, the dashboard should help you see whether it is one store, one category or a cost that went up.
Business intelligence vs reports and AI
- A report: a fixed snapshot, such as this month's sales.
- Business intelligence: lets you ask a question and filter, such as the same sales by store and by week.
- AI for business: models that read and write text.
Both are useful, but business numbers should come from calculation, not from phrasing.
Common mistakes
- Revenue without costs. A dashboard that shows only sales, without product cost, shipping and fees, makes the business look more profitable than it is.
- Too many charts. Twenty charts nobody checks are worth less than five checked every week.
- Data out of sync. Comparing stores whose data updates at different times leads to wrong conclusions.
- Confusing GMV with revenue. Gross merchandise value does not account for returns and cancellations, and says nothing about what is left.
Business intelligence in StoreChart
StoreChart's business intelligence builds dashboards from every store you connect:
- Metrics: orders, revenue, gross profit, costs, profit margin, items sold, customers and stock value.
- Ready-made presets: sales trend, revenue by store, profit trend and cost breakdown.
- Your own charts: add them to a dashboard and filter by date range and store.
- Where profit comes from: the profit calculation of each order.
- Not included: there are no metric targets or alerts at the moment.
Frequently asked questions
Business intelligence vs artificial intelligence?
Business intelligence calculates and displays what happened in the business, from exact data. Artificial intelligence reads, sorts and writes text. When you ask how much profit you made last month, you want a BI calculation, not a language model's phrasing.
Does a small business need a BI tool?
Yes, once data lives in more than one place. A single store with its platform's built-in reports can manage at first, but with a second store, another sales channel or costs the platform does not see, it is hard to see real profit without BI.
How often should I look at a dashboard?
Check sales and orders daily or weekly, and review profitability and stock at least monthly. Looking at the same few metrics consistently matters more than building more and more charts.