Dashboard Week – Day 5

Dashboard Week – Day 5

Day 5 topic, ‘Basix Certificate in NSW’: This challenge is very hard, not because the data need a lot of wrangling, but because we only have a limited time to build this, unlike other challenges we have a whole day to work on. Data wrangling The data is...
Dashboard Week – Day 4

Dashboard Week – Day 4

Day 4 topic, ‘University Ranking – Web Scrapping’: This challenge is very, well, challenging. Because it has involved using web-scrapping and using regex to parse the context into readable format. One of the hard parts is to isolate the context from...
Dashboard Week – Day 3

Dashboard Week – Day 3

Day 3 topic, ‘CoinPaprika API’: So today challenge is quite different from others. It is mainly because we have to retrieve all the data from a public API. Alteryx makes it a breeze to download parse in JSON format. So the challenging part is how to get...
Dashboard Week – Day 2

Dashboard Week – Day 2

Day 2 topic, ‘World Bank FMIS Projects Database’: So this dataset is used to keep track of all the projects funded by the World Bank. This dataset is in an excel file. The layout is nicely formatted for human consumption with a few tables within a sheet,...