by Andrew Banh | Mar 18, 2019 | Uncategorized
2nd last day of dashboard week! Our task was to use Eventful’s API to webscrape events from their website. The brief was quite open ended. Just use the API and make something. So, something I made! The difficulty begins with the data we actually extracted from the...
by Andrew Banh | Mar 14, 2019 | Uncategorized
Today we delved in to the Global Terrorism Database. The data set was very rich in terms of the details of each attack down to the predominant weapons used. I did parse it through Alteryx quickly though, because the eventID field had the date embedded in it. Also, the...
by Andrew Banh | Mar 7, 2019 | Uncategorized
Disclaimer: This is going to be one of those dates where the other person just constantly talks about work, because I will be going through some date formulas and how to create parameters to filter out different date views. The formulas we will be using include...
by Andrew Banh | Feb 25, 2019 | Uncategorized
This blog post is a deeper dive of star schemas. Please go to this link to check that out first (https://www.thedataschool.com.au/andrew-banh/the-allure-of-star-schemas/). Facts and dimensions tables form the basis of any business’ data strategy. It is from the data...
by Andrew Banh | Feb 25, 2019 | Uncategorized
A Star Schema is one of the simplest data warehouse schema where data is manipulated into facts and dimensions. This blog post will be an overview of what the star schema and a deeper dive into facts and dimensions will follow. So, what exactly is a star schema? The...
by Andrew Banh | Feb 1, 2019 | Uncategorized
A Decision Tree is a powerful machine learning model which has the added bonus of being easy to understand, as it can be used to visually understand the model. Luckily, last week we had our 2nd taste of Predictive Analytics where we looked at Decision Trees. A...
