Description
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.
Open the assignment CTU instructions.
Download the BI software.
Create your Tableau Public Account.
Click the download link for the 60614 file (file will open in Excel).
Click the download link for the U.S. file (file will open in Excel).
The following are some options:
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 IncomeChicagoU.S.198019901980 to 199020001990 to 20001980Median Household Income18,43841,2271.23669,3110.68116,902Average household Income24,24567,6071.788114,6150.69520,382Per Capita Income13,56438,5181.8463,7910.6567,321
See a sample of the file available with column headings and extraneous blanks.
2000 Educational AttainmentU.S.ChicagoCollege: Associates Degree6.3%1.9%College: Bachelor’s Degree15.5%44.2%College: Graduate Degree8.9%34.0%College: Some College, no Degree21.1%8.7%School: 9th to 11th grade, no diploma12.1%3.2%School: Grade K-96.1%2.0%School: High School Graduate28.6%5.6%
Create a file with data organized without extraneous rows and columns but including headings.
The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
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.
Save the file(s) on your computer.
Open Tableau. Then do a
File > Open > Open
on your saved file.
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).
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.
Under “Dimensions†on the left, you should see “Household Income.†Click on “Household Income,†and pull it into column.
In the second column from the left, you should see “Measures.â€Â
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.
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.
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.)
After the file is saved, open the .png file, and edit or copy the graph.
Open your PowerPoint file, and then paste (special) it on the slide. You can adjust the size.
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
Microsoft. (2018).
Create a chart from start to finish.
Retrieved from
https://support.office.com/en-us/article/Create-a-…
References
Pak, A. (2013, August 12).
Tableau public – Overview and applications
[Video file]. Retrieved from
Tableau
.
(2018).
Tableau public
. Retrieved from
http://www.tableausoftware.com/public/
Scenario
Big data is everywhere, and various businesses around the world are driven by big data. While some businesses
rely on big data for organizational decision making, this does not mean that the implications and applications of big
data are properly used to ensure optimal effectiveness for the organization
For this scenario, you have been appointed as a business analyst for Big D Incorporated, charged with providing
authoritative recommendations to the Board of Directors. As the business analyst, the recommendations that you
provide will be based upon data calculated from statistically appropriate formulas. Be reminded that you are not
the company’s statistician yet. However, as the business analyst, you are therefore responsible for interpreting
statistical data and making the appropriate recommendations.
Big D Incorporated was offered a series of business opportunities, and it is your job as the business analyst to
provide expert insight and justification for recommendations regarding these potential prospects.
Date: March 3, 2006
Current Geography Selection: Entire US:
Entire US
General Summary Report
US Census 2000 Basic Variables
2000 Educational Attainment
College: Associates Degree
College: Bachelor’s Degree
College: Graduate Degree
College: Some College, No Degree
School: 9th to 11th grade no diploma
School: Grade K – 9
School: High School Graduate
6.32%
15.54%
8.86%
21.05%
12.05%
6.11%
28.63%
2000 Marital Status
Divorced
Never Married
Now Married
Separated
Widowed
9.75%
27.10%
51.13%
5.40%
6.63%
US Census 2000 Race and Ethnicity
Total Population: Race
Hispanic Ethnicity: Race
American Indian, Eskimo, Aleut Population
Asian
Black Population
0.90%
3.60%
12.30%
American Indian/Alaska Native Alone
Asian Alone
Black Alone
1.20%
0.30%
2.00%
Hispanic Ethnicity
12.50%
Native Hawaiian/Other Pacific Islander
Alone
0.10%
Native Hawaiian and Other Pacific Islander
Alone
Not or Latino
Other Population
Two or More Races
White Population
0.10%
87.50%
5.50%
2.40%
75.10%
Some Other Race
Two or More races
White Alone
Hispanic Ethnicity Population
42.20%
6.30%
47.90%
3504
US Census 2000 Occupation and
Employment
2000 Means of Transportation to Work
Bicycle
Bus or trolley bus
Carpooled
Drove alone
Ferryboat
Motorcycle
Other means
Railroad
Streetcar or trolley car
Subway or elevated
Taxicab
Walked
Worked at home
Workers Age 16+
2000 Travel Time to Work in Minutes
Median Travel Time To Work
0 to 5
5 to 9
10 to 14
15 to 19
20 to 24
25 to 29
30 to 34
35 to 39
40 to 44
45 to 59
60 to 89
90 or more
Worked at home
2150.00%
3.30%
10.70%
14.50%
15.30%
14.00%
5.60%
12.80%
2.50%
3.20%
7.20%
5.00%
2.70%
3.30%
71,787,347
Male Householder
3,776,997
79,134,868
5,428,325
Male HHldr, no wife present, own
children < 18
Female Householder
2,190,989
2,685,682
Female HHldr, no husband present, own
children < 18
7,561,874
0.38%
2.50%
12.20%
75.70%
0.00%
0.10%
0.70%
0.50%
0.10%
1.50%
0.20%
2.90%
3.30%
45551
US Census 2000 Family Status: Family
Households
Family Households
Natural Born or Adopted Children in Family
Hhlds
Grandchildren in Family Hhlds
Step Children in Family Hhlds
4,258,524
Married Couple Family
Married Couple Family w/ Children < 18
54,493,232
24,835,505
Married Couple Family w/ no own Children < 18
29,657,727
Date: March 3, 2006
Current Geography
Selection: Entire US
Census Trend 1980 to 2000 Summary Report
Basic Variables
Population
Percent Female
Percent Male
1980
1990
Percent
Change
1980 to
1990
2000
Percent
Change
1990 to
2000
224,811,135
248,710,012
10.60%
281,421,906
13.20%
51.50%
51.30%
10.20%
50.90%
12.50%
48.50%
48.70%
11.10%
49.10%
13.90%
79,887,387
91,947,641
15.10%
105,480,101
14.70%
2.75
2.63
-4.20%
2.59
-1.40%
193,665,964
203,905,540
5.30%
231,374,718
13.50%
5,417,823
6,697,345
23.60%
7,778,633
16.10%
1980
1990
Percent
Change
1980 to
1990
2000
Percent
Change
1990 to
2000
Median Household Income
$16,902
$30,102
78.10%
$42,257
40.40%
Average Household Income
$20,382
$38,464
88.70%
$56,643
47.30%
Total Households
Average Household Size
Family Population
Group Quarters Population
Household Income
Per Capita Income
$7,321
$14,381
96.40%
$21,231
47.60%
$ 0 - $9,999
23,151,917
14,160,538
-38.80%
10,061,842
-28.90%
$ 10,000 - $14,999
12,228,204
8,114,324
-33.60%
6,653,726
-18.00%
$ 15,000 - $19,999
11,292,020
8,091,126
-28.30%
6,597,532
-18.50%
$ 20,000 - $29,999
9,945,771
15,439,727
55.20%
13,729,008
-11.10%
$ 30,000 - $39,999
12,617,264
13,358,162
5.90%
12,946,852
-3.10%
$ 40,000 - $49,999
3,359,065
10,221,806
204.30%
11,203,306
9.60%
$ 50,000 - $74,999
3,591,660
13,795,934
284.10%
20,529,242
48.80%
$ 75,000 +
3,719,547
8,754,151
135.40%
23,758,288
171.40%
$ 75,000 - $99,999
2,578,079
4,711,982
82.80%
10,793,156
129.10%
$100,000 +
1,141,468
4,042,169
254.10%
$100,000 - $124,999
$125,000 - $149,999
$150,000 +
12,965,132
220.70%
1,834,823
5,488,333
199.10%
763,165
2,654,858
247.90%
1,444,181
4,821,941
233.90%
Race and Ethnicity
2000
Percent
Change
1990 to
2000
42.10%
2,475,956
26.40%
112.00%
10,641,833
46.40%
45.80%
15,359,073
56.70%
29,986,018
13.80%
34,658,190
15.60%
199,686,676
22,353,238
6.90%
53.80%
211,460,626
35,305,818
5.90%
57.90%
1980
1990
Percent
Change
1980 to
1990
2000
Percent
Change
1990 to
2000
Owner Occupied Housing
51,428,015
59,025,095
14.80%
69,815,753
18.30%
Renter Occupied Housing
28,459,214
32,922,614
15.70%
35,664,348
8.30%
1980
1990
American Indian, Eskimo,
Aleut
1,378,738
1,958,777
Asian
3,429,040
7,270,823
Other
6,726,165
9,804,230
Black
26,338,642
186,878,591
14,538,161
White
Hispanic Ethnicity
Percent
Change
1980 to
1990
Housing Units
Date: March 3, 2006
Current Geography Selection: Entire US:
Entire US
Occupation and Employment Summary Report
Employment
Not in Labor Force
1990
2000
66,603,437
34.70%
78,319,195
36.10%
125,216,716
65.30%
138,829,294
63.90%
115,716,133
92.40%
129,728,865
93.40%
Unemployed
7,780,384
6.20%
7,947,452
5.70%
In Armed Forces
1,706,113
0.90%
1,152,977
0.80%
In Labor Force
Employed
2000 Census Transportation, Industry
and Occupation
Means of Transportation to Work
Workers Age 16+
Travel Time to Work
130,881,842
Median Travel Time To Work in Minutes
21
Bicycle
0.40%
0 to 5
3.30%
Bus or trolley bus
2.50%
5 to 9
10.70%
Carpooled
12.20%
10 to 14
14.50%
Drove alone
75.70%
15 to 19
15.30%
Ferryboat
0.00%
20 to 24
14.00%
Motorcycle
0.10%
25 to 29
5.60%
Other means
0.70%
30 to 34
12.80%
Railroad
0.50%
35 to 39
2.50%
Streetcar or trolley car
0.10%
40 to 44
3.20%
Subway or elevated
1.50%
45 to 59
7.20%
Taxicab
0.20%
60 to 89
5.00%
Walked
2.90%
90 or more
2.70%
Worked at home
3.30%
Worked at home
3.30%
Employment by Industry
Occupation
Accommodation and food services
Administrative and support and waste
management service
6.10%
3.40%
Aircraft and traffic control occupations
Architects surveyors cartographers and
engineers
Agriculture forestry fishing and hunting
1.50%
Arts design entertainment sports and media
occupation
1.90%
Arts entertainment and recreation
1.80%
Building & grounds cleaning & maintenance
occupat
3.30%
Construction
6.80%
Business operations specialists
2.10%
Educational services
8.80%
Community and social services occupations
1.50%
Finance and insurance
5.00%
Computer and mathematical occupations
2.40%
Construction trades workers
4.70%
Drafters engineering and mapping technicians
0.60%
Health care and social assistance
Information
11.10%
3.10%
0.10%
1.50%
Management of companies and enterprises
Manufacturing
0.10%
14.10%
Education training and library occupations
5.60%
Extraction workers
0.10%
Mining
0.40%
Farmers and farm managers
0.60%
Other services (except public administration)
4.90%
Farming fishing and forestry occupations
0.70%
Professional scientific and technical services
5.90%
Financial specialists
2.20%
4.80%
Fire fighting prevention and law enforcement
workers
1.20%
1.90%
Food preparation and serving related
occupations
4.80%
Health diagnosing and treating practitioners
and tech
3.20%
Public administration
Real estate and rental and leasing
Retail trade
11.70%
Transportation and warehousing
4.30%
Health technologists and technicians
1.40%
Utilities
0.90%
Healthcare support occupations
2.00%
Wholesale trade
3.60%
Installation maintenance and repair occupations
3.90%
Personal care and service occupations
2.80%
Legal occupations
1.10%
Life physical and social science occupations
0.90%
Management occupations except farmers and
farm manage
8.50%
Material moving workers
2.50%
Motor vehicle operators
2.90%
Office and administrative support occupations
15.30%
Production
8.40%
Protective Service Occupations
0.80%
Rail water and other transportation occupations
Sales and related occupations
0.30%
11.20%
Supervisors construction and extraction
workers
0.70%
Supervisors transportation and material moving
worker
0.20%
Date: March 3, 2006
Current Geography
Selection: Entire US:
Entire US
Income Summary Report
2000 Census Household
Income by Type
Total Households
105,480,101
Average Household Income
$56,643
Total Population
281,421,906
Median Household Income
$42,257
Total Workers
130,881,842
Per Capita Household Income
$21,587
Income by Type:
Earnings
$ 1 to $2,499 or less
Household Income Percents
$ 0 - $9,999
9.54%
$ 2,500 to $4,999
10,621,378
7,953,137
$ 10,000 - $14,999
6.31%
$ 5,000 to $7,499
8,124,698
$ 15,000 - $19,999
6.25%
$ 7,500 to $9,999
6,504,581
$ 20,000 - $24,999
6.57%
$ 10,000 to $12,499
9,597,527
$ 25,000 - $29,999
6.44%
$ 12,500 to $14,999
6,201,326
$ 30,000 - $34,999
6.37%
$ 15,000 to $17,499
8,302,907
$ 35,000 - $39,999
5.91%
$ 17,500 to $19,999
6,179,510
$ 40,000 - $44,999
5.65%
$ 20,000 to $22,499
9,086,198
$ 45,000 - $49,999
4.97%
$ 22,500 to $24,999
5,644,521
$ 50,000 - $59,999
9.04%
$ 25,000 to $29,999
12,996,782
$ 60,000 - $74,999
10.43%
$ 30,000 to $34,999
11,366,211
$ 75,000 - $99,999
10.23%
$ 35,000 to $39,999
9,219,670
$100,000 - $124,999
5.20%
$ 40,000 to $44,999
7,744,095
$125,000 - $149,999
2.52%
$ 45,000 to $49,999
5,200,969
$150,000 - $199,999
2.20%
$ 50,000 to $54,999
5,563,669
$200,000 +
2.37%
$ 55,000 to $64,999
6,146,281
$ 65,000 to $74,999
2,041,290
$ 75,000 to $99,999
2,191,536
$100,000 or more
1,850,632
HH Income By Age of
Householder
Purchase answer to see full
attachment
