Introduction We’re going to try something a little different this week. We’re going to make a viz/dashboard without a dataset. Having just come from my daughter’s Christmas show this evening, and thinking I wanted to focus on container/dashboard formatting but keep it simple, I decided to build, then decorate a Christmas tree. So, that’s what …
Introduction The challenge for this week is to first build a scatter plot of fertility vs life expectancy of different countries. However, this will not just be for a single year, but will contain information across many years, making it possible to slide the year and see how all the bubbles move. The key challenge …
2024 Week 27 | Power BI: Scatter plot showing the path of selected data points Read More
Introduction Another month another week and we are already in the second quarter of the year! Let’s start this quarter strong and use timeseries in dashboards. This week is based on similar dataset as the week 4 and 9 but has been organized by energy types as a column! The challenge is to create a …
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 …
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
Introduction The Christmas Season is upon us and with that we bring you one last collab for the year – the Preppin’ Data team is back with a festive challenge for you all. The goal of that challenge is to get the data Tableau-ready. You will produce two outputs which are both used in this …
Introduction This is week 28 of 2023 and week 2 of #RE-VIZ-IT and I’m bringing back my VERY FIRST #WOW challenge from WAY BACK in the summer of 2018! I chose this challenge because “back in my day” this use case required additional sheets, a “custom” chart and a lot of sheet swapping. If you …
Introduction Conditional formatting is a robust feature in Power BI that you can leverage to help users gain insights. Typically, we see conditional formatting applied to the table and matrix visuals. For example, you might apply a background color, font color, or icons to the values based on a set of rules. Conditional formatting of …
#WOW2022 W43: Advanced Formatting by Jeremy Anderson Read More
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
Introduction This week’s challenge is brought to you by a guest coach, my colleague Valerija Kirjackaja, who came across this problem at work and created a beautiful solution for it. How often do you get asked to re-create Excel tables in Tableau? On a scale from 1 to ‘I am never doing this again’ – …
#WOW2022 | Week 35 | Conditional Table Formatting with Dynamic Headers Read More
