Business Intelligence

When designing the architecture of a data warehouse system we have to raise different environments for which data must pass en route to its Data mart or target cube. Given the amount of changes that have to do, and normally the DWH, besides fulfilling its function of support analytical
requirements, performs a data integration function that will form the Corporate store and they will have to be also consulted the traditional way by the operational systems, it is recommended to create different data areas in the path between source systems and OLAP tools.

Each of these areas as characterized by the functions performed, how data is organized in the same, and what type of need can service. The area that is 'at the end of the road' is important, but it will not be the only store data that will exploit the reporting tools...

The BI-DWH world can now enjoy a new version of the methodology Hefesto to build a Data Warehouse. Engineer Ricardo Dario Bernabeu has completed version 1.0, which replaces the original 0.1, published in our manual section, which we discussed in another article. 

We have updated the online manual for Dataprix with the methodology, but for those who prefer download the attached document in pdf format which has published Dario.

As always, I encourage anyone who wants to make any improvement or suggestion, surely the author of the work is appreciated.

Using ROLAP (Relational Online Analytical Processing) or MOLAP (Multidimensional OnLine Analytical Processing) is something to be raised at the stage of physical design and affects how the tool of exploitation of the Data Warehouse 'attack' to the data .

If ROLAP, the attack tool to exploit the information directly to the stars that have been created in the relational DBMS chosen.

Nigel Pendse is the principal analyst and author of the well known OLAP and OLAP Survey Report, which provide key information in the world of Business Intelligence, especially if you select a tool on which to base a BI system and to obtain an analysis professional and independent of the best products available on the market.

The consultant BARC, current owner of the reports published two articles on your website very interesting and translated into Castilian by Nigel Pendse.

In Nigel Pendse explains the process for Business Intelligence projects, the author provides several guidelines for the implementation and subsequent maintenance of a successful Business Intelligence project. The points covered are: