Power BI Challenge 6 - Insurance Complaints Entry from Matteo (non-member)

Here’s the entry from one of our non-member participants, Matteo.

Here’s how Matteo described it:

I read the brief and watched the work of Marieke on Enterprise DNA Forum, which inspired me much. I wanted to create a report fully dynamic and interactive with all informations needed.

So at first there is a summary slide where you can view all essential informations such as the number of complaints, % of client satisfaction and of surveys with no answer or the trend of daily complaints.

After this, there are insights on specific and important issues, that are open complaints, duration and number of status changes, client satisfaction and at the end a focus on brokers and customers.

A little of time I want to spend on the slide called “Client satisfaction: brokers”, because it is the main thing of parting with the works I saw before concluding mine. Here I wanted to know and see who are the best brokers in terms of number of clients satisfied and % of client satisfaction. In this way, I created a column in order to classify brokers according to results of precedent year. I attach the image with the code used to classify brokers.

4 Likes

Welcome to the challenge great to see your submission.

One thing that I can’t look past is just the colors here. You’ve gotta make sure that your color palette is consistent and not to you overuse colors when you could showcase all the insights you need with a simplified palette. This is a really simple fix and something I really recommend having a good think about.

Another thing that really sticks out to me as well is your tables you haven’t taken off the word Rep and so some rows are much bigger than others and I think this can confuse the consumer so you’ve got to be quite careful there.

I can see you’ve put a lot of effort into this report so I really commend you for that and also I love this story that you’ve told throughout all the different pages and you’ve taken the user through a good narrative.

So to me it really covers the brief quite comprehensively which you’ve got to be pleased about. To me it’s just some really small changes around how you’ve creatively gone about this and your report would go to another level quite instantly.

Nice work

Sam