Reply to post: Limited use cases

A bad day for DBAs: MIT boffins are replacing you with a mere spreadsheet

Sirius Lee

Limited use cases

It's hard to tell from the article or video how functional the tool is (maybe the answers to my questions are in articles at the end of the links provided). Most queries I create have to transform some of the values into columns - for example period based data. It's not clear that it's possible to do this using the tool.

It's easy to assert A is better/faster/cheaper/easier than B if the measurement criteria favour what A does well. Spreadsheets allow users to create presentations that are much more than just query engines.

How does this tool allow a user to create a 'lag' function since SQL-92 does not include this concept but is essential in any financial reporting. OLAP query engines were created to address these requirements.

How does this tool compare with PowerBI? Access is nearly 3 decades old and Microsoft has many other query tools that do a better job of allowing a user to query a data source.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon