Introduction Welcome to Week Seventeen! This week, you’re going to perform a Cohort Analysis of food truck customers based on when they placed their first order. Conditional formatting will help highlight which cohorts have a greater percentage of customers in them. As a bonus, you will implement a dynamic page control input to let the …
2024 Week 17 | Sigma: Can you Cohort These Customers? Read More
Introduction Hey guys! Welcome back to a new challenge!! One of the things I like the most about CRMA is how easy is to customize and make the dashboard dynamic and flexible, to display the data we want. In this challenge , let’s build a chart using 3 different datasets, and use the interactions of …
Introduction Welcome back to Workout Wednesday! This week we’re celebrating Earth Day (April 22) with a design challenge. You can do whatever your designer heart desires with this challenge. I’ve provided a sample, but this is just to get your creative juices flowing. Whatever you do, ensure that your design is accessible and that you’re …
2024 Week 17 | Power BI: Design an Earth Day Infographic Read More
Introduction For the final week of Community Month, it is my pleasure to introduce you to a new Guest Coach on the Workout Wednesday team, Deborah Simmonds. For a number of years, Deb has been one of the most dedicated #WOW participants, so I was delighted to invite her to create her own challenge for you. …
#WOW2024 | Week 17 | How far would total steps from TC23 respondents take you? Read More
Introduction In this week’s challenge, we are creating a timeline visual on a sine wave. You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions. Alternatively, with small multiples. Requirements Obtain the data from Kaggle and/or Wikipedia Create a …
2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals Read More
Introduction My past few challenges have been quite heavy on the formatting. Today I wanted to take a break from challenging you to format your workbooks, to showing you a powerful feature in Sigma that I don’t see used as often as I think it should be. Trellising! If you’re not familiar with trellising, it …
Introduction This week’s challenge comes from Chasoso (Hideaki Yamamoto), who is an active participant in WorkoutWednesday and was the runner-up in last year’s Viz contest at the Japan Tableau User Group (JTUG) annual meeting. # Introduction(EN)I’m very happy to join Workout Wednesday as a guest coach.Because I’ve been encountering interesting vizzes every week, I admire …
#WOW2024 | Week 16 | Can you create a sales dashboard by effectively utilizing headers? Read More
Introduction Since I watched the solar eclipse from Texas this week, we have a solar theme. We are visualizing the sunrise time each day in 2024 to date. I’m keeping it simple with the line chart core visual, but you can use whatever visual you would like. Requirements 1. Retrieve the data from Data.World. 2. …
2024 Week 15 | Power BI: Visualize sunrise times with a line chart Read More
Introduction Continuing with our community month, I decided to invite the OG himself back for a challenge, Andy Kriebel. All I’m going to say about this challenge is, I’m sorry if it’s super hard and don’t be afraid to sneak a peak into the actual workbook to get insight into how Andy’s mind works! Click …
#WOW2024 Week 15: Can you create a (super) dynamic trellis chart? Read More
Introduction This week, we’re building a staple in my bar chart library: Top, Bottom, and Other Values. I often use this bar chart to easily show the breadth of the outliers while not losing sight of the typical. This challenge is also a great example of the flexibility of modeling at different levels of granularity …
2024 Week 15 | Sigma: Can you identify the top, average, and bottom profitable customers? Read More
