Welcome to my personal SQL portfolio repository! Here you'll find a collection of SQL projects and queries I've worked on, showcasing my skills and expertise in database management, data analysis, and data manipulation using SQL.
I am a passionate data enthusiast with a strong background in SQL. Over the years, I have honed my skills in designing and optimizing databases, writing complex queries, and leveraging SQL's powerful features to extract meaningful insights from data. This portfolio serves as a testament to my proficiency in SQL and demonstrates my ability to tackle real-world data challenges. Visit Tushar-Aggarwal.com
In this repository, you will find a variety of SQL projects, including:
-
Sales for Retail and Food Services in U.S.A.: This project aims to analyze and visualize the sales data for Retail and Food Services in the U.S.A. The data is sourced from the U.S. government website and has been processed using SQL to create a database for easy management and analysis. The main focus of this project is to explore the sales data based on NAICS (North American Industry Classification System) code and category.
-
International Debt Analysis: The focus of this project is to delve into the realm of international debt analysis and understand its dynamics in a specific context. By narrowing down the scope, I aim to provide in-depth insights that resonate with the complexities and challenges faced by the selected region/country.
-
Instagram User Analytics: This project revolves around the exploration and analysis of user engagement patterns on the popular social media platform, Instagram. By delving into user data and interaction metrics, this project aims to provide valuable insights into user behavior, content performance, and trends.
-
Pizza Sales Analysis: Pizza Sales Analysis has a comprehensive year's worth of sales data from a fictitious pizza place. The dataset includes detailed information about each order, such as the date and time of purchase, the types of pizzas served, their sizes, quantities, prices.
-
Employee Distribution: This repository contains valuable insights and visualizations derived from an extensive HR dataset spanning from 2000 to 2020, with over 22,000 rows. The data was meticulously cleaned and analyzed using PostgreSQL, and the results are beautifully visualized with Power BI. This comprehensive dashboard aims to answer crucial HR-related questions and shed light on various aspects of the organization's workforce.
-
Operation Analytics and Investigating Metric Spike: The project will cover a wide range of areas, including user engagement, sales performance, marketing effectiveness, and more. You'll be provided with access to datasets containing user information, events data, and email engagement details.
-
Bank Accounts Management System using PostgreSQL : The Bank Accounts Management System is a portfolio project showcasing my skills in designing and developing a real-world application. This project simulates a system that manages bank accounts using PostgreSQL as the backend database. It aims to demonstrate my proficiency in database design, backend development, frontend development, security implementation, and more.
-
Library Management System: The Library Management System is a project aimed at creating an efficient system for managing a library's operations. This system allows users to issue books, search for different books and their titles, and provides detailed information about the books available in the library. By automating these processes, it eliminates the need for manual record-keeping and offers a user-friendly experience.
To explore my SQL portfolio, follow these steps:
-
Navigate to the project links that interests you.
-
Open the README file to get an overview of the project and its components.
-
Review the SQL scripts and any accompanying documentation to gain insights into the project's implementation and results.
If you have any questions, feedback, or collaboration opportunities, please feel free to reach out to me. You can contact me via email at info@tushar-aggarwal.com or connect with me on LinkedIn at Tushar Aggarwal.
Thank you for visiting my Data Analysis Portfolio! I hope you find my projects informative and insightful.
Thank you for visiting my SQL portfolio repository. I hope you find my projects informative and engaging. Happy exploring!