Amazon Sales Data Analysis (AMJ ‘22)

Cleaned and analyzed Amazon's AMJ quarter sales data using SQL queries, revealing key insights like revenue, top-selling products, and peak sales periods. Identified opportunities for operational improvement, reflected in a visually appealing Tableau dashboard.

Walmart Retail Data ETL Pipeline

Constructed a robust data pipeline for Walmart, proficiently managing sales data extraction, transformation, and analysis using Python. Facilitated insightful analysis, emphasizing technical expertise in scalability and automation.

Covid - 19 Vaccinations EDA

Analyzed global Covid-19 data using SQL queries, emphasizing Canada's metrics. Calculated death percentages, infection rates, and vaccination progress. Leveraged advanced SQL techniques like CTEs and Window functions for data manipulation.

Banking Data Analysis

Explored banking transaction data using R, dplyr, and ggplot2, showcasing proficiency in data manipulation and visualization techniques, while providing insights into transaction patterns and customer behavior.

British Airways Customer Reviews Dashboard

Created a concise Tableau dashboard showcasing British Airways' average ratings from customer reviews. Utilized cleaned data for flexible analysis and included key visualizations like the Country-wise Ratings Map. Accessible on Tableau Public for transparency.

Space Exploration Database

Created PostgreSQL database dump containing tables for celestial objects like asteroids, galaxies, moons, planets, and stars, alongside their attributes. The project serves as a practice exercise for SQL skills and reflects an interest in space exploration and astronomy.

New York City Taxi Data Analysis

Analyzed NYC "Green" Taxi data, revealing peak trip times, airport trends, and derived trip speed insights for operational enhancements. Created histograms and visualizations to illustrate trip distance distributions and average trip speeds, aiding in decision-making processes.

Frequent Words in Moby Dick Using Web Scraping

Extracted Herman Melville's "Moby Dick" text from Project Gutenberg via web scraping with Python's requests and BeautifulSoup. Processed the text data through tokenization and stop word removal using nltk, facilitating the identification of the most frequent words in the novel using Counter.

City of Montreal Crime Analysis

Analyzed Montreal's crime data using Python, Geopandas, and Folium, unveiling trends like prevalent crimes, peak activity times, and top police precincts with complaints. Integrated GeoJSON file for geographical mapping, revealing insights visually through an interactive Folium map.

Global Terrorism Data Analysis

The purpose of this project is to analyze historical trends and patterns in global terrorism, identify correlations between attack methods and casualties, and visualize the geographical distribution of terrorist incidents to glean insights that could inform counterterrorism strategies.