Objectives:
Provide some recomendations how to achieve higher level of success in the projects of BI solutions and DW development.
Outline:
Traditional and modern DW development
Business and organisational issues
Multiple applications and multiple DB sources complexity
Data quality, data cleansing and consolidation
Design layer architecture
Some recomendations for the usage of design layer architecture in the BI solution development process
Full Abstract:
Multiple data sources, need for reliable and timely reporting and growing business requirements for ad-hoc reporting are most often the reason why companies start DW and BI projects. DW modeling methodologies and OLAP based BI solutions are nowadays widely used by a number of companies. However, due to poor data quality, redundancy, inconsistency and complexity of transactional data, business needs are often not met. On the other hand, faster changes in business environment lead to ever higher business expectations.
This presentation will start with an overwiew of basic principles of developing traditional as well as modern DW solutions. It will then continue with some typical issues that we have been meeting during our consultancy on DW development projects.
Besides organisational and business issues, application systems complexity and inconsistent business terminology are major underlying reasons for most of the problems. The last part of the presentation will include recomendations how to resolve some of the most critical problems regarding the usage of design layer modelling architecture. Design layer architecure will be outlined as the method for simplification, better understanding and easier control of the whole DW and BI solution development process.
HR
EN
SL