Kerry Kolosko

2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve

Power BI, Workout Wednesday / By

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 »

2024 Week 22 | Power BI: Approximate Binned Mapping with Scatterplots

Power BI, Workout Wednesday / By

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 »

Radial Plots

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions

Power BI, Workout Wednesday / By

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 »

Star Trek timeline data plotted on a sine wave

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals

Power BI, Workout Wednesday / By

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 »

Overlapping Histogram

2024 Week 13 | Power BI: Overlapping Histogram

Power BI, Workout Wednesday / By

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 …

2024 Week 13 | Power BI: Overlapping Histogram Read More »

2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals

Power BI, Workout Wednesday / By

Introduction This week’s challenge we will be utilising visual calculations (this will require turning Visual Calculations on in Preview settings of February 2024 Desktop) and some additional new data label formatting options to create a pipeline funnel with out of the box visuals in Power BI. Visual calculations can be handy for visual specifiic calculations …

2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals Read More »

DataViz Makeover of bar chart

2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia

Power BI, Workout Wednesday / By

Introduction This week’s challenge is a little different, we will be looking to make-over a report from the Australian Bureau of Statistics. This report contains a lot of information and data sources to download, so it is up to you as to how much or how little you want to do. The primary challenge, however, …

2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia Read More »