Тёмный

How to Make a SANKEY diagram for Free (Step-by-Step) 

Metabolism of Cities
Подписаться 29 тыс.
Просмотров 49 тыс.
50% 1

In this video you'll learn how to make a Sankey diagram from scratch, for FREE, even if you never coded before.
If you want to know more about what is a Sankey diagram see this video before ( • What is a SANKEY diagr... )
To make the Sankey diagram, I use www.sankeymati...
If you want to be able to feed information on SankeyMatic through GoogleSheets you can use this template: docs.google.co...
I hope you'll find this video useful. Don't forget to like this video and subscribe to our channel for more videos.
#sankey #sankeydiagram #datavizualisation #sankeychart
-------------------------------------------------------------------------------------------------
💻 For more information about Metabolism of Cities (visit metabolismofcit...) and make sure to subscribe to our newsletter 📧 metabolismofci...
🎓 Take one of our online courses on Urban Metabolism 👨‍🎓👩‍🎓(education.meta...)
📊 Have a look at our Metabolism of Cities Data Hub - for all data about urban resource use and pollution flows 💡🚿🏭🚚🚂🍏♻️ (data.metabolis...)
📌 Subscibe to our RU-vid channel for more videos on Urban Metabolism
📌Follow us on Twitter - / citymetabolism
📌Follow us on Instagram - / metabolismofcities
📌Follow us on LinkedIn - / 18773645
#urbanmetabolism #materialflowanalysis #circulareconomy

Опубликовано:

 

