3 ms·
Congrats Matt! Very cool to see. A question. I'm trying to find a tool to visualise and document the evolution of obscure sports (purely because I find the int
by sails 4y ago
Congrats Matt! Very cool to see.
A question. I'm trying to find a tool to visualise and document the evolution of obscure sports (purely because I find the interactions fascinating). It seems that your tool might be the perfect fit, especially the "writing" examples. I was wondering if it would be possible to visualise something along the lines of a quasi-directed graph. Nodes being specific instances of the inception of a "new" sport (hence the date requirement), and edges being the influence on other spots. Multiple edges for each node are possible, and all sports will have a start date and some an end date. I tried[2] with a basic POC but it seems the issue is that the nodes run without an end date, which breaks the dependency visualisation.
One comment. Once logged in I wasn't easily able to get back to the landing page, which had some useful info around visualisation types that I wanted to review.
And a note. I've apologised to a few people who I subjected to a variation on your SQL screener interview question [2], which contained far too much fiddling with SQLite time functions, entirely my mistake in ruining an otherwise great basic SQL test!
[1] https://www.preceden.com/timelines/868890-obscure-sports?s=e0d469326e067313 https://www.preceden.com/timelines/868890-obscure-sports?s=e...
[2] https://mattmazur.com/2018/11/12/analyzing-89-responses-to-a-sql-screener-question-for-a-senior-data-analyst-position/ https://mattmazur.com/2018/11/12/analyzing-89-responses-to-a...
- matt1 4y agoGlad you found that SQL screener interview question helpful and sorry if the date/time manipulation made it more complex than it needed to be :). Regarding the visualization capabilities: I would change the shape of the events from a line to a solid bar. When you combine that with the connections (which you're already using) it will look more like a directed graph like you're interested in. End dates are optional for events, so you should be able to get by with or without it. Happy to discuss more over email: help@preceden.com. Regardless, good luck with your visualization, it's a fascinating use case.
- sails 4y agoThanks, I think the gant format might be too restricting in the end, but I'll see how far I can get.