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 »
Power BI, Workout Wednesday
Introduction Welcome to WoW Week 7! Have you ever needed to show different or conditional information on a dashboard… that is not actually a part of the page being viewed?? Or maybe you want to make changes to a dashboard but not yet ready to render them to a user?? Need to optimize dashboard efficiency
2023 Week 07 | Hidden Pages Read More »
CRM Analytics, Workout Wednesday
NPS Survey data can be tricky to wrangle and work with. Check out this week’s Tableau #WorkoutWednesday and see if you can do it!
#WOW2023 Week 7: Can you create a Jittered Bar Chart? Read More »
Tableau, Workout Wednesday
Introduction This week we have a lot going on! I originally found a hack about 2 years ago how to create a timeline stacked bar chart. I don’t know if I just didn’t find the easy way to do it or if they released a new feature since then. Anyway, this is what we’ll do
2023 Week 06 | Timeline Stacked Bars Read More »
CRM Analytics
Introduction As Donna mentioned last week, this month we’re focusing on alternative chart types. This jitterplot is a fun one inspired by one of Steve Wexler‘s charts in The Big Book of Dashboards. I like jitterplots because they allow you to easily see how an individual compares to the rest of the group via distribution,
#WOW2023 | Week 6 | Can you create a normalized jitterplot? Read More »
Tableau, Workout Wednesday
Introduction For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered. Requirements Create a calendar visual: Show day of the week on rows and week on columns. (Hint: If you get stuck on
2023 Week 06 | Power BI: Create a Calendar Heatmap Read More »
Power BI
Introduction Using a moving average is a great technique to smooth out fluctuations in data points and help us see the overall trend of a particular metric. We could create a visualization that fixes the moving average to a particular number of months, but we could bring greater value to the user by allowing them
2023 Week 05 | Dynamic Moving Average Read More »
CRM Analytics
Introduction Hi everybody. It’s now my turn to set my first challenge as part of the official #WOW crew – eeek!. For those of you who don’t know me, I’ve been completing these challenges since the program was launched in 2017, and I blog solution guides on my personal blog at https://donnacoles.home.blog/. I’ve been approached
#WOW2023 | Week 5 | Can you build a funnel chart? Read More »
Tableau, Workout Wednesday
Introduction Hello and welcome back to Workout Wednesday! If you’re joining us for the first time, be sure to check out our complete list of challenges. This week we’re looking at data from the American Academy Awards, also known as the Oscars. The Oscars are awards for artistic and technical merit for the American film industry
2023 Week 05 | Power BI: Visualize the Oscars with an Isotype/Pictogram Chart Read More »
Power BI
NPS Survey data can be tricky to wrangle and work with. Check out this week’s Tableau #WorkoutWednesday and see if you can do it!
#WOW2023 | Week 4: Can you visualize survey data? Read More »
Tableau, Workout Wednesday