Introduction This week we return to another business-specific challenge. This team we will explore hospitality data. The goal of this challenge is to determine what the average occupancy is by day at three different properties. The challenge of this data is that you’ll only ever know when customers check-in or check-out. Not the actual total …
2022 – Week 34: What is the average occupancy by weekday? Read More
Introduction Calculation Groups in Power BI essentially allow you to apply logic or formatting to a variety of measures at the same time. For example, let’s say you were looking to create a Month-To-Date, Quarter-To-Date, and Year-To-Date view across Revenue, Orders, and Units. This would require you to create a calculation for each of the …
Introduction Welcome back to Workout Wednesday! This week we’re visualizing two series of values in a take on last week’s Tableau challenge! This week’s challenge uses youth cellphone data and gives you the opportunity to either build a dumbbell chart using Charticulator or to build a lipstick column chart using a custom visual. Complete one or both …
2022 Week 33 | Power BI: Compare two series of values Read More
Introduction When looking through the challenge insights I realised we haven’t had many of the fundamental LOD style Workouts for a while. So this week we take a look at how does the latest month compare to the prior X months average? Click to open in Tableau Public Requirements Dashboard Size: 800 x 700px 2 …
#WOW2022 W33: Can you compare the latest month to the prior X months average? Read More
Introduction About three years ago, I was participating in our weekly Makeover Monday group at work, and happened to immediately know what I wanted to build and got it done in about 40 minutes. A colleague also completed theirs in that time, and so we then shared what we had built with the rest of …
Introduction My name is Spencer Hamilton, Analytics Consultant with phData, and I’ll be guest hosting this week’s challenge! For the challenge, we’re going to look at one of Power BI’s newer features, Field Parameters, and create some calculations that dynamically change based on the selected parameter value. In this specific example we’re looking at Sample …
2022 Week 32 | Leverage Field Parameters in Measures Read More
Introduction This week for Workout Wednesday we are getting familiar with the PlotlyJS visual by creating traces and annotations for a connected scatterplot. Connected scatterplots are a cross between a scatterplot and a lineplot whereby two numeric variables are connected by a third ordered variable (often time). The below graph created with the …
2022 Week 31 | Power BI: Connected Scatter with PlotlyJS Read More
Introduction In Power BI, you are able to create mobile views for every desktop report. This is especially useful if you have users access the reports through the Power BI app on an iOS or Android device. This week’s challenge is to develop a mobile view of the Covid-19 tracking sample for US state and …
Introduction I’ve been wanting to create this challenge for some time, so I’m really glad to finally be releasing it. This challenge was inspired by some work I did last year where a client wanted to be able to visualize the number of hours that their team had spent working on different projects. What made …
Introduction Working with financial data is hard. There are some calculations that make for long evenings to get right. One of those calculations is Time-Weighted Return. This challenge is simple: calculate the Time-Weighted Return Rate for a simple data source and return a line chart. Click to open in Tableau Public Requirements Dashboard Size: 400px …
