Intermediate

2022 Week 32 | Leverage Field Parameters in Measures

Power BI, Workout Wednesday / Spencer Hamilton

Introduction My name is Spencer Hamilton, Analytics Consultant with phData, and I’ll be guest hosting this week’s challenge! For the challenge, we’re going to look at one of Power BI’s newer features, Field Parameters, and create some calculations that dynamically change based on the selected parameter value. In this specific example we’re looking at Sample […]

2022 Week 32 | Leverage Field Parameters in Measures Read More »

#WOW2022 Week 31: Let’s build a KPI dashboard

Tableau / Sean Miller

Introduction Who doesn’t love a good KPI dashbaord? This one is fairly simple and straightforward. Let’s look at four simple metrics and see how each subcategory ranks within a selected metric. With this challenge – MIND THE NUMBER FORMATTING 🙂 Click to open in Tableau Public Requirements Dashboard Size: 700 x 350 2 sheets Display

#WOW2022 Week 31: Let’s build a KPI dashboard Read More »

Tableau

2022 Week 30 | Power BI: Creating a Mobile View

Power BI, Workout Wednesday / Rob Saunders

Introduction In Power BI, you are able to create mobile views for every desktop report. This is especially useful if you have users access the reports through the Power BI app on an iOS or Android device. This week’s challenge is to develop a mobile view of the Covid-19 tracking sample for US state and

2022 Week 30 | Power BI: Creating a Mobile View Read More »

Power BI, Workout Wednesday

2022 Week 29 | Create a Stream Graph

Power BI, Workout Wednesday / Meagan Longoria

Introduction This week, we are taking a look at a lesser used visualization type called a stream graph. Stream graphs are similar to a stacked area chart, but they have values displaced around a central axis rather than stacking on top of an axis. They have received criticism in the past for being difficult to

2022 Week 29 | Create a Stream Graph Read More »

Power BI, Workout Wednesday

2022 Week 25 | Power BI: Visualizing Music

Power BI, Workout Wednesday / Rob Saunders

Introduction June is still music month, so for this week’s challenge we’re going to visualize music. Sometimes the simple visualizations tell the best stories. That is definitely the case for the “warming stripes” visualization which was used to show the change of global temperature over time. Using this as motivation, what if we created a

2022 Week 25 | Power BI: Visualizing Music Read More »

Power BI, Workout Wednesday

2022 Week 24 | Scatterplot with custom marker

1 Comment / Power BI, Workout Wednesday / Meagan Longoria

Introduction For this workout, we are visualizing data in a scatterplot in a bit of a non-traditional manner. This week marks 26 years since Ella Fitzgerald, the “Queen of Jazz”, passed away. So we are visualizing melodies to a few of her songs. My approach is a bit abstract – not quite sheet music but

2022 Week 24 | Scatterplot with custom marker Read More »

Power BI, Workout Wednesday

2022 Week 23 | Collab with Preppin Data – Salesforce Opportunities

1 Comment / Power BI, Workout Wednesday / Shannon Lindsay

Introduction Welcome back to Workout Wednesday! This week is our annual collaboration with Preppin’ Data and the Tableau team! This week we’re visualizing Salesforce data – looking at current open opportunities, and trying to distinguish the dollar amount of opportunities due to close this month. This week’s challenge can be done in both Power BI and Tableau, and

2022 Week 23 | Collab with Preppin Data – Salesforce Opportunities Read More »

Power BI, Workout Wednesday

2022 Week 19 | Power BI: Oh Rats! Tableau Recreation

Power BI, Workout Wednesday / Rob Saunders

Introduction A few week’s ago, Sean Miller created an incredibly slick dashboard showing Rat Sightings in New York since 2010 for week 16 of Tableau’s Workout Wednesday (Challenge Link). The challenge used Hexbins to combine multiple map points into shapes of the same size to show density more clearly within a map. This week, we’re

2022 Week 19 | Power BI: Oh Rats! Tableau Recreation Read More »

Power BI, Workout Wednesday

2022 Week 18 | Power BI: Remake this Tableau budget burndown chart

Power BI, Workout Wednesday / Meagan Longoria

Introduction For the month of May, we are remaking Tableau visualizations with Power BI. Although the visuals made by the two tools may be similar, the calculations and formatting options are a bit different. This makes some things easier in one tool compared to the other. If you use both Power BI and Tableau, feel

2022 Week 18 | Power BI: Remake this Tableau budget burndown chart Read More »

Power BI, Workout Wednesday

2022 Week 17 | Power BI : Create a Custom Theme

4 Comments / Power BI, Workout Wednesday / Shannon Lindsay

Introduction Welcome back to color month! It’s our 4th color-focused challenge and in stark contrast to Kerry’s week 14 challenge, we’re using loads of bright colors! This week we’re creating a custom theme using the color palette of the United Nations Sustainable Development Goals. This challenge was inspired by a Makeover Monday challenge – take a look

2022 Week 17 | Power BI : Create a Custom Theme Read More »

Power BI, Workout Wednesday