Daniel Yam
Daniel has a master’s degree in Egyptology from the University of Birmingham, and a bachelor’s degree in Ancient History from Macquarie University. He decided to switch career paths to data analysis following encouragement from a friend who had also made a similar career change and discovered his own love and passion for presenting insights in a visually appealing format. Since relocating back to Sydney, he has applied and joined The Data School in order to pursue this new dream.
In his spare time, he enjoys watching his football team lose miserably and painting tiny miniatures for his self-satisfaction.
Using CROSSFILTER and USERELATIONSHIP in PowerBI
DAX is HARD Another Friday, another day of infinite struggle. To say DAX is not beginner friendly would perhaps be a huge understatement, and while there was a public holiday between days of training, it was still just as brutal. Fortunately, in the mass of...
How to Generate Good Data in Mockaroo
For our final week in training at The Data School, we had the opportunity to create our own datasets to answer a question of our own choosing using Mockaroo. This is a fantastic website that can be really tweaked in any way you want, especially in practicing creating...
How to Prepare for a Teaching Session
A few weeks have passed since we were given the opportunity to teach a free session open to the public as part of the Learn What the Data School Learns (LWTDSL) initiative. Predictably, our manager assigned us all topics we were unfamiliar or uncomfortable with as a...
Dashboard Week #5 – Harry Potter
For the final day of Dashboard Week, we were given a light and enjoyable dataset for once, no more depressing data about the state of the world or how crime and inflation are going up. Instead, we were given information on the Harry Potter films. The various sheets...
Dashboard Week #4 – Big Fish, Little Fish
Day 4 of Dashboard Week and its back to Power BI, this time however, the data was actually very clean, and didn’t really require any Alteryx work to get into a workable state. The data was also very open-ended, we were given a choice amongst the 17 Sustainable...
Dashboard Week #3 – Where in the World is the Hamburglar?
Day 3 of Dashboard Week was back in Tableau, but also an exercise in webscraping some data on the crime index of cities around the world. We were also required to get another source of data to further enrich our existing information to create our dashboard. This was...
Dashboard Week #2 – Keno
For the second day of Dashboard Week, we were given data on gambling habits and revenue for a variety of games and forms of wagering. Not knowing really anything about gambling, I just chose Keno since I had some vague idea of how the game worked (if it could even be...
Dashboard Week #1 – Hospitals
Our first task in Dashboard Week was one that also involved the use of APIs, specifically, an API from the Australian Institute of Health and Welfare with a whole variety of information from hospitals all across Australia. The one piece of advice that we were all...
How to Incorporate a Dynamic Measure Select in PowerBI
One of the features across the various visualisation programmes that is exclusive to Tableau are its parameters, and for those of us who predominantly work within Tableau, may find that the sudden lack of parameters a daunting task when creating dashboards and...
DAX for the Lazy Person
I'm incredibly lazy, especially when it comes to things like the complexities of DAX. If I can help it, I won't ever be making extra tables or measures unless it is something that I'll be constantly referring to. That's why I'm extremely glad to have learnt the...