Workout Wednesday

2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data

2 Comments / Power BI, Workout Wednesday / Shannon Lindsay

Introduction Welcome back to Workout Wednesday! This week’s challenge is for participants new to Power BI and/or new to data visualization. We’re building a report containing 2 charts, a table, and a slicer. My challenge to you is to design the report in a way that a) makes sense to business users and b) is […]

2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data Read More »

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions

Power BI, Workout Wednesday / Kerry Kolosko

Introduction In this week’s challenge, we are experimenting with Radial Plots using Line and Scatter Core Visuals. Radial Lollipop charts are an alternative to radar charts. Power BI does not have Polar Plots, only cartesian plots, so we will need to use trigonomic functions within DAX to calculate the cartesian X and Y position of points. Requirements

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions Read More »

2024 Week 19 | Sigma: Can you clean a string?

Sigma, Workout Wednesday / Eric Heidbreder

Introduction After last week’s awesome product launch, I was thinking about some of the Sigma features that we have not yet highlighted in Workout Wednesday. One of those is Custom Functions, and while the ability to create Custom Functions is currently reserved for admins, it’s a great feature for users to be aware about when

2024 Week 19 | Sigma: Can you clean a string? Read More »

Playing with Ranks in CRM Analytics!

CRM Analytics, Workout Wednesday / Sayantani Mitra

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

Playing with Ranks in CRM Analytics! Read More »

#WOW2024 | Week 19 | Can you expand this segmented bar chart?

Tableau, Workout Wednesday / Donna Coles

Introduction So this week follows on from my previous challenge in week 13 here. Feel free to either recreate completely from scratch or use my/your own original solution to build on (my solution for week 13 is here and my solution guide is here). Having built a segmented bar chart, we are now going to

#WOW2024 | Week 19 | Can you expand this segmented bar chart? Read More »

#WOW2024 | 18 | Sleep Survey Marimekko

Tableau, Workout Wednesday / Sean Miller

Introduction Welcome to week 18 and this week’s challenge. This is a special challenge as it is the challenge that coincides with Tableau conference and #Data24! This week your challenge is to analyze sleep survey data and build a marimekko chart in Tableau! Click to open in Tableau Public Requirements size: 1000×800 the x axis

#WOW2024 | 18 | Sleep Survey Marimekko Read More »

2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image

Power BI, Workout Wednesday / Meagan Longoria

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

2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image Read More »

2024 Week 18 | Sigma: Can you consolidate data?

Sigma, Workout Wednesday / Michal Shaffer

Introduction Welcome to Week 18! This week we’ll be consolidating menu item data and sales data from Sigma’s sample food trucks database using a powerful tool – Joins! We’ll use both Joins and Lookups to get a feel of the difference between the two. The formatting styles and colors in this challenge are all up

2024 Week 18 | Sigma: Can you consolidate data? Read More »

2024 Week 17 | Sigma: Can you Cohort These Customers?

Sigma, Workout Wednesday / Ashley Bennett

Introduction Welcome to Week Seventeen! This week, you’re going to perform a Cohort Analysis of food truck customers based on when they placed their first order. Conditional formatting will help highlight which cohorts have a greater percentage of customers in them. As a bonus, you will implement a dynamic page control input to let the

2024 Week 17 | Sigma: Can you Cohort These Customers? Read More »

2024 Week 17 – Dynamic dashboard Tables

CRM Analytics, Workout Wednesday / Phillip Schrijnemaekers

Introduction Hey guys! Welcome back to a new challenge!! One of the things I like the most about CRMA is how easy is to customize and make the dashboard dynamic and flexible, to display the data we want. In this challenge , let’s build a chart using 3 different datasets, and use the interactions of

2024 Week 17 – Dynamic dashboard Tables Read More »