EnterpriseDNA - Data Visualization Workout 001 - Ratings Tables & Bar Charts

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)

Other Enhancements:

Load the main dataset:

Review Date

Review Rating (1-5)

Hotel Name

Hotel Type

Start* --> Calculated Column based on the Review Rating.

Stars = 
    SWITCH([Review Rating],
        1, UNICHAR(9733),
        2, UNICHAR(9733) & UNICHAR(9733),
        3, UNICHAR(9733) & UNICHAR(9733) & UNICHAR(9733),
        4, UNICHAR(9733) & UNICHAR(9733) & UNICHAR(9733) & UNICHAR(9733), 
        5, UNICHAR(9733) & UNICHAR(9733) & UNICHAR(9733) & UNICHAR(9733) & UNICHAR(9733),
        ""
        )