This is the third post of a series dedicated to Viney@rd features. Find the first here and the second here.

Viney@rd has its own query feature, which can draw tables on Excel worksheets, but it is aimed mainly at creating complex, refreshable, layouts. It is easy to understand that, while this is felt by many as a requirement not fulfilled by classical BI tools, it is not the best approach to data analysis. Controllers and data analysts require both. Nonetheless Excel has a powerful built-in feature to analyze data, the pivot tables.
One of the ideas underlying Viney@rd is not to cater twice what the user has already purchased, so, instead of duplicating the feature, I created something to integrate pivot tables with Viney@rd.

From Viney@rd client you can create a workbook connection to a model. The connection exposes as fields all the dimensions, the attributes and the measures. So, you can analyze all these data in the usual way.

With this feature you can also use Viney@rd data as a source for PowerPivot engine in the coming 2010 version, working with an even better analysis tool.

Try Viney@rd, 3 months, fully functional demo!

Learn more about Viney@rd