Introduction This week’s challenge again comes from trying to solve a problem in my day job, where I was exploring the possibility of parameters being multi-select like filters. We couldn’t use filters because we had different data sources, so I found a few forum and blog posts that make multi-select parameters a possibility, even if …
#WOW2024 | Week 38 | Can you create multi-select parameters? Read More
Introduction Ternary plots are a unique plot that is typically used to look at the mineral composition of rocks. However these plots have been adapted in data journalism for looking at voting intention in varying demographics. Each point on the plot comprises a percentage of each dimension e.g of the 65+ age demographic, 16% of …
Introduction This week’s challenge is a bit different; you have two options! Imagine you’re creating a workbook showing off all the cool features and functionalities to your coworkers and want to provide a curated list of Sigma’s help documentation. In this challenge, you’ll create an embedded documentation element enabling the end users to choose a …
2024 Week 37 | Sigma: What would you like help with? Read More
Introduction In honor of the Power BI Desktop dark mode being scheduled for public preview this month, we are making a report that allows you to switch between light mode and dark mode. Requirements Get the data from Data.World. Filter the report to the year 2024. Create a card that shows current year sales. Create …
2024 Week 37 | Power BI: Create a Report with Light and Dark Mode Read More
Introduction We’re going back to the Paris 2024 Olympic Games this week. I loved them and built my own version of the medal table that I’d been looking at constantly throughout the 2 weeks based off of the BBC (UK) mobile app. I added the ability to click and see what medals were won each …
#WOW2024 | WEEK 37 | What medals did each country win each day? Read More
Introduction Welcome back to another challenge. This week we’re tackling some financial data and in particular, a waterfall chart based on multiple measure columns. Can you handle it? Click to open in Tableau Public Requirements Dashboard Size 800 x 600 One worksheet Create a waterfall chart for Gross Sales Discounts Net Sales COGS Profit Create …
#WOW2024 | 36 | Can you build a Measure Names Waterfall? Read More
Introduction Welcome to Week Thirty-Six! This week, we’re going to focus on some more advanced filtering. By now, you should know how to utilize a page control’s targets to filter a single column in an element. What do you do when you need to affect multiple columns in the same element? You can utilize a …
2024 Week 36 | Sigma: Can you filter without targets? Read More
Introduction Welcome back to Workout Wednesday. This week we’re taking inspiration from the incredible infographics team over at the New York Times. Their 2015 article looks at the average American’s contribution to the drought in California. As of today (Sep 2024), about a third of California remains abnormally dry. This challenge features some fun data work …
2024 Week 36 | Power BI: Recreate a NYT Interactive Article Read More
Introduction Have I expressed my deep appreciation for Input Tables? With Snowflake or Databricks, we can write back to the database, which allows for some great methods of simplifying getting user-maintained information into a database. Even though I am a big fan of input tables, it’s still risky to allow users to edit a database …
2024 Week 35 | Sigma: Can you create a support request form? Read More
Introduction Overlapping histograms with normal curve overlays are used to compare the distribution of a numerical variable across different groups such as male and female body mass. With this we can glance the central tendency, spread, and skewness of the data within each group and also how well the data follows a normal distribution. The …
2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve Read More
