State of Data #102

#1Read_this_Week The Girl with the Dragon Tattoo’ makes a SQL mistake – ‘My favourite part, though, was when Lisbeth Salander begins to solve a 40 year old murder cold case using SQL.’


#analysisA good series on ‘Moving Beyond Conversion Rates’ –

Part 1: Avoid Ratios for Metrics
Part 2Not All Visitors Make Great Customers
Part 3Visitors Are Not All The Same
Part 4Campaigns Are Where Conversion Rates Shine


#big_dataDataPop’s story –  startup that ‘relies on semantic search and natural-language processing to infer connections between what consumers enter into the search window and what they really want, and then on machine learning to help with everything from determining common spelling mistakes to search construction to the sequence of events that leads to a purchase’


#Data_ScienceHow to predict Eurovision Song Contest winners


ROW vs. SET processing of records


“1. Set based processing will likely be much faster than row based processing. Our experiment of processing 100K rows showed row based processing was 3700 times slower than set based processing. Not twice as slower or even 10 times slower… 3700 times slower!

2. Compared to set based processing, row based processing times degrade much quicker than set based processing. That is, row based processing does not scale nearly as well as set based processing. We saw this in that the linear trend line for row based processing was 0.00259 compared to 0.00000 for set based processing”

#idea Nassim Taleb, author of bestseller ‘Black Swan’, writes about ‘side effects’ of too much reliance on data

‘In business and economic decision-making, data causes severe side effects —data is now plentiful thanks to connectivity; and the share of spuriousness in the data increases as one gets more immersed into it. A not well discussed property of data: it is toxic in large quantities —even in moderate quantities.’

#learning –   

  1.  Pros and Cons of Scatterplots
  2. Case for using a density plot instead of a scatterplot

#visualizationWhat’s wrong U.S.” is visualization of Target and Walgreens’ sales data to see which state has most headache problems or allergy or stuffy nose



About Nilendu Misra
I love to learn, create and coach. Things that I do well are - Communicating ideas - verbally or through words and diagrams; Problem Solving - Logical or Abstract; Very Large Scale Systems; think about 'Frighteningly Simple' approach first. Things that I intend to do better are - Establishing Stringent Process; Exchanging Tough Feedback; Keeping up with my reading or To-Do list to be able to completely relax.

Comments are closed.

%d bloggers like this: