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
Introduction Who doesn’t love a good KPI dashbaord? This one is fairly simple and straightforward. Let’s look at four simple metrics and see how each subcategory ranks within a selected metric. With this challenge – MIND THE NUMBER FORMATTING 🙂 Click to open in Tableau Public Requirements Dashboard Size: 700 x 350 2 sheets Display …
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
