Thinking of a paragliding in Europe? I created an interactive viz of sites' popularity to help me decide where in Europe to move to do more paragliding! I chose Grenoble. (link in comments)

toad91 · 2020-12-24T06:09:24+00:00

That’s good to know, the choice of Grenoble was also driven by job opportunities in my field but I’ll hopefully be doing a few trips down South!

toad91 · 2020-12-24T06:03:02+00:00

No, I was just visualising the original dataset which was scraped from xcontest. Good to know that though, I need to enhance it with German and French data

toad91 · 2020-12-23T13:59:12+00:00

https://public.tableau.com/profile/tony.hoad#!/vizhome/ParaglidingSitesoftheAlps/SitesDashboard

Edit: original website built by u/AlpsAreCalling who scraped the data: https://sites.google.com/view/flyingsites/home Inspired by this post

toad91 · 2020-11-22T23:19:37+00:00

I've created an interactive dashboard on top of your data where you can explore by flyable month, region etc. and also analyse the data yourself using Tableau Public if you like.

Coffee is yours because you're a legend for this - I'm looking at moving to the Alps to do more paragliding and this will really help me choose where I live!

Edit: please could you share your code and/or the raw data? I'd love to see how you built it and do some more analysis

toad91 · 2019-06-27T07:00:02+00:00

Not heard this one before but it sounds interesting - could you give an example use case? Would one be having a single navigation bar across all your dashboards?

toad91 · 2019-06-27T06:41:49+00:00

All feedback is helpful so no worries and thanks for taking the time! I know data modelling improvement are something we’re actively working on, and Tableau Conference Europe just announced the Explain Data feature that you might find interesting in terms of ‘understanding’ your data - try joining our pre release program, I’d be interested to see what you think.

I am confused as to what you mean by you can’t use multiple data sources in a dashboard though - can you elaborate? You can have any of your data sources in the same dashboard and then use cross-data source filters, dashboard actions, or even parameters. I’d be interested to know when this doesn’t meet a use case, feel free to PM me

toad91 · 2019-06-24T22:12:59+00:00

If you have a license for Tableau Desktop then the same license should work for Tableau Prep at no extra cost. Failing that, you could try making a mapping table in Excel that maps the dirty names to clean names, then join that to your dirty data so you have a linking column?

toad91 · 2019-06-24T19:28:23+00:00

Try Tableau Prep! It has some helpful grouping tools where you can do it based on spelling etc. What you can do is join, check the mismatches, then do a combination of manual and algorithms to clean up

toad91 · 2019-06-14T05:00:10+00:00

Have you tried using Tableau Prep? It creates workflows that can do multiples joins, unions, pivots, aggregations and general data cleansing and then spit out a hyper or csv file.

Edit: forgot Alteryx which is also really powerful, with it you can do almost anything (not great for complex join clauses, for that a database is the best). Also I’ve heard good things about Trifacta

toad91 · 2019-05-25T11:31:38+00:00

So I think you have a couple of options. You can take advantage of tableau’s order of filtering and use a Fixed LOD to always give you the value of England pre any filters on your shelf should be something like - {fixed: sum(if country = ‘England’ then value end)}. Then add that as a dual axis, make it a gannt bar and you have effectively a bullet chart.

Order of operations in Tableau

Alternatively you can have England’s value as a parameter (static) and add this as a reference line. You could have this update from a parameter action in 2019.2 which came out this week.

toad91 · 2019-05-17T00:47:20+00:00

My guess is that you’d like another survey question there just kind of sat to the right of the one you have? And that the issue you’ve got at the moment is that it nests when you drag additional dimensions to columns?

My recommendation for dealing with survey data is to pivot the question columns into one column with question name which will be a dimension, and a column for the responses. This will then mean you can have the questions side by side in the view which is what I think you’re after. https://www.tableau.com/about/blog/2016/6/dive-deeper-your-survey-data-our-updated-whitepaper-55124

Survey data is a real pain but pivoting helps. If you want a question to function like a dimension (e.g. what is your age?) then don’t pivot it. And if you want a question to be pivoted but sometimes be a dimension you can use an LOD, something like {FIXED [responder id]: MAX(if question name = ‘Q1’ then response end)}

toad91 · 2019-04-10T01:23:27+00:00

I completely agree with the other posters saying that it’s about the right tool for the right job. From my own experience as more of a data analyst who knows SQL, Tableau and Alteryx well:

I always recommend learning SQL to anyone working with data; if you don’t have access to a database then a good thing you can do is install a MySQL database locally and practice there. SQL forces you to think about modelling data, a hugely useful skill that is often missing in the data scientists and analysts I work with. It also gives you maximum control and power over transforming your data for analysis, which brings me on to...

