Introduction Hello and welcome to Week 34! Let’s get the fun started this week with Rows and Columns Total in the Pivot Table! Yes, you heard that right, we want to sum the rows and columns and yet have all the data show. Requirements Create a dev org or use an existing org you have …
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 …
Introduction We are already into the mid 2024 and hope you are ready for another challenge! This is hopefully easier than some of the previous challenges we have set in CRM Analytics this year! It contains windowing function with input widgets. Yes, you read that right! Two great tools that can make your and your …
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 Another month another week and we are already in the second quarter of the year! Let’s start this quarter strong and use timeseries in dashboards. This week is based on similar dataset as the week 4 and 9 but has been organized by energy types as a column! The challenge is to create a …
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 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 …
Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new …
2023 Week 01 | Power BI: Use DAX to control visual display Read More
Introduction I felt like I was seeing more news about food recalls lately, and I did the thing any good data-minded individual would do: pulled down data from the FDA to see if what I’m feeling is backed up by data. When I pulled the data down from, I realized there was still a lot …
Introduction This week’s visualization is inspired by the concept of rules – understanding them and knowing how to bend them (but never break them!) At a high level, Power BI visualizations are rendered using a combination of JavaScript, HTML, and CSS in a web browser. By learning the foundational aspects of various data visualization tools, …
Introduction This week’s challenge was inspired by a suggestion that I made to a colleague when he faced the problem of having a small space to work with, but wanting to give the end user the ability to drill-down a bit deeper. His idea was to only show the Top 5 within a selected Sub-Category. …
#WOW2024 | Week 47 | Top 5 Product Sales vs Other Products Read More
Introduction Welcome to Week 46! This week we pretend to be a streaming service, trying to see which of our 3 new shows are doing well with the viewer base. Funnel charts will be our main focus here, but feel free to play around with the sample data to find other key insights! The formatting …
2024 Week 46 | Sigma: Can you create a Funnel Chart? Read More
Introduction Hey everyone! This week’s Workout Wednesday focuses on creating clear, actionable patient demographic visuals using a Sankey, a KPI, and two bar charts—binned and unbinned. Here’s the setup: the Sankey chart helps us map distribution, while the KPI delivers an at-a-glance view of a key metric to ground the analysis. With the bar charts, …
2024 Week 45 | Sigma: Can you create these patient demographic visuals? Read More
Introduction Utilising the dataset from a previous challenge (week 43), this week we are going to build a bubble likert chart. Likerts are usually ordered categorical data, and often it does not make sense to convert categories to a numerical score to find averages. Sometimes, likerts can be treated as interval data. https://www.scribbr.com/methodology/likert-scale/. For the …
Introduction This week we are live at DataFam Europe in London and we have paired up with Preppin Data to make sure our data is in the best format ready to go for building our visualisation. If you want to take part in the PreppinData challenge, you can find it here. As we are in …
Introduction This month we hold Global Community Weeks! We’ll feature guest coaches from around the world in the coming weeks. I’m excited and honored to introduce Tomoki Goda (@padawan_viz) from Japan! Tomoki is relatively new to Tableau but is strongly passionate about Tableau community activities. He is one of the co-hosts of a popular Japan …
#WOW2024 | Week 45 | Can You Switch A Dashboard Theme? Read More
Introduction A bump chart shows changes in rank over time. This week, inspired by a visual from Statista Charts, we are making a bump chart of the countries with the highest GDP in 3 selected years. The example below uses a ribbon chart core visual to create the bump chart, but you are welcome to use …
Introduction Welcome back to Workout Wednesday! I’m nearing the end of my 4th year contributing to this incredible initiative, and quite honestly, I am running out of ideas! This week I went to the Fabric Data Stories Gallery to look at reports that have inspired me, and I was reminded of this incredible report that Jason Thomas …
2024 Week 44 | Power BI: Community Appreciation – SQLJason Read More
