Latest Enterprise DNA Initiatives

Power BI Challenge 10- Supplier Insight

Hi @ErikaLoz,

Welcome to the challenge.

Currently there is no further data available, all plants are in the US.

Thanks,
Haroon

HI
when I plot the “Lant Location” and a map, the values for “Venice” and “Reading” it show me in Europe (Italy and UK, instead of USA Florida and Pensilvania)
Is there any way to force them to the correct geographical location without modifing the raw data supplied?

I attached the screen capture of the map viz

Thanks
Luca

1 Like

Hi @LucaB72. Shouldn’t be a problem … just add a new column for “Country” to your [Plants] table, set it to “US” and then add this to the map. Without latitude and longitude Bing maps tries its best but can easily give the wrong answer when place names are not unique (e.g., Venice, CA and Venice, Italy). Hope this helps. Greg

3 Likes

To add to @Greg’s comment, you may want to add “State” as well. There are several States that have “Venice” as a city.

image

Thanks
Jarrett

3 Likes

First timer on the challenge. I have been trying to make sense of the defects number, is there a base to compare the number of defects?

Just wanted to give a big :+1: to all the first time Challenge participants jumping in on this thread. Always great to have new entrants participating in the Challenge!

Also, as @haroonali1000 mentioned, every Challenge we offer some great prizes to the first-time eDNA member entrant judged to have the top entry:

  1. a copy of the Definitive Guide to DAX, 2nd Edition (the indispensable "bible"of DAX) or your choice of any other book from the eDNA Forum Recommended List ; or
  2. a copy of SnagIt 2021 , a do-it-all screen capture and graphics tool used by the members of the expert team for screen grabs, annotation, gif and video generation, photo editing, etc. @nick_m got me hooked on this, and it has a million and one uses for Power BI report development; or
  3. a four-month subscription to FlatIcon.com - this is an online service with millions of downloadable and editable icons that you can use to really polish your Power BI reports.

When you submit your entry, just be sure to include that you are a first-time participant.

Good luck to all! Can’t wait to see your reports.

  • Brian
3 Likes

Challenge accepted!

5 Likes

You mean Florence not Venice as Venice doesn’t exist in the dataset.

Yes, sorry my mistake

as suggested I created a hierarchy on the plant location adding Country (all with USA) and State, but still when putting on thr map it does show me values in Italy and England.

any suggestion?

Thanks
Luca

Map:


Table Values:
Links:

1 Like

@LucaB72,

The best option would be to go on google maps and get the Latitude and Longitude for each of the plants ( Based on City & State) if you want it to show up correctly. May be a little extra work, but it will get the results you want.

Thanks
Jarrett

1 Like

Hello guys ! any tips and tricks for the dashboard visuals ?
I’m a little bit lost when it comes to show the metrics, KPIS…

@amira.bedhiafi.pro
The basic rule for KPI is to show the current status, previous status (year , quarter , month or day) and the trend. You can refer to the following video for step by step guide to create a KPI.

However, if you are looking for amazing KPI visual, check the challenge # 9 report by @alexbadiu here

Thanks.

4 Likes

@LucaB72, I do not know if you succeeded to do the changes you wanted. Another way of tacking this problem is simply replacing values for the incorrect plants location in Power Query.

1 Like

Thanks,
I solved using the Longitudine and Latitudine.
I went to google maps and quickly pick them up.

Lesson learned for me that there are different Lat/Lon convention, the Bing map in Power BI work with the Longitudine in negative format.

In this way have an unique identifier and pick the correct city in case of same name for different ones.

Luca

Attached an extract of the table with few of the Lat / Lon : LatLon

3 Likes

Hi,

I’ve been using Excel all my life. I’ve just got into Power BI about 4 months. I’m having issues with designing the dashboards. It’s not something I’m used to doing. Anyone got any tips on how to make my report look really snazzy?

Supplier Insight.pbix (287.0 KB)

4 Likes

@YusufGillani,

It looks like you’re off to a really good start here. You’re clearly addressing the questions in the brief, and you’ve got a nice clear, gridded organization to your report.

In my opinion, the best possible resource for improving your design and visualization skills is the Enterprise DNA Challenge Showcase. This compiles all the previous entries to past challenges in an easy to browse format, so you can quickly identify the ones you like that may have techniques, color schemes, designs, etc. you can adopt in your report to polish the look of it.

Starting at about challenge 3 or 4, the entrants began drafting very detailed writeups explaining how they implemented their reports. These are phenomenal resources for improving your design skills, and you can also download all the PBIX files to dig further into how they did it.

Big kudos to you for jumping into the challenge after just four months of working in Power BI. You’re clearly picking it up quickly, and participating in the challenges is one of the fastest ways to further improve your skills.

I hope this is helpful. Good luck!

  • Brian
3 Likes

@YusufGillani Adding to the great advice by @BrianJ, you are way ahead and can probably do more analysis.

Don’t try to put all the analysis in one page. Try to divide the page in 3 or 2 sections and create an analysis per section that should complement other sections. For e.g. you showed the card visuals on top that’s the first section. In the second section, try to focus on the worst performers rather than showing all the vendors, category and material type. The third section might be where you can show the trend of defects or downtime. Keep it simple and make separate pages to tell a different story leading up to the main story.

Try different visuals and ditch the table visual. Choose color patterns, preferable one to three or one with a family of colors. For color inspiration, you can check out the reports in other challenges.

Best of luck for your report!!

3 Likes

Thanks Brian. Much appreciated!

Thanks Mudassir! Thanks for your support.

1 Like