Jeremy Kashel's Blog

Browse by Tags

All Tags » PowerPivot (RSS)
Power View Default Field Set
Here's another quick tip when creating data models for use with Power View - Default Field Sets can be created in both Tabular SSAS and PowerPivot that give the user a shortcut for automatically adding multiple fields to a report. As an example, here's...
PowerPivot Settings for Power View
I’ve been using both PowerPivot and Power View quite a bit recently and, in addition to the post I did a while back , have made a few further observations on getting the two to play nicely together. Building an Example PowerPivot Model For this post I...
Working with Images in Power View
Power View includes several ways to create visualisations with images, ranging from a simple table, to the scrollable tile visualisation. In this post I’m going to explain a bit about the tile visualisation, showing how it can be used in Power View, before...
Allocations in PowerPivot Using DAX
Although I didn't mention it, the inspiration for my last post was the excellent MDX Solutions 2nd Edition . Whilst flicking through the book a while back, I though it would be interesting to see how DAX and PowerPivot could handle the so called 'Common...
DAX Closing Balances
One of the often required calculations for users in reports is to be able to calculate a point-in-time closing balance, which is especially relevant when dealing with stock levels or financial data. In the Analysis Services world, at least in the Enterprise...
PowerPivot and Data Warehousing
A consultant that I know has recently been through the process of reviewing his company's management information requirements, and also the process of evaluating what technology platform can deliver those requirements. Naturally, a data warehouse...
PowerPivot CTP3 Released
Following last week's release of the November CTP for SQL Server 2008 R2, the latest CTP for PowerPivot is now also released! The links for the downloads are: 32 Bit PowerPivot Download 64 Bit PowerPivot Download PowerPivot Main Download Page Included...