Data Analysis Skills
Creating databases using DML, DDL, and DCL is only a part of what I'm capable of. I can also make queries to retrieve data from tables. I'll demonstrate my analytical skills using my project's database as an example.
Window Functions
For my project, I generated several orders that were placed on different dates. As shown below, I use a query that tells me the number of products sold during business hours.
Common Table Expression
In this example, I want to show how many quantities are available for sale. During the process of an order, they will be marked as part of the inventory, but not available for picking. As shown below, you can see that I have 125 qty in the warehouse, but 11 are not reserved for an order. This is necessary to know so we don't oversell products and go beyond the amount available in the inventory.
Subqueries
Throughout my project, I had to figure out a way to determine if an order is ready to be processed. I don't want to process any order unless all the parts for that order are staged. The query below shows me the order id along with the locations of their parts that are ready to be processed.
Pivot Tables
I've used pivot tables numerous of times in my project to show me the locations of certain products. In this case, I want to know the location of my braking pads. I've labeled my breaking pads with an id 1-10. As shown below, you can see how many of these parts are located on shelf A101-A110.
