-
If you are curious to look at the upcoming book Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I wrote with Alberto , you can see the first 4 chapters in draft format through the “ Rough Cuts ” initiative by O’Reilly. I’d like to get 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 Read more
-
In the next 2 to 3 weeks I will publish a few blog posts about importing data to PowerPivot using Analysis Services as a data source. This is something I studied a lot during the beta test of PowerPivot and it is not a topic that has a place in the upcoming Read more
-
Did you missed our SQLBI Methodology session at PASS Summit 2009? Don’t worry. We will make the show again, live and directly on your PC – for free! On September 15 and 16 there will be a new edition of 24 Hours of PASS . I and Alberto will show SQLBI Read more
-
I really don’t like to use the blog as an advertising tool, but sometimes I feel the need to mention third party products because I thing they are interesting enough. Today I discovered that CozyRoc implemented the Parallel Loop Task in SSIS . This is Read more
-
I recently discussed with Darren Gosbell about how to calculate the Median in DAX. The problem is to make the calculation using a measure, so that you can use it in a dynamic way into a PivotTable. We have a People table with three columns: Gender, Customer Read more
-
In reality, there are two news. First, PivotViewer for Reporting Services CTP1 has been released and you can try it. Second, Cristian Petculescu has a blog and you can find a video about how to install and start using PivotViewer. Cristian is one of the Read more
-
A couple of weeks ago the first version of Vizubi has been released. It is an Excel AddIn with many of the features of PowerPivot, but also with a few important differences. I made some tests and in this post I give my first impression of the product. Read more
-
There are already several posts in the blogosphere about the need of using a separate Dates table in PowerPivot to make almost any type of analysis. An important step you should make whenever you have a Dates table (almost always, in theory!) is to hide Read more
-
Last week I’ve been at Microsoft BI Conference and I presented an interactive session about PowerPivot DAX Patterns. Unfortunately only the breakout session were recorded and available on TechEd Online . The room was full and there were probably many Read more