Shubham Rana's
Portfolio

Data Analyst well versed in SQL, Excel (Adv.), Power BI, Tableau.

Data Cleaning in SQL

The SQL queries to perform data standardization, addressing missing values, parsing property and owner addresses into separate columns, converting, removing duplicate entries based on specific columns, and finally, deleting unused columns like OwnerAddress, TaxDistrict, PropertyAddress, and SaleDate.

COVID 19
Data Exploration

The SQL queries to retrieve and analyzes COVID-19 data, including total cases, deaths, and vaccinations, calculating percentages and creating a view for future visualization. It addresses data cleaning, population-based metrics, and vaccination progress, providing insights into the pandemic's impact.