Last month, I described analytic application stages that are useful to think about the architecture of a data warehouse (DW)/business intelligence (BI) system. We considered the example of an airline fare planner who is tasked with determining why the yield has dropped. Remember that in this case yield refers to a key performance indicator (KPI) signifying the revenue or profits from a fixed, perishable resource. In this month’s column, I’ll continue with this example and explore how to implement analytic capabilities to explore “why” in a real data warehouse/business intelligence system. The fare planner may ask “why” in five ways:

1. Give me more detail.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access