As service oriented architectures are becoming mainstream we should consider how this affects data warehousing. We can expect impacts of service oriented architectures on both ends of data warehousing implementations: in the way we load data as well as in the way we consume it. — Article published in Sistem November 2006, p. 6-7.
Data warehouses are the source for consolidated reporting from various data sources. Due to increasing demands for fast results, data warehouses are required to provide data in real time. The largest and technologically most challenging component of data warehouse implementation is loading the data through the ETL (Extract-Transform-Load) process. The article presents a case study…
I had the pleasure of interviewing Ralph Kimball on one of his many visits to Slovenia, where he was always happy to come both to deliver trainings and to spend time relaxing and enjoying the beautiful Bled region. The interview was first published in Info SRC.SI 2005/Issue 42, p. 5-7. 1. This is your sixth visit to…
Data that is required for decision support must be available immediately when the business needs it. Data warehouses as the basis for decision support must provide data in real time. Loading data into a data warehouse in the usual batch oriented process doesn’t work if we want it in real time. Alternate solutions to loading…
The key to good business decisions is access to data, understanding of the business and pain points to be addressed. Companies must ensure that all required data is captured in their information systems and that infrastructure to support it is in place. Much is to be expected from business intelligence solutions in the future. —…
Data warehouses are often used just as a source of data for reporting and not for meaningful business intelligence which is their original intent. What can we do to fulfill customer expectations and increase the business value? — Article published in Sistem September 2004, p. 23.
Maja Ferle, business intelligence consultant at SRC.SI, says that the anticipated entry of foreign competition after Slovenia joined the European Union that would spur the need for business intelligence hasn’t happened. “Companies still don’t believe that they could gain a competitive advantage by using business intelligence solutions and thus be a step ahead in the…
Data warehouse users want more than just reporting and business intelligence – they often want all that in real time. Does this make sense and is it possible? — Article published in Sistem July 2004, p. 15-16.
A data warehousing project is not much different from a typical IT development project, facing similar risks and potential troubles. In data warehousing we often face the risk of too loosely defined requirements, bad quality of source data or poor performance. — Paper delivered at Dnevi slovenske informatike 2004, Portorož, April 14 – 16, 2004.
Business intelligence require data about customers, but that is not all. Knowing and understanding the customers enables companies to plan new activities in the area of customer relationship management. New tools and solutions to support CRM are appearing and companies are increasingly implementing them to support their CRM initiatives. — Article publisned in Sistem April…