Introduction This week we’re going to be building a recipe to create a dataset that we’ll use in a future dashboard. The focus is on IT tickets. We have a data set with information about open & closed tickets and some SLA data. We’re going to be combining these together in CRMA. Before we do …
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 …
Introduction The April 2023 release of Power BI Desktop gave us dynamic format strings for measures. While the end result could be previously accomplished by using calculation groups, we can now have measures with different formats based upon various conditions – no need to go into Tabular Editor to do this now! While we can …
2023 Week 16 | Power BI: Measure Format Strings and Conditionally Formatted Titles 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.
Introduction My turn again! I got a message from Ruy Aguilera recently, asking if there is a way to create a heat map with rectangles rather than squares in CRMA. While I don’t really mind squares, the way it is implemented leaves room for improvement! For starters, if the chart is dynamic and might show …
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 …
Introduction This week we are going to explore embedding dashboards within a Salesforce record page and apply a filter to make the insights contextual to the account you are viewing. Requirements Create a simple recipe: Bring in the Account Object – ensure the Account ID Field is included Bring in the Case Object – ensure …
2023 Week 14 | Embedding CRM Analytics Dashboards in Salesforce Read More
