Hi again,
My recent project a trend of sales between 2020 and 2022, with Structured Query Language SQL.
DATA SOURCE
https://drive.google.com/file/d/1E2epDmqbmC63glQZD27iirE0nobLPaz6/view?usp=drivesdk
The datasets consist of 9 different tables, which are:
Customers Table
Sales 2020 Table
Sales 2021 Table
Sales 2022 Table
Product Table
Product Category Table
Product SubCategory Table
ReturnData Table and
Territory Table
DATA WRANGLING
For the Sales Tables (2020-2022), I structured the tables with the UNION ALL operator [( it allows duplicates and merges everything from the tables, unlike the UNION operator that removes the duplicates and merges the distinct values on the tables )] to combine the three Tables, for easier access and less queries, named it “SALESDATA”.
Rather than using the JOIN statements to merge all the tables together, using their PrImary keys as the relationships between the tables for lesser queries and create a new table, I used the JOIN Statements to form a relationship from their respective Tables, using their Primary Keys for Each Business requirement.
Attached is the google drive link to the Project Presentation.
https://drive.google.com/file/d/1Mr097BLg2FO0EqBeDmLWF1g_YMtaj18-/view?usp=gmail
Ciao! Bye for now.👋