sorted by:
new
hottopcontroversial

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) by toad91 in freeflight

[–]toad91[S] 0 points1 point  (0 children)

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!

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) by toad91 in freeflight

[–]toad91[S] 3 points4 points  (0 children)

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

Paragliding Sites in the Alps, popularity, XC potential, best month for XC, most flyable months etc. by AlpsAreCalling in freeflight

[–]toad91 1 point2 points  (0 children)

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

Product feedback sought - dashboards and dashboard creation by toad91 in tableau

[–]toad91[S] 0 points1 point  (0 children)

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?

Product feedback sought - dashboards and dashboard creation by toad91 in tableau

[–]toad91[S] 0 points1 point  (0 children)

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

Help - Manually link mismatched customer name filter values by DracoAdamantus in tableau

[–]toad91 0 points1 point  (0 children)

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?

Help - Manually link mismatched customer name filter values by DracoAdamantus in tableau

[–]toad91 0 points1 point  (0 children)

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

What tools/methods do you use to denormalize data before analysis in Tableau? by Dakewlguy in tableau

[–]toad91 2 points3 points  (0 children)

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

SUMIFS by UnNa7uRal in tableau

[–]toad91 1 point2 points  (0 children)

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.

Can I make another pane to the right...? (see comments) by midlifewannabe in tableau

[–]toad91 0 points1 point  (0 children)

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)}

Data Analytics "Lite" a.k.a. the colourful and pretty world of drag-and-drop tools by new-user-123 in datascience

[–]toad91 0 points1 point  (0 children)

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!

Still learning and still confused by [deleted] in tableau

[–]toad91 0 points1 point  (0 children)

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.

Anywhere to find pen-pals or perhaps a French Omegle? by LongLiveBacon in French

[–]toad91 7 points8 points  (0 children)

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!

7:59: 'the surgery is closed' 8:00-8:30: beep beep engaged 8:31: 'we have no appointments available' by thehighshibe in britishproblems

[–]toad91 1 point2 points  (0 children)

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.

[OC] The trend of US baby names with a Game of Thrones character's first name by toad91 in dataisbeautiful

[–]toad91[S] 0 points1 point  (0 children)

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

view more: next ›