Slice and dice with Pivot Tables and Pivot Charts

You want to visualize your data and make business decisions using your data on the backend server, but you are not an experienced BI developer using Microsoft SQLServer's BIDS or Visual Studio. Well, you can do nearly the same thing using your Excel product. You can look up data on an ad-hoc basis using Pivot Table and Pivot Charts using Microsoft Excel. If you want to know the mechanics of doing it, read the detailed article brought to you by DotNetSlackers.com.

Creating Pivot Table and Pivot Chart with data from SQL Server 2008