This repository showcases my SQL projects. Feel free to explore and reach out with any questions. Also, check out my Tableau portfolio.
| Project Name | Description | Source Code |
|---|---|---|
| Metropolitan Museum of Art and MoMA Collection Analysis | This project showcases a series of SQL queries designed to analyze and cross-reference art collection data from two prominent museum databases: MoMA (Museum of Modern Art) and the Metropolitan Museum of Art. It includes operations such as extracting unique tags from artworks, aggregating artworks by these tags, and joining artist information across both collections based on ULAN (Union List of Artist Names) IDs. | View |
| Fortune 500 Company Stats 2023 | This project provides a detailed analysis of the Fortune 500 companies for 2023, focusing on the distribution of female leadership across sectors, the market value of New York-based companies by industry, and identifying rapidly growing newcomers with fewer than 5,000 employees. | View |
| Product Sales and Trends | This SQL project is tailored for analyzing the consumer electronics retail sector, focusing on sales data to uncover product performance, customer buying patterns, and effective pricing strategies. Through detailed queries, it explores monthly sales, identifies key insights into consumer preferences, and evaluates the impact of sales strategies. | View |
| Netflix Content Analysis | This SQL project offers a deep dive into Netflix's content library, showcasing technical prowess in database management and insightful analysis through SQL queries. It highlights the latest content trends, the diversity of Netflix's offerings, and the key figures behind these titles. By exploring the catalog's structure and extracting meaningful insights, such as content distribution and historical content evolution, this project serves as a concise yet comprehensive examination of Netflix's dynamic streaming landscape. | View |
| Superstore | This project conducts a comprehensive analysis of a Superstore's inventory through SQL, focusing on the cataloging of products, pricing strategies, and sales performance across different categories. It aims to optimize inventory management, identify high-value product segments, and enhance the store's overall financial performance by utilizing targeted queries for sorting, aggregating, and examining product data based on pricing, stock levels, and category insights. | View |
| Furniture Store Sales Analysis | A comprehensive SQL analysis of an online furniture store's sales data, revealing key insights into product popularity, pricing strategies, and customer behavior. This project uncovers trends in sales prices, top-selling products by country, and sales distribution over time, offering valuable insights for optimizing sales strategies and improving customer engagement | View |