Creating Ready To use SQL or Access DATABASE
You will be creating complete ready to use database schema that can count a lot of the same products names from various CSV files with same format and sum all together into a number that shows in the table the data base should be able to separate shop name and Date of sale item so we can see when it sold and which item was the best selling.
Mainly To calculate the best selling Item for each store and from all of the other store from various CSV files that have the same format.
The database should be ready to use with PowerBi for analyze presentation.
You should be able to work with Database such as SQL, Access to create the complete ready to use database schema.