February 2023 – Workout Wednesday

2023 Week 09 | Power BI: Create a table with custom and built-in microcharts

1 Comment / Power BI / By Meagan Longoria

Introduction This week we are making a table with microcharts (sparklines). Power BI does offer built-in sparklines, but sometimes we want formatting options not available with the defaults. Our challenge this week uses both the built-in sparklines and custom SVG images in a table. Requirements Create a custom column with the following logic: If the …

2023 Week 09 | Power BI: Create a table with custom and built-in microcharts Read More »

2023 Week 09 | Mobile KPI Scorecard

CRM Analytics, Workout Wednesday / By Jack Parry

Introduction Not everyone wants to consume analytics through their desktop these days. We live in a busy world where people are often on the go, so we’re focussing on a mobile dashboard this week. The goal is to create a simple view that can be quickly glanced at to see our KPIs vs. last year’s …

2023 Week 09 | Mobile KPI Scorecard Read More »

#WOW2023 | Week 9 | A tricky filter

1 Comment / community, Tableau, Workout Wednesday / By Erica Hughes

Introduction This week’s challenge was inspired by a question from a client. In truth, I was not able to solve the problem for them upfront. This challenge would not exist were it not for an article in the Tableau Community that explains how to achieve the desired outcome – thanks to whoever wrote this up! …

#WOW2023 | Week 9 | A tricky filter Read More »

2023 Week 08 | Power BI: Create an interactive resume

2 Comments / Power BI, Workout Wednesday / By Shannon Lindsay

Introduction Welcome back to Workout Wednesday! This week we will use Power BI to build an interactive resume. This challenge is for a few different audiences. 1) Job seekers – feel free to use this template, plug in your information, make design tweaks, and post this to your portfolio! 2) Data vizzers – use the starter …

2023 Week 08 | Power BI: Create an interactive resume Read More »

2023 Week 8: Can you build a comet chart as an alternative to a side-by-side bar chart?

Tableau, Workout Wednesday / By Luke Stanke

Introduction The theme for February 2023 has been alternatives. This week I present an alternative (and trust me, there are many other alternatives) to my least favorite chart: the side-by-side bar chart. The reason this chart is so difficult for me is because it takes up a lot of space and when I am doing …

2023 Week 8: Can you build a comet chart as an alternative to a side-by-side bar chart? Read More »

2023 Week 08 | Hidden Pages Extended

1 Comment / CRM Analytics, Workout Wednesday / By Lauren Mills

Introduction Welcome to WoW week 8! Last week we looked at hidden/unused pages in within your dashboards. The exercise last week was to get familiar with how to create and navigate between hidden pages. This week we will attempt different variations of uses cases of this functionality. Requirements Edit the dashboard from week 07 or …

2023 Week 08 | Hidden Pages Extended Read More »

2023 Week 07 | Power BI: Non-linear Regression

2 Comments / Power BI, Workout Wednesday / By Kerry Kolosko

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 »

2023 Week 07 | Hidden Pages

1 Comment / CRM Analytics, Workout Wednesday / By Lauren Mills

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 »

#WOW2023 Week 7: Can you create a Jittered Bar Chart?

Tableau, Workout Wednesday / By Lorna Brown

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!

2023 Week 06 | Timeline Stacked Bars

CRM Analytics / By Alex Waleczek

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 »

Month: February 2023