-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
108 lines (91 loc) · 5.71 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<!DOCTYPE html>
<html lang='EN-US'>
<head>
<meta charset="UTF-8">
<title>Group 1 ETL Project</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous"> <link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="style.css">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<a class="navbar-brand" href="#">Group 1's Project</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNavDropdown" aria-controls="navbarNavDropdown" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNavDropdown">
<ul class="navbar-nav">
<li class="nav-item active">
<a class="nav-link" href="index.html">Project Summary & Design </a>
</li>
<li class="nav-item">
<a class="nav-link" href="data.html">Data </a>
</li>
<li class="nav-item">
<a class="nav-link" href="database.html">Final Database </a>
</li>
</ul>
</div>
</nav>
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1 class="text-center" style="margin-top: 2em"> Looking at Starbucks, McDonald's, and While Food Locations by Zip Code</h1>
<h5 class="text-center"> by John Goebel, Nick Weaver, Carol Pietro, and Mohammed Irshad </h5>
</div>
</div>
<div class="row">
<div class="col-lg-2"></div>
<div class="col-lg-8" style="margin-top: 2em;">
<h3>Executive Summary</h3>
<div class="panel panel-default">
<div class="panel-body">
Welcome to our CWRU Bootcamp ETL project!
Please review the documentation located on this site for use of the data contained within. We welcome you to explore our data. We selected these particular datasets and views after reading a related article on cbsnews.com, which analyzed the relationship between Starbucks and property values. We chose to change the property value to median household income and also to add other retail components such as McDonalds and Wholefoods.
Our team, John, Nick, Carol and Mohammad used the skills we have learned in the DataAnalytics bootcamp to bring to you a transformed set of data for use in answering potential questions like:
</br>
<ol>
<li>
Is there any correlation between Starbucks, McDonald’s, Whole Foods and median household income?
</li>
<li>What are the median incomes per zip code?</li>
<li>What zip codes have the most concentrated representations of high-end retail?</li>
<li>Does the zip code influence the likelihood of a McDonald’s, Starbucks, or Whole Foods opening in the area?</li>
</ol>
If you are considering doing any analysis that involves the data we provided, the final aggregation of data is available at the "Final Database" section.
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-6" style="margin-top: 2em">
<h3 class="text-center"> Our Project Design:</h3>
<img src="Images/process_mapping.png" alt="Process Mapping">
</div>
<div class="col-lg-4" style="margin-top: 2em">
<div class="panel panel-default">
<div class="panel-body">
<p style="margin-top: 2em">By clearly defining up the tasks of this project, we were able to clearly divy up work and get it done in a timely manner. </p>
</div>
</div>
</div>
</div>
<div class="row" style="margin-top: 5em">
<div class="col-lg-5">
<h3 class="text-center"> Our ERD:</h3>
<div class="panel panel-default">
<div class="panel-body">
<p style="margin-top: 2em">A look at how our data is arranged in our final database. </p>
</div>
</div>
</div>
<div class="col-lg-7" style="margin-top: 2em">
<img src="Images/project2-ERD.png" alt="ERD">
</div>
</div>
</div>
</body>
</html>