Pinned Repositories
AdityaJain.github.io
Adityajainaj22
Config files for my GitHub profile.
Amazon-Web-Scraping
Web scraper using Python's BeautifulSoup and requests to extract Amazon product details, including name, rating, price, and description. Data is exported to a CSV with automated periodic updates and email alerts for price drops. Demonstrates web scraping and automation skills.
Credit-Card-Churn-Analysis
Crypto-Data-Extraction-using-API
Automate crypto data extraction using Python and Coin Market Cap's API! Add timestamps, automate data appending, and visualize with Plotly/Matplotlib. Archive data in CSV files for easy access. Automating and transforming crypto data.
Data-Professional-Survey-Analysis
In this Power BI project, I transformed survey data from data professionals, simplified and transformed raw data using Power Query. Perform data cleaning in Power Query using custom formulas. Last I created visualizations and dashboards showcasing key insights.
Project-Airbnb-Seattle
Tableau project using Seattle Airbnb data which includes listings, pricing, and reviews data. I joined all the sheets within Tableau itself and created a pricing analysis dashboard. This project showcases my ability to handle data joins, perform relevant data filtering, and create insightful visualizations.
Project-Coronavirus
Analyzed COVID-19 data using SQL and Tableau. Set up a SQL Server, cleaned data, and created a database. Built an interactive dashboard in Tableau to visualize trends in reproduction rates, ICU patients, testing metrics, and vaccination impacts.
Project-Movie-Correlation
Explored movie dataset correlations with Python. Cleaned data, handled missing values via deletion and KNN imputation. Visualized relationships with scatter, regression plots, and correlation matrices. Found budget and votes positively correlated with gross revenue using Pearson, Kendall, and Spearman methods.
Project-Nashville
This repository features a Nashville housing data project where I imported, cleaned, and standardized 56,477 rows using SQL. Tasks included refining dates, addressing null values, splitting addresses, and removing duplicates for enhanced data usability.
Adityajainaj22's Repositories
Adityajainaj22/AdityaJain.github.io
Adityajainaj22/Adityajainaj22
Config files for my GitHub profile.
Adityajainaj22/Amazon-Web-Scraping
Web scraper using Python's BeautifulSoup and requests to extract Amazon product details, including name, rating, price, and description. Data is exported to a CSV with automated periodic updates and email alerts for price drops. Demonstrates web scraping and automation skills.
Adityajainaj22/Credit-Card-Churn-Analysis
Adityajainaj22/Crypto-Data-Extraction-using-API
Automate crypto data extraction using Python and Coin Market Cap's API! Add timestamps, automate data appending, and visualize with Plotly/Matplotlib. Archive data in CSV files for easy access. Automating and transforming crypto data.
Adityajainaj22/Data-Professional-Survey-Analysis
In this Power BI project, I transformed survey data from data professionals, simplified and transformed raw data using Power Query. Perform data cleaning in Power Query using custom formulas. Last I created visualizations and dashboards showcasing key insights.
Adityajainaj22/Project-Airbnb-Seattle
Tableau project using Seattle Airbnb data which includes listings, pricing, and reviews data. I joined all the sheets within Tableau itself and created a pricing analysis dashboard. This project showcases my ability to handle data joins, perform relevant data filtering, and create insightful visualizations.
Adityajainaj22/Project-Coronavirus
Analyzed COVID-19 data using SQL and Tableau. Set up a SQL Server, cleaned data, and created a database. Built an interactive dashboard in Tableau to visualize trends in reproduction rates, ICU patients, testing metrics, and vaccination impacts.
Adityajainaj22/Project-Movie-Correlation
Explored movie dataset correlations with Python. Cleaned data, handled missing values via deletion and KNN imputation. Visualized relationships with scatter, regression plots, and correlation matrices. Found budget and votes positively correlated with gross revenue using Pearson, Kendall, and Spearman methods.
Adityajainaj22/Project-Nashville
This repository features a Nashville housing data project where I imported, cleaned, and standardized 56,477 rows using SQL. Tasks included refining dates, addressing null values, splitting addresses, and removing duplicates for enhanced data usability.
Adityajainaj22/Project-Bike-Sale-Analysis
This project demonstrates my Excel skills in data cleaning, pivot tables, and dashboard creation. I analyze a dataset with various demographics, create visualizations, and design a professional dashboard. The process begins with data cleaning, removing duplicates, and standardizing entries.
Adityajainaj22/Project-Coffee-Sales-Analysis
Created a dynamic Excel dashboard using advanced PivotTables, PivotCharts, INDEX, Multiple IF Functions, and slicers. Customized chart elements, applied XLOOKUP for data validation, and utilized table automatic updates. Enhanced data visualization with custom styles and interactive timelines.
Adityajainaj22/Project-Video-Game-Analysis
In this project, I explored the top 400 best-selling video games from 1977 to 2020, analyzing sales, critic reviews, and user ratings to identify the golden age of gaming. Using SQL queries, I determined the best years for video games based on sales and scores.