ApacheCon US 2008 Session

OFBiz Framework Tools for Integrated Business Intelligence

Dimensional modeling has become the most widely accepted approach for data warehouse design. The presentation will introduce some of the most important dimensional modeling techniques and best practices, together with the OFBiz Framework tools that implement them and can be used to build and maintain an OFBiz dimensional data model fully integrated and synchronized with the OFBiz transactional data model; the simple yet complete prototype that comes with OFBiz will be described as well to illustrate the complete process from data model definition (dimensions, fact tables and star schemas), to data processing (ETL) and creation of a simple dimensional report.