Category Archives: White Paper

End-User Microsoft BI Tools – Clearing up the confusion

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 Pivot, Power View/Project Crescent, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments

SQL Server Analysis Services Performance Guide published

Another must read white-paper: Analysis Services 2008 R2 Performance Guide. This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions.  It applies to SQL Server … Continue reading

Posted in SQLServerPedia Syndication, SSAS, White Paper | Leave a comment

SQL Server Analysis Services Operations Guide published

Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide This white paper describes how you can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, … Continue reading

Posted in SQLServerPedia Syndication, SSAS, White Paper | Leave a comment

Great white paper: Microsoft EDW Architecture, Guidance and Deployment Best Practices

A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices. It’s a must read if you are a data architect, data developer, or DBA involved in an Enterprise Data Warehouse (EDW).  As the paper says, the … Continue reading

Posted in Data warehouse, SQLServerPedia Syndication, White Paper | Leave a comment