Please produce the graph visualization of the data for each exercise using either Excel or Tableau. Under each exercise, please copy and paste the screen shot of your graph visualizations. Then, as directed below, add your design justification and rational for each design feature.
Exercise 1:
Imagine that you work in the Financial Planning and Analysis department. It’s your job to report how actual quarterly expenses during the previous year compared to the budget for each of the five departments that report to the Vice President (VP) of Operations. The VP is only interested in the degree to which actual expenses deviated from budget, not the actual dollar amount. Here’s the raw information:
Q1 Q2 Q3 Q4
Department Budget Actual Budget Actual Budget Actual Budget Actual
Distribution 390,000 375,000 395,000 382,000 400,000 390,000 410,000 408,000
Facilities 675,000 693,000 800,000 837,000 750,000 713,000 750,000 790,000
Human Resources 350,000 346,000 350,000 342,000 350,000 340,000 350,000 367,000
Information Systems 950,000 925,000 850,000 890,000 875,000 976,000 900,000 930,000
Create one or more graphs to display this information and copy paste below. Once you’ve completed your graph, take a few minutes to describe its design, including your rationale for each design feature, in the space below.
