Marco Russo's Blog

   View full profile
Page 47 of 715 results

Rough Cuts of the PowerPivot book available!

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

Importing data from Analysis Services 2000 to PowerPivot

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

SQLBI Methodology at 24 Hours of PASS

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

The Parallel Loop Task in SSIS

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

Median calculation in DAX

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