Introduction Utilising the dataset from a previous challenge (week 43), this week we are going to build a bubble likert chart. Likerts are usually ordered categorical data, and often it does not make sense to convert categories to a numerical score to find averages. Sometimes, likerts can be treated as interval data. https://www.scribbr.com/methodology/likert-scale/. For the …
Introduction This week’s challenge is to test your data storytelling skills and enhance a line chart of service desk survey responses to focus attention on important aspects. No solution file provided this week. Requirements Obtain the data Model Data Create a chart showing survey response trends Dataset This week’s dataset is downloadable from Github https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Help%20Desk.xlsx …
Introduction Ternary plots are a unique plot that is typically used to look at the mineral composition of rocks. However these plots have been adapted in data journalism for looking at voting intention in varying demographics. Each point on the plot comprises a percentage of each dimension e.g of the 65+ age demographic, 16% of …
Introduction Overlapping histograms with normal curve overlays are used to compare the distribution of a numerical variable across different groups such as male and female body mass. With this we can glance the central tendency, spread, and skewness of the data within each group and also how well the data follows a normal distribution. The …
2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve Read More
Introduction This week’s challenge was inspired by an XKCD comic and Kamala Harris’ love of Venn diagrams. Leveraging a prior challenge by Phil Seamark, this challenge we are going to apply SVG filters to make the shapes appear hand drawn XKCD style, and import XKCD font via the HTML content visual. XKCD font can be …
Introduction This week’s challenge looks to create a time brush slicer. The time brush slicer can be created with Deneb or another custom visual. Requirements Obtain the data from a previous challenge Model data Option A Import Timbrush Slicer and Small Multiple Custom Visual Create a time brush slicer Create a line chart with small …
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 …
2024 Week 22 | Power BI: Approximate Binned Mapping with Scatterplots Read More
Introduction In this week’s challenge, we are experimenting with Radial Plots using Line and Scatter Core Visuals. Radial Lollipop charts are an alternative to radar charts. Power BI does not have Polar Plots, only cartesian plots, so we will need to use trigonomic functions within DAX to calculate the cartesian X and Y position of points. Requirements …
2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions Read More
Introduction In this week’s challenge, we are creating a timeline visual on a sine wave. You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions. Alternatively, with small multiples. Requirements Obtain the data from Kaggle and/or Wikipedia Create a …
2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals Read More
Introduction In this week’s challenge we are creating an Overlay Histogram. An overlay histogram utilises overlapping columns or bars to compare two populations. In this case, we are utilising the speed dating data from a previous challenge to compare male and female differences in dating preferences. Requirements Obtain the data from the Workout Wednesday 2022 …
