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 […]
#WOW2022 Week 32: Can you build a dumbbell chart? Read More »
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 Who doesn’t love a good KPI dashbaord? This one is fairly simple and straightforward. Let’s look at four simple metrics and see how each subcategory ranks within a selected metric. With this challenge – MIND THE NUMBER FORMATTING 🙂 Click to open in Tableau Public Requirements Dashboard Size: 700 x 350 2 sheets Display
#WOW2022 Week 31: Let’s build a KPI dashboard 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
2022 Week 30 | Power BI: Creating a Mobile View Read More »
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
#WOW2022 | Week 30 | Dynamic Dates in a Heatmap Read More »
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
2022 – Week 29: What is the Time-Weighted Return? Read More »
Introduction This week, we are taking a look at a lesser used visualization type called a stream graph. Stream graphs are similar to a stacked area chart, but they have values displaced around a central axis rather than stacking on top of an axis. They have received criticism in the past for being difficult to
2022 Week 29 | Create a Stream Graph Read More »
Introduction This week my challenge comes from two places of inspiration. Firstly the ONS website and secondly a final interview for someone applying to the Data School. I loved the concept of the chart and it helps with context and also synchronisation of axis. Have fun. Click to open in Tableau Public Requirements Dashboard Size: 800
#WOW2022 W28: Can you build a butterfly chart? Read More »
Introduction Welcome back to Workout Wednesday! If you’re joining us for the first time, welcome! We present you with a challenge, a dataset to recreate the challenge, and a solution video or file. You can use these challenges to build your skills and your portfolio! This week we’re exploring the error bars feature in Power
2022 Week 28 | Power BI: Error Bars Read More »
