Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
01-24-2018 20:55 PM - last edited 11-26-2018 17:56 PM
I was interested in this topic after seeing data surrounding North Korea's progress in missile technology. The country also launched two missiles over Japan in 2017 and was in the news a lot. While the country first tested a nuclear device over a decade ago, it now has the capability to launch missiles much further than it could at the end of 2016. View the report to see how far each missile can reach as well as some potential cities around the globe that could be in range.
A few notes:
1) The color selection is meant to evoke a military feel.
2) I used DAX to calculate the sample trajectories of test launches and displayed them using the line chart. By including a reference to the where the ISS orbits, viewers can see how high certain missiles travel (much higher than I expected).
3) The image sliding over the map makes use of the What-If parameter, HTML Viewer custom visual, and the Flow Map custom visual. I wanted to see if it was possible to build a before/after image comparison without having to build a brand new custom visual. This help show the flexibility of the HTML Viewer.
4) Bookmarks are used to navigate using a consistent arrow in the top right corner.
Data came from a few different sources (also listed with direct URLs on the last report page):
1) Missile launch data was obtained from the CNS North Korea Missile Test Database, a collection of statistics about North Korea's missile tests (launch date, missile name, missile type, distance, apogee, etc.). Available via the Nuclear Threat Initiative (NTI). The PBIX directs to the web version of the CNS North Korea Missile Test Database rather than a local file.
2) Air distances from Pyongyang to various international locations were compiled from https://www.distancefromto.net/ using latitude and longitude, and the resulting data was posted as a dataset to Data.World. The PBIX pulls the data from Data.World as a result.
3) Various statistics about the Hwasong missile types were obtained from Wikipedia (max estimated range in particular).
4) One local Excel "helper" source file facilitates the image over map slider (ImageComparison.xlsx available here: https://github.com/deldersveld/pbiImageSlider/blob/master/ImageComparison.xlsx).
eyJrIjoiN2Q4YWMzZTYtOTA0Ni00MjIzLTlhNTgtMjE0OTQwY2U1MjA5IiwidCI6ImFjYzhhYWE1LWYxOTEtNDgyZi05MjFiLWNmNmMzM2E1ODgzMiIsImMiOjF9
Good and interesting post, thanks. I guess there are very few things we know about North Korea, it is very closed and specific country, welcomes zero tourists and restricts it's citizens from visiting other countries, too. Everything I know about NK I owe to travel books and some documentaries, and of course I would like to know more.
Awesome data storytelling!
And great use of DAX/PowerBI visuals' features!
Well done!