Introduction Welcome to Week Thirty-Two! This week, we’re going to highlight one of Sigma’s latest enhancements to Actions. In this challenge, you’ll add actions to controls to show or hide columns in visualizations based on the column names selected in the control. This new action gives users more control over the data they want to …
2024 Week 32 | Sigma: Can you pick the right columns? Read More
Introduction Hi again, guys. In this challenge, we will learn a new way to filter our dataset. I know, it’s pretty basic, but check the rules session to make it more interesting and have fun 😉 Requirements Create a dev org or use an existing org you have access to. Connect 2 related objects to …
Introduction Welcome back to Workout Wednesday. This week we get to combine our love for data and the Olympics by building an Olympic medal tracker! This is a design challenge. I have created a sample for inspiration, but feel free to build the report in any way your creative heart desires. In this challenge you’ll …
2024 Week 32 | Power BI: Track the Olympic Medal Count! Read More
Introduction The Olympics continue this week, so we’re continuing with an Olympic theme this week as well. When thinking about a challenge, a Makeover Monday I did in 2018 came to mind (which was inspired by this viz by Rody Zakovich). But that one was the Winter Olympics, so we’re going to build a version …
#WOW2024 | Week 32 | Can you compare Olympic medalist age to a user’s age? Read More
Introduction I’ve always appreciated when developers take the time to incorporate images into their visualizations, whether it’s as simple as adding an up arrow / down arrow to denote positive or negative trends, or going all the way to showing a business’s/team’s logo when referring to them in a table. This week, I wanted to …
Introduction This week’s challenge is brought to you by Guest contributor Roland Szirmai. Requirements Download data from SQLBI’s blog2. Create a Sales YTD and Sales PYTD patterna. Don’t forget the ShowValueForDates calculated column and the DateWithSales measure 3. Confirm that the Sales YTD and Sales PYTD measures are correct4. Replicate the TopN vs Others measures …
Introduction The 33rd Summer Olympic Games started in Paris last week, so we have an Olympic themed challenge this week, and I hope this is a fun one. When researching ideas, I saw this viz on my colleague, James Newton’s (Twitter|X / Linked In ), Tableau Public profile and thought it would be good fun to …
#WOW2024 | Week 31 | How do you compare against the world’s best 100m runners? Read More
Introduction This week’s challenge was inspired by an XKCD comic and Kamala Harris’ love of Venn diagrams. Leveraging a prior challenge by Phil Seamark, this challenge we are going to apply SVG filters to make the shapes appear hand drawn XKCD style, and import XKCD font via the HTML content visual. XKCD font can be …
Introduction This week’s challenge was inspired by a lively discussion I was a part of, covering what date calculations a data analyst should or should not know. We’ve already covered several common ones, such as the current time period vs the prior time period. So this week, I wanted to add another to the list: …
2024 Week 30 | Sigma: Can you show partial or whole months? Read More
Introduction It’s no surprise that many analysts tend to enjoy looking at data via a scatterplot. It’s a great way to show correlation across two measures for a cohort of dimensions. Additionally, one of the most popular charts of all-time is a line chart which shows historical trends. So how we do show correlation of …
