Kerry Kolosko

Vertical Area Chart describing Republican and Democrat shifts in ideology

2023 Week 3 | Vertical Area Chart

Introduction Howdy All! We’re all topsy-turvey this week turning line charts on their side! ⇩ This weeks challenge was inspired by Nick Desbarats article Are Vertical Line Charts Ever a Good Idea? Can you find some other examples where vertical line charts may be a good idea? ⋟^◕ܫ◕^⋞ Happy Vizzing Requirements Power Query Obtain the voteview_polarization_data.csv …

2023 Week 3 | Vertical Area Chart Read More

Power BI page featuring an image carousel

2022 Week 52 | Image Carousel

Introduction “Hot days, warm nights, beaches, backyard cricket and Christmas celebrations are all part of summer in the Southern Hemisphere.” This week we will be connecting to a public flickr photo gallery from the State Library of South Australia, to create an image carousel using a custom visual from AppSource. Requirements Power Query Connect to the …

2022 Week 52 | Image Carousel Read More

How Brits met their partners

2022 Week 45 | Power BI: Ribbon Chart (Advanced)

Introduction Another Deneb visual this week – creating a custom Ribbon Chart.   This ribbon chart takes on a slightly different form than the ribbon charts you may be used to. This ribbon chart is focused on highlighting the change in rank and proportion of response types between the first and last dates of a …

2022 Week 45 | Power BI: Ribbon Chart (Advanced) Read More

2022 Week 36 | Power BI: Split Violin Plot and HTML

Introduction Another PlotlyJS visual this week – creating a split violin plot. We’ll be comparing male and female dating preferences collected from speed dating events between 2002-2004. EXTRA CREDIT – For those with a little more time on their hands, an extended workout challenge is included; conduct your own data analysis and create a data …

2022 Week 36 | Power BI: Split Violin Plot and HTML Read More

2022 Week 31 | Power BI: Connected Scatter with PlotlyJS

Introduction This week for Workout Wednesday we are getting familiar with the PlotlyJS visual by creating traces and annotations for a connected scatterplot.   Connected scatterplots are a cross between a scatterplot and a lineplot whereby two numeric variables are connected by a third ordered variable (often time).   The below graph created with the …

2022 Week 31 | Power BI: Connected Scatter with PlotlyJS Read More

2022 Week 26 | Power BI: Polar Plots with Charticulator

Introduction June is Music Month and this week we are getting arty with Charticulator. In our previous Charticulator challenges, we designed with cartesian plots, spiral plots and tried our hand at nested charts. For this challenge we use a Polar Scaffold to visualise songs segments by time/duration.   This challenge presumes some Power Query experience. …

2022 Week 26 | Power BI: Polar Plots with Charticulator Read More

2022 Week 20 | Power BI: Pie Matrix Tableau Redo

Introduction May is Tableau Redo month and this week we will be recreating Tableau #WoW2019 Week 45 by Luke Stanke.   Requirements Filter the data up until November 6th, 2021. Create a matrix showing region and last 7 days (up to November 6th, 2021). Create SVG Measures to build a doughnut chart that shows the …

2022 Week 20 | Power BI: Pie Matrix Tableau Redo Read More

2022 Week 14 | Power BI: Create an achromatic report

Introduction April is colour month for Power BI Workout Wednesday 2022. First up we are going to try our hand at creating reports WITHOUT hue. Using a file from a previous challenge, can you create an achromatic report that uses contrast and lightness effectively? There will be some creative freedom involved in this challenge, no …

2022 Week 14 | Power BI: Create an achromatic report Read More

2022 Week 08 | Power BI: Can you make a Gantt Chart?

Introduction This week we are creating Gantt Charts in Power BI. It is not required to do all 4 variations, choose one of the options that interests you the most. Each option increases in time and/or experience level. Requirements QUICK MODE Import data Import the Microsoft Gantt Chart from AppSource Place Project Category in the …

2022 Week 08 | Power BI: Can you make a Gantt Chart? Read More

Week 05 2022 Challenge

2022 Week 05 | Power BI: Can you make a Nested Chart with Charticulator?

Introduction This week we are familiarising ourselves with Charticulator and Nested Charts. This graph was inspired by Gus Wezerek and Sara Chodosh’s chart for NYT Opinion. Requirements Download the data and remove all columns excepting the Date field, New Cases Smoothed Field and Location (save as csv) Create a second csv with only Location = …

2022 Week 05 | Power BI: Can you make a Nested Chart with Charticulator? Read More

Scroll to Top