Dnsvault overview data analytic
Part of data scientist skill sets are: 1. Programming 2. SQL / Database programming and database administration 3. Data Visualization 4. Unstructured data manipulation ref: https://www.kdnuggets.com/2018/05/simplilearn-9-must-have-skills-data-scientist.html https://blog.udacity.com/2014/11/data-science-job-skills.html dibawah adalah group ranked data. saya menggunakan window query untuk dapatkan top rank every category. ref: https://medium.com/@amulya349/how-to-select-top-n-rows-from-each-category-in-postgresql-39e3cfebb020 https://www.postgresqltutorial.com/postgresql-window-function/