Kerry Kolosko

Area between loess

2025 Week 36 | Power BI: Area between timeseries smoothing

Power BI, Workout Wednesday / By

Introduction This weeks challenge is an extension of week 21, whereby we will create a timeseries smoothing over lines rather than scatter points. The challenge here is to emphasize the difference between two populations, whilst having the details visible, but not prominent – getting the opacity/strokedash (for overlapping lines) and colour contrast (for perceptibility) right …

2025 Week 36 | Power BI: Area between timeseries smoothing Read More

2025 Week 21 | Power BI: Scatterplot / Timeseries Smoothing

1 Comment / Power BI, Workout Wednesday / By

Introduction When looking at timeseries data, we may encounter high variability from one week to the next, creating highly jagged and difficult to read charts. There are a number of techniques to smooth the lines to better depict trend. Some may use rolling averages, others, like YouGov, use LOESS regression. https://yougov.co.uk/topics/society/trackers/how-often-brits-exercise In this weeks challenge …

2025 Week 21 | Power BI: Scatterplot / Timeseries Smoothing Read More

Dr Who Story Arc Diagram

2025 Week 11 | Power BI: Can you create a (story) arc diagram with core visuals?

Power BI, Workout Wednesday / By

Introduction Welcome to week 11 of Workout Wednesday 2025. This week’s challenge is to recreate the Dr Who Villain story arc’s visual depicted below showing the timelines of the first and last season of Villain appearances or, to challenge you to create your own data visualisation about Dr Who Villains. Perhaps you will recreate The …

2025 Week 11 | Power BI: Can you create a (story) arc diagram with core visuals? Read More

Embedded charts from Datawrapper and Our World in Data

2025 Week 6 | Power BI: Can you embed charts from Web?

Power BI, Workout Wednesday / By

Introduction Welcome to week 6 of Workout Wednesday 2025. In this week’s challenge we will be exploring other charting options used across the web and how these can be embedded into Power BI Desktop. Using publicly accessible charts and data, we will utilise the HTML content visual to embed interactive charts within iFrames. The examples …

2025 Week 6 | Power BI: Can you embed charts from Web? Read More

bubble likert

2024 Week 46 | Power BI: Likert Bubble

Power BI, Workout Wednesday / By

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 …

2024 Week 46 | Power BI: Likert Bubble Read More

Chart Makeover

2024 Week 43 | Power BI: Line Chart Makeover

Power BI, Workout Wednesday / By

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  …

2024 Week 43 | Power BI: Line Chart Makeover Read More

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

Scroll to Top