-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
166 lines (154 loc) · 6.85 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
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
<!DOCTYPE HTML>
<!--
Forty by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title>Ashish Sahu, Data Analyst Portfolio</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/f8c0bbec__main.css" />
<noscript><link rel="icon" type="image/png" href="Ashish.JPG" /></noscript>
</head>
<body class="is-preload">
<!-- Wrapper -->
<div id="wrapper">
<!-- Header -->
<header id="header" class="alt">
<a href="index.html" class="logo"><strong>Ashish Sahu</strong> <span>Data Analyst</span></a>
<nav>
<a href="#menu">Menu</a>
</nav>
</header>
<!-- Menu -->
<nav id="menu">
<ul class="links">
<li><a href="index.html">Home</a></li>
<li><a href="https://www.linkedin.com/in/ashish-sahu-45143721a/">LinkedIn</a></li>
<li><a href="https://github.com/sahugithub1">GitHub</a></li>
</ul>
</nav>
<!-- Banner -->
<section id="banner" class="major">
<div class="inner">
<header class="major">
<h1>Ashish Sahu, Data Analyst Portfolio</h1>
</header>
<div class="content">
<p> Google-certified Data Analyst <br />
Excelling in Power BI, Tableau, MySQL, and Excel.<br />
Scroll down to view my individual portfolio projects.</p>
<div data-iframe-width="110" data-iframe-height="130" data-share-badge-id="12c3c7cf-f26e-422d-b32a-59759ef69365" data-share-badge-host="https://www.credly.com"></div><script type="text/javascript" async src="//cdn.credly.com/assets/utilities/embed.js"></script>
<ul class="actions">
<li><a href="https://www.linkedin.com/in/ashish-sahu-45143721a/" class="button next scrolly">GO TO MY LINKEDIN</a></li>
</ul>
</div>
</div>
</section>
<!-- Main -->
<div id="main">
<!-- One -->
<section id="one" class="tiles">
<article>
<span class="image">
<img src="images/upworkc.png" alt="">
</span>
<header class="major">
<h3><a href="https://sites.google.com/view/upworkprojectcrimereportingdas/home" class="link"> Upwork Project (Crime Reporting Dashboard)</a></h3>
<p>Tool: Power BI
● After ETL process in power query created table relationship with star and snowflake schemas, created rolling calendar, created calculated columns using Weekday, year, logical functions,text functions, created complex Explicit measures, Built KPIs, create tooltip with other page, combined all visualizations in Report.
</p>
</header>
</article>
<article>
<span class="image">
<img src="images/Power-BI.jpg" alt="">
</span>
<header class="major">
<h3><a href="https://sites.google.com/view/adventure-works-report/home" class="link">Adventure Works Cycles</a></h3>
<p>Tool: Power BI
● After ETL process in power query created table relationship with star and snowflake schemas, created calculated columns using Weekday, year, DATEDIFF, logical functions,text functions.created complex Explicit measures with CALCULATE & ALL,CALCULATE & FILTER, ITERATOR functions (SUMX,COUNTX),Time Intelligence Formulas.Built KPIs, combined all visualizations in Report.
</p>
</header>
</article>
<article>
<span class="image">
<img src="images/harrypotter.jpg" alt="">
</span>
<header class="major">
<h3><a href="https://sites.google.com/view/ashishmavenmagicchallenge/home" class="link">Harry Potter Movies Data Analysis</a></h3>
<p>Tool: Power BI
● Built Model in Power BI after using power query to match number of particular spells to characters, created DAX Measures and Calculated Column, Built Visualizations, combined all visualizations in Report.
</p>
</header>
</article>
<article>
<span class="image">
<img src="images/0c503c67__tableau.jfif" alt="">
</span>
<header class="major">
<h3><a href="https://public.tableau.com/app/profile/ashish.sahu3987" class="link">Tableau Dashboards</a></h3>
<p>Tableau Dashboards for Exploratory Data Analysis – Terrorism & Sports
● Tools: Tableau Desktop
● Strategies: Build and Beautify Visualizations with slicers, top N filters and other filters, combined all visualizations in Dashboard, Aggregate Measures
</p>
</header>
</article>
<article>
<span class="image">
<img src="images/excel.jpg" alt="">
</span>
<header class="major">
<h3><a href="https://github.com/sahugithub1/Excel-for-Analytics" class="link">Excel for Analytics</a></h3>
<p>Solved Business problems after Data cleaning, wrangling and Data Exploration.
● Used xlookup, Hlookup, Vlookup, Index match, Forecasts ● Analysis and visualizations in Excel </p>
</header>
</article>
</section>
</div>
<!-- Contact -->
<section id="contact">
<div class="inner">
<section class="split">
<section>
<div class="contact-method">
<span class="icon solid alt fa-envelope"></span>
<h3>Email</h3>
<a href="#">ashish-sahu@outlook.com</a>
</div>
</section>
<section>
<div class="contact-method">
<span class="icon solid alt fa-home"></span>
<h3>Location</h3>
<span>Kanpur, Uttar Pradesh, INDIA</span>
</div>
</section>
</section>
</div>
</section>
<!-- Footer -->
<footer id="footer">
<div class="inner">
<ul class="icons">
<li><a href="https://www.linkedin.com/in/ashish-sahu-45143721a/" class="icon brands alt fa-linkedin-in"><span class="label">LinkedIn</span></a></li>
<li><a href="https://github.com/sahugithub1" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
</ul>
<ul class="copyright">
<li>© Ashish Sahu</li><li>Design: <a href="../../html5up.net/file_f76da7f2.pwc">HTML5 UP</a></li>
</ul>
</div>
</footer>
</div>
<!-- Scripts -->
<script src="assets/js/ba1a511d__jquery.min.js"></script>
<script src="assets/js/b6d6c908__jquery.scrolly.min.js"></script>
<script src="assets/js/8faa50b1__jquery.scrollex.min.js"></script>
<script src="assets/js/7a1b7222__browser.min.js"></script>
<script src="assets/js/ee259bed__breakpoints.min.js"></script>
<script src="assets/js/b1e6d663__util.js"></script>
<script src="assets/js/75629088__main.js"></script>
</body>
</html>