This project's aim was to showcase the use of SQL in the process of Data Cleaning, Data Preprocessing and Data Analysis.
Additionally, this data was connected to Microsoft Excel and used to make visualisations on PowerBI and Tableau.
The pursuit of this project showcased my ability to:
- Create databases and, read, update and delete records and tables
- Select, group, order and join data from multiple files
- Use aggregate functions on columns
- Rename columns
- Use Common Table Expressions
- Use Views
- Create Visualisations using Tableau