7 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 74   
@GerryIGF
@GerryIGF 7 месяцев назад
That's really one of the best explanations of how to make a Sankey! Thank's a lot! Nice Job! 😁👍
@myllasunaya3871
@myllasunaya3871 2 года назад
Thank you so much! This is so helpful, currently, I am doing my master thesis about plastic recycling and your video helped me out of desperation how to visualize my data better for my supervisor 😄 Best of luck for you and wish me luck for my master thesis
@MetabolismofCities
@MetabolismofCities 2 года назад
Thanks for your comment Mylla. Glad this helps. Fingers crossed for your thesis🤞
@jesusislordandgodislove6065
Thanks so much for the helpful tutorial, it saved after long struggles with R
@r3albuzz
@r3albuzz Год назад
Thanky you. Had a really hard time finding a software for a simple creation of sankey diagram without much effort.
@patricion.3607
@patricion.3607 3 года назад
Sankeymatic seems like a great tool. I think it will save me the money I was planning to expend in e!Sankey. Thank you very much
@MetabolismofCities
@MetabolismofCities 3 года назад
Nice to hear that you found it helpful Patricio. There are plenty of great tools out there (rawgraphs.io/ is another one) that are free to be honest. Good luck on your Sankey endeavours.
@patricion.3607
@patricion.3607 3 года назад
@@MetabolismofCities Awesome. Thanks again and keep up the great work with the channel and webpage!
@MetabolismofCities
@MetabolismofCities 3 года назад
@@patricion.3607 🙏 thank you for your kind comment. Do share your Sankeys when you're done.
@sakarihoysniemi4936
@sakarihoysniemi4936 2 года назад
This was a very helpful tutorial, thx! I would be interested to see a follow up to this on how to finalise Sankey with Adobe Illustrator or related program. I liked those isometric graphics of London in particular in other video.
@MetabolismofCities
@MetabolismofCities 2 года назад
Many thanks Sakari! Good point. Ok this will go on the list for future videos.
@signalmas5673
@signalmas5673 2 года назад
I found this VERY helpful. It took me a bit to find the proper name to the SANKEY or flow diagram. I started by searching images for “ribbon graphs”…. Eventually I got here and you have a new subscriber ! I can’t wait to put it in use, my use case as a finance person is to explain P&L to non-finance people.
@MetabolismofCities
@MetabolismofCities 2 года назад
Thank you Signal. Yes indeed hard to find it. Another way to call it is alluvial graph. Glad to hear that it will be useful in your work
@aubreyp.muswema3053
@aubreyp.muswema3053 2 года назад
Amazing tool. Material flows are a very interesting topic to guide intervention points where local governments can vary management option scenarios! Sankey diagrams helps with this easy visualization - a picture is worth a thousand words…
@MetabolismofCities
@MetabolismofCities 2 года назад
Thanks Aubrey! We have another video on Material Flow Analysis if you're interested ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UNuXWhFAJTc.html
@bohzapata9665
@bohzapata9665 8 месяцев назад
Just dropping a line to thank you for your tutorial. Very interesting indeed
@MetabolismofCities
@MetabolismofCities 8 месяцев назад
Many thanks!!
@teddy.graphics
@teddy.graphics Год назад
Thank you so much for explaining and sharing your google spreadsheet 🙏🙏🙏
@MetabolismofCities
@MetabolismofCities Год назад
Glad it was helpful!
@renukakulkarni1604
@renukakulkarni1604 2 года назад
Hi this is so helpful!! Thankyou for such a detailed tutorial!
@MetabolismofCities
@MetabolismofCities 2 года назад
Hi, very glad you found this helpful! Enjoy making Sankey diagrams!
@miguelalvaradojuarez1339
@miguelalvaradojuarez1339 8 месяцев назад
Thanks for the great explanation you have made
@bymmijprime281
@bymmijprime281 6 месяцев назад
This easy to follow and works well. great video and thanks for sharing!
@muhammadikhsantaipabu6385
@muhammadikhsantaipabu6385 2 года назад
Thank you so much for such a helpful tutorial.
@MetabolismofCities
@MetabolismofCities 2 года назад
You're very welcome! Glad it helped!
@tahirhanif9669
@tahirhanif9669 Год назад
Excellent presentation, thank you
@Shaunhodges
@Shaunhodges 2 года назад
Thank you for the clear examples of tools and how to build a Sankey diagram. Very Helpful! :)
@MetabolismofCities
@MetabolismofCities 2 года назад
Thanks for your comment Shaun! Glad that it was helpful!
@siddharthrajagopal4369
@siddharthrajagopal4369 2 года назад
Thank you, found this very helpful. Was always curious how these charts were made.
@stefanharms8157
@stefanharms8157 2 месяца назад
Just awesome - Thank you!
@nororavoavahy7400
@nororavoavahy7400 Год назад
Really, really helpful. Thank you so much for your good teaching !
@gabrielleavena1295
@gabrielleavena1295 2 года назад
So helpful, thank you very much!
@MetabolismofCities
@MetabolismofCities 2 года назад
Thanks Gabrielle, very glad it was helpful! Hope that you will be able to do your own Sankey diagrams.
@silencedbaktta
@silencedbaktta 2 года назад
A big thank you!
@MetabolismofCities
@MetabolismofCities 2 года назад
Our pleasure! Hope you're going to have fun doing you own Sankeys.
@amneal81
@amneal81 Год назад
Super helpful. Thank you so much for this tutorial.
@youtimeful
@youtimeful Год назад
Fabulous Video!!! You are a live saver.
@MetabolismofCities
@MetabolismofCities Год назад
Glad it helped!
@kristinayolanda2914
@kristinayolanda2914 2 года назад
thanksss a lot! this is so helpful!!
@MetabolismofCities
@MetabolismofCities 2 года назад
Thanks Kristina. Glad it helped!
@user-gs8pm5wi7p
@user-gs8pm5wi7p Год назад
This is helpful.Thanks for such a detailed tutorial~
@MetabolismofCities
@MetabolismofCities Год назад
Great to hear it is helpful!
@noumbissieleonel8778
@noumbissieleonel8778 Год назад
Thank you, very helpful!
@MetabolismofCities
@MetabolismofCities Год назад
Glad it was helpful!
@charleskuhn382
@charleskuhn382 2 года назад
Thank you for a great tutorial!
@MetabolismofCities
@MetabolismofCities 2 года назад
@Charles Kuhn Glad you enjoyed it. Hope it will help you in your future endeavours.
@beingsentient
@beingsentient Год назад
Metabolism of Cities, can you give me a quick comparison of Google Sheets to the latest version of Microsoft Excel? Many thanks for an excellent video.
@MegaFiredon
@MegaFiredon 19 дней назад
How about creating a Sankey TV App with an M3U8...
@puppiesrawesemz97
@puppiesrawesemz97 2 года назад
Thanks for the great videos! Came here after seeing the What is a sankey Diagram video? I'm currently working on a project to visualize energy flows where they use Sankey Diagrams and I'd never heard of them. They're quite confusing to a layperson who's never seen one before or have little knowledge on the subject! Your videos really helped clear it up. One question I had was more general to Sankey diagrams, rather than building it in SankeyMATIC, but I'd love to know if it's possible to do it in the software. I found it confusing that the nodes aren't labelled aside from what the specific one is. For example when you spoke about imported and natural resources, those nodes are describing how energy is collected (in-country or out of country). Or when listing housing, taxes, etc. Those are your costs. Same with "gold, silver, copper" those would be materials. Is there a way to add these category labels for the group of nodes? I feel this would improve user experience to give an idea of what we're talking about at each node stage. Do you agree? I'd love to hear your thoughts. Another quick question is about units that the flows are measured in. Is there a way to show the unit somewhere? Eg. money and currency, energy, weight, etc. Thanks for such a great video! Looking forward to learning more
@joshuaknight1748
@joshuaknight1748 2 месяца назад
Hsve used sankeymatic a few times, but today found out some limitations. I don't think you can have more than four nodes in series. It throws up a "text not recognised" error.
@PECL-ds3pl
@PECL-ds3pl 3 месяца назад
Hi sorry do you know if it is possible to not have the number if all are [1] ?
@ebbiekalan8753
@ebbiekalan8753 2 года назад
Very helpful!!
@MetabolismofCities
@MetabolismofCities 2 года назад
Many thanks Ebbie!
@GeorgeRamrod
@GeorgeRamrod 2 года назад
Πολύ καλος!!
@jingyang9740
@jingyang9740 Год назад
Hello, this is very useful - Do you know if Power BI could create circular flows like ifu's e-sankey? Many thanks!!
@MetabolismofCities
@MetabolismofCities Год назад
Many thanks. Not sure about Power BI, not a big user.
@MrBHGuitar
@MrBHGuitar Год назад
What could we do to have SankeyMATIC supporting circular mass flows? Now any circular flows go towards the output side of the node. I would rather see them at the input side of the node...
@MetabolismofCities
@MetabolismofCities Год назад
Unfortunately, this is a downside of SankeyMatic, it can't do circular flows. You can try to contact its creator for some help (I think this feature is in the pipeline but don't know when this would be available).
@pmmpp3578
@pmmpp3578 Год назад
Thank you. I do also like the software you prepared your tutorial with, what's the name?
@-igor-
@-igor- Год назад
Must be Excel :)
@nitinkolhe1
@nitinkolhe1 2 года назад
Thank you. Very useful. However, there is an issue that Sankey diagrams adds everything if the names of the nodes appear twice. For example: IF i have to look at death rate in each London, East Midland, West Midlands and so on, the death rate is added. Is there a way to avoid that please
@MetabolismofCities
@MetabolismofCities 2 года назад
Thanks Nitin! Yes, indeed that is a problem with SankeyMatic it cannot make circular flows. However you can reuse the same nodes (as destination and not targets), if you for instance use a small symbol before or after. For instance write London_In and London_Out. You can then click on remove the labels and add them in another software (for instance ppt).
@Kimberley6595
@Kimberley6595 2 года назад
Thank you for the video, do you know how to control the order of the nodes?
@MetabolismofCities
@MetabolismofCities 2 года назад
Hi Kimberly, thanks for your comment. The order seems indeed quite random. You can reorder them by dragging them to a higher or lower position (some patience is needed). Be careful though, only do this once you have finished inputting the data and previewing the diagram (else the nodes will be rearranged and you will have to start all over). Hope this helps
@Kimberley6595
@Kimberley6595 2 года назад
@@MetabolismofCities thank you!
@Sciencefriend
@Sciencefriend 2 года назад
Thank you very much! (How?) is it possible to build subcategories e.g. under hobbies?
@Sciencefriend
@Sciencefriend 2 года назад
Problem solved! :-)
@MetabolismofCities
@MetabolismofCities 2 года назад
@@Sciencefriend Good to hear! Did you just add Hobbies [ x ] Hobby 1 ; Hobbies [ x ] Hobby 2 ; etc. ?
@Sciencefriend
@Sciencefriend 2 года назад
@@MetabolismofCities Yes, I thought so. However, it still doesn't quite work out. Let's say I have an income. The income splits into taxes and net. With net again a branch goes away for example in cars. This should then branch out again to the right in the graph into Car 1, Car 2, Car 3. I can't get the split in the graph to open to the RIGHT. I always get car 1 to car three on the left side. Idea? What am I doing wrong? thx a lot
@MetabolismofCities
@MetabolismofCities 2 года назад
Hmm let's see so here is the code we would propose, does that work? Income [1000] Net Income [250] Taxes Net [400] Car 1 Net [400] Car 2 Net [200] Car 3
@johannes21e6
@johannes21e6 2 года назад
Can it be automated that the remaining money goes to savings?
@MetabolismofCities
@MetabolismofCities 2 года назад
It would be possible but not through this software. You would need to code this (for instance python) and have the variable savings be automatically measured based on the other variables and then plot it. There are some nice libraries to plot Sankey diagrams in python
@johannes21e6
@johannes21e6 2 года назад
@@MetabolismofCities thanks! Just searching for phyton library Sankey?
@MetabolismofCities
@MetabolismofCities 2 года назад
@@johannes21e6 you can have a look at this one for instance plotly.com/python/sankey-diagram/ (else for simple Sankeys seaborn library might be enough)
Далее
Новый хит Люси Чеботиной 😍
00:33
Here's The Secret How To Create These Animated Diagrams
11:12
What is a SANKEY diagram (+ examples) ??
8:04
Просмотров 24 тыс.
SANKEY DIAGRAM TABLEAU
19:42
Просмотров 428 тыс.
Post Growth - Life after Capitalism (Tim Jackson)
44:44