Business Intelligence Consultant

Methodologies

Methodology is a cornerstone of any project but often the most overlooked aspect. There are two ways how BI professionals approach BI or DW project: Kimball method or Inmon. There is a great debate going on between supporters of these two methodologies on which way is better. Yet there are organizations that attempt to develop BI solution without using any of these philosophies. I’ve been practicing Kimball methodology since 2001 and believe his method is the most logical and elegant

According to Bill Inmon, Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form

Ralf Kimball defines Data warehouse as conglomerate of all data marts within the enterprise. Information is always stored in the multidimensional model. The Kimball Method is specifically intended to deliver large-scale enterprise business intelligence/data warehouse solutions. Kimball provides concise architecture blue-print for overall solution, starting with horizontal, cross-department gathering of requirements. He introduced concept of the "enterprise bus matrix", a powerful design concept for understanding and creating the appropriate enterprise data architecture to support the business requirements

E-mail: slavalit@hotmail.com