Hi,
I am Kunal Gaurav
Data Analytics

I am a life time learner, good observant who have excellent analytical and visualizing skills. Hands on experience in SQL, Power BI, Excel, Visualization, ETL, Dashboard Creation.

Image

About

Image

I am Kunal Gaurav, a graduate of East West Institute of Technology, specializing in Electronics and Communication, completing my studies in 2021. My journey into the realm of data began with a course in Data Science and Data Visualization, where I delved into the intricacies of tools like Power BI and Excel. Through hands-on projects during the course, I honed my skills and developed a passion for leveraging data insights.
My experience navigating datasets, crafting compelling visualizations, and deriving actionable insights has ignited my interest in pursuing a career in data-related domains.
I believe my proficiency in tools like Power BI and Excel, coupled with my analytical mindset, make me a strong fit for roles that demand a deep understanding of data management and analysis.
I am excited about the opportunity to contribute to the growth and success of organizations by leveraging data-driven strategies. My strengths lie in translating data complexities into meaningful solutions, aligning with the objectives of the job role, and fostering continuous improvement in production and efficiency.

Skills

Excel

  • Data cleaning and Data transforming
  • Basic formulas: SUM, AVERAGE, MEAN, MEDIAN, SUMPRODUCT, CONCATENATE
  • Advance formulas: VLOOKUP, INDEX, MATCH, IF, COUNTIF, SUMIF
  • Remove duplicates and conditional formatting, Charts, filters, sort, slicers, Pivot tables and pivot charts

Data Visualization

  • Understanding business requirements, analysing the data, identifying key performance indicators (KPI's) and present it using effective visuals.

SQL

  • HackerRank has awarded me 5 star ranking for SQL.
  • Basic Queries: SELECT, WHERE, DISTINCT, LIKE, BETWEEN, ORDER BY, LIMIT, GROUP BY, HAVING CLAUSE, INSERT, UPDATE, ALTER, IMPORT, Data types.
  • Advance Queries: Date time function, Window function, Sub query, Case statement, CTE, query optimisation.
  • JOINS: Inner, Outer, Left, Right

Power BI

  • Created more than 10 dashboards that provide meaningful insights for business growth.
  • Hands on experience in power query, interactive visual reports, ETL, DAX. Great Learning certification of analyzing and visualizing data with Microsoft Power BI.

Python

  • In python, I can handle fundamental problems with loop, if-else, case statement, functions. I am able to use multiple python functions for modifying list.

Presentation Skills

  • I can provide the insights to the stakeholders and top-level management by thoroughly understanding the business requirements by compile the whole work on Microsoft PowerPoint.

Work

Power BI

View Projects

Python

View Projects

Excel

View Projects

SQL

View Projects

Certification

Data Science

Internshala

View certification here.

Python for Data Analysis

Great Learning

View certification here.

Data Visualization with Power BI

Great Learning

View certification here.

SQL for Data Analysis

Great Learning

View certification here.

Google Analytics

Great Learning

View certification here.

Contact

Address

SMR VINAY ESTELLA
Bangaluru 560097

Contact Number

9113561972

9480281547

Email Address

kunalgaurav960@gmail.com

Download

Download resume here.