CHETAN'S
PORTFOLIO

You got me!!!,I am an aspiring data Analyst,having Hands on experience on SQL,BI tools like Power BI,Tableau,working knowledge of Python.I Also have an 1.5 years experience on HTML,CSS3 and Aftermarket services and now, want to kickstart my career from this domain.I have given 110% to learn the data concepts as it is going to be the new fuel in the future.

Data Cleaning project using
SQL

This beginner friendly project is about cleaning data in MySQL Database. Data Cleaning is a super underrated skill
in the Data community,but contrastingly It's the stepping stone foe any visual creation. I hope this project will fulfil the understanding of cleaning using basic clauses (char,charindex etc)

COVID 19 Analysis and
it's impact on the world

This project revolves or rather helps in exploring the adversities of COVID 19 pandemic on the continents of the world and populates the deaths,rolling vaccinations and vaccinations.Necessary CTE and joins have been used to arrive at the insights to get to know the effects.


Kickdstarter Crowdfunding Analysis

Kickstarter is an American public benefit corporation based in New York, that maintains a global crowdfunding platform focused on creativity.People who back Kickstarter projects are offered rewards or experiences in exchange for their pledges. This model traces its roots to subscription model of arts patronage, in which artists would go directly to their audiences to fund their work.

OLIST ECOMMERCE
STORE ANALYSIS

The Olist Store Analysis project aims to analyze customer purchasing patterns and payment statistics on an E-commerce platform, Olist. This project covers several key performance indicators (KPIs) such as weekday vs weekend sales, payment statistics, delivery time, and customer behavior.The data is cleaned by removing outliers if any to extract valuable insights.

Hospitality domain project
using Power bi

Atliq Grands is an hospitality offering Co. which is facing revenues surge in the current time in different cities,As a data analyst intern in that company, I have got a task to find out the areas to improve and provide withe the insights to Team of the stakeholders.

RFM analysis Project
using SQL

This project is regarding analysis of sales and the customers of a particular store using the concept "RFM analysis" which is the abbreviation of Recency,Frequency,Monetory Value. Recency means How often the customer has visted their store. This helps the store to analyse their new and old cutomers. Now,Frquency means the No of times the customer has visited in a particular period of time. Lastly,Monetory value means, what was the revenue generated by a particular customer. These all factors will be enough to sneak peek into their database to have an account for their sales and revenue.

YT Channel analysis
using youtube API

This is the guided project for Youtube channel analysis using Youtube API key from google developer console website ,from where we are going to create the API key (youtube API V3) and get the channel ids from the rwspective channels of youtubers. After that, we would beusing the API key for youtube to provide us the channel details of the above mentioned youtube channels.

T20 World cup analysis by
web scraping

This data analysis project is about building a Report using BI and it's workspace for the best playing XI from the recently concluded T20 WC 2022 . before doing that, the data is scrapped from popular website "espncricinfo" and then scrapped using Brightdata website then converted into json file ,eventually uploaded into power BI.

Address

Belagavi,Karnataka

Phone

(+91) 8217711973

Email

pujar.chetu98@gmail.com

Social