Introduction
When used with care, scatterplots can be used to create symbol maps using an equidistant projected map (or Geographic or Plate Carrée) as the plot background image. Attention will need to be paid to proportions and axis scales.
More information on projection types. https://en.wikipedia.org/wiki/List_of_map_projections
Requirements
- Obtain the snowfall data from github
- Create new columns to bin the latitude and longitude data TIP: One way of doing this would be using the CEILING function to round to the nearest 5 intervals (note the symbols cannot be offset)
- Add a Scatterplot to the visual canvas
- Find an equidistant world map projection to utilise as the plot background, make sure this image is evenly cropped and fits the entire plot area.
- Set the axes to be -90, 90 and -180, 180
- Ensure the X axis is half the size of the Y axis
- Add the binned data to the scatterplot
- Conditionally format the symbols as a gradient based on the average snowfall amount
- Add filters or play axis for snowfall by month
Dataset
This weeks dataset is available via Github
Share
After you finish your workout, share on Twitter using the hashtags #WOW2024 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.