article

Budget and Other Data at Different Granularities in PowerPivot

PowerPivot and BISM Tabular handle relationships between tables by using a single column that requires to be a unique column in the lookup table. In this article you will see how to handle relationships between tables that have different granularities,…  Read more

The project codenamed Gemini has an official name now: PowerPivot. The complete name should be “PowerPivot for Excel 2010”, but PowerPivot is simpler. I didn’t like that name yesterday, but today it seems better. Microsoft announced this name at the…  Read more

Companies that have cubes on Analysis Services 2000 and still have not completed a migration to SSAS 2005/2008 might be interested in connecting to AS2000 from PowerPivot. Unfortunately, there are several limitations about using AS2000 as a data source for…  Read more

Yesterday Microsoft released the Windows Azure Marketplace DataMarket (which everyone will simply call DataMarket, I hope). It was previously called Codename “Dallas”. This is an important step toward the empowerment of self-service BI tools. Microsoft also released two add-ins: The…  Read more

One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot. You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful…  Read more

I just installed a brand new server (well, a virtual machine) with SharePoint 2010 SP1 and SQL Server 2012 RC0, including PowerPivot and Reporting Services / Power View. The server is joined to the domain I use in our development…  Read more

Microsoft published an interesting article about how to optimize memory consumption of a PowerPivot Data Model in Excel 2013. All these suggestions are also valid for SSAS Tabular. I also wrote an article Checklist for Memory Optimizations in PowerPivot and Tabular Models…  Read more

If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models. This is the simplest way…  Read more

I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature…  Read more

If you have a PowerPivot workbook created with Excel 2010, in order to navigate and/or update the data model with Excel 2013 you need to upgrade the workbook.  Read more