Details:
The purpose of this assignment is to create a data story and communicate findings to key stakeholders.
Part 1:
For this assignment, you will use the “Arizona Incomes by Zip Code” dataset. You will use Tableau to create a data story that illustrates the median household incomes of Arizona residents. The data provided includes all zip codes in Arizona. Each record is a unique zip code. The data includes the following columns:
- Zip_Code:An Arizona zip code.
- Metro_Area:Whether or not the zip code is within the Phoenix-metro area.
- City:The city name of the zip code.
- Median_Income:The median household income of each zip code based on 5-year estimates (2010-2014) from the U.S. Census Bureau.
The marketing manager has asked you to analyze income data for Arizona residents so that leaders in his department can determine the company’s advertising strategy. The marketing manager intends to share this data with other decisions makers and the marketing department staff so that everyone has a thorough understanding of how the income information can be used to determine specific target markets in upcoming advertising campaigns. Because most of these individuals do not have a strong understanding of analytics, they must be able gain the information listed below from studying the charts. In the data story, use visualizations, heat maps, boxplots, etc. to describe the following:
- How do incomes differ across zip codes within the Phoenix-metro area (using geo-mapping)?
- What is the relative difference in incomes across zip codes within the Phoenix-metro area (use a heat map)?
- What are the distribution of incomes across Arizona?
- How do incomes within the Phoenix metro area differ from those outside of that area?
Part 2:
Demonstrate the ability to communicate the analytics story to key stakeholders, including the marketing manager, by creating a 6-10 slide PowerPoint presentation (with speaker notes for each slide). Use the charts generated in Tableau to illustrate the data story as it relates to the income of Arizona residents. The slides and speaker notes should address the following for each chart presented.
- What information is the chart providing to stakeholders?
- Why is the information in the chart important to key stakeholders?
- How can this information be used in making decisions about how marketing dollars can be allocated?
| Zip_Code | Metro_Area | City | Median_Income |
| 85003 | Yes | Phoenix | $42,661 |
| 85004 | Yes | Phoenix | $29,567 |
| 85006 | Yes | Phoenix | $24,983 |
| 85007 | Yes | Phoenix | $27,200 |
| 85008 | Yes | Phoenix | $34,581 |
| 85009 | Yes | Phoenix | $22,137 |
| 85012 | Yes | Phoenix | $53,333 |
| 85013 | Yes | Phoenix | $46,920 |
| 85014 | Yes | Phoenix | $42,162 |
| 85015 | Yes | Phoenix | $29,838 |
| 85016 | Yes | Phoenix | $46,399 |
| 85017 | Yes | Phoenix | $28,385 |
| 85018 | Yes | Phoenix | $54,028 |
| 85019 | Yes | Phoenix | $29,335 |
| 85020 | Yes | Phoenix | $43,927 |
| 85021 | Yes | Phoenix | $37,445 |
| 85022 | Yes | Phoenix | $46,529 |
| 85023 | Yes | Phoenix | $47,646 |
| 85024 | Yes | Phoenix | $63,864 |
| 85027 | Yes | Phoenix | $52,137 |
| 85028 | Yes | Phoenix | $89,030 |
| 85029 | Yes | Phoenix | $42,137 |
| 85031 | Yes | Phoenix | $23,054 |
| 85032 | Yes | Phoenix | $47,691 |
| 85033 | Yes | Phoenix | $32,935 |
| 85034 | Yes | Phoenix | $21,052 |
| 85035 | Yes | Phoenix | $31,065 |
| 85037 | Yes | Phoenix | $47,869 |
| 85040 | Yes | Phoenix | $30,664 |
| 85041 | Yes | Phoenix | $41,438 |
| 85042 | Yes | Phoenix | $45,420 |
| 85043 | Yes | Phoenix | $40,636 |
| 85044 | Yes | Phoenix | $67,154 |
| 85045 | Yes | Phoenix | $109,500 |
| 85048 | Yes | Phoenix | $95,628 |
| 85050 | Yes | Phoenix | $80,233 |
| 85051 | Yes | Phoenix | $38,389 |
| 85053 | Yes | Phoenix | $44,039 |
| 85054 | Yes | Phoenix | $75,093 |
| 85083 | Yes | Phoenix | $101,453 |
| 85085 | Yes | Phoenix | $80,342 |
| 85086 | Yes | Phoenix | $80,477 |
| 85087 | No | New River | $74,275 |
| 85118 | Yes | Apache Junction | $63,492 |
| 85119 | Yes | Apache Junction | $44,200 |
| 85120 | Yes | Apache Junction | $34,808 |
| 85121 | Yes | Bapchule | $32,891 |
| 85122 | No | Casa Grande | $44,150 |
| 85123 | No | Arizona City | $45,231 |
| 85128 | No | Coolidge | $40,820 |
| 85131 | No | Eloy | $28,130 |
| 85132 | No | Florence | $48,625 |
| 85135 | No | Hayden | $39,531 |
| 85137 | No | Kearny | $44,762 |
| 85138 | No | Maricopa | $65,290 |
| 85139 | No | Maricopa | $56,168 |
| 85140 | Yes | San Tan Valley | $57,585 |
| 85141 | No | Picacho | $31,875 |
| 85142 | Yes | Queen Creek | $71,927 |
| 85143 | Yes | San Tan Valley | $59,830 |
| 85145 | No | Red Rock | $55,962 |
| 85147 | Yes | Sacaton | $22,000 |
| 85172 | No | Stanfield | $35,467 |
| 85173 | No | Superior | $43,750 |
| 85192 | No | Winkelman | $52,604 |
| 85193 | No | Casa Grande | $49,777 |
| 85194 | No | Casa Grande | $47,190 |
| 85201 | Yes | Mesa | $34,532 |
| 85202 | Yes | Mesa | $41,513 |
| 85203 | Yes | Mesa | $45,346 |
| 85204 | Yes | Mesa | $43,912 |
| 85205 | Yes | Mesa | $43,341 |
| 85206 | Yes | Mesa | $45,557 |
| 85207 | Yes | Mesa | $64,728 |
| 85208 | Yes | Mesa | $44,455 |
| 85209 | Yes | Mesa | $55,329 |
| 85210 | Yes | Mesa | $37,322 |
| 85212 | Yes | Mesa | $78,902 |
| 85213 | Yes | Mesa | $57,220 |
| 85215 | Yes | Mesa | $55,994 |
| 85224 | Yes | Chandler | $61,754 |
| 85225 | Yes | Chandler | $55,753 |
| 85226 | Yes | Chandler | $76,253 |
| 85233 | Yes | Gilbert | $74,668 |
| 85234 | Yes | Gilbert | $78,649 |
| 85248 | Yes | Chandler | $67,301 |
| 85249 | Yes | Chandler | $99,910 |
| 85250 | Yes | Scottsdale | $59,840 |
| 85251 | Yes | Scottsdale | $50,159 |
| 85253 | Yes | Paradise Valley | $112,005 |
| 85254 | Yes | Scottsdale | $90,236 |
| 85255 | Yes | Scottsdale | $112,531 |
| 85256 | Yes | Scottsdale | $35,212 |
| 85257 | Yes | Scottsdale | $50,740 |
| 85258 | Yes | Scottsdale | $73,526 |
| 85259 | Yes | Scottsdale | $100,250 |
| 85260 | Yes | Scottsdale | $75,916 |
| 85262 | Yes | Scottsdale | $133,199 |
| 85263 | Yes | Rio Verde | $107,606 |
| 85264 | Yes | Fort McDowell | $50,833 |
| 85266 | Yes | Scottsdale | $103,883 |
| 85268 | Yes | Fountain Hills | $72,530 |
| 85281 | Yes | Tempe | $31,600 |
| 85282 | Yes | Tempe | $49,173 |
| 85283 | Yes | Tempe | $51,837 |
| 85284 | Yes | Tempe | $111,145 |
| 85286 | Yes | Chandler | $90,451 |
| 85295 | Yes | Gilbert | $87,267 |
| 85296 | Yes | Gilbert | $84,714 |
| 85297 | Yes | Gilbert | $87,049 |
| 85298 | Yes | Gilbert | $91,961 |
| 85301 | Yes | Glendale | $26,802 |
| 85302 | Yes | Glendale | $41,574 |
| 85303 | Yes | Glendale | $48,739 |
| 85304 | Yes | Glendale | $60,518 |
| 85305 | Yes | Glendale | $62,689 |
| 85306 | Yes | Glendale | $55,405 |
| 85307 | Yes | Glendale | $47,757 |
| 85308 | Yes | Glendale | $68,166 |
| 85309 | Yes | Glendale Luke AFB | |
| 85310 | Yes | Glendale | $90,077 |
| 85320 | No | Aguila | $24,423 |
| 85321 | No | Ajo | $26,833 |
| 85322 | No | Arlington | $36,154 |
| 85323 | Yes | Avondale | $45,159 |
| 85324 | No | Black Canyon City | $36,150 |
| 85325 | No | Bouse | $29,306 |
| 85326 | No | Buckeye | $50,546 |
| 85328 | No | Cibola | $44,489 |
| 85331 | Yes | Cave Creek | $90,038 |
| 85332 | No | Congress | $35,917 |
| 85333 | No | Dateland | $36,250 |
| 85334 | No | Ehrenberg | $33,958 |
| 85335 | Yes | El Mirage | $47,564 |
| 85336 | No | Gadsden | $30,000 |
| 85337 | No | Gila Bend | $33,311 |
| 85338 | Yes | Goodyear | $65,583 |
| 85339 | Yes | Laveen | $63,690 |
| 85340 | Yes | Litchfield Park | $78,202 |
| 85341 | No | Lukeville | |
| 85342 | No | Morristown | $43,750 |
| 85343 | No | Palo Verde | $32,404 |
| 85344 | No | Parker | $35,846 |
| 85345 | Yes | Peoria | $44,513 |
| 85346 | No | Quartzsite | $41,340 |
| 85347 | No | Roll | $36,689 |
| 85348 | No | Salome | $36,084 |
| 85349 | No | San Luis | $31,064 |
| 85350 | No | Somerton | $31,834 |
| 85351 | Yes | Sun City | $34,729 |
| 85352 | No | Tacna | $24,250 |
| 85353 | Yes | Tolleson | $52,371 |
| 85354 | No | Tonopah | $48,241 |
| 85355 | Yes | Waddell | $72,919 |
| 85356 | No | Wellton | $40,592 |
| 85357 | No | Wenden | $30,625 |
| 85360 | No | Wikieup | $26,719 |
| 85361 | No | Wittmann | $50,000 |
| 85362 | No | Yarnell | $26,250 |
| 85363 | No | Youngtown | $35,737 |
| 85364 | No | Yuma | $38,686 |
| 85365 | No | Yuma | $50,979 |
| 85367 | No | Yuma | $52,200 |
| 85371 | No | Poston | $23,182 |
| 85373 | Yes | Sun City | $50,266 |
| 85374 | Yes | Surprise | $48,143 |
| 85375 | Yes | Sun City West | $46,622 |
| 85377 | Yes | Carefree | $85,436 |
| 85379 | Yes | Surprise | $71,066 |
| 85381 | Yes | Peoria | $70,980 |
| 85382 | Yes | Peoria | $63,135 |
| 85383 | Yes | Peoria | $102,047 |
| 85387 | Yes | Surprise | $61,078 |
| 85388 | Yes | Surprise | $67,900 |
| 85390 | No | Wickenburg | $40,081 |
| 85392 | Yes | Avondale | $66,947 |
| 85395 | Yes | Goodyear | $76,453 |
| 85396 | No | Buckeye | $76,314 |
| 85501 | No | Globe | $40,400 |
| 85530 | No | Bylas | $23,304 |
| 85531 | No | Central | $52,857 |
| 85533 | No | Clifton | $49,125 |
| 85534 | No | Duncan | $33,065 |
| 85535 | No | Eden | |
| 85536 | No | Fort Thomas | $33,281 |
| 85539 | No | Miami | $45,462 |
| 85540 | No | Morenci | $65,133 |
| 85541 | No | Payson | $40,690 |
| 85542 | No | Peridot | $32,125 |
| 85543 | No | Pima | $45,673 |
| 85544 | No | Pine | $49,805 |
| 85545 | No | Roosevelt | $38,155 |
| 85546 | No | Safford | $47,681 |
| 85550 | No | San Carlos | $31,250 |
| 85551 | No | Solomon | $52,422 |
| 85552 | No | Thatcher | $52,533 |
| 85553 | No | Tonto Basin | $35,190 |
| 85554 | No | Young | $50,114 |
| 85601 | No | Arivaca | $30,781 |
| 85602 | No | Benson | $40,496 |
| 85603 | No | Bisbee | $33,726 |
| 85605 | No | Bowie | $33,542 |
| 85606 | No | Cochise | $40,625 |
| 85607 | No | Douglas | $26,684 |
| 85608 | No | Douglas | |
| 85609 | No | Dragoon | $58,967 |
| 85610 | No | Elfrida | $45,461 |
| 85611 | No | Elgin | $39,519 |
| 85613 | No | Fort Huachuca | $55,000 |
| 85614 | No | Green Valley | $48,300 |
| 85615 | No | Hereford | $54,780 |
| 85616 | No | Huachuca City | $41,477 |
| 85617 | No | Mc Neal | $36,438 |
| 85618 | No | Mammoth | $36,875 |
| 85619 | No | Mount Lemmon | |
| 85620 | No | Naco | $26,964 |
| 85621 | No | Nogales | $27,952 |
| 85622 | No | Green Valley | $55,842 |
| 85623 | No | Oracle | $55,082 |
| 85624 | No | Patagonia | $39,038 |
| 85625 | No | Pearce | $36,276 |
| 85626 | No | Pirtleville | $14,070 |
| 85627 | No | Pomerene | $49,000 |
| 85629 | No | Sahuarita | $62,939 |
| 85630 | No | Saint David | $44,286 |
| 85631 | No | San Manuel | $42,952 |
| 85632 | No | San Simon | $36,417 |
| 85633 | No | Sasabe | $24,250 |
| 85634 | No | Sells | $26,250 |
| 85635 | No | Sierra Vista | $54,022 |
| 85637 | No | Sonoita | $70,129 |
| 85638 | No | Tombstone | $32,500 |
| 85640 | No | Tumacacori | $23,750 |
| 85641 | No | Vail | $83,824 |
| 85643 | No | Willcox | $42,998 |
| 85645 | No | Amado | $50,036 |
| 85646 | No | Tubac | $50,606 |
| 85648 | No | Rio Rico | $50,680 |
| 85650 | No | Sierra Vista | $77,730 |
| 85653 | No | Marana | $57,143 |
| 85654 | No | Rillito | $9,409 |
| 85658 | No | Marana | $84,788 |
| 85701 | No | Tucson | $36,211 |
| 85704 | No | Tucson | $52,214 |
| 85705 | No | Tucson | $24,489 |
| 85706 | No | Tucson | $30,000 |
| 85707 | No | Tucson | |
| 85708 | No | Tucson | $47,440 |
| 85710 | No | Tucson | $42,049 |
| 85711 | No | Tucson | $32,815 |
| 85712 | No | Tucson | $32,109 |
| 85713 | No | Tucson | $33,301 |
| 85714 | No | Tucson | $25,604 |
| 85715 | No | Tucson | $55,694 |
| 85716 | No | Tucson | $33,313 |
| 85718 | No | Tucson | $79,155 |
| 85719 | No | Tucson | $29,100 |
| 85723 | No | Tucson | |
| 85724 | No | Tucson | |
| 85726 | No | Tucson | |
| 85730 | No | Tucson | $46,558 |
| 85735 | No | Tucson | $47,333 |
| 85736 | No | Tucson | $37,400 |
| 85737 | No | Tucson | $80,789 |
| 85739 | No | Tucson | $60,681 |
| 85741 | No | Tucson | $51,410 |
| 85742 | No | Tucson | $68,209 |
| 85743 | No | Tucson | $69,139 |
| 85745 | No | Tucson | $47,432 |
| 85746 | No | Tucson | $41,419 |
| 85747 | No | Tucson | $84,230 |
| 85748 | No | Tucson | $65,035 |
| 85749 | No | Tucson | $85,861 |
| 85750 | No | Tucson | $73,029 |
| 85755 | No | Tucson | $83,326 |
| 85756 | No | Tucson | $45,684 |
| 85757 | No | Tucson | $53,300 |
| 85901 | No | Show Low | $40,393 |
| 85911 | No | Cibecue | $12,031 |
| 85912 | No | White Mountain Lake | $24,738 |
| 85920 | No | Alpine | $41,827 |
| 85922 | No | Blue | $33,125 |
| 85923 | No | Clay Springs | $12,122 |
| 85924 | No | Concho | $34,702 |
| 85925 | No | Eagar | $52,333 |
| 85926 | No | Fort Apache | $56,750 |
| 85927 | No | Greer | $40,804 |
| 85928 | No | Heber | $26,159 |
| 85929 | No | Lakeside | $43,220 |
| 85930 | No | McNary | $40,893 |
| 85931 | No | Forest Lakes | $32,143 |
| 85932 | No | Nutrioso | $28,750 |
| 85933 | No | Overgaard | $36,488 |
| 85934 | No | Pinedale | $57,625 |
| 85935 | No | Pinetop | $62,811 |
| 85936 | No | Saint Johns | $36,628 |
| 85937 | No | Snowflake | $52,159 |
| 85938 | No | Springerville | $39,612 |
| 85939 | No | Taylor | $55,657 |
| 85940 | No | Vernon | $47,050 |
| 85941 | No | Whiteriver | $26,614 |
| 85942 | No | Woodruff | |
| 86001 | No | Flagstaff | $46,328 |
| 86003 | No | Flagstaff | |
| 86004 | No | Flagstaff | $59,714 |
| 86011 | No | Flagstaff | $20,039 |
| 86015 | No | Bellemont | |
| 86016 | No | Gray Mountain | $20,833 |
| 86017 | No | Munds Park | $34,600 |
| 86018 | No | Parks | $44,050 |
| 86020 | No | Cameron | $30,441 |
| 86021 | No | Colorado City | $30,962 |
| 86022 | No | Fredonia | $47,530 |
| 86023 | No | Grand Canyon | $29,421 |
| 86024 | No | Happy Jack | $66,458 |
| 86025 | No | Holbrook | $46,563 |
| 86028 | No | Petrified Forest Natl Pk | |
| 86029 | No | Sun Valley | $13,105 |
| 86030 | No | Hotevilla | $35,964 |
| 86031 | No | Indian Wells | $14,934 |
| 86032 | No | Joseph City | $47,396 |
| 86033 | No | Kayenta | $21,633 |
| 86034 | No | Keams Canyon | $21,548 |
| 86035 | No | Leupp | $29,201 |
| 86036 | No | Marble Canyon | $25,543 |
| 86038 | No | Mormon Lake | |
| 86039 | No | Kykotsmovi Village | $18,636 |
| 86040 | No | Page | $52,690 |
| 86042 | No | Polacca | $35,000 |
| 86043 | No | Second Mesa | $31,713 |
| 86044 | No | Tonalea | $23,750 |
| 86045 | No | Tuba City | $45,833 |
| 86046 | No | Williams | $47,279 |
| 86047 | No | Winslow | $34,355 |
| 86052 | No | North Rim | |
| 86053 | No | Kaibeto | $28,792 |
| 86054 | No | Shonto | $29,375 |
| 86301 | No | Prescott | $45,587 |
| 86303 | No | Prescott | $45,727 |
| 86305 | No | Prescott | $58,264 |
| 86313 | No | Prescott | |
| 86314 | No | Prescott Valley | $40,298 |
| 86315 | No | Prescott Valley | $56,180 |
| 86320 | No | Ash Fork | $26,204 |
| 86321 | No | Bagdad | $64,617 |
| 86322 | No | Camp Verde | $38,039 |
| 86323 | No | Chino Valley | $43,439 |
| 86324 | No | Clarkdale | $45,297 |
| 86325 | No | Cornville | $43,777 |
| 86326 | No | Cottonwood | $38,341 |
| 86327 | No | Dewey | $50,269 |
| 86329 | No | Humboldt | $47,628 |
| 86331 | No | Jerome | $25,641 |
| 86332 | No | Kirkland | $36,484 |
| 86333 | No | Mayer | $37,446 |
| 86334 | No | Paulden | $43,984 |
| 86335 | No | Rimrock | $41,528 |
| 86336 | No | Sedona | $49,796 |
| 86337 | No | Seligman | $32,554 |
| 86338 | No | Skull Valley | $38,264 |
| 86343 | No | Crown King | $38,500 |
| 86351 | No | Sedona | $58,443 |
| 86401 | No | Kingman | $43,692 |
| 86403 | No | Lake Havasu City | $37,807 |
| 86404 | No | Lake Havasu City | $41,050 |
| 86406 | No | Lake Havasu City | $44,981 |
| 86409 | No | Kingman | $31,237 |
| 86411 | No | Hackberry | $45,735 |
| 86413 | No | Golden Valley | $33,662 |
| 86426 | No | Fort Mohave | $41,600 |
| 86429 | No | Bullhead City | $41,176 |
| 86431 | No | Chloride | $16,484 |
| 86432 | No | Littlefield | $35,548 |
| 86433 | No | Oatman | $4,560 |
| 86434 | No | Peach Springs | $37,083 |
| 86435 | No | Supai | $44,750 |
| 86436 | No | Topock | $34,004 |
| 86437 | No | Valentine | $32,188 |
| 86438 | No | Yucca | $31,516 |
| 86440 | No | Mohave Valley | $39,167 |
| 86441 | No | Dolan Springs | $24,571 |
| 86442 | No | Bullhead City | $36,395 |
| 86443 | No | Temple Bar Marina | |
| 86444 | No | Meadview | $21,458 |
| 86445 | No | Willow Beach | $50,142 |
| 86502 | No | Chambers | $21,000 |
| 86503 | No | Chinle | $30,904 |
| 86504 | No | Fort Defiance | $34,854 |
| 86505 | No | Ganado | $23,529 |
| 86506 | No | Houck | $21,944 |
| 86507 | No | Lukachukai | $22,188 |
| 86508 | No | Lupton | $20,682 |
| 86510 | No | Pinon | $21,816 |
| 86511 | No | Saint Michaels | $31,563 |
| 86512 | No | Sanders | $23,482 |
| 86514 | No | Teec Nos Pos | $21,205 |
| 86515 | No | Window Rock | $34,375 |
| 86520 | No | Blue Gap | $16,250 |
| 86535 | No | Dennehotso | $22,386 |
| 86538 | No | Many Farms | $35,750 |
| 86540 | No | Nazlini | $19,524 |
| 86544 | No | Red Valley | $25,682 |
| 86545 | No | Rock Point | $26,705 |
| 86547 | No | Round Rock | $22,647 |
| 86556 | No | Tsaile | $19,954 |