SSAS 2014 No Tabular Instance Installable

SSAS Tabular available in SQL Server Standard Edition?

There’s a lot of confusion on the web with people asking if or why they can’t install SSAS (SQL Server Analysis Services) Tabular data model on their server, thinking you can’t install both Multidimensional (SSAS MD) and Tabular on the same server etc. Especially as only MD is offered by default on new installations and already Read More

pivottable-wizard

Making the most out of PowerPivot and PivotTables…

Welcome to the site which tries to squeeze the max out of PivotTables, Charts and PowerPivot… basically Business Intelligence BI but on a practical scale, even if the underlying data is millions of records. In fact, that’s why PowerPivot is so useful now – because it can crunch millions of records (not just the 1 Read More

powerpivot-cube

Is PowerPivot any good?

Is PowerPivot a gimmick to sell Excel, or a serious BI tool? We were surprised to find the latter. Although PivotTables and PivotCharts have been around since before even Excel 97 days (when they became more usable), even they were neglected as too “complicated” for busy users to employ. But when they were, did they transform reporting! Read More