Introduction This week we are going to focus on data security and how we can ensure that only certain users see certain opportunity data! Sharing inheritance and security predicates are supported in CRM Analytics – this week we are going to look at security predicates – row-level security which enables you to model many different […]
2023 Week 19 | Security Predicates Read More »
Introduction Welcome back to Workout Wednesday! We’re taking inspiration once again from our friends at Makeover Monday. This one is fun – the Makeover Monday team was inspired by a bar chart featured in a blog post and they decided to recreate it in Tableau! You can read Andy’s full post on his blog if you want more info. Today
2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator Read More »
Introduction This week’s challenge is a little SVG fun. Recent Power BI Desktop changes have allowed even further width and height adjustments for images in matrix visuals. So we will be extending this by making a bar chart of chocolate bars. Requirements Power Query Obtain the dataset from 2023-week-11 challenge or; Obtain the dataset from
2023 Week 18 | Power BI: SVG Clip Path Read More »
Introduction One of my favorite challenges from the past is from Week 4 2020: Can you combine relative and custom dates? I was always fielding questions if I could have a relative date filter and a date picker on the same dashboard, but hadn’t ever figured it out. After Sean’s challenge that week, I implemented
#WOW2023 Week 18: Can you combine relative and custom date filters? Read More »
Introduction This week’s challenge is provided by Guest Contributor Ben Ferry aka Power BI Guy. Requirements Power Query Transform data (hint unpivot and reduce the number of columns) Load Data Power BI Desktop Create a Measure for the Sum of the values column Create a measure to rank the characters based on the measure you
2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks Read More »
Introduction For the last week of Community Month, I’m thrilled to introduce you to my colleague at Biztory, Nik Eveleigh (@MrEvilEye). I’ve known Nik virtually through our shared love of #WOW for around 3 years. After he returned to the UK from South Africa at the end of last year, I was delighted to learn
#WOW2023 | Week 17 | Custom Map Analysis Read More »
This week’s challenge is to enhance a Superstore text table, inspired by Luke Stanke’s 26 Ways to Enhance your Tables in Tableau and Sam Parsons’s amazing Super Advanced Tableau Tables.
#WOW2023 week 16: Can you build insightful advanced tables? Read More »
Introduction It’s Community Month once again here at #WOW2023 which means we have a guest coach. I wanted to use this opportunity to connect with our global community. Without a doubt, the most active group of challenge participants I see on Twitter, beyond those in anglophone countries, are the #DataSaber community based in Japan. I
#WOW2023 | Week 15 | Can you create Digital Signage with Tableau? Read More »
Introduction Welcome back to Workout Wednesday! This week we’re using a Makeover Monday dataset that was inspired by Andy Kriebel’s post on Twitter (dataviz inception!). Andy has been working through Makeover Monday challenges in Power BI, and I thought it would be a good opportunity for us to do some of these together! This week’s challenge uses what-if parameters, a
2023 Week 15 | Power BI: What-if parameters inspired by Makeover Monday Read More »
Introduction This week’s challenge is inspired by recent Twitter activities. We are creating a word cloud containing common misspellings in the US. Requirements Power Query Obtain the dataset from https://www.dailymail.co.uk/femail/article-11357183/Google-search-data-reveals-commonly-misspelled-words-spell-correctly.html OR https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings Transform and load data HINT : Add Index column, create modulo column, unpivot data Power BI Desktop Obtain Word Cloud custom visual from
2023 Week 14 | Power BI: Word Cloud and Modulo Read More »
