<p> E-commerce is one of the most rapidly expanding area in recent time, the everyday huge size of data is generated. E-commerce companies are collaborating with big IT companies for researching & designing the data warehouse for the E-commerce. Data Warehouse is core riggings for analysing data as data warehouse as it stores huge amount current and historical data and helps E-commerce companies for better decision making. In this paper we discuss requirement analysis design of data warehouse, we also discuss the dimension table for data warehouse, snowflake schema and star schema for the data warehouse will helpful in developing the data warehouse in E-commerce, and also discuss some problem and purposed a solution for that.</p>