design a data warehouse Star Schema using an OLTP database design for the IT industry.

Identify the business process: which business process in your source system$$s database design will you use to develop the dimensional model. Also, develop a set of business questions that should be answered via queries against the data warehouse.

Identify the grain of the fact table: determine how granular a row in the fact table must be and why.

Identify the dimension tables, their variables, and attributes

Identify the fact table, its variables, and attributes