2023 Week 11 | Power BI: Determining trend with LINEST
Determining trend for use in smart narratives with DAX LINEST and Power BI
2023 Week 11 | Power BI: Determining trend with LINEST Read More »
2023 Week 07 | Power BI: Non-linear Regression
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
2023 Week 07 | Power BI: Non-linear Regression Read More »
2023 Week 03 | Power BI: 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 03 | Power BI: Vertical Area Chart Read More »
2022 Week 52 | Power BI: 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 | Power BI: Image Carousel Read More »
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 »