Data Warehousing and Business Intelligence

Date: 
Friday, 11 April, 2008 - 14:15 - 15:00
Speaker: 
Leo Lušičić

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.
 

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023