Author: Simon

Getting Started with SQL

Startup Stock Photo

If you’re interested in data, you’re going to have to learn to interact with data one way or another – there are an awful lot of tools out there, and many are optimized for certain professions or fields. The Doctor uses SPSS for her analysis, but she’s an academic psychologist – not a super useful tool for folks interested in growth. For me, working at WordPress.com, SQL seemed like a great place to start, since many of the WordPress foundations are built on plain old SQL tables.

There are lots of places where folks will be very glad to take your money to teach you SQL (or anything else, for that matter) – in matters of education, I would encourage you to examine your options, and to at least get a taste of the no-cost options. With the Internet as it is, there is such a wealth of information and generosity of spirit, a dedicated and motivated learner can often find themselves with more than enough educational resources at their fingertips.

For me, I started with Khan Academy’s Hour of Code on SQL – available here – KA really does a great job, and the subjects they cover are growing every day. Once you’ve spent an hour with them, if you’re following my footsteps anyway, you’d want to move on to SQL Zoo, a wiki-style educational series of problems and a number of different databases to play with.

After SQL Zoo, I’m not sure! Are there other resources that you would recommend for a data-driven autodidact?

Notes from A More Beautiful Question Pages 1 – 88

2015-01-Life-of-Pix-free-stock-photos-measuring-instruments-navigation-wall-julien-sister

– Five Habits of Mind: Evidence, Viewpoint, Connection, Conjecture, Relevance. There is value in recognizing a system or process behind questioning and then evaluating those questions. Essentially, looking at my questions, and rather than immediately pursuing an answer, considering the question itself.The big one is Relevance – “Does this matter?” 

– There’s a real value in recognizing the answer that sometimes comes packed in a question – this is the difference between an open and closed question. Consider, “Why is torture effective?” vs. “Is torture effective?” The way a question is asked will result in different answers, and can reveal much about the questioner.

– Asking questions online is different – and easier – than asking questions in person. This is because it allows for a certain amount of anonymity. Especially in work or social cultures where asking questions can indicate weakness, being able to anonymize questions opens up a whole realm of possibility. This reminds me of Gladwell’s Cockpit Culture from Outliers.

– Great quote from Edwin Land, founder of Polaroid, from 1942: “If you dream of something worth doing and then simply go to work on it … if you think of, detail by detail, what you have to do next, it is a wonderful dream even if the end is a long way off, for there are about five thousand steps to be taken before we realize it; and start making the first ten, and stay making those twenty after, it is amazing how quickly you get through those five thousand steps.”

– It’s great to see the power of habit discussed, especially in terms of questioning our long-ingrained ideas. These habits and ideas get caught in a groove, and become psychologically calcified, invulnerable to questioning not because they are the best answers, but simply because they always have been. And that’s not a great reason.

– More on that: “It means thinking of things that are usually assumed to be negative as positive, and vice versa. It can mean reversing assumptions about cause and effect, or what matters most versus least. It means not traveling through life on automatic pilot.

Documentation, Support, and Customer Success

oIpwxeeSPy1cnwYpqJ1w_Dufer-Collateral-test-1400x1136

I’ve had a bunch of conversations recently around the role of documentation in hospitality on the internet. My friend and colleague Andrew posted about documentation recently, and of course my love for Buffer requires I point out their approach to documentation – documentation is such a big deal in support communities that we even have a conference dedicated to it.

When it comes to documentation, I am of two minds. Software development, especially code languages and learning code languages, involve a lot of documentation, and a lot of referring to documentation, and so forth. We need to recognize, though, that when we use code to build really awesome things, we are building those things for an audience who is perhaps not as steeped in a documentation-heavy culture.

Working in support for WordPress.com, I am grateful every day for the documentation that we have – for little things that folks can work out for themselves if they have a guide (like, say, a custom menu or static front page), and certainly for big things that are challenging even for me (intricate Theme setups especially).

Lately, though, I have been shifting my thinking on documentation. Part of this comes from doing some deep dives in our Google Analytics account for our docs, finally getting a real bite of how huge our docs base is, and seeing for the first time how much traffic they really get (about 60,000 visitors per day). Recently I’ve started to see documentation as a psychological band-aid, and as a sidestep to improved products. Here’s what I mean:

Docs as a Psychological Band Aid
When a member of our staff recognizes that we have a flow, or a feature, or some other piece that requires additional education, and they invest their time and brainpower in creating documentation for that flow or feature, we can breathe a sigh of relief, right? Now, when a customer asks about that flow or feature, we have a resource for them. That problem is solved. Here you go – read this. We’ve scaled. We can check that box.

The problem here, is that when ever we feel like that box is checked, we calcify our thinking on that issue – we think it’s taken care of. A question about X? Here’s our documentation about X. Especially in a company where staff feels overworked and understaffed (ie, all of them), this becomes the path of least resistance, which then becomes habit. A habit of deferring replies to documentation has two unfortunate psychological consequences: first, it calcifies us in a place where critical thinking no longer takes place. More on this in the next point.

Second, it (inappropriately!) shifts the responsibility from us, as hospitality professionals, onto our customers. It is no longer our job to create an excellent environment where they can accomplish their goals – now it is the customer’s job to read the documents we created for them – time spent in documentation is time spent not accomplishing their goals.

Docs as Sidestepping Product Improvement
Every support document is an admission that a flow or feature doesn’t Just Work. When we create a long series of nested documentation on how to accomplish something is an indication that something is hard to do. A great company makes its customers feel smart, safe, and powerful. Taking someone out of your features, out of your flows, out of the path to their success, to refer to documentation represents a point of friction, an obstacle.

If you want to take the principles of Growth Engineering and apply them to doing hospitality right at your company, take a look at the top search terms in your Support page. Take a look at how people use those documents. Those are break points, those are places where a document is acting as a band aid to a better UX, or a better product (in this, we could learn a lot from modern computer and video games, but that’s a post for a different day).

So What Then?
I don’t hate documentation. I think for a lot of use cases it’s necessary, and it can be done really, really well. I do think that serving our customers to the very best of our ability, however, means reducing our documentation, approaching problems with ownership and a critical mindset – not “Well why don’t they read the guide?” but rather “Why does embedding this require a guide?”

Documentation can be a great tool in the Internet Hospitality Toolbox, but it’s only a temporary stopgap – Docs should be the clamp that holds two boards together while the glue cures, not the permanent solution.

Worth Reading: The Busy Trap

carnivorous-plant-217187_1280

In the first post in this series, I recommended David Foster Wallace – the man who introduced David Foster Wallace’s work to me is Tim Kreider, who I know through his cutting and brilliant comic career. Of late he has turned his attention to cultural and political commentary and he is, naturally, killing it.

One of my favorites of his work is a piece called The Busy Trap, which if you are a person who works in the United States today, you should read. And, once in a while, read again.

Cheers to the FCC for Supporting Title II to Protect the Open Internet

Paul Sieminski's avatarTransparency Report

WordPress.com aims to democratize publishing – to build the tools that give writers, bloggers, and creators of all sizes a way to get their voices to the world. Today we see that our voices were heard, and that they had a big impact on the future of the internet.

This morning, FCC chairman Tom Wheeler announced his support for strong network neutrality rules, by proposing to reclassify internet service under Title II of the telecommunications act. We applaud Chairman Wheeler for today’s announcement. It’s a historic step, and one that would not have been possible without the support of the millions of internet users – from individual WordPress.com bloggers to the President of the United States – who voiced their support for the open internet for the past several months. At Automattic, we’re proud to have participated in this historic effort, and pledge to continue supporting this important cause…

View original post 18 more words