2 Challenges in Building Data Warehouse Regarding to End User and DSS

Data warehouses are one of the most important systems for organizations nowadays. Building Data warehouse is a Challenging work, making good choice requires understanding of the two main data warehousing models Inmon’s and Kimball’s approaches, we will preview both approaches and the main comparative studies showing similarities and differences. This paper shows that we can balance between both by concentrating on user understandability and by returning to DSS field the common reference discipline for the two approaches, taking XPDSS as a balanced methodology, then it present a case study of CRM Data warehouse for Airlines FFP systems.