Power BI Challenge 6 - Insurance Complaints

@sam.mckay,

Even with all of the phenomenal reports and showcases you’ve produced over the years, I honestly think this is the single best one. The look is so simple, yet polished and gorgeous, the flow is intuitive and flawless (especially when you experience the web version), there is an enormous range of analyses available to the user yet it never feels crowded or overwhelming, and the global settings page is a fantastic idea. So much we can learn and take from this one. Amazing stuff!

  • Brian
3 Likes

Thanks Brian. Loved putting this one together. Really wanted to think outside the box and create something that showcased how incredible Power BI has become.

What an incredible group of submissions. Just blown away.

Every challenge, the quality just goes up and up.

Just shows you the power of the collective group we have, and how good a learning experience this initiative is.

I myself have been learning and been inspired but what’s been put on show.

Well done everyone.

Sam

3 Likes

@sam.mckay this looks really cool. Having watched a number of your videos, i know you are a fun of using grids in your reports but although you haven’t much of it in this particular one, it still looks great and very intuitive.
This has given me some ideas and I am glad to be learning and part of this challenge.

2 Likes

Couldn’t complete fully, submitting what I did so far under Newcomer category.
Insurance Compliants



8 Likes

@BrianJ Ah, that makes sense, I knew there was something I was missing there. Thanks! Though not sure I follow what you mean by mirror image top and bottom chart axes? Your entries are always really awesome!

@sam.mckay This Power BI Challenge idea is really awesome. When I mentor people with Power BI I hear often that they want some data to play with, and/or wait for a specific project to come up in work. This I think caters to both. There are many data sets available but they are always there so no real hurry. Whereas this data set is given with a deadline and objective like a project at work. And you get to see what others are doing with it at the same time, which makes it even cooler than an work project in my opinion!

3 Likes

@datazoe Yes I agree and the only difference with work projects is that you are given specific requirements and you don’t go all out with creativity or analysis. Sometimes people don’t realize that analytical dashboards are not created at the flip of a button and it takes hours and hours of efforts and concentration.

1 Like

Hi MudassirAli
Excellent work in the visual and organizational part. A very good history telling.
But the segmenters of chapter 4 (Complaints Status), I do not notice synchronization between them and the results of the table below.
If I choose a region and a State corresponding to that region, the other segmenters should only contain the brokers and customers for the selected regions, and I think it does not.
If I’m wrong, please excuse me.
Cordial greeting

1 Like

Jejeje
Yes, I joined today.

1 Like

Hi @alejos1971 Welcome to EDNA Power Bi Community and really appreciate your comments. You are correct that slicers were not synchronized. I made use of the filter pane but forgot to update the Clear Filter bookmark so what happened was all the changes were undone when I cleared the filter. Now everything is filtering everything. Thanks for pointing this out.

2 Likes

Hi all,

Hope you are doing great.

This is one of the best challenges yet from Enterprise DNA Team. I am so excited and I am learning a lot. Many Thanks.

For this report I created five pages containing insights such as:

  1. Yearly Overview
  2. Some Details
  3. Complaints Status
  4. Open Complaints
  5. Brokers

Any feedback is welcome

This is the Power BI file I’ve prepared.
Power BI Challenge #6.pbix (1.3 MB)

Here are some details about what I’ve done in this report:

I used a dark theme because I thought it is so attractive.

In the “Yearly Overview” Page, I placed some general information about the data, as well as “Number of Complaints Year to Date” using Time Intelligence function in Power BI.
I’ve also used Year over Year function to monthly show the percentage of changes in the number of complaints.

In the “Some Details” Page, I used a typical line chart for the number of handling days, but since it has a lot of details, I thought that maybe a categorical column named “handling duration” can practically explain the subject. So, I created a pie chart to summarize the line chart based on “handling duration”.
Since the population in each region is different, I decided to standardize the number of complaints in each region based on the population. Therefore, I created a column named “complaints in each region” and based on that created another column named “Complaint/10k Population” using the following formulas:

Complaints In each Region = CALCULATE(SUM(Customers_L[# Complaints for each Customer]),FILTER(Customers_L,Customers_L[RegionID]=Regions_L[Region ID]))

complaints/10K pop = DIVIDE(Regions_L[Complaints In each Region],Regions_L[population])*10000

and finally created the scatter plot in this page.

In the “Complaints Status” Page, I prepared two different tables for complaints details and complaints status history. By clicking on any row in the complaints details tables you can see the history details on the other table. I’ve also created a scatter plot showing the number of complaints per 10k population and used the number of replicates for each complaint for “Size” section. By placing satisfaction status in the “Legend” section, I is so easy to see satisfaction in each region.
I’ve also used drill-through option in this page so that from every other page you can drill through this page and find details.

In the “Complaints Status” Page, I used a scatter plot to show the number of complaints for each broker, as well as complaints status history and the percent of satisfied people.

Best Regards
Hossein

10 Likes

Very good.
And thanks for the welcome. :+1:t4:

1 Like

Hello everyone, I am still learning and would appreciate any feedback about my submission please

@Eze,

Great overall entry, and I love how you have your data model structured. Here are a few recommendations:

  1. If you are going to have a home page, make sure you either have a picture or a logo on it to help catch the viewers attention. I would also include a link for every page in your report on each slide, not just for the home page.

  2. I think that you had too many different colors incorporated into the report. I like that you had a dark black theme, but try to stick close to colors that go with your theme.

  3. The chart that you used to show the different levels of satisfaction probably would have better off using some kind of bar, or donut shape visual. I rarely use that type of chart unless I’m comparing something on a cumulative basis vs a daily basis. It looks real fancy, but most of the time doesn’t show a clear picture to the end user.

Thanks
Jarrett

1 Like

Hello @JarrettM,

I like the feedback and really appreciate it. Thanks for the input

2 Likes

My Submission to this challenge 6.
PBIX file attached.

Please try the link below and provide your suggestions and feedbacks:

EDNA challenge 6_Mohammed Ali.pbix (2.1 MB)

12 Likes

Wow very nice

1 Like

you produce such visually appealing work DianaB. Just so clean and beautiful.

1 Like

Very nice work here. Well done.