Introduction It’s the 18th week of the year and time for another CRM Analytics challenge! This week’s task is to rank the energy dataset by country for each year and create one chart out of it. This chart will show the least and most energy consumed based on the type of energy consumption selected. Sounds …
Introduction Continuing on last week’s infographic theme, we are recreating an infographic from Visual Capitalist this week, this time showing average lifespan for different mammals. We will be using a scatterplot visual of your choice this week. I made two demo versions, one using the Deneb custom visual and one using the Enhanced Scatterplot custom …
Introduction In this week’s challenge, we are creating a timeline visual on a sine wave. You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions. Alternatively, with small multiples. Requirements Obtain the data from Kaggle and/or Wikipedia Create a …
2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals Read More »
Introduction Welcome back to Workout Wednesday! This week we’re recreating a really neat viz that was originally created by Flávio Matos for the Tableau team back in 2023. Flavio created the Periodic Table of Wine, with an option for users to select the food they’ll be eating to help them pair the perfect wine. Today, …
2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz Read More »
Introduction This week’s challenge uses a custom visual to achieve some formatting that cannot currently (as of March 2024) be achieved using core visuals. First, we have a table that contains 2 columns and no headers. Next, we have some contact cards that contain both an image and text. The catch is that the number …
2024 Week 12 | Power BI: Contact Cards and Headerless Tables Read More »
Introduction Welcome back to Workout Wednesday! This week we’re taking notes out of Injae Park’s portfolio and recreating one of his IBCS charts. IBCS, or the International Business Communication Standards is a set of rules to level up how businesses talk and share info. Think of it as a cheat code for clearer charts and …
Introduction Almost the end of February! Time flies fast! – And another WoW Challenge is here!! This week is based on the same dataset and maps we had as a challenge during Week 4! The changes are adding one KPI, and one top 5 chart to the existing dashboard. Then add an Interaction (not binding) …
2024 Week 09 – Formulate Select and Navigate Dashboard Read More »
Introduction Welcome back to Workout Wednesday! This week’s challenge is inspired by Ann Jackson, who created the challenge back in 2021 for the Tableau team. Let’s create a Customer Lifetime Value (CLV) Matrix, a tool that marketers use to segment customers based on their value and loyalty to a business. This helps marketers allocate resources …
2024 Week 6 | Power BI: Customer Lifetime Value Matrix Read More »
Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. This week we are building on a faceted strip plot made in 2023 week 35, and adding a median overlay. Inspired by …
2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay Read More »
Introduction We are already into the 4th week of the year – WOW!! My first time creating a WoW challenge. This one is based on maps! Yes, I know CRM Analytics maps make us desire for better versions, but we can always do cool things with what already exists. But, but… this one is not …
