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.
For this last exercise, you are a Sales Analyst. Based on analysis of sales revenues for the past four years, you’ve noticed that there is a clear cyclical trend. The highest revenues are always generated during the last month of each quarter and the last quarter of each year. without exception. You want to use this information to point out the need for distributing sales activity more evenly across the year so that sales operations are not hit with such spikes in activity at quarter ends, especially at year ends. The following table contains the data, in U.S. dollars:
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2008 50,000 52,000 55,000 51,000 52,000 55,000 48,000 49,000 50,000 53,000 56,000 62,000
2009 54,000 56,000 57,000 53,000 53,000 57,000 53,000 55,000 59,000 60,000 65,000 71,000
2010 61,000 60,000 65,000 62,000 64,000 68,000 59,000 60,000 65,000 67,000 70,000 75,000
2011 60,000 61,000 68,000 63,000 63,000 67,000 60,000 61,000 67,000 66,000 68,000 74,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.
