Context :
Having completed two comprehensive courses on SQL, It is time to apply their newly acquired knowledge in a real-world context. Through the use of SQL queries and data cleaning techniques, the project aims to extract actionable insights from a messy and disorganised dataset.
Project overview and objective :
The primary objective of this project is to utilise SQL statements and techniques to clean and prepare a raw dataset for further analysis or visualisation.
By carefully selecting and executing appropriate SQL statements, the project aims to address inconsistencies, redundancies, and inaccuracies in the dataset and transform it into a more structured and organised format.
While the project does not include further analysis or visualisations, the cleaned dataset can serve as a valuable resource for future investigations and inform data-driven decision-making in a variety of domains.
Tools used :
PostgreSQL
Jupyter Notebook