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 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 …
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
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 …
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
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
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
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
Introduction Welcome to Week Twenty-Eight! Now that we are firmly in Summer Mode, let’s plan a lake vacation! This week, we’re going to evaluate water quality monitoring data in the Great Lakes. The dataset we’re using comes from Data.Gov. This dataset has many different characteristics measured in one long table. Don’t worry. I’ve already created a Sigma …
Introduction Do you like panel chart? I love it.It is often requested in practical work because it is suitable for getting an overview.This time, I am taking up some of the more challenging requests from past practical work.I believe this will help you level up your panel chart skills, so please enjoy the challenge! Click …
WOW2024 | Week 28 | Can you design a multi-dimensional Panel Chart for detailed analysis? Read More
