July 28, 2012
I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services.Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS ...
July 21, 2012
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the sixth post in a series of posts that I am making from the material of the course:
Reporting Services 2008 R2
In Report Builder 3.0 we can use report parts that exist on the Report Server. In Reporting Services in Visual Studio,...
July 3, 2012
This is a summary of a lecture given in the last BI User Group meeting in Israel by Mr. Itay Braun:
SSAS will give you better performance on top of a DWH of a few Terras (2+) rather than Tabular mode. That's because of the data summary and compression SSAS does to the data. Tabular is not necessarily faster than MOLAP.
Tabular mode is a new DB engine with 2 possible modes of interaction:
1. Tabular Mode
- Column store
- In memory
- Compression (~1:3)
- All the data copied
2. Direct SQL
- Queries translated into SQL running against the SQL DB
- Serves as Tabular mode's...