Dashboard Day

by Henry Coley-Fisher

To be clear, this is supposed to be a dashboard week post, however as I am taking annual leave for today and tomorrow this is now entitled Dashboard day.

For context last week DS27 were working with a financial services client, who seek to promote and provide tools for better understanding and mitigating economic risk. During the presentation of our work to the client, they noticed that certain aspects of the dataset I was given were not complete and should supplementary information become available it would be great to have that in the current dashboard.

Fast forward to today, first day back after the Christmas bank holidays and I find in my inbox a new dataset to update my existing work. As Dashboard day took a little while to get going due to some technical glitches which meant that we were without a dataset for about an hour in the morning, I took the initiative and decided to continue with my work. After double checking with Carl that I could continue as requested by the client I cracked on and got a finished dashboard out in only a few hours.

The main challenge of the day was updating a lot of calculated fields and parameters to include the new data. A secondary challenge was building a dashboard that could be easily added to as new metrics become available (the data is downloaded periodically from a website). After spending a fair bit of time working on the original dashboard I realised that it wouldn't make sense to have both rate metrics and absolute currency values on one dashboard. I created a completely new but related dashboard which meant duplicating and editing all the calculated fields I had already made to begin with. A few tricky LoD calculations later and I have completed the complementary dashboard ready to package up and send off to the client.

This was a bit of an unusual dashboard day assignment but I am pleased with the work I have managed to complete.

Avatar

Henry Coley-Fisher

Mon 31 Jan 2022

Thu 20 Jan 2022

Tue 18 Jan 2022

Fri 24 Dec 2021