Projects

Data Exploration using SQL

    In this SQL project, I conducted an analysis of the COVID-19 dataset. My focus was on data exploration and I extracted the following information:
  • The relationship between total cases and total deaths
  • The relationship between total cases and population
  • An examination of countries with the highest infection rate compared to population
  • A display of countries with the highest death count
  • A breakdown of data by continent
  • A presentation of continents with the highest death count per population
  • Global COVID statistics
  • An investigation of the relationship between total population and vaccinations using a common table expression and a temporary table.

Data Cleaning using SQL

    In this SQL project, I cleaned the "Nashville Housing" dataset using the following steps:
  • Standardizing the date format
  • Handling missing values in the "PropertyAddress" column
  • Breaking down the address into individual columns (address, city, state)
  • Changing "Y" and "N" to "Yes" and "No", respectively, in the "SoldAsVacant" column
  • Removing duplicates
  • Updating all the changes made
    • Overall, these cleaning methods improved the quality and consistency of the dataset, making it easier to work with and analyze.


Data Visualization using Power BI

    In this Power BI project, I used the 'Data Professional Survey' dataset to derive some useful insights, including:
  • Average salaries of different data-related jobs
  • Preferred programming languages for these jobs
  • Difficulty of breaking into the field
  • Happiness and work/life balance scores
  • Overview of major countries in the field.

Data Visualization using Tableau

    In this Tableau project, I used the 'Airbnb' dataset to derive some useful insights, including:
  • Average price by number of bedrooms
  • Distinct count of the number of bedrooms
  • Price by zip code using different maps
  • Revenue trend throughout the year.


Scraping Amazon Product Details

I completed a simple web scraping project to extract Amazon product title and price. The scraping interval can be customized to your preference, allowing for automated periodic scraping of data.

Scraping Tweets using Selenium

In this project, I scraped tweets from a desired profile using Selenium to automate the task and avoid duplicate tweets. You can limit the number of tweets and search for specific tweets using special keywords