Business Analytics

1. The Sooner Manufacturing Company is concerned with the training level of its employees. Legal and corporate directives require that each employee receive training in a number of areas (safety regulations, affirmative action, quality management, etc.) on a periodic basis. Employees have to repeat some courses each year. Managerial employees require different training than hourly employees. Nancy Leader, the VP for Human Relations has requested a data warehouse to support this. One of the reports she would like looks like the one below:

Department: xx

Name Manager? Training-Received Date-Trained Hours-Trained

xx Y/N xxxxx mmyy nnn

She indicated that she would like to be able to run the report by department; summarize it by month, quarter, or year; or restrict it to any training program. She would also like to be able to identify any employee that had not received necessary training and contact the employee and their supervisor by phone or e-mail.

Design a dimensional Data Mart for this system. Include attributes that you think are necessary.

a) What is the grain of this data mart ?

b) Provide a Data Schema (E-R diagram) including all attributes