Thank you so much for giving me the opportunity to join this challenge-5.
Here is how I imaged to build up the report.
I was trying to image if I was in Penny’s position, what would I expect myself to streamline the current process.
What I read from the Penny’s instruction and also what I would like to manage are
- Patients schedule
- Patients details
- Possible sales promotion
Patients schedule and details can be managed by using the historical data supplied.
I also thought by categorising due days reasonably they can use that data for their sales promotion by emailing, calling or posting etc.
Out of 3,389 patients, I wouldn’t want to focus on the patients whose due is yet to come.
That’s why I have created 6 groups by due days.( also I tried not to create too many)
First category “Yet to Due” is 24% so we could successfully reduce the number we would like to focus on.
Next category “Due 30days” is only 181 patients so maybe Penny wants to look into this group first.
I also want to show Penny what it can be achievable by PBI.
Interestingly some patients were having two tests on the same day with having different results.
This could be test quality assurance issue so Penny should know about.
(Something found useful on this report)
In the report, I have used dynamic colour measure and found this worked well on this report.
The measure used is as below.
and then go to the conditional formatting, chose “front color” this time
chose “Colour measure” I created
Good side of this dynamic colour measure is we can use it repeatedly with different chart and different page.
(Sadly I found negative side too… If there is no option of conditional formatting or f(x) , I still had to change colour manually… PBI does not smile 100% always)
Thank you so much all the members.
As one of the participants, it isn’t easy for me to participate in the challenge because of the pressure I feel but definitely this is incredible experience with connected members & experts closer than before.
Also I appreciate a lot EDNA experts who created this environment and working very hard behind the scene.
Congrats all the participants all reports looks beautiful and nice.
With all my respects to all the EDNA members.
PBIX file attached.
challenge5 (Hideo).pbix (3.9 MB)