You need the following materials to complete this assignment:

1. An active IBM Cognos Analytics account.

2. Please download WA_HR_Training.csv file

Questions

The WA_HR_Training.csv file records information about the costs of HR training courses in a company. The information include in which year a course cost occurs (i.e., the Year column), for which position a course cost occurs (i.e., the Position column), for which department a course cost was spent (i.e., the Department column), etc. Use IBM Cognos Analytics to create a dashboard, and answer the HR managers following questions:

1. Summarize the Course Cost spent by Year in a bar chart. Sort the chart in a descending order, and answer in which year most course costs were spent.

2. Build a Pie chart to show how Course Cost is spent among Organizations.

3. Build a Driver analysis. What implications can you get from this analysis? Should the manager use one driver or two driver analysis? Which two drivers should be chosen to predict Course Cost? Why?

What to Submit

Create a Word document, and name it as AI Design Project. In the Word document, please make screen captures of charts for questions 1, 2, and 3. Write your interpretations of the results given by the charts.