
The short answer is both.
Companies today are using both to deal with ever-larger volumes of data. For the business user, analyzing large data can be challenging simply because traditional tools are slow and cumbersome. Some companies are turning to in-memory analytics, which lets users extract set of data and take advantage of the computing power on their local machine to speed up reporting and take query load off their transactional systems. Others are investing in fast, analytical databases that are distinct from their transactional systems.
There are times when you need to work within the comfort of your own PC without touching the database. On the other hand, sometimes a live connection to a database is exactly what you need. The most important thing is not whether you choose in-memory or live, but that you have the option to choose.
This whitepaper outlines:
Download this whitepaper to review scenarios where in-memory or live reporting might be preferable in various database environments.
Ellie Fields is the Director of Product Marketing at Tableau Software. She has spoken at numerous industry events for business intelligence as well as for data journalism. Prior to Tableau, Ellie worked at Microsoft and in late-stage venture capital. Ellie is a graduate of Rice University and the Stanford Graduate School of Business.