Kimball multidimensional design
Information stored in facts and dimension is a very old concept (since the1960’s) that has been growing in complexity and ability to deliver solutions. The last standardised application of this concept is the Kimball methodology, the most worldwide accepted Data Warehouse design technique. It is a comprehensive solution of how to store, clean and offer information to be used by a Business Intelligence tool (reporting, cubes, FPM, etc). It is so powerful that it can work on its own using any simple reporting tool that you company already has (as Crystal Report or even Microsoft Excel). At the same time it is very flexible. It is easy to modify, escalate and improve. It can grow with your company without you needing to redo everything. You can prepare it to record changes in the structure in order to analyse the past from a new point of view. It also includes methods to speed up only certain areas of your Data Warehouse if some information is not being provided fast enough to your reporting tools. It does not require any technology in particular and can be implemented in nearly any database system.