Data Visualization Workout 001 - Ratings

Workout 001 – Hotel Rating – bar chart and table
Difficulty rating: 2,5 out of 5

Goals

In this workout, using the supplied dataset we are going to replicate the following set of vizualizations (left section in a report screenshot), including a slicer, bar chart section and table section. Holistic solution requires to include each section listed above, but it’s also eligible to provide a solution that will only contain either the bar chart section or the table section. Also, please feel free to add any extra visual if needed (provided that core visualizations are included in the first place).

001 - Workout - Hotel rating (bar chart & table).xlsx (71.8 KB)

Practiced skills:

    • Creating interactive set of vizualizations (verifying if data is presented correctly after using interactions / slicers)
    • Presenting data in the top-bottom structure (overall metrics / details)
    • Using supplemental visual elements (unicode symbols / icons)
    • Writing basic dax formulas to achieve desired visual effects (grey bars in a bar chart, text box with names of selected items)
    • Enhancing data story-telling by using the combination of chart(s) and table(s)

Submission

Please load the supplied data (xls file) into a new Power BI file, replicate visualizations, and reply to this post including the screenshot (or a gif) of your solution along with the pbix file.

Period

This workout is released on Monday March 27, 2023, and the author’s solution will be posted on Monday April 3, 2023.

Additional notes
Link to the interactive dashboard:

6 Likes

@Gustaw is in the house! Superb workout, I can’t wait to get stuck in……shame I have a job otherwise I’d be starting it now!

4 Likes

“Exhilarating! Although it presented a challenge, I am grateful for the opportunity to expand my knowledge and skills. I eagerly anticipate the next challenge that comes my way.”

6 Likes

Mmmm, I got close I guess.

**Updated 28/03/23 -
as @Gustaw has said, lots of little design elements can add up to a great design…woke up this morning and realised how I had missed an element in the table.

By adding white lines, it separates out the grey background of the 2nd scale column to create/enhance the effect of a target data bar. Updated PBIX included also

Data Visualization Workout 001 - Ratings.pbix (88.4 KB)

9 Likes

Great workout - need some additional formatting and report title but here it is:

Rating_Example.pbix (44.2 KB)

6 Likes

Really top work!

2 Likes

Dear all, thanks for the nice challenge: On first glance it seemed easy, but some features did need some consulting of ChatGPT …
I added also two cards for the most and best rated hotels.

workout1_hotelRatings.pbix (751.3 KB)

8 Likes

Great first post on the forum @DianaAckermann :clap: :clap:

3 Likes

If someone need a native visuals for stars, you can check at:

6 Likes

@Gustaw - great workout!

I’ll preface this by saying I don’t have a lot of time this week but didn’t want to miss out. I didn’t try to hit the formatting, color scheme, or the full layout and rather just focused on capturing most of the elements (missed a few).

I think this is similar to skipping the one hour aerobics class and just hitting the treadmill for a few minutes.

Workout 001.pbix (70.7 KB)

8 Likes

@Gustaw

Here is my Submission for Viz Workout001

VIZ_workout001.pbix (80.2 KB)

Thanks
Dharmendar S

9 Likes

Workout 001 -Ratings.pbix (34.1 KB)

I like this workout. I am waiting for more …

6 Likes

Really enjoyed this one, learnt some visualisation and design tricks that will definitely be using going forward!

Data Visualization Workout 001 - Ratings.pbix (85.0 KB)

5 Likes

Absolutely bang on @jamie.bryan

1 Like

@DavieJoe Your pbix helped a lot with the bits I was stuck on!

2 Likes

Ahhhh, I love a bit of credit :wink:

Glad it helped, Gustaw let me know on the couple of bits I missed out on, like the line at the bottom and top of the bar chart. He also, rightly, called out the colour of the Y Star Axis wasn’t the same as the Star KPI at the top.

I genuinely woke up, the day after I posted mine, and my mind went ping…“ah he put white lines on his matrix to create the effect of the light grey being a surround” :joy:

Lots of small details can add up to big things!

3 Likes

Really enjoy this data visualization workout 001 - Ratings
Here it is my submission

Ratings workouts Gustaw Dudek.pbix (118.5 KB)

5 Likes

Hi,

I am stuck, I can’t make the values in the Scale columns disappear.

thank you for your help.

Rémi

3 Likes

Use the magic formatting trick of 3 semi colon’s ;;

image

4 Likes

Hello @Remi10

You can apply “;;;” format for your duplicated measure (i.e. for Reviews v2, and Avs Score v2).
It’s best to apply format using built-in format pane on the top ribbon, istead of using “format” function.

image
instead of i.e. whole number, you can rewrite to ;;;

4 Likes