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

Challenge Updates
1

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

image

image

image

image
image1376×766 156 KB

image
image1372×753 156 KB

image
image1371×762 132 KB

image
image1372×759 148 KB

Here’s how Amal described it:

My report covers data for the last two years.
It is divided into 6 pages with a home page that navigates to the other report pages.

  1. The first page of the “Insurance Complaints Overview” report gives us a global view of the company’s insurance data, with KPI indicators: number of complaints, average duration taken to process complaints, percentage of clients satisfied, total reimbursements, percentage of new complaints or in progress complaints.
    Other visuals show complaints by state, by source, by date, product category, by type of complaint.

  2. A second page dedicated to customer details “Customer Performance”, in which I detailed the personal information concerning customers and I calculate their distribution by age, gender, social status.
    I also processed their satisfaction in a pie chart visual and displayed in a scatter chart, the correlation between the number of complaints and the duration of complaint handling for each customer

  3. “Complaints status changes” page from which I calculated the number of statuses , the duration in days for each complaint and I detail the evolution of the status associated with a complaint.
    I have prepared for this, two different tables for complaint details and complaint status history. it is by choosing a complaint in the complaints details table that you will see the history details on the other table.

  4. In the “Broker Performance” page, I tried to focus on the worst brokers in terms of complaint management: for example, I displayed those with more complaints, with more number of customer unsatisfied, or those who take much longer to handle complaints

  5. The “Reasons for Complaints” page details the categories of complaints, and I tried to highlight the categories with the highest number of complaints.

  6. In the “Type Product Insurance” page, I detailed the complaints by category, sub-category and product.
    I showed for example the top 5 categories with most complaints and other very relevant visuals for decision making.

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.

power-bi-chal-1

1 Like
2

Very cool submission here. You’ve really gone all out with the colors. Very bright and bold.

I’m not sure if all the colors work well together but you’ve certainly given it a shot and I commend you on that.

Also you’ve really provided all of the insights I think any stakeholder would want from the particular scenario that we were working with.

Just a couple of things to have to think about.

Think you want to make sure that your visuals all align in some way. Like on some pages you have a random card just out there by itself and then other visuals and backgrounds bunched together so there’s not as much continuity as you would probably want to make this more compelling.

image
image898×280 116 KB

Maybe just have a clearer picture in your mind of how you want to represent the data and the story that you want to tell throughout your report. Sometimes before I jump into my design I think about it, and draw it out, so that I have a good feel for what I want to represent.

Also don’t feel that you have to place every single piece of data in your report page, sometimes you can showcase all the things you need to in a much more compact and similar way. It just takes a bit of time thinking about it and then implementing something creatively.

Well done on your work here, it seems like you’re really coming at all nicely with power BI and starting to really get the hang of all of the great features and techniques available to us.

Sam

1 Like