Artículos IT, información y publicaciones sobre Data warehouse

Últimas publicaciones destacadas en Dataprix sobre esta temática TIC

Introduction to IBM Cognos BI, Business Intelligence suite of IBM

Average: 3.9 (10 votes)

Introduction to IBM Cognos BI, Business Intelligence suite of IBMIBM Cognos 8 BI suite is one of the most widely used business intelligence. Software is a fairly comprehensive, yet manageable, and one of the BI market leaders.

The main applications are used from a web portal that controls the Business Intelligence Server, which is the heart of the tool.

This portal is called Cognos Connection and from the same, provided by web, you can access environmental management options and services to the different applications that provides Cognos, the folder structure that organizes the reports, to dashboards, and other accessories that can be integrated in the portal.

Each application is designed to cover a type of needs that often occur in such environments. Most handles 100% from the web browser, both to develop and design reports, events and metrics to consult or analysis tasks...

 

Business Intelligence Forum 2010

Average: 3 (1 vote)

On Wednesday May 12 celebrated the 10th Forum of Business Intelligence, which has been Dataprix Media Partner and I had the opportunity to attend.

The event was quite interesting, and it was a good opportunity to learn first-hand opinions and impressions of deployments responsible for business intelligence projects.

I find it very appropriate that most of the interventions were responsible for the area of IT or business data warehouse, as the vision and how to communicate to the person who runs a project internally is often the most realistic and that can best explain the needs, problems and what actually can be considered at the level of business success or failure of a technology project.

 

Data Warehouse Architecture: data areas of our Corporate Data Warehouse

Average: 2.9 (4 votes)

Areas de datos para la carga de un Data WarehouseWhen 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 suites of Oracle Business Intelligence

Average: 3 (1 vote)
Cuadros de mando de Oracle AnswersOracle, in addition to their famous manager database has a large catalog of software products, many developed internally and acquired through the purchase of other companies.  Within the environment of business intelligence that fact is even more remarkable as just more of Oracle's recent acquisitions were purchases of BI software vendors.
 
The result is that although each tool has some features and a more appropriate market, there are many overlaps, and costs a little lie when choosing what software or set of tools we could use for our business intelligence project...

Pervasive Business Intelligence Report

Average: 4 (1 vote)

Pervasive Business Intelligence could be translated as Omnipresent Business Intelligence, at least at the enterprise level. This is to make the BI system to reach all levels of the organization, at the right time, and the information needed for each. You can even include integration with other systems operating normally, and also provide interaction capabilities, not just access to information.

TDWI have done a study on the extent of introduction of the BI tools in business. Used as a basis a survey of over 700 people involved in BI projects and in-depth interviews with over 20 vendors and professional world of BI.

The results of this study is the report Pervasive Business Intelligence, Techniques and Technologies to Deploy BI on an Enterprise Scale, which way to summarize what I find most relevant:

Poll Results  

Adoption of BI tools and level of use

  • Adoption based on roles

Others who lead the adoption of both ratios (allocation of licenses) and use of BI tools are the business analysts, followed by managers and executives.

The error ORA-30926 as a result of a Merge

Average: 3.3 (4 votes)

ORA-30926 error usually occurs when performing merge operations, and typically we leave something descolocados as the description of it does not give too much information about what is happening: 
ORA-30926: unable to get a stable set of rows in the source tables.

Normally this error occurs when the merge operation to target a row to be updated on it more than one row in the table source. As the engine does not know what to choose register returns an error. It is a problem of duplication in the origin table.

Example:

  • We have: 
    TABLA_ORIGEN with the values 
    ID Description 
    1 'The first value' 
    1 'The value with duplicate id' 
    2 'Another value'

Update of methodology Hefesto

Average: 3 (1 vote)

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. 

HEFESTO 

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.

Pentaho in a Virtual Machine

Average: 5 (1 vote)

We have prepared virtual servers with a preconfigured installation of Pentaho, the well-known open source platform for Business Intelligence (BI Pentaho PCI).
You can freely download a virtual machine ready with the virtualization software VirtualBox 2.0 Sun, and another with VM 2.0 server software:

ROLAP vs MOLAP

Average: 3.3 (2 votes)

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, OLAP and Business Intelligence Survey

Average: 2 (1 vote)

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:

Syndicate content