by The Data School | Feb 19, 2024 | The Data School
If you studied system design and analysis during your tertiary degree, chances are high that you came across Unified Modelling Language (UML). So you might feel slightly surprised to see the Entity-Relationship Diagram (ERD) and wonder why they are calling it ERD...
by Andrew Banh | Mar 20, 2019 | Uncategorized
Last dashboard of dashboard week! Today we are looking at Motor Vehicle Census data from the Australian Bureau of Statistics. When I think of ABS data, vehicle census data has never crossed my mind but I am glad that we are exposed to this today. Firstly, with the...
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...
