There is an interesting movement towards “R”, but I see it as an additional tool for certain users and usages, and not as something that can replace existing technologies. I think that we will not see a single language/technology replacing everything we are using now. Moreover, MDX is used by other products (Pentaho, SAP HANA, and others), whereas by now DAX is used only by Microsoft products (Power Pivot and SSAS Tabular). But for certain applications, C++ is the only option. Nowadays, many people use C# (myself included, and I have been using C++ for many years). Well, I’m pretty much convinced that MDX will be like C++. The spike you see in the first quarter is because of the different distribution of the two publishers, so just consider the trend in the following quarters.Ī common question I receive also in comments to my blog posts is about the future of Multidimensional and MDX. So what about SSAS Tabular? The book Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model has a shortest sales history, but it has a regular trend, with a slow decrease over time. This can be a predictable behavior, but what is interesting is that the lifespan of this book is much longer than average (of other software product books) and the technology we talk about is not going to disappear in the market. Well, this book kept the same level of sales for 3 years, it decreased sales after the release of Analysis Services Tabular, and it increased sales with the release of the new edition. The average “life” of a book covering a software product is 2-3 years. The main change we had to do compared to the first edition published in 2009 was changing the screenshot. I co-authored books that cover SSAS Multidimensional and we recently released a refresh of the Expert Cube Development with SSAS Multidimensional Models. As a book and blog author, I have some data that I can share. In fact, MDX is also the name of a car mode, and DAX is the main German Stock Index. For example, it’s hard to discriminate between MDX and DAX web searches (Google Trends is an interesting tool for this kind of things). Thus, only indirect observations are possible: books sold, web page reads, web searches, support calls, consulting engagements, and so on.Īccessing to public data is very hard. For this reason, it’s also more difficult to analyze the effective usage of the two different model types: Multidimensional and Tabular. I think that also Microsoft does not know (and cannot know) the exact number of users. It provides more features, cost and scalability benefits, plus projects can be created and deployed with Power BI Desktop, which can cut off the development time and has wider base of developers.SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. Power BI Premium, a SaaS, a superset of tabular, would be the preferred choice for greenfield projects.
0 Comments
Leave a Reply. |