While practicing my SQL skills, I completed these projects that showcased advanced SQL functions and formulas for exploratory data analysis. These projects involved complex queries and aggregation techniques to derive meaningful insights from raw data. I also learned how to optimize queries for better performance and gained experience with different SQL databases like MySQL, SQL Server, and PostgreSQL.
-
Olympic Games: The primary goal of this project was to utilize SQL queries to extract and analyze pertinent information from the comprehensive Olympic Games data set. This task involved understanding the data set, identifying relevant information, and then implementing SQL queries to fetch this information effectively. This process enabled me to gain valuable insights into various aspects of the Olympic Games, contributing to a deeper understanding of this global sporting event. To view script, click here
-
Danny's Dinner: The goal of the project was to use SQL to answer questions that will help Danny get deeper insights about is customers visiting patterns, how much money they’ve spent and also which menu items are their favourite. Having this deeper connection with his customers will help him deliver a better and more personalised experience for his loyal customers. To view script, click here
-
Sales Analysis: The goal of the sales analysis is to understand the performance of different products and identify trends that can inform future business strategies. By analyzing sales data, areas that need improvements and opportunities for growth are identified. To view script, click here