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
Introduction A huge thank you to Valerija Kirjackaja for sharing this fantastic challenge with us. It’s a little trickier than last week, this one is a classic #WOW – simple on the surface with lots of tricks behind the scenes. Reordering a chart using set or parameter actions is a pretty common use case – …
#WOW2024 | Week 35 | Advanced Parameter/Set Action Read More
Introduction This week’s challenge is provided by guest contributor Erik Svensen https://www.linkedin.com/company/catmansolution. The workout will use visual calculations in combination with numeric parameters to highlight a period in a development chart. (Please note visual calculations do not currently publish to web) Requirements 1. Retrieve the data from Google Sheets – (you only need orders)2. Add …
2024 Week 34 | Power BI: Visual Calcs and Parameters Read More
Introduction Welcome to Week 34! Creating a histogram in Sigma is easy when you use the built-in Bin functions to divvy up your data. This week we’ll be creating a histogram using a two different Bin functions in Sigma and some controls to make the charts more dynamic! The formatting styles and colors in this …
Introduction Hello and welcome to Week 34! Let’s get the fun started this week with Rows and Columns Total in the Pivot Table! Yes, you heard that right, we want to sum the rows and columns and yet have all the data show. Requirements Create a dev org or use an existing org you have …
Introduction Have you ever received a request to make the data displayed on a dashboard different depending on who is viewing it? For example, let’s think about a scenario where the sales for each sub-category are displayed, but the sub-categories shown vary depending on the viewer. It’s straightforward if one sub-category is to be displayed for …
#WOW2024 | Week 34 | Can You Control the Displayed Data Based On Sub-Category Assignment? Read More
Introduction Sigma is all about making data manipulations and explorations accessible to everyone! This week’s challenge might sound intimidating, extracting data from JSON, but Sigma makes it a breeze. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click here to Watch: How to Register & Get …
2024 Week 33 | Sigma: Can you find the safe to eat items? Read More
Introduction Editor’s note: This week we have a guest post from Imran Haq (LinkedIn, X). If you haven’t already, try out his previous WoW contribution to make a jittered column chart. The segmented bar chart from week 29, inspired some experimentation with similar designs. This week we are making segmented donut charts. These donut charts have 2 …
