Year: 2024

2024 Week 49 | Power BI: Visualize Ranges with Percentiles

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

#WOW2024 W49: Can you create a scatter plot investigation?

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

2024 Week 48 | Power BI: Use a Calendar as a Filter

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

#WOW2024 | 48 | Can you make a Candle Line Chart?

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

2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes?

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

Animated button

2024 Week 47 | Power BI: HTML & CSS

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, …

2024 Week 47 | Power BI: HTML & CSS Read More

#WOW2024 | Week 47 | Top 5 Product Sales vs Other Products

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

2024 Week 45 | Sigma: Can you create these patient demographic visuals? 

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

Scroll to Top