database - Stringfest Analytics https://stringfestanalytics.com Analytics & AI for Modern Excel Thu, 29 Dec 2016 22:13:13 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://i0.wp.com/stringfestanalytics.com/wp-content/uploads/2020/05/cropped-RGB-SEAL-LOGO-STRINGFEST-01.png?fit=32%2C32&ssl=1 database - Stringfest Analytics https://stringfestanalytics.com 32 32 98759290 Spreadsheet Thinking, or Bad Thinking? https://stringfestanalytics.com/spreadsheet-thinking-or-bad-thinking/ Thu, 28 Apr 2016 19:10:03 +0000 http://georgejmount.com/?p=1865 I really enjoyed this piece by Robert Kosara on “spreadsheet thinking vs database thinking.” Describing the former as “short and fat” and latter as “long and skinny,” Robert documents why database-style datasets win out.  Subscribe for more spreadsheet tips. This is a helpful distinction, but it might be unfair for spreadsheet users. Because you can […]

The post Spreadsheet Thinking, or Bad Thinking? first appeared on Stringfest Analytics.

]]>
I really enjoyed this piece by Robert Kosara on “spreadsheet thinking vs database thinking.” Describing the former as “short and fat” and latter as “long and skinny,” Robert documents why database-style datasets win out. 

Screenshot 2016-04-28 18.00.13

Subscribe for more spreadsheet tips.

This is a helpful distinction, but it might be unfair for spreadsheet users. Because you can apply database thinking to spreadsheets. 

It’s all about putting data in a form that is easiest for the computer to manipulate. This means your inputs should be stored separately from outputs and no inconsistently formatted fields.

A spreadsheet that doesn’t do these things isn’t designed using “spreadsheet thinking.” It’s just designed badly.

Watch for this in your spreadsheets — are you treating it like a database? I highly encourage you to check out the full post.

The post Spreadsheet Thinking, or Bad Thinking? first appeared on Stringfest Analytics.

]]>
1865