Is PowerPivot the Next Access?
I'm impressed with the current generation of semantic modeling technology from Microsoft. I've had the opportunity to use both PowerPivot and SSAS Tabular Models on a handful of client projects and have had very good results so far. The xVelocity in-memory aggregation and data compression engine seems to be everything that was promised. PowerPivot doesn't allow us to do everything we can do with Analysis Services cubes but for simple aggregate values and calculations performed with moderately large volumes of data, it performs quickly and is fast and easy to to implement. In some ways, we can do more with Tabular models than multidimensional models with less effort. I'm anxious to continue to test the limits of this technology and really find its practical boundaries and capabilities.
Read more...Tags: powerpivot, tabular