-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathelements.html
392 lines (309 loc) · 22.8 KB
/
elements.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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
<!DOCTYPE HTML>
<!--
Massively by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title>Rahul Patel - Projects</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
<style>
body {
background: URL("images/bg.jpg") no-repeat center center fixed;
background-size cover;
background-attachment: fixed; /* Ensure the background stays fixed while scrolling */
color: white; /* Text color */
font-family: Arial, sans-serif; /* Font family for the text */
}
#wrapper {
background-color: rgba(0, 0, 0, 0.5); /* Background overlay color */
padding: 100px 0; /* Add padding to the wrapper */
}
#intro {
text-align: center;
}
#intro h1 {
font-size: 3em;
}
#intro p {
font-size: 1.2em;
}
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
</head>
<body class="is-preload">
<!-- Wrapper -->
<div id="wrapper">
<div id="intro">
<h1><span style="font-size: 2em; font-weight: bold;">Projects</span><br /></h1>
</h1>
<p>Welcome to the project page of my portfolio website, showcasing my expertise in data analysis and data science. Below, you'll find a curated selection of projects that highlight my proficiency in extracting valuable insights from data and developing innovative solutions to real-world problems. <a href="https://www.linkedin.com/in/rahul-patel-933858175/">@Rahul_Patel</a> <br />
</p>
<ul class="actions">
<li><a href="#header" class="button icon solid solo fa-arrow-down scrolly">Continue</a></li>
</ul>
</div>
<!-- Header -->
<header id="header">
<a href="index.html" class="logo">Make the Data Shine!</a>
</header>
<!-- Nav -->
<nav id="nav">
<ul class="links">
<li><a href="index.html">About me</a></li>
<li><a href="generic.html">Certificates of Completion</a></li>
<li class="active"><a href="elements.html">Projects</a></li>
</ul>
<ul class="icons">
<li><a href="https://www.linkedin.com/in/rahul-patel-933858175/" class="icon brands alt fa-linkedin"><span class="label">linkedin</span></a></li>
<li><a href="https://github.com/Rahul-Patel321" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
</ul>
</nav>
<!-- Main -->
<div id="main">
<!-- Featured Post -->
<!-- Posts -->
<section class="posts">
<article>
<header style="margin-bottom: 0;">
<h2><a href="https://github.com/Rahul-Patel321/Business_Insight_360">Business Intelligence Dashboard with Power BI<br />
</a></h2>
<p style="color: black; font-size: 16px;">This project features a comprehensive set of dashboards designed to provide crucial insights across various business domains including finance, sales, marketing, supply chain, and executive performance.
</p>
</header>
<a href="https://github.com/Rahul-Patel321/Business_Insight_360" class="image main"><img src="images/Business insight 360.png" alt=""/></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/Business_Insight_360" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header style="margin-bottom: 0;">
<h2><a href="https://github.com/Rahul-Patel321/pizza_sales-SQL/blob/main/pizza_Sales%20Project.pdf">Analysis of Pizza Sales Data<br />
[Insights and Findings from SQL Queries]
</a></h2>
<p style="color: black; font-size: 16px;">The objective of this analysis is to gain comprehensive insights into pizza sales
patterns, identify top-selling products, understand customer preferences, and
provide actionable recommendations for business strategy.
</p>
</header>
<a href="https://github.com/Rahul-Patel321/pizza_sales-SQL/blob/main/pizza_Sales%20Project.pdf" class="image main"><img src="images/pizza_sale.png" alt=""/></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/pizza_sales-SQL/blob/main/pizza_Sales%20Project.pdf" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header style="margin-bottom: 0;">
<h2><a href="https://github.com/Rahul-Patel321/Google-Data-Analytics-Capstone-Projects/blob/main/Google%20Data%20Analytics%20Capstone%20Project%20-%20Case%20Study.ipynb">Google Data Analytics Capstone Project - <br />
[Cyclistic Case Study]
</a></h2>
<p style="color: black; font-size: 16px;">This project serves as the capstone for the Google Data Analytics Professional Certificate course on Coursera. It presents a case study centered around data from Cyclist, a fictional bike rental company in Chicago. The objective is to discern and comprehend the primary distinctions between annual members and casual riders, leveraging data analysis techniques.
</p>
</header>
<a href="https://github.com/Rahul-Patel321/Google-Data-Analytics-Capstone-Projects/blob/main/Google%20Data%20Analytics%20Capstone%20Project%20-%20Case%20Study.ipynb" class="image main"><img src="images/capstone project.jpg" alt=""/></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/Google-Data-Analytics-Capstone-Projects/blob/main/Google%20Data%20Analytics%20Capstone%20Project%20-%20Case%20Study.ipynb" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header style="margin-bottom: 0;">
<h2><a href="https://github.com/Rahul-Patel321/Excel-Sales-Analytics">Excel-Sales-Analytics<br />
</a></h2>
<p style="color: black; font-size: 16px;">In this Project I developed customer performance reports and compared market performance with sales targets to identify sales patterns and track KPIs. Additionaly, Created P&L reports by fiscal year, month, and market to evaluate financial performance and support decision-making.
</p>
</header>
<a href="https://github.com/Rahul-Patel321/Excel-Sales-Analytics"><img src="images/" alt=""/></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/Excel-Sales-Analytics" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/Sales-Dashboard-Excel/tree/main">Sales Dashboard Using <br />
Excel<br />
</a></h2>
<p style="color: black; font-size: 16px;">This project features a Sales Dashboard created in Microsoft Excel. The dashboard offers an interactive and visual analysis of sales data, helping users understand sales performance, identify trends, and derive key insights.</p>
</header>
<a href="https://github.com/Rahul-Patel321/Sales-Dashboard-Excel/tree/main" class="image main"><img src="images/salesdashboard.png" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/Sales-Dashboard-Excel/tree/main" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Data%20Cleaning%20in%20SQL%20(Nashville_Housing_data).sql">Data Cleaning in <br />
SQL<br />
</a></h2>
<p style="color: black; font-size: 16px;">In this project, I've executed data cleaning procedures within SQL Server, focusing on the Nashville housing dataset. Through a series of SQL queries and transformations, I've addressed inconsistencies, missing values, and anomalies in the data to ensure its quality and reliability for subsequent analysis
</p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Data%20Cleaning%20in%20SQL%20(Nashville_Housing_data).sql" class="image main"><img src="images/housing.jpg" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Data%20Cleaning%20in%20SQL%20(Nashville_Housing_data).sql" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/Power-BI-Projects/blob/main/SalesDashboard.pbix">Sales Dashboard Using <br />
Power BI<br />
</a></h2>
<p style="color: black; font-size: 16px;">This project entails the development of a comprehensive Power BI Dashboard specifically tailored for a computer hardware business grappling with the challenges posed by a dynamically evolving market. The dashboard will provide a robust analytical toolset to enable the business to monitor key performance indicators, track market trends, and make data-driven decisions.</p>
</header>
<a href="https://github.com/Rahul-Patel321/Power-BI-Projects/blob/main/SalesDashboard.pbix" class="image main"><img src="images/bbb.png" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/Power-BI-Projects/blob/main/SalesDashboard.pbix" class="button large">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://public.tableau.com/app/profile/rahul.patel7099#!/?newProfile=&activeTab=0">Tableau Projects<br />
</a></h2>
<p style="color: black; font-size: 16px;"> In this section, I've created visualization dashboards using Tableau for projects encompassing Covid-19 data analysis, CO2 emissions per capita, Bitcoin prices, and visual representation of World Happiness data. These dashboards offer intuitive insights into the respective datasets, enabling users to explore trends, correlations, and patterns effectively. </p>
</header>
<a href="https://public.tableau.com/app/profile/rahul.patel7099#!/?newProfile=&activeTab=0" class="image fit"><img src="images/tableau.png" alt="" /></a>
<ul class=" actions special">
<li><a href="https://public.tableau.com/app/profile/rahul.patel7099#!/?newProfile=&activeTab=0" class="button">View Projects</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Covid_Project(data%20analysis).sql">Data Exploration in <br />
SQL</a></h2>
<p style="color: black; font-size: 16px;">In this project, I conducted data exploration of the Covid-19 dataset using SQL Server. Through SQL queries and analysis, I delved into the dataset's various dimensions, such as infection rates, geographical trends, demographic patterns, and temporal variations, to gain insights into the spread and impact of the pandemic.</p>
</header>
<ul class=" actions special">
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Covid_Project(data%20analysis).sql" class="image fit"><img src="images/covid.jpg" alt="" /></a>
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Covid_Project(data%20analysis).sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Project%20(Movie%20Correlation).ipynb">Movie <br />Correaltion with <br />
Python</a></h2>
<p style="color: black; font-size: 16px;">In this project, I investigated the factors influencing gross revenue in the film industry. By analyzing various variables such as production budget, genre, release date, cast, and marketing expenditure, I aimed to discern their impact on the overall revenue generated by movies.</p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Project%20(Movie%20Correlation).ipynb" class="image fit"><img src="images/movie_correlation.jpeg" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Project%20(Movie%20Correlation).ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Data%20Exploration%20and%20Cleaning%20Titanic%20Dataset%20.ipynb">Data Exploration and Cleaning-Titanic Dataset <br /> <br />
</a></h2>
<p style="color: black; font-size: 16px;">In this project, I've engaged in exploratory data analysis (EDA) by harnessing a variety of Python libraries. Through the utilization of tools such as Pandas, NumPy, Matplotlib, Seaborn, and others, I've conducted comprehensive data exploration, visualization, and statistical analysis to gain insights into the underlying patterns, trends, and relationships within the dataset.</p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Data%20Exploration%20and%20Cleaning%20Titanic%20Dataset%20.ipynb" class="image fit"><img src="images/titanic.jpeg" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Data%20Exploration%20and%20Cleaning%20Titanic%20Dataset%20.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/SQL%20Queries%2C%20Analysis%20and%20Visualization%20using%20Jupyter%20Notebook.ipynb">Movie <br />SQL Queries, Analysis and Visualization using Jupyter Notebook <br />
</a></h2>
<p style="color: black; font-size: 16px;">In this project, I've conducted a series of SQL queries on the Sakila sample database within a Jupyter notebook environment. The SQL implementation employed for this notebook is SQLite3. Through the execution of these queries, I've explored the dataset, extracted relevant information, and performed analytical tasks to gain insights into the data stored within the Sakila database. </p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/SQL%20Queries%2C%20Analysis%20and%20Visualization%20using%20Jupyter%20Notebook.ipynb" class="image fit"><img src="images/Sql.png" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/SQL%20Queries%2C%20Analysis%20and%20Visualization%20using%20Jupyter%20Notebook.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Football%20Data-Analysis%20Project.ipynb">EPL 2020-21 <br />Dataset Analysis <br />
</a></h2>
<p style="color: black; font-size: 16px;">In this project, I've undertaken an Exploratory Data Analysis (EDA) utilizing Python on the English Premier League (EPL) 2020-21 Football Dataset. Through systematic examination and visualization of the data, I've aimed to uncover patterns, trends, and insights that offer valuable perspectives on the performance and dynamics within the league</p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Football%20Data-Analysis%20Project.ipynb" class="image fit"><img src="images/Epl.jpeg" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Football%20Data-Analysis%20Project.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Python_Project%20(Netflix%20dataset%20Analysis).ipynb"> <br />Pyhton_Project <br />
Netflix Dataset Analysis</a></h2>
<p style="color: black; font-size: 16px;">In this project, I've conducted an in-depth big data analysis on diverse parameters within the Netflix dataset. Leveraging advanced analytical techniques, I've explored various dimensions of the dataset to extract valuable insights and discern trends, contributing to a comprehensive understanding of its contents.</p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Python_Project%20(Netflix%20dataset%20Analysis).ipynb" class="image fit"><img src="images/Netflix.jpg" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Python_Project%20(Netflix%20dataset%20Analysis).ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/India%20Census-2011%20Dataset%20Analysis.ipynb"> <br />
India Census-2011 Dataset Analysis</a></h2>
<p style="color: black; font-size: 16px;">In this project, I've conducted comprehensive big data analysis on various parameters extracted from the India Census-2011 dataset. Through extensive examination and exploration, I've delved into diverse facets of the dataset to derive insights and draw meaningful conclusions.</p>
<ul class=" actions special">
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/India%20Census-2011%20Dataset%20Analysis.ipynb" class="image fit"><img src="images/census.jpg" alt="" /></a>
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/India%20Census-2011%20Dataset%20Analysis.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Exploratory%20data%20analysis%20of%20telecom_churn%20dataset%20using%20pandas%20.ipynb"> <br />
Exploratory Data Analysis of telecom_churn dataset using pandas</a></h2>
<p style="color: black; font-size: 16px;">" In this project, I've extensively utilized Python to execute a multitude of operations on the pandas DataFrame, encompassing tasks ranging from data manipulation to analysis. </p>
</header>
<a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Exploratory%20data%20analysis%20of%20telecom_churn%20dataset%20using%20pandas%20.ipynb" class="image fit"><img src="images/telecom_churn.png" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/PortfolioProjects/blob/main/Exploratory%20data%20analysis%20of%20telecom_churn%20dataset%20using%20pandas%20.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/Rahul-Patel321/Big_Data_Analysis-Using-Python-/blob/main/Python_Project(London%20housing%20Dataset%20Analysis).ipynb"> <br />Pyhton_Project <br />
London Housing Dataset Analysis</a></h2>
<p style="color: black; font-size: 16px;">In this project, the London Housing Dataset is analyzed using Python. The analysis includes exploring housing trends, identifying key factors affecting prices, and visualizing data to uncover insights about the real estate market in London.</p>
</header>
<a href="https://github.com/Rahul-Patel321/Big_Data_Analysis-Using-Python-/blob/main/Python_Project(London%20housing%20Dataset%20Analysis).ipynb" class="image fit"><img src="images/LondonHousing.jpeg" alt="" /></a>
<ul class=" actions special">
<li><a href="https://github.com/Rahul-Patel321/Big_Data_Analysis-Using-Python-/blob/main/Python_Project(London%20housing%20Dataset%20Analysis).ipynb" class="button">View Project</a></li>
</ul>
</article>
</section>
</div>
<!-- Footer -->
<footer id="footer">
<section class="split contact">
<section class="alt">
<h3>Phone</h3>
<p>+91-8382020852</p>
</section>
<section>
<h3>Email</h3>
<p><a href="#">rahulpatelue188076@gmail.com</a></p>
</section>
<section>
<h3>Address</h3>
<p>Sector-70, NOIDA</p>
</section>
<section>
<h3>Social</h3>
<ul class=" icons alt">
<li><a href="https://www.linkedin.com/in/rahul-patel-933858175/" class="icon brands alt fa-linkedin"><span class="label">linkedin</span></a></li>
<li><a href="https://github.com/Rahul-Patel321" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
</ul>
</section>
</section>
</footer>
</div>
<!-- Copyright -->
<div id="copyright">
<ul><li>© Rahul Patel</li></ul>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
<script src="assets/js/scripts.js"></script>
</body>
</html>