Monday, October 05, 2009

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


orageek said...

It is much easier to do this using Pebble Reports. Excel is great, but after you slice and dice can you publish the view to Reporting Services? No. Pebble Reports can. Check it out at

Jayaram Krishnaswamy said...

I have no tried it. But good to know.


Jay Protection Status