Business Intelligence

Business Intelligence


Debates y experiencias sobre <strong>Business Intelligence</strong>: suites de BI, datawarehousing, modelos de diseño, metodologías y mejores prácticas.

Always exploit the possibilities of Business Intelligence tools?


Sometimes we have found that a customer had made a large investment in software licenses Business Intelligence, and then used only a small part of what is acquired.

The most common case is to be acquired BI software and is only used to make reporting operational, rather than use the analytical possibilities of the product. Or that instead of creating new reports are designed to exploit the possibilities offered by a suite of BI, is requested or make only a migration of existing reports on an old platform reporting.


The problem is that usually occurs after having invested heavily can be a feeling that has not improved much and cause some dissatisfaction with the software.

Sometimes it also happens that licenses are being purchased, but after booting the project will not resort to external specialized consulting services, although the staff of the IT department does not have enough experience to implement a BI system.

You agree with us? Someone has been found in similar situations? I think there may be other causes?



Saima solutions


Time dimension: Star Schema or Snowflake?


Hello everyone:

I am preparing the design of a DW for use with Pentaho, and to revise the definition of the time dimension I have some doubts. I explain:

DW is a sales analysis. In the model I have two fact tables, one for sales, whose granularity is at the level of day, customer, product, etc, and a fact table which records the information in the sales forecast (this table has a level of different granularity, where a month and level of client channel (which is one of the attributes of the customer dimension)). The keys to the fact table are not therefore the keys to the dimension table, but a component within a dimension.




Initial Logical Model

Given this, I rather doubt arise about the best design choice to build the database:

1) Having made tables on a different level of granularity, is it necessary or advisable to spend the dimensions involved in a star schema to work properly after the consultation?.