Introduction A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it’s inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look …
2024 Week 49 | Power BI: Visualize Ranges with Percentiles Read More »
Introduction This weeks challenges come from a fellow Data School Coach, Robbin Vernooij. He created this back in 2019, but I thought it was a pretty cool dashboard and gets you to think about Sets in a good way! Click to open in Tableau Public Requirements Dashboard Size 1000×800 Connect the data together You can …
#WOW2024 W49: Can you create a scatter plot investigation? Read More »
Introduction Welcome back to Workout Wednesday! I’ve been getting so much of my inspiration from the community lately, and this week’s challenge is no exception! Recently, Andy Kriebel posted a cool calendar filter on LinkedIn, that he built using Tableau. Our very own guest contributor and friend Erik Svensen took Andy’s post and re-created it …
2024 Week 48 | Power BI: Use a Calendar as a Filter Read More »
Introduction Hey there #DataFam! Welcome to week 48 of 2024…that’s wild when you think about it. That means that we have 47 other challenges already this year. So what are doing this week? We’re gonna play different mark types on dual axis. This week’s challenge is something I’m calling a “candle line” chart. Check it …
#WOW2024 | 48 | Can you make a Candle Line Chart? Read More »
Introduction Welcome to Week Forty-Eight! This week, I am heavily focused on my Thanksgiving preparations, so naturally, we will be taking our Workout Wednesday to the kitchen. I asked Chat GPT to generate us a dataset involving popular Thanksgiving dishes by state. We’re going to use that to utilize some newer features, like a conditional …
2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes? Read More »
Introduction I felt like I was seeing more news about food recalls lately, and I did the thing any good data-minded individual would do: pulled down data from the FDA to see if what I’m feeling is backed up by data. When I pulled the data down from, I realized there was still a lot …
Introduction This week’s visualization is inspired by the concept of rules – understanding them and knowing how to bend them (but never break them!) At a high level, Power BI visualizations are rendered using a combination of JavaScript, HTML, and CSS in a web browser. By learning the foundational aspects of various data visualization tools, …
Introduction This week’s challenge was inspired by a suggestion that I made to a colleague when he faced the problem of having a small space to work with, but wanting to give the end user the ability to drill-down a bit deeper. His idea was to only show the Top 5 within a selected Sub-Category. …
#WOW2024 | Week 47 | Top 5 Product Sales vs Other Products Read More »
Introduction Welcome to Week 46! This week we pretend to be a streaming service, trying to see which of our 3 new shows are doing well with the viewer base. Funnel charts will be our main focus here, but feel free to play around with the sample data to find other key insights! The formatting …
2024 Week 46 | Sigma: Can you create a Funnel Chart? Read More »
Introduction Hey everyone! This week’s Workout Wednesday focuses on creating clear, actionable patient demographic visuals using a Sankey, a KPI, and two bar charts—binned and unbinned. Here’s the setup: the Sankey chart helps us map distribution, while the KPI delivers an at-a-glance view of a key metric to ground the analysis. With the bar charts, …
2024 Week 45 | Sigma: Can you create these patient demographic visuals? Read More »
