Hamburger vs Fried Rice

Back to Basic: Spreadsheet is supposed to help us manage data systematically, clean and tidy. Not unless we are doing it right!

An analogue.

Look at the picture below,

a classic Hamburger & a bowl of Fried Rice.

Now you have two tasks to complete

1) Retrieve the burger patties from Hamburger

2) Pick out the tiny meat pieces from the Fried Rice.

Which task is completed faster? The Hamburger one, obviously.

Why? Because the Hamburger ingredients are stacked in order and visibly upfront.

The same intuition goes for managing spreadsheet.

>> Always build dashboards in orderly sequence. Don’t merge cell unnecessarily!

>>Consistent format of data within column/category.

>>Keep frequently referenced/important columns easy to spot.

Assessment checklist

Lastly, we are safe to go if the answers to these 3 questions are YES.

  1. Can I easily to pivot the table into clean summary?

2. Can I easily append/merge the table into other’s file, thanks to its standardized heading and data format?

3. Can I add/remove/override the data easily with minimal intrusion of the original layout?

Do not fry and toss your data on a spreadsheet!





Richard Thaler: ‘If you want people to do something, make it easy’

Recommended from Medium

How Data Scientists can help Government Agencies Effectively Respond to Natural Disasters

Rating Product & Sorting Reviews on Amazon

How to use time travel to debug your ML pipelines

The “One Minute Map” — static and interactive maps creation with the R tmap package

Top 5 Visual Analytics Tools for Business Intelligence

Pulling NSE (National Stock Exchange), India data to do analytics.

Explore and communicate landslides risk in Nepal using interactive maps

How to create custom COCO data set for object detection

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
tcs's Medium

tcs's Medium


More from Medium

Single Customer View, a road often taken (and abandoned) in developing Data Warehouses

4 Emerging Data Monetization Models Disrupting Businesses

Centralized vs Decentralized: Redefining data storage solutions

Auto-generated documentation with AAD authentication and granular role management