David Sánchez Martín
David Sánchez Martín
As a biomedical scientist with +10 years of experience in cancer research, David has found a need to make existing data available and accessible. From clinical trials to genomic sequence, plenty of information ready to be explored exists already, but the layman may be daunted by the complex jargon, sophisticated methodology and the vast upfront investment in training needed to get useful information.
He sees Tableau and Alteryx as a way of empowering scientists to do visual analytics and to develop compelling stories to communicate the findings to different audiences – from the world expert to the general public (usually funding the research).
In his spare time David enjoys rock climbing, sailing, a good book and going out for dinner.
Fun times at DS. So many things have happened in these last months. I kept track of different facts in my life with a google form. This is the summary.
Plotting with rows that are not there. Using densification to draw some lines – the beauty of Index & Bins.
Tableau can be for everyone. Just find what drives them or what use can they give it and people will want to use it. Case in point: my father during the holidays.
I recently came across an unexpected (for me!) behaviour of Alteryx: I had built a batch macro that was receiving single letter arguments (a-z) in the control parameter, and the macro was working OK sometimes, but not all the time. It took a while to figure it out:...
My thoughts on Dashboard week at DataSchool DS7 – fun, intensive and so much learned!
Today we had the opportunity of using RegEx once again. How have we been able to live so long without knowing & using it is a question for another day. Suffice it to say, for me, despite my aversion to cheese, the day was worth it just because of the data prep part....
Second day of dashboard week – where should you go to find love. An alternative story point format. There is some analysis –mostly behind the curtains.
Saving time in Alteryx. Narrowing the question. Ignoring all irrelevant data. My thoughts on the first day of Dashboard Week.
The last in a series of posts to make Alteryx macros accessible: iterative macros, the WHILE loop in Alteryx
Second post on a series of making Alteryx macros accessible to anyone. Overview of the batch macro: uses and the secret of the Control Parameter.
Using Tableau Server’s Repository (PostgreSQL) to identify views that are not providing the answers your users are looking for, potential leakages of information,… Including a sample workbook to test on your server.
You run tabcmd export myWorkbook/myView –fullpdf expecting to get a pdf with all the views from your Tableau Server; however, the fullpdf you just downloaded has only the myView in it. Why? The most likely reason is the small print in the Tableau help: To export a...
First post on a series of making Alteryx macros accessible to anyone. Overview of the standard macro: what it is and 3 use-case scenarios (reuse code, single point of maintenance, division of labour).
One week per day. 5 days per week. 9 of us. Tableau formatting, Alteryx tools. You name it. Here, the summary plus the video. Enjoy and comment on your favourite tips.
Do you have a filter with a Boolean that includes Null when shown? Does it annoy you? Want to get rid of it? Well, there are a couple of ways of doing some cleaning, but first of all let’s see why you get those values: How you write the calculation matters: Do you...
Zoom into charts and maps, sure. But also into calculation windows – show/hide to your audience what you typed.
Consider how your audience is going to interact with your Viz. Are you tweeting it? Then maybe it’s worth it to add a phone layout… It will help you also with the embedding in your blog!
Quick tip to change the colour of the search box in the map for a single workbook. Personalize and add some sparkle to your maps.
A quick tip for adding colour from two different sets stolen from Andy today: Build your viz (here profit vs. sales, split by product ID). Add your first set to detail. Add your second set to detail. Click on the dots for each set and add them to colour....
3 examples of points, lines and spatial tools in Alteryx. Convert a series of GPS coordinates into a path. Intersecting paths and splitting and joining new lines.
16-week project to build progressively with Tableau and Alteryx to analyze 16 years (an $400 billion!) of funding by the National Institutes of Health.
3 take away messages from week 1:
Tailor your Message, Keep it Simple, and use Visual Cues. Combining the information received from Andy and Caroline and putting it to practice.