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

Ú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...

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.

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:

Syndicate content