A repair shop is a storing information about the engines being repaired at the shop. The shop managers would like to create a DW in order to keep track and get reports about the jobs being done at the job. He made a request about the information he is seeking for in the reporting tool. Follow Kimball steps for dimensional modeling in order to put together a model to support his needs. Once you identified facts, dimension, attributes, and grains, draw a model that correctly represents your analysis