Design is the creation of a plan or convention for the construction of an object or a system (as in architectural blueprints, engineering drawing, business process, circuit diagrams and sewing patterns). Design has different connotations in different fields. In some cases the direct construction of an object (as in pottery, engineering, management, cowboy coding and graphic design) is also considered as design.

It includes the following topics -

• Data and architecture design
• Hardware and Software Selection
• Generate data warehouse matrix
• Dimensional modeling and ETL