News for hackers. Stuff that matters.
Re:MonetDB – Column-store database by dragonwriter on Monday June 13, 2016 @06:29PM (#11898275)
> Tabular is designed to capture the Excel analyst market. DAX is designed to look like Excel formulas

And, in fact, Excel's "Power Pivot" feature (and uses DAX for calculations) is powered by Excel running its own instance of SSAS Tabular.

Re:MonetDB – Column-store database by greggyb on Monday June 13, 2016 @07:06PM (#11898500)
Yes. Power Pivot is the reason that I said Tabular arguably came to SQL Server 2008R2, which can run Analysis Services in a mode to support a Power Pivot workbook hosted on SharePoint. There was no standalone SSAS Tabular, but the Vertipaq engine and DAX were run on a SQL Server instance.

Power BI Desktop (and hosted data models on the PowerBI.com cloud service) is also powered by the Tabular engine and utilizes DAX as a query and modeling language.

Microsoft is pushing Tabular hard. It's probably the right choice for most organizations, and at worst serves as a great prototyping tool for a Multidimensional model (when we have clients who need Multidimensional for whatever reason, we often still do initial development and pilots on Tabular).

Re:MonetDB – Column-store database by blahi on Tuesday June 14, 2016 @03:01AM (#11900282)
Thanks for the answers. Really appreciated! I am analyst and I deal with databases, but in a very specific way. The way I tried to explain to myself the difference is that OLAP is used if you have a lot of fine-grained hierarchies accessed by a big number of people. In this scenario it would make sense to make all those aggregations ahead of time because a columnar store would have to calculate them each time somebody slices and that would be waay to expensive, even if you have state of the art caching.
Re:MonetDB – Column-store database by greggyb on Tuesday June 14, 2016 @10:02AM (#11902059)
That is a useful distinction to make, but as in all programming tasks, profiling will get you further than intuition when tuning for performance.