Power BI Challenge 10- Supplier Insight

This is my first submission. I learnt a lot of things by participating this challenge. Thanks for EDNA for hosting this challenge.

I used 1 report for showing most important metrics.

6 Likes

I am new to Enterprise DNA and new to Power BI. There are some fantastic submissions that have taught me more about the potential of Power BI as a biz intelligence tool and give me some great ideas about different charts and how to effectively present data.

If appropriate, I would offer the following as a topic of discussion: How do we determine if something is the best or worst item in a category? In other words, if we have two suppliers and one has 15 million total defects and another has 8 million, is the second supplier better than the first? Or do I need to add context and convert it to a comparable measure? In my experience, “Total” figures are only relevant if everything else is equal. Not properly adjust totals to “per…” measures usually leads to incorrect business decisions.

So if a dashboard is using a ‘Total Defects’ or ‘Total Downtime’, is that the best indicator of which vendor or plant is the best/worst?

2 Likes

20th Dec 2020 will be my one year anniversary of learning PowerBI.

Here is my submission for this challenge 10.
I have considered two key metrics for this challenge: total defects and the total downtime that these defects caused. With that, I have created Treemaps to understand who are the worst vendors (top 10), with respect to downtime and identify which plants do a better job finding and rejecting defects, to minimize downtime (top 10). Any feedback and suggestions are most welcome.

As always, so many excellent submissions to learn.

7 Likes

That’s incredible. You just took Power BI reporting to a another level. I didn’t even think this was possible.

2 Likes

I liked your design. It’s very clean and easy to understand. Sometimes I feel like less is more.

Yusuf.

1 Like

This time I combined Adobe Photoshop, Power Point, Custom Visuals & Charticulator Visuals. Oh wait, yes Native Visuals too :smile: Thanks to my brother who helped me in some design aspects of the report.

I found this one very challenging not because of the complexity of the analysis but how to present the required analysis. So here is my submission for Challenge # 10.

17 Likes

@marieke Good work in this challenge. The color theme looks pretty cool and the navigation in the report is a breeze. I feel the colors in the Bar charts are somewhat overwhelming so you can try to reduce the number of colors in a visual. Overall a good report with good analysis. :+1:

@Greg The design of the report is somewhat similar to your previous challenge and I like the Navigation at top that looks pretty cool. You have become a master of using smart narrative visual and I still use Card Visuals with Text Boxes :smile:. The level of detail is great in the report and the explanation is awesome as usual. Thanks for participating in the challenge again :+1:

@MudassirAli Wow! Your report is so very cool! It looks amazing, and all the analysis is amazing. I really like the cost per downtime hour especially.

2 Likes

Mind blowing report @MudassirAli! Wow! Design pushed to the level of art! Well done! :clap: :clap:

1 Like

Everything is possible with Power BI, there are a lot of amazing reports in this challenge, every report is different from one to another, everyone has their own style and their unique ideas to present their solutions and that is the beauty of this challenges.
looking forward to see your amazing report for the next challenge.
Thanks @YusufGillani for your lovely feedbacks !!!

2 Likes

Yup … I’m falling into a “style” hole (that’s a good thing for production reports, I think … not so much for challenge entries …)

2 Likes

Hello All

Please find attached my submission;

This is about my 5months into PowerBI and I can only say I am here to learn.
Looking at the other submissions, I know I have a lot of ground to cover and looking forward to learning more.
Any comments on this will be greatly appreciatedSupplierAnalysis.pbix (580.8 KB)

4 Likes

@Rachwen_Mesbehi This is just extreme creativity. It’s probably not so difficult to get the theme you selected but very difficult to match the visuals with the theme of the report which you did magnificently well. Which Text format did you use? Is it native in PBI or you imported the texts after designing in Power Point?
The only thing I feel there are many visuals clustered in a page that makes it somewhat difficult to focus and to get the flow of the story. Maybe the difficulty level is set as Veteran?

I’m stuck for superlatives, your report is stunning!

1 Like

Beautiful report!!! Great Visualization

1 Like

Thanks @MudassirAli for asking this good question, Indeed, I wanted to create an incomplete report (a lot of colors, a lot of disorganized visuals, and also a lot of ugly buttons and shapes) all of this in order to simulate the problems that faced this industry in that period (80’s) when the developers were struggling with a lot issues even after they launched the final product (Bugs , glitch and many other things), but after all this we see that this industry has developed and has had a lot of success, all this begins with a small step, we are still learning and developing our Skills everyday and this is really nice.
About the Text Format, I designed all texts from this website https://www.pixilart.com/

PS: After I saw your amazing entry, I think I’ll add a “Veteran” Button linked to your report .
Thanks
Rachwen

1 Like

Hi DataZoe,

How did you make that Slicer menu. That’s a really good idea.

Yusuf.

1 Like

Hi @YusufGillani to make the slicer menu what I did was the following:

  1. Insert → Shapes → Rectangle to the page and size it to where you want the panel to be.
  2. Turn off the fill, make line fully transparent, and turn on the background (color that the panel color you want).
  3. Open the selection and bookmark panes, View → Bookmarks and View → Selection (the selection pane allows you to specify the z-order, or which objects are on top of others, on the page, as well as hiding and showing of objects.
  4. Add slicers and place them on the panel. If you are using existing slicers, you will need to order them higher than the panel in the selection pane so they are “on top” of the rectangle shape.
  5. I typically make them dropdown slicers, with search turned on, and no background, but you can format however you like.
  6. You can also add text boxes – you get the idea!
  7. Now I add two buttons, one to hide and the other to show the panel. I like to keep these in the same place off the panel, so I user can simply toggle the panel without moving the mouse. Insert → Buttons → Blank, then turn off icon, outline, and background. Turn on fill. I go get a menu icon from remixicons.com and click on “add image” (in the fill section). I also like to have default state a lower transparency than the hover state, and also add a background color on press state.
  8. Now all the pieces are created so we need to get it working. In the selection pane, hold down ctrl and click all the visuals that are part of the panel and one of the buttons, right-click and choose group. This group should be at the top of the selection list, and the other button should be directly under it.
  9. click on the group in the selection pane and add a bookmark. Click the “…” next to the bookmark and choose “Selected Visuals” so it now has the green check mark, and choose “Data” so it loses its check mark. This is super important! You can double click the bookmark to rename it, and rename it “Show panel”.
  10. Now click the little eye for the group to make it invisible on the page, then making sure that group is still the only visuals selected, make another bookmark. Same as before, “selected visuals” only and uncheck “data”. Rename this one “Hide panel”.
  11. On the button outside of the group, click that one and add it’s action to be the bookmark “show panel”, and you can specify the tooltip as well, which I usually name “show panel”.
  12. Ctrl-click the button to show the panel.
  13. On the button inside the group, click that one and add it’s action to be the bookmark “hide panel”, and you can specify the tooltip as well, which I usually name “hide panel”.
  14. Now you can ctrl-click that button to test it, which should cause the panel to hide.

That’s how it’s created :slight_smile: Making sure your “Data” is unselected is very important or the slicers will reset when the panel is triggered which defeats the whole purpose.

4 Likes

Wow very impressive work

1 Like