Management

    For this assignment, you will need to become familiar with specialized busin" rel="nofollow">iness in" rel="nofollow">intelligence (BI) software, then download the software. Complete the followin" rel="nofollow">ing steps to begin" rel="nofollow">in: • Step 1: Watch an in" rel="nofollow">instructional video on the BI software. • Step 2: Download the BI software. After you select the lin" rel="nofollow">ink, look for the orange icon in" rel="nofollow">in the middle portion of your screen to begin" rel="nofollow">in the download. Consider the followin" rel="nofollow">ing scenario: The National Sales meetin" rel="nofollow">ing is approachin" rel="nofollow">ing. Each regional sales manager has to do a short presentation for the marketin" rel="nofollow">ing department that highlights how the consumers in" rel="nofollow">in their territory are different from those in" rel="nofollow">in the total United States. You are still workin" rel="nofollow">ing with the local regional sales manager. Complete the followin" rel="nofollow">ing: • Click here to download the reports for the United States. This file contain" rel="nofollow">ins reports generated from a marketin" rel="nofollow">ing organization's Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contain" rel="nofollow">ins 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the entire United States. • Click here to download the reports for zip code 60614. This particular file contain" rel="nofollow">ins 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the U.S. zip code 60614. • Usin" rel="nofollow">ing all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page memo explain" rel="nofollow">inin" rel="nofollow">ing how your territory differs from the national profile. Feel free to note anythin" rel="nofollow">ing that you found surprisin" rel="nofollow">ing in" rel="nofollow">in this data. • Use the busin" rel="nofollow">iness in" rel="nofollow">intelligence software to depict in" rel="nofollow">information from these reports. • Prepare a presentation of 5–6 slides of your major fin" rel="nofollow">indin" rel="nofollow">ings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least one graph and a headlin" rel="nofollow">ine that summarizes a key takeaway from the graph. The last page should contain" rel="nofollow">in at least 3 questions that you would want answered based on what you've seen in" rel="nofollow">in this comparison. Your presentation should in" rel="nofollow">include 5–6 slides in" rel="nofollow">in PowerPoin" rel="nofollow">int, plus title and reference slides with speaker notes (200–250 words per slide). For assistance with the usage of Tableau for analysis and reportin" rel="nofollow">ing, review and use the followin" rel="nofollow">ing in" rel="nofollow">instructions. This should be helpful if you are havin" rel="nofollow">ing problems with the software usage or with problems with the data: Instructions to Create Bar Graph in" rel="nofollow">in Tableau 1. Open the assignment CTU in" rel="nofollow">instructions. 2. Download Busin" rel="nofollow">iness Intelligence Software. 3. Create your Tableau Public Account. 4. Click the download lin" rel="nofollow">ink for the zip code (60614) file (file will open in" rel="nofollow">in Excel). 5. Click the download lin" rel="nofollow">ink for the US file (file will open in" rel="nofollow">in Excel). 6. The followin" rel="nofollow">ing are some options: 1. Create separate demographical worksheets. For example: Education Attain" rel="nofollow">inment File - Worksheet (in" rel="nofollow">include both Zip Code and U.S. data); Household Income (in" rel="nofollow">include Zip Code and U.S. data) ? See a sample of the file available with column headin" rel="nofollow">ings and extraneous blanks. Household Income Chicago U.S. 1980 1990 1980 to 1990 2000 1990 to 2000 1980 Median Household Income 18,438 41,227 1.236 69,311 0.681 16,902 Average household Income 24,245 67,607 1.788 114,615 0.695 20,382 Per Capita Income 13,564 38,518 1.84 63,791 0.656 7,321 ? See a sample of the file available with column headin" rel="nofollow">ings and extraneous blanks. 2000 Educational Attain" rel="nofollow">inment U.S. Chicago College: Associates Degree 6.3% 1.9% College: Bachelor's Degree 15.5% 44.2% College: Graduate Degree 8.9% 34.0% College: Some College, no Degree 21.1% 8.7% School: 9th to 11th grade, no diploma 12.1% 3.2% School: Grade K-9 6.1% 2.0% School: High School Graduate 28.6% 5.6% 2. Create a file with data organized without extraneous rows and columns but in" rel="nofollow">includin" rel="nofollow">ing headin" rel="nofollow">ings. 3. The idea is to clean up the file before usage. Separatin" rel="nofollow">ing files and worksheets may be the best way to make this happen 4. Note in" rel="nofollow">in the real situation, when usin" rel="nofollow">ing BI software, you will want to ensure your data are clean and you have similar data in" rel="nofollow">in your files. 8. Save the file(s) on your computer. 9. Open Tableau. Then do a File > Open > Open your saved file. 10. At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in" rel="nofollow">in the top left corner). 11. Under Measures (on left), you should see Chicago and U.S. Click on U.S. and pull it in" rel="nofollow">into rows at the top of the screen. Then click on Chicago and pull it over in" rel="nofollow">into rows. 12. Under Dimensions on the left, you should see Household Income. Click on Household Income and pull it in" rel="nofollow">into column. 13. Now in" rel="nofollow">in the second column from the left, you should see measures. 14. In the top right corner, you should see a “show me” box illustratin" rel="nofollow">ing ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third lin" rel="nofollow">ine with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data. 15. To save in" rel="nofollow">in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log in" rel="nofollow">into Tableau Public usin" rel="nofollow">ing your e-mail and password. 16. When your graph is saved in" rel="nofollow">in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in" rel="nofollow">in tableau public.) 17. After the file is saved, open the .png file, and edit or copy the graph. 18. Open your PowerPoin" rel="nofollow">int file, then paste (special) it on the slide. You can adjust the size. 19. Repeat the same in" rel="nofollow">in Tableau openin" rel="nofollow">ing of any other prepped and cleaned file. Note: Measure values are your number fields; measure names are the descriptors. Please submit your assignment. For more in" rel="nofollow">information on creatin" rel="nofollow">ing PowerPoin" rel="nofollow">int Presentations, please visit the Microsoft Office Applications Lab. References Pak, A. (2013, August 12). Tableau Public - Overview and Applications [Video file]. Retrieved fromhttp://youtu.be/PnkMiHocqRw Summary reports. (n.d.). Retrieved March 3, 2006, from the Free Demographics Service on the American Marketin" rel="nofollow">ing Association Web site: http:/www.marketin" rel="nofollow">ingpower.com/content753.php Tableau Public. (n.d.). Retrieved November 11, 2014 from http://www.tableausoftware.com/public/