Twitter’s product ideas funnel

Since its founding, Twitter has made a religion of listening to users. After all, they came up with some of the company’s best ideas — including the hashtag, reply and retweet. After the flow of good ideas from users stopped, Twitter was hard-pressed to come up with its own.

Bloomberg: Why Twitter Can’t Pull the Trigger on New Products

The first part of that quote is a fact – users came up with hashtag, reply, and retweet, and Twitter (the company) adopted them.

However…

Continue reading Twitter’s product ideas funnel

Premier league table – the trend continues

Follow-up to the last week’s post.

Premier League table - spread by points - week 21 - 2
Premier League table – spread by points – week 21 – 27

All the trends from the previous week continue…

  1. Manchester City (blue) continue to run away with the title, West Brom (slate) continue a lonely run at the bottom.
  2. The 2nd and 5th placed teams are now just 4 points apart (red) – Manchester United lost, while Chelsea, Tottenham, and Liverpool all won.
  3. Arsenal (slate) continue to be in the middle of nowhere – 7 points behind 5th, 9 points ahead of 7th.
  4. The mid-table / relegation pack (light grey) got even tighter – only 11 points between the 7th and 19th placed teams.

Continue reading Premier league table – the trend continues

Premier league table – some trends this season

That chart from the BBC got me interested. Looking at the Premier league table distributed by points makes it lot more interesting than distribution by ranks.

So, I downloaded the Premier League data for current season from Football Data, and created some graphs1.

Weeks 1-8: Mixed bag, except for Crystal Palace

Crystal Palace's dismal start to the season
Crystal Palace’s dismal start to the season

7 straight defeats! Crystal palace really had a crap start to the season!

Continue reading Premier league table – some trends this season

Chrome Extensions I use (start 2018 edition)

This is the updated, early 2018 snapshot of the list of Chrome extensions and apps I use.

Favourites/recommendations are in bold.
My own extensions/apps are marked with an asterisk (*).
Extensions by Google are marked with a (G)

The previous list, from late 2015, is here.

Continue reading Chrome Extensions I use (start 2018 edition)

Chart of the day: Premier league table

Premier league teams on a linear scale of points after 23 matches
Premier league teams on a linear scale of points after 23 matches

The usual Premier league table gives a good idea of the ranking, but the gaps between teams aren’t immediately obvious1. I love how this visualisation shows both the rankings and the gaps with one simple line.

Source: BBC sport

Continue reading Chart of the day: Premier league table

Guy Kawasaki’s 10/20/30 presentation deck rule

A PowerPoint presentation should have ten slides, last no more than twenty minutes, and contain no font smaller than thirty points.


The “or else” implication, in Mark Twain’s words:

I didn’t have time to write a short letter, so I wrote a long one instead.

Source: The Marketoonist

TIL: Conditional sum product in Google Sheets

=SUMPRODUCT(D5:D1009="",C5:C1009,B5:B1009)

Just learnt an easy way to do conditional SumProduct1 calculations in Google Sheets2.

In above example, I wanted the SumProduct of values in columns B and C, when the respective cell in column D was empty.

The solution is to simply introduce the conditional column as another input, with the condition stated in the input.

Sheets does the SumProduct calculations, with each true as 1, and false as 0, thus making it a Conditional SumProduct :)

Continue reading TIL: Conditional sum product in Google Sheets

Biometrics – to identify, not authorise

Biometrics are your username, not your password.

This tweet by Koushik made a lot of sense on first reading. But I couldn’t place my finger on why I agreed with it. Until I read the paragraph below:

All ‘passwords’ should be replaceable. If your credit card gets stolen, you can block it and get a new card. If your Aadhaar number and fingerprint are leaked, you can’t change it, you can’t block it.

Pranesh Prakash in HT

That clinches it for me.

If my password gets stolen, I can reset it to something new, something stronger.

What do I do if my fingerprint is my password? Can’t get a new fingerprint.

Can’t get a new retina, or DNA either. And they’re all a fair bit easier to steal than a strong password.

Sure, use biometrics to identify if you want. But follow the identification with authentication (with a password, or more), before giving that identity any authority.

Some feedback: WordPress reader on desktop

Navigation in reader

  • There are no visible cues hinting at ability to navigate from one expanded post to the next (or previous).
  • Navigating back to the post list (using back button), and then to next post makes it slow, and click heavy.
  • Keyboard shortcuts work, but there are again no visible cues indicating even their presence.

Keyboard shortcuts

  • No visible hints that any keyboard shortcuts exist
    • Keyboard shortcut discoverability is solely by trial and error, or ‘Google’
    • Traditionally, pressing ‘?’ (in, say, GMail or Pocket) brings up relevant shortcuts modal. Doesn’t work in reader.
    • One suggested hint could be to place a keyboard icon next to the help (?) icon, at the bottom, in the left navigation bar.
  • Navigation shortcuts
    • j/k navigate to next/previous post as expected. However, the more ‘lay’ user-friendly left-arrow/right-arrow versions don’t.
    • esc key works the same as browser’s back button – navigating back through history stack (i.e. going back to last viewed post).
      • A better (expected) implementation would be to jump out of expanded-post view to the posts list view, ideally scrolled to the last viewed post.
  • Like keyboard shortcut, l, works as expected. Adding f as an additional activator would be useful – a lot of platforms use favourite as an alternative to like, and some users may be more behaviourally trained to press f instead of l