This assignment requires the use of Tableau and PowerPoint

Xvatpuhpx

Programming

Asked: Oct 21st, 2018

Question Description

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?

Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

While APA format is not required for the body of this assignment solid academic writing is expected, and documentation of sources should be presented using APA formatting, guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Unformatted Attachment Preview

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