Varun Kumar - Data Analyst Portfolio

Data Exploration
in SQL

The SQL commands used for data exploration include tasks such as querying and summarizing data, filtering records based on conditions, grouping data for aggregate analysis, joining tables to combine datasets, creating calculated columns, and identifying trends.

SQL Data Exploration Retail Sales

View Project

Layoffs Dataset
Data Cleaning

SQL Data Cleaning Layoffs

I cleaned a layoffs dataset by removing inconsistencies, filling in missing values, and standardizing entries to ensure accuracy. I worked on tasks like making job titles consistent, normalizing company names and categorizing the reasons for layoffs.

View Project

WEB SCRAPING
WITH PYTHON

This Python script leverages BeautifulSoup and requests to scrape product information from Amazon, focusing on names and prices. It cleans and organizes the data, saving it to a CSV file with a timestamp.

Python Web Scraping BeautifulSoup Data Collection

              # Sample code snippet

              import requests

              from bs4
              import BeautifulSoup

              def
              scrape_amazon_data(url):

                  headers = {"User-Agent": "Mozilla/5.0"}

                  page = requests.get(url,
              headers=headers)

                  soup = BeautifulSoup(page.content,
              "html.parser")

                  # ... extraction logic

View Project

Weather
Dashboard

A fully interactive Power BI dashboard that fetches live data using a Weather API. It displays the current weather conditions for five Indian states, provides a 7-day forecast, tracks air quality index (AQI), and highlights key details like sunrise/sunset times.

Power BI Data Visualization Dashboard

View Project

Lego Sales
Dashboard

Lego Dashboard PowerBI

The Lego Sales Dashboard provides insights into overall sales performance, showcasing the most sold products, top colors by demand, and sales distribution across categories , uncover which Lego themes and colors drive best revenue.

View Project

Data Survey
Dashboard

Survey PowerBI Excel

An insightful Power BI dashboard analyzing survey data on professions, work-life balance, happiness, and related indexes. Visualizes key trends and correlations to uncover meaningful patterns and support informed decision-making.

View Project

Varun Kumar Data Analyst

Varun Kumar
Data Analyst