Power BI

2022 Week 41 | Power BI: Likert Scale and Net Promoter Score (NPS)

1 Comment / Power BI, Workout Wednesday /

Introduction This month we are getting the #WorkoutWednesday community involved in the challenges with Community Month. Each week we’re going to have an outstanding member of our community present a challenge. This week we have Gerard Duggan from sunny down under (Australia). Gerard rocks the Power BI community showing us how to present outstanding analysis […]

2022 Week 41 | Power BI: Likert Scale and Net Promoter Score (NPS) Read More »

Power BI, Workout Wednesday

#WOW2022 W40: Power BI: Field Parameters with Conditional Formatting

community, Power BI, Workout Wednesday /

Introduction This month we are getting the #WorkoutWednesday community involved in the challenges with Community Month. Each week we’re going to have an outstanding member of our community present a challenge. This week we have one of the best out there, Sekou Tyler, gracing us with his presence. Sekou is an accomplished BI professional and

#WOW2022 W40: Power BI: Field Parameters with Conditional Formatting Read More »

community, Power BI, Workout Wednesday
Error Bars showing standard deviation from the average

2022 Week 39 | Power BI: Use error bars to show statistical ranges

Power BI, Workout Wednesday /

Introduction We first looked at error bars in week 28. But error bars have several formatting features and can be used in several types of visuals. This week, we are going to use error bars to show a dynamically populated range around an average.  Requirements Calculate the average height and standard deviation for the heights.

2022 Week 39 | Power BI: Use error bars to show statistical ranges Read More »

Power BI, Workout Wednesday

2022 Week 38 | Power BI: Create a Waterfall Pipeline

3 Comments / Power BI, Workout Wednesday /

Introduction Welcome back to Workout Wednesday! This week we’re collaborating with the Tableau team to create a waterfall pipeline using Salesforce data. Lorna Brown, the creator of the challenge is attending Saleforce’s Dreamforce conference, hence the nature of the challenge. We’re building a waterfall chart using the Simple Waterfall custom visual by Datanomy Limited. This week’s workout can be done in

2022 Week 38 | Power BI: Create a Waterfall Pipeline Read More »

Power BI, Workout Wednesday

2022 Week 37 | Power BI: My First Deneb

2 Comments / Power BI, Workout Wednesday /

Introduction I sit back every week and watch the other amazing members of the #WorkoutWednesday Power BI team go through Deneb challenges like it’s nothing. The visuals are fantastic, the customizations are intriguing, but the truth is – I’ve never done a Deneb visual! Until this week that is.    If you’re like me and

2022 Week 37 | Power BI: My First Deneb Read More »

Power BI, Workout Wednesday

2022 Week 36 | Power BI: Split Violin Plot and HTML

3 Comments / Power BI, Workout Wednesday /

Introduction Another PlotlyJS visual this week – creating a split violin plot. We’ll be comparing male and female dating preferences collected from speed dating events between 2002-2004. EXTRA CREDIT – For those with a little more time on their hands, an extended workout challenge is included; conduct your own data analysis and create a data

2022 Week 36 | Power BI: Split Violin Plot and HTML Read More »

Power BI, Workout Wednesday

2022 Week 34 | Power BI: Calculation Groups

Power BI, Workout Wednesday /

Introduction Calculation Groups in Power BI essentially allow you to apply logic or formatting to a variety of measures at the same time.  For example, let’s say you were looking to create a Month-To-Date, Quarter-To-Date, and Year-To-Date view across Revenue, Orders, and Units.  This would require you to create a calculation for each of the

2022 Week 34 | Power BI: Calculation Groups Read More »

Power BI, Workout Wednesday

2022 Week 33 | Power BI: Compare two series of values

Power BI, Workout Wednesday /

Introduction Welcome back to Workout Wednesday! This week we’re visualizing two series of values in a take on last week’s Tableau challenge! This week’s challenge uses youth cellphone data and gives you the opportunity to either build a dumbbell chart using Charticulator or to build a lipstick column chart using a custom visual. Complete one or both

2022 Week 33 | Power BI: Compare two series of values Read More »

Power BI, Workout Wednesday

2022 Week 32 | Leverage Field Parameters in Measures

Power BI, Workout Wednesday /

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 »

Power BI, Workout Wednesday