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 […]
2024 Week 31 | Power BI: TOPN and Others Read More »
Power BI, Workout Wednesday
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 »
Tableau, Workout Wednesday
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
2024 Week 30 | Power BI: SVG Filters Read More »
Power BI, Workout Wednesday
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 »
Sigma, Workout Wednesday
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
#WOW2024 | week 30 | Connected Scatterplots Read More »
Tableau, Workout Wednesday
Introduction Welcome to Week 29! When dealing with time series data, sometimes we want to see how the data changes from period to period, specifically how it increases and decreases. Enter, the waterfall chart. Waterfall charts are a great way to see the journey of a value from start to end, and to see how
2024 Week 29 | Sigma: Can you create a Waterfall Chart? Read More »
Sigma, Workout Wednesday
Introduction This post is special! It has been sent by Pedro Gagliadri who has been working on CRM Analytics since it was called Wave! Yes, some of us have been using this tool forever! Now for the challenge: This Outliers Detection will use Z-Scores. Prepare a recipe and a dashboard that allows you to see
Outliers Detection in CRM Analytics Read More »
CRM Analytics
Introduction This week, we are recreating a previous Tableau workout in Power BI in which we build a segmented bar chart that contains a bar for the total amount followed by a bar that shows a categorical breakdown of that amount. This challenge involves a bit of data transformation as well as some more advanced
2024 Week 29 | Power BI: Remake of a Tableau Segmented Bar Chart Read More »
Power BI, Workout Wednesday
Introduction Tableau 2024.2 has recently released and I was excited to put together a New Features challenge for you all, including the Multi-Fact Relationship model and maybe a Viz Extension or two. While I’ve had a lot of fun diving deep into learning about Multi-Fact Relationships, I pretty quickly encoutered a limitation for incorporating it
#WOW2024 | Week 29 | Formatting & Intermediate Tableau Charts Read More »
community, Tableau, Workout Wednesday
Introduction Welcome back to Workout Wednesday! This week’s challenge is purely dataviz – there is no data transformation involved. A huge thanks to our friend and colleague Zoe Douglas for providing us with a beautiful and fun report to recreate. Find the data and instructions to complete the challenge below, and as always, have fun! Requirements
2024 Week 28 | Power BI: Create custom navigation with Zoe Douglas Read More »
Power BI, Workout Wednesday