Category Archives: Report Builder

Microsoft BI tools: How they use data sources

Posted on April 2, 2013 by

A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (multidimensional-based): Report Builder – Using “SQL Server”, auto-detects joins if source system has foreign-key relationships (by selected “Auto … Continue reading →

Posted in Excel, PerformancePoint, Power View/Project Crescent, PowerPivot, Report Builder, SQLServerPedia Syndication, SSRS | 1 Comment

End-User Microsoft BI Tools – Clearing up the confusion

Posted on February 27, 2012 by

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles.  There is a … Continue reading →

Posted in Excel, PerformancePoint, Power View/Project Crescent, PowerPivot, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments