for COMP_SCIENCE PROF

Using the data in the Occupational Labor Statistics tableau workbook, prepare tableau data visualizations to help determine the city in Colorado and the one other city in a different US state, that may offer the most opportunities to practice your chosen occupation. Be sure to specify your selected occupational category (e.g.; market research analyst, financial analyst, personal financial advisors etc.)

Please prepare data visualizations to support and a memo to justify your choices. Save your visualizations to a pdf and print out the pdf.

Turn in:

A) A written (typed) memo to yourself explaining and justifying your choices of:

a. The city/region in Colorado that you picked

b. The other city/region outside Colorado that would offer the best opportunities to practice your chosen occupation.

B) Print-out a “pdf” of the following tableau visualizations:

1. Create a sort by Colorado’s city/regions which indicate the best to worst average Mean Annual Wage for your selected occupational category?

2. If you wanted to work in your selected occupation and you wanted lots of job opportunities and also wanted to make a high salary, which state would you choose? Hint: Create a map where the marker size relates to Average Total Employment across all states and where color represents Average mean Annual Wage. You may want to overlay demographic data such as medium state income to help you make a decision.

3. For your selected state prepare a visualization that presents your occupations wage differential between your chosen state and Colorado (Hint: see below)

4. For your selected occupation. Prepare a sort of city/region from best to worst according to average Mean Annual Wages in your chosen state? (that is other than Colorado)