Operational, Tactical and Strategic BI
The Kolkata delay now has three owners asking three questions. The shift lead wants to know which parcels will miss today's promised date. Farah wants to know whether to add an evening shift for the next three months. Meera wants to know whether Weftwise should open a warehouse in the south next year. Same problem, three very different reports. Mixing them up gives each person the wrong thing.
The rule
Today's action, this quarter's plan, next year's direction.
BI serves three levels of decision, and each level sets the report's users, freshness and detail:
| Level | Who | Horizon | Refresh | Detail |
|---|---|---|---|---|
| Operational | Shift leads, support staff | Today, this hour | Hourly or close to live | Single orders and parcels |
| Tactical | Department heads such as Farah and Rohan | Weeks to a quarter | Daily or weekly | Grouped by week, site, channel |
| Strategic | Meera and investors | A year or more | Monthly or quarterly | Summarised trends and comparisons |
- Operational BI helps someone act right now: a list of today's at-risk orders, sorted by promised date. The data must be fresh; a report that is a day old is useless at this level.
- Tactical BI helps a team plan and adjust: weekly on-time rate by warehouse and shift, used to decide staffing for the next quarter.
- Strategic BI helps set direction: two years of orders by region, delivery times to southern states and the cost of a new site. It changes slowly, so fresh data adds cost and noise rather than insight.
The shortcut
Read the clock in the question. "Today", "now" or "this shift" means operational. "This month", "next quarter" or "for the season" means tactical. "Next year", "should we become" or "should we enter" means strategic. Then set the refresh and the detail to match the clock.
"Which Kolkata parcels will miss today's promised date?"
The clock says today: operational. Refresh every hour, list individual orders, and put it on the shift lead's phone.
The trap is a mismatch between the clock and the report. A live, second-by-second feed for a strategic question is expensive and distracting; a monthly summary for an operational question arrives after the parcels have already missed their dates.
Drills
Answer fast — trust the rule.
"Which orders placed before noon are still waiting to be packed?" Which level of BI is this?
Rohan asks which ad channel should get more budget next quarter. Which level is this?
How often does a strategic report on "should we open a southern warehouse" typically need refreshing?
Meera asks for a live, minute-by-minute order feed to plan next year's warehouses. What is the best response?
What level of detail does operational BI usually show?
Remember
- Today's action, this quarter's plan, next year's direction.
- Read the clock in the question, then match refresh and detail to it.
- Trap: live feeds for strategic questions, monthly summaries for operational ones.