Abstract: “Many organizations owns billions of bytes data but may suffer from problem to access and analyze data. In order to solve this problem new concept and tools have evolved into a new information technology called data warehousing. A Data Warehouse is a collection of technologies aimed at enabling the knowledge worker to make better and faster decisions. Data warehouse is designed by using data models which act as a blueprint for the information requirements of an organization. Without a data model, the understanding, implementation and maintenance of the data warehouse are difficult. There are three levels of abstractions in the data modeling i.e. conceptual, logical and physical. Here in this paper we will create these data models and map one model from the earlier model which greatly helps in designing a data warehouse.”

Keywords: Data warehouse, Conceptual Modeling, Logical Modeling, Physical Modeling