TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

With a new tool, spreadsheet users can construct custom database interfaces

89 pointsby renafowleralmost 9 years ago

12 comments

kfkalmost 9 years ago
OK... but where are decent user-friendly tools to manipulate, manage and share data and insights? Really, the problem is that to this day data in Corporations is a mess. The moment you step out of the standard warehouse systems you find yourself navigating a mess of spreadsheets, word docs, power points, all showing sometimes the same data in different formats. You duplicate data every time you send an Excel file by email... this data needs to be in sync and when not people get screamed at or fired. That means a lot of work goes into manually maintaining thousands of different files to make sure they tie to the overall picture. It&#x27;s a mess. The bad part is that nobody is looking into this, everybody is focusing on analytics or reporting, which by now are the easy part.<p>Then you have ancient tools like HFM or BPC that try to &quot;enhance&quot; spreadsheets and spreadsheets consolidations. They don&#x27;t work. They are barely reliable and they cost a lot of money for no reason (they are simple SQL databases, they can&#x27;t even be compared to much more complex software like salesforce or similar).<p>Then Corporations are now being sold this all &quot;big data&quot; thing, which is old by now for tech audiences, but it&#x27;s just new for most of the big companies nowadays. Unfortunately, while big data has a lot of potential, it further moves away investments on good old small data where probably there is much more ROI to grab simply because solving this problem is not that difficult and not that expensive if you want to actually fix it.<p>Then now everybody wants to do Predictive, but Predictive won&#x27;t beat saving hundreds of employees thousands of working hours by improving the efficiency of how we handle data and data insights. You can literally create a new workforce out of the many hours you would save with better efficiency in this area. Without even considering that on top of efficiency, you get much better, more fact based, decisions driven by the overall increase in transparency which you lose when insights are spread around thousands and thousands of files.<p>There is some light at the end of the tunnel. Software solutions like Tableau go in the right direction, but they do not provide the much (more) needed tools to properly manipulate and manage data and, especially, consolidations and integration. The only way to get out of this mess is to control the data flow but especially to have 1 and only 1 data flow. That means once your insights are approved and locked, every other view should read this data, there should be no manual intervention any more. If the locked data is wrong, it will be wrong for everybody, which is a good thing compared to having multiple copies of the same and then people fighting on which one is the right one.
评论 #12153376 未加载
评论 #12153367 未加载
评论 #12153060 未加载
评论 #12153919 未加载
dhruvkaralmost 9 years ago
<a href="http:&#x2F;&#x2F;www.fieldbook.com" rel="nofollow">http:&#x2F;&#x2F;www.fieldbook.com</a><p>I haven&#x27;t used this in production, but messed around with it for a while. Seems to do what this article is suggesting.
评论 #12153947 未加载
fspeechalmost 9 years ago
Very cool. The right side of the article provides links to a video presentation of the tool and a SIGMOD paper reporting on the details. It is specifically compared against Access in a study on usability.<p>Link to the project page: <a href="http:&#x2F;&#x2F;people.csail.mit.edu&#x2F;ebakke&#x2F;sieuferd&#x2F;" rel="nofollow">http:&#x2F;&#x2F;people.csail.mit.edu&#x2F;ebakke&#x2F;sieuferd&#x2F;</a>
johnmaguire2013almost 9 years ago
This sounds a lot like AirTable[1] to me. AirTable has quickly become my favorite Spreadsheets replacement because it has a nice REST API, ways of linking data from multiple tables, data integrity principles, and pretty solid mobile phone data entry, while still maintaining the simplicity of a spreadsheet.<p>[1] <a href="https:&#x2F;&#x2F;airtable.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;airtable.com&#x2F;</a>
评论 #12153733 未加载
philprxalmost 9 years ago
Am i missing something but... ... Where is the tool ?<p>Source code or it doesn&#x27;t exist ;)
wx196almost 9 years ago
&quot;when you have something extremely industry-specific is, you have to hire a programmer who spends about a year of work to build a user interface for your particular domain&quot; — with tools like Oracle APEX it can be done much faster, so I think nothing new.
评论 #12152796 未加载
infinite8salmost 9 years ago
I&#x27;m not sure how this is any easier than using Tableau, which can construct most of these types of business analytic queries fairly easily. More complicated queries that pull in data from multiple tables usually requires an understanding of the organization of data across these tables, but that is true of this tool as well (at least from the video on the author&#x27;s website - <a href="http:&#x2F;&#x2F;people.csail.mit.edu&#x2F;ebakke&#x2F;sieuferd&#x2F;index.html" rel="nofollow">http:&#x2F;&#x2F;people.csail.mit.edu&#x2F;ebakke&#x2F;sieuferd&#x2F;index.html</a>)
alirobealmost 9 years ago
So... Pivot Tables? Excel has done this for ages. Excel 2016 even has in-memory BI.
评论 #12152980 未加载
ww520almost 9 years ago
Microsoft Access?
评论 #12152789 未加载
based2almost 9 years ago
<a href="http:&#x2F;&#x2F;people.csail.mit.edu&#x2F;ebakke&#x2F;" rel="nofollow">http:&#x2F;&#x2F;people.csail.mit.edu&#x2F;ebakke&#x2F;</a>
zyxleyalmost 9 years ago
So... they&#x27;ve reinvented Access?
评论 #12152428 未加载
评论 #12152358 未加载
评论 #12152342 未加载
评论 #12153111 未加载
评论 #12153310 未加载
Marioneticalmost 9 years ago
really cool, easy start to any project