This presentation overviews many products in the Microsoft business intelligence stack including SharePoint, SQL Reporting & Integration services. Standing on these technologies and the Adventure Works database, we'll build a faceted/dimensional search capability using only out of the box capabilities. Faceted search has found a home in the product listing arena (see BestBuy.com website), but is an under-utilized player in the business intelligence arena. This highly intuitive real-time reporting UI has much of the bang of a data cube or pivot table in a streamlined, executive friend approach. This Microsoft Architecture review will demonstration where and how the pieces fall into place to build a useful capability.