O'Reilly logo

Business Intelligence by Jerzy Surma

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2.4. Sources of Data

Returning to the example of the report from Table 2.1, it is vital to understand how the fact table (i.e., Table 2.2) and other tables were filled in with data. For instance, in order to calculate the sales quantity for a given product, one must

  1. check which transactional data system the source data (i.e., the invoices or orders, on the basis of which one can specify the quantity of sales) are stored in.
  2. determine the interface between the system with the source data and the data warehouse and enter suitable data. Information from the given day should be added to the previous data to extend the history of sales by another day.
  3. aggregate the data from the invoices, which are single transactional business events, to show the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required