Introduction This week we are continuing our viz efforts inspired by the 1 dataset 100 visualizations project, presented by the Data Viz Project. Last week, Meagan challenged us to create as many visuals as possible using the Deneb custom visual available in Power BI AppSource. The week before, Shannon challenged us to make as many visuals as …
2023 Week 25 | Power BI: Bubble Chart Variants with Charticulator Read More
Introduction This week’s challenge uses Deneb custom visual to create a jittered scatter with inverted axis plus a bubble plot with labels. Requirements Power Query Obtain the dataset from Australian Bureau of Meteorology Website Model and load data Power BI Desktop Option 1: Obtain Deneb Custom Visual from AppSource Create a Scatter Chart with point …
2023 Week 22 | Power BI: Inverted Jittered Scatter Read More
Introduction This week’s challenge is a little SVG fun. Recent Power BI Desktop changes have allowed even further width and height adjustments for images in matrix visuals. So we will be extending this by making a bar chart of chocolate bars. Requirements Power Query Obtain the dataset from 2023-week-11 challenge or; Obtain the dataset from …
Introduction This week’s challenge is inspired by recent Twitter activities. We are creating a word cloud containing common misspellings in the US. Requirements Power Query Obtain the dataset from https://www.dailymail.co.uk/femail/article-11357183/Google-search-data-reveals-commonly-misspelled-words-spell-correctly.html OR https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings Transform and load data HINT : Add Index column, create modulo column, unpivot data Power BI Desktop Obtain Word Cloud custom visual from …
Determining trend for use in smart narratives with DAX LINEST and Power BI
Introduction This week for Workout Wednesday we will be trying our hand at non-linear regression with the Deneb custom visual. With Vega and Vega-Lite we can create a non-linear line of best fit over our data points and utilise the statistical API to return a correlation coefficient. Requirements Power Query Obtain the dataset from the …
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 …
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 …
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 …
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
