During the discussion of Data Wrangling with SQL, the subject of selecting data from multiple tables was introduced. This subject connects to the blog of last week, in regard to my job. Being able to import data from tables, i.e. multiple suppliers, would be extremely beneficial, since I can have data tables for each of my supplier. Using SQL, I can make monthly report and create tables by defect across all suppliers. I find that the FULL join could be an excellent way of combining tables, while also understanding the outliers between all. I will be looking forward to seeing how increasing my level of my skills over the semester.
Another subject that caught my attention was PROC RANK, mainly due to the college football reference. This can also be used when scoring and ranking suppliers based on their defect ratings, defect type, and frequency of defects. This would have been very useful in the past simply because it could have been used to make an internal score sheet rather than having to use the corporate score sheet supplied by our corporate team.
I understand that coding is a learned skill and it takes time to learn. I will say that with life going on, I have started to get slightly discouraged and wondering if this degree is sacrifice that I need/want to make. This week’s session somewhat lit a fire of interest in me again, so I hope that my interest continues to build.
Gregory's Look Into Analytics 