Introduction Scatterplots are one of the most useful visual chart types for data exploration. You can use them to identify relationships among two or more variables, find clusters of data, encode data in several ways for communicating insights etc. This is especially useful when working with large datasets. In this WoW challenge, our goal is to use marker …
2024 Week 42 | Power BI: Scatter Plot Dynamic Colour Density Read More
Introduction Welcome back to Workout Wednesday. This week we’re extending the #FabConEurope edition of Workout Wednesday. We’re hosting a contest and three winners will receive a 30-minute one-on-one mentoring session with one of the three Workout Wednesday hosts. For more information on how to enter, see contest details below. Requirements Get and transform data Get …
2024 Week 40 | Power BI: #FabConEurope Edition – Contest Deadline Extended! Read More
Introduction Welcome back to Workout Wednesday. This week we’ve got a special #FabCon Edition of Workout Wednesday. We’re hosting a contest and three winners will receive a 30-minute one-on-one mentoring session with one of the three Workout Wednesday hosts. For more information on how to enter, see contest details below. Requirements Get and transform data Get …
Introduction Ternary plots are a unique plot that is typically used to look at the mineral composition of rocks. However these plots have been adapted in data journalism for looking at voting intention in varying demographics. Each point on the plot comprises a percentage of each dimension e.g of the 65+ age demographic, 16% of …
Introduction In honor of the Power BI Desktop dark mode being scheduled for public preview this month, we are making a report that allows you to switch between light mode and dark mode. Requirements Get the data from Data.World. Filter the report to the year 2024. Create a card that shows current year sales. Create …
2024 Week 37 | Power BI: Create a Report with Light and Dark Mode Read More
Introduction Welcome back to Workout Wednesday. This week we’re taking inspiration from the incredible infographics team over at the New York Times. Their 2015 article looks at the average American’s contribution to the drought in California. As of today (Sep 2024), about a third of California remains abnormally dry. This challenge features some fun data work …
2024 Week 36 | Power BI: Recreate a NYT Interactive Article Read More
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 Welcome back to Workout Wednesday. This week we get to combine our love for data and the Olympics by building an Olympic medal tracker! This is a design challenge. I have created a sample for inspiration, but feel free to build the report in any way your creative heart desires. In this challenge you’ll …
2024 Week 32 | Power BI: Track the Olympic Medal Count! Read More
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 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