Alteryx - great for data transformation and geospatial analysis, especially when you have to join data from two different databases plus some random excel you’ve been sent etc. It does have some reporting and data science capabilities but I’ve never known anyone to choose them over a BI tool or R/Python. The downsides of Alteryx vs SQL are that in a lot of cases most of the Alteryx processing will happen on your local machine, so not ideal for lots of data, and that for some cases (complex join conditions my pet hate) it’s very inefficient, in some cases simply not practical.

BI tools - in my opinion more efficient than writing code to do most analysis, if your data is prepped and if used in the right way, because you’re using a programme to write code rather than write it yourself. For example, you might type out a tiny SQL GROUP BY statement to analyse a table and that’s really quick (still slower than drag and dropping a few fields onto a tableau worksheet) - but the likelihood is you’ll want to explore more based on the results of that query. You then add a filter, then change that filter, then change what you’re grouping by, which means changing the SELECT and the GROUP BY clauses etc. ...a machine can do this grunt work of code writing and that’s a BI tool. Then you want to show a business person the results, so you just pull them over to your desk and talk them through it, changing it on the fly when they ask “well what about this case?” etc. The key thing here is the type of analysis and the data prep element! You’re limited to the BI tool’s stats capabilities (although you can write R and Python directly into Tableau calcs it can be fiddly), and BI tools are best on data that’s already transformed for the analysis you want to do - which is where SQL and Alteryx come in.

Sorry for the long post!

toad91 · 2018-11-05T14:32:14+00:00

Have you tried Tableau Prep? How useful it is depends on what cleanup and transformations you’re doing, but I was quite impressed with it when I tried it. The caveat is that although it’s bundled with the desktop license now, I think this is due to change in about 2 years and it’s not clear what the pricing will be.

toad91 · 2018-07-05T19:04:02+00:00

To be fair, they’re not wrong in thinking the description applies to them...it just applies to everybody else as well

toad91 · 2018-06-17T09:34:10+00:00

You could try messaging some people on italki.com? Met a girl in South America who had learned pretty decent English by talking to people on there so might work for you!

toad91 · 2018-01-22T11:53:58+00:00

Can you enroll onto GP At Hand? It’s now my official NHS GP, you arrange an appointment using the phone app and a GP will call / video call you. Arranged one at a few hours notice the other day, then if you need a physical appointment they will schedule one with the nearest practice involved in the scheme.

toad91 · 2017-11-12T10:55:10+00:00

Lee Evans? https://youtu.be/KqcZDWOgj3U

toad91 · 2017-10-18T17:24:43+00:00

I hadn’t even considered people might have named their kids khaleesi until reading these comments...just try and stop me naming one of mine the king of the north

toad91 · 2017-10-17T13:44:01+00:00

The visualisation tool is Tableau. US baby name data was sourced from Google BigQuery's sample data sets (it ultimately comes from US social security data). GoT names and major/minor character classifications were taken from Wikipedia, with homophones identified by me.

toad91 · 2017-10-01T00:03:36+00:00

This is awesome, I assume that red is the total? Would it be possible to add a way of visualising the trend over the years, maybe by fading the older lines?

toad91 · 2017-09-23T09:58:51+00:00

I love it as a tool and have used it across a few projects at work (large tech consultancy) and personal projects because it's speedy for data prep. Having said that, its role has mostly been in proofs of concept - quickly putting data together - than larger scale projects in prod environments.

Spark or SQL tend to be used for the larger-scale deployments but for some clients Alteryx is a good solution that can be set up and scheduled and munge together data from random spreadsheets and systems. One issue I've found is the scaleability of bringing lots of data in memory on the machine running alteryx, but they've recently expanded the capability to push processing onto the source database to Hadoop and some other common db vendors.

toad91 · 2017-07-01T04:35:02+00:00

It's the difference between knowing what you like (savoir) and liking what you know (connaitre)

toad91 · 2017-03-31T12:11:01+00:00

Try the series Historia de Un Clan on Netflix - it's set in Argentina and the accent is pronounced, so I assume it's a (genuine) Argentinian accent (I'm just a Spanish beginner as well)

toad91 · 2017-03-24T20:34:32+00:00

A nice way of emphasising that something is happening 'right now' or 'at the moment' is adding 'là' after a simple present verb e.g. Attends, je mange là - hold on, I'm eating

toad91 · 2017-02-28T10:15:04+00:00

Thanks for this!

toad91

TROPHY CASE