Sham Prasher
Sham studied Information Technology at the University of Queensland. After working in Business Intelligence for a few years, he spent some time creating treasure hunts for corporate team building events, working in event management, and creating mobile games/apps.
Sham enjoys creative pursuits like game development, writing poetry, graphic design, and data visualisation, which lead him to The Data School as a pathway back to the analytics industry.
Stay In School, Kids.
Today, I looked at US Jail data and the correlation between number of people jailed with various education levels achieved in the population. Looking at the final dashboard, there are some interesting trends. First, Nevada and Arizona are the worst offenders in terms...
Creating a Diagnostic Dashboard for Starlink Satellite Internet Coverage
Click below to check out the VLOG: https://www.loom.com/share/69c12e8036c54b77be5ecf58311b51d4?sid=cef8fded-1af9-45b3-b453-d8cc27bbae46
Star Trek – Was TNG Really Better than DS9?
Star Trek fans endlessly debate questions like this (partly because they don’t realise Star Wars is far better). So, I wanted to take a closer look at the facts. Step 1 – The Data We begin with a dataset containing information on Star Trek episodes. The data contains...
Designing a CPU + GPU recommendation tool
So my boss mentioned that he wants to set up a new media server and needs me to recommend the best CPU and GPU chips/cards to buy. So what do I do? I look at the data. The data provides ‘some’ information on CPU and GPU chipsets as follow: There are some notable...
Crime in LA – Looking at Child Kidnappings Around Schools
Crime in LA – Looking at Child Kidnappings Around Schools What kind of crimes target children within 500 meters of schools in settings outside of the home? To look at this question, I began by augmenting the data. Step 1 – Augmenting the data The data set contains...
Direct and Indirect Flight Paths: Using Sets to Identify Transitive Relationships
Flight path data is typically presented as a table with some columns giving the details of the flight’s origin and other columns describing the flight’s destination. One record represents a single flight leg between two locations/airports, so it has an origin and...
Using FIXED LODs to Enhance a COVID-19 Map
A quick and easy way to use Tableau maps is to colour countries by some measure and view the difference between countries by gradations of that colour. Take a look at the map below showing the highest confirmed cases to data as of a given week starting 12 Apr 2021:...
Finding Nearby Spatial Objects in Tableau
"Find which hotels have pubs within 500 meters." "Find which houses, priced under $750,000, are less than 2km away from a school." "Where were crimes committed closeby to other, similar crimes in the same neightbourhood?? (I would very much like to avoid living around...
Butterfly Charts – Making them Easier to Read
A butterfly chart is generally used to compare two datasets at a time over some dimension. Recently, I used a butterfly chart in an online challenge and, while it looked nice, I noticed that it was quite difficult to read. Below, we have population figures for age...
Set Actions for Dashboard Investigation
In Tableau, sets are a great way to create a segment of a dimension’s data. For instance, suppose we have sales data with a dimension for the product categories and subcategories. A recent survey of our store reveals which products are particularly popular with...