Data Visualization Workout 009 - KPIs & Targets

Workout 009– KPIs & Targets (line charts)
Difficulty rating: 4.0 out of 5

Intro note
This workout combines various visualization techniques. The most important part of the workout is practice - entries does not have to include every element or functionality to be still considered as great . Please pay attention to the list of functionalities (provided in the screenshoot and in published-to-web report), which includes ‘basic’ elements (1st-3rd point), supplemental (4th-6th point) and extra (7th point). I would kindly recommend to review them before executing green/blue/orange points to provide proper plan and flow of your work.

A good starting point is to implement first three basic points, by selecting a single chart (top line chart or bottom chart) and displaying a single metric (it can be KPI: DSO as an example). Realizing further points (blue/orange) will provide additional technical practice. You might also replicate both charts (top and bottom) if you’d like to.

Top chart generally requires a few less steps (but dynamic color for marker might be a bit trickier though), whereas bottom chart is generally more complex (bands / areas) while having a fixed marker color (for simplicity).

Following workout bases on exact same data source as provided in workout 008 - if you already participated in 008 workout - please feel free to reuse your already transformed datasource / model / measures etc. Not all columns provided in the dataset have to be used in that particular workout.

**Feel free to use your entries as a part of your project portfolio, if it’s instrumental in realizing your goals.

Additional notes

Regarding the column naming convention:
Column ‘Payable turnover’ - DPO (in days)
Column ‘Receivable turnover’ - DSO (in days)
Column ‘Inventory turnover’ - DIO (in days)

Within the report section:
“TG” - Target
“LPT” - Last data point (in current date range context)

In many cases lower DSO might be considered as favorable scenario, but in this particular workout it’s an exemplary KPI, thus we might incorporate additional slicer to determine wheter we consider values below the target as favorable or adverse (negative) scenario. It brings additional interactivity that can be reused in other case-scenarios


Goals

In this workout, using the supplied dataset and reviewing the provided interactive report (link below) we are going to replicate either a single choosen line chart or both line charts, depending on your goals. Additional custom tooltips are not a part of this workout (they can be simplified comapred to what we can see in the published to web report). Also, please feel free to add any extra visual if you would like to (provided that core visualizations are included in the first place).

009 - Workout - Financial KPIs - line chart - targets.xlsx (15.7 KB)

Data-source

Core actions (practice) :

    • Creating line charts and applying various formatting options
    • Leveraging various chart elements to apply (fx) formats (shadows / subtitles)
    • Applying conditional formatting for specific data points
    • Incorporating numeric parameters (targets)
    • Using error bar functionalities

Submission

Please load the supplied data (xls file) into a Power BI file, replicate visualizations (considerating list of points in the introductory report screenshot and the general design and functionality provided through interactive published-to-web report), and reply to this post including the screenshot (or a gif) of your solution along with the pbix file (please, include name or EDNA forum nick in the pbix name).

Period

This workout is released on Tuesday May 23, 2023, and the author’s solution will be posted on /Tuesday - Wednesday 30-31 May, 2023.

Additional materials

Link to the interactive dashboard:

Have a great fun!

Best regards!

2 Likes

I’ve been waiting since yesterday

2 Likes

My solution is below. I hope I solved everything correctly. It seems the training is paying off as it took me less time than usual :slight_smile:


workout 009.pbix (173.9 KB)

6 Likes

I’m currently in Greece on holiday……I was BANNED from taking my laptop……”you’ll just try and sneak some time on those Power BI Workouts if the laptop comes along”……so I now have workout 007 to finish off the last few bits…then I have 008 & 009 awaiting! Lots to do haha!

2 Likes

@Gustaw,

I was able to replicate most of the content of your original report. Regrettably, I made no adjustments to the color of the areas under the curves based on whether “good” is above the target or below the target.

One oddity I noticed in both mine and yours is that the values of the lower slicer for “Positive if LPT is…” appear too far above the slicer.

submission-deh

6 Likes

we miss you David

2 Likes

Awesome work HufferD

2 Likes

Awesomeness the “queen” of Data Visualization workout

2 Likes

thanks, that’s how I feel after this workout :rofl:

3 Likes

hi,
may I ask you a suggestion on what to use to make a video of the solution ?
thanks in advance

2 Likes

App: ‘Screen to gif’ should be sufficient, Roberto

1 Like

ooook.
thanks !

2 Likes

Hi,
Another excited workout. Learned a couple of valuable tricks. Thank you very much!
Workout 009_EDNA_AngelinaMihejenkova
Workout 009_EDNA_AngelinaMihejenkova.pbix (651.7 KB)

5 Likes

Awesome Work

1 Like

Thank you! :grinning:

1 Like

hi,
it was fun to create so many measures in order to fullfill every single requirement/viz setup.
I learn a lot ! thanks for the workout.

Please find attached my solution.
ciao !

Workout 009 - KPI and targets - Roberto Ravani.pbix (420.0 KB)

workout 9 RR

3 Likes

Looking great, Roberto!
Great work and thank you for participation!

2 Likes

@Gustaw, thank you for another great workout. :clap: :clap: :clap:

Here is my solution. I wasn’t quite sure what was going on with the right slicer, so I made it dynamic based on the target selected. Otherwise, I think I hit the criteria and learnt a lot along the way :blush:

Workout #9 KPIs & Targets Kim Cook.pbix (260.0 KB)

4 Likes

Looks amazing, Kim! Clean and functional.

Thank you for participation!

1 Like

Hi Data Team ,
This is My First Data Visualization work out in Enterprise DNA , I want to take this platform to thank Enterprise DNA for this opportunity

Here is the video of my workout , please have a look into this

Thank you .

4 Likes