Create a file with data organized without extraneous rows and columns but including headings.

For this assignment, you will need to become familiar with specialized business intelligence (BI) software, and then download the software. Complete the following steps to begin:

  • Step 1: Watch an instructional video on the BI software.
  • Step 2: Review various BI Software options, including Tableau and Excel. Search the CTU Library and the Internet to learn about optional software.
  • Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any BI software to create a graph illustrating comparison between the United States and zip code data.

Consider the following scenario, continued from Unit 1 Individual Project:

Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the business analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets to make the best recommendation possible. Complete the following:

  • Download the reports for the United States from this 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 contains 4 reports:
    • General Summary
    • Census Trend 1980 to 2000 Summary
    • Occupation and Employment Summary
    • Income Summary (based on the entire United States)
  • Download the reports for zip code 60614 from this Web site. This particular file contains 4 reports:
    • General Summary
    • Census Trend 1980 to 2000 Summary
    • Occupation and Employment Summary
    • Income Summary based on the U.S. zip code 60614
  • Using 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 summary slide explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in the data.
  • Use the BI software you choose to depict information from these reports.
  • Prepare a presentation of 4–5 slides of your major findings. 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 2 graphs and a headline that summarizes a key takeaway from the graph.

Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (75-word minimum per slide).

For assistance with the usage of Tableau for analysis and reporting, review and use the instructions below. Those should be helpful if you are having problems with the software usage or data. However, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the Internet and in videos to learn how to use Excel to create graphical presentations including table usage.

The instructions to create a bar graph in Tableau (optional) or in another BI software are as follows.

  1. Open the assignment CTU instructions.
  2. Download the BI software.
  3. Create your Tableau Public Account.
  4. Click the download link for the 60614 file (file will open in Excel).
  5. Click the download link for the U.S. file (file will open in Excel).
  6. The following are some options:
    1. Create separate demographical worksheets (e.g., Educational Attainment or Household Income). Include zip code and U.S. data.
      • See a sample of the file available with column headings 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 headings and extraneous blanks.

 

2000 Educational Attainment 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%

 

    1. Create a file with data organized without extraneous rows and columns but including headings.
    2. The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
    3. Note that in the real situation, when using BI software, you will want to ensure that your data are clean and that you have similar data in your files.
  1. Save the file(s) on your computer.
  2. Open Tableau. Then do a File > Open > Open on your saved file.
  3. 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 the top left corner).
  4. Under “Measures” (on the left), you should see “Chicago” and “U.S.” Click on “U.S.,” and pull it into rows at the top of the screen. Then, click on Chicago and pull it over into rows.
  5. Under “Dimensions” on the left, you should see “Household Income.” Click on “Household Income,” and pull it into column.
  6. In the second column from the left, you should see “Measures.”
  7. In the top right corner, you should see a “show me” box illustrating 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 line 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.
  8. To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
  9. When your graph is saved 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 Tableau Public.)
  10. After the file is saved, open the .png file, and edit or copy the graph.
  11. Open your PowerPoint file, and then paste (special) it on the slide. You can adjust the size.
  12. Repeat the same in Tableau opening of any other prepped and cleaned file.

Note: Measure values are your number fields; measure names are the descriptors.

For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.

Additional Resources to Use

American Marketing Association. (n.d.). Summary reports. Retrieved from http:/www.marketingpower.com/content753.php

Igines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video file]. Retrieved from https://www.youtube.com/watch?v=Xn7Sd5Uu42A

Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2

References

Pak, A. (2013, August 12). Tableau public – Overview and applications [Video file]. Retrieved from http://youtu.be/PnkMiHocqRw

Tableau.(2018). Tableau public. Retrieved from http://www.tableausoftware.com/public/

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

find the cost of your paper

The post Create a file with data organized without extraneous rows and columns but including headings. appeared first on Best Custom Essay Writing Services | EssayBureau.com.

Essaylink
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
? Hi, how can I help?