A Comparison between SQL Server 2012 BI Tools

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 ...

Reporting Services and JavaScript in SharePoint 2010

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,...

The Tabular Model in SQL Server 2012

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...
one comment