Alberto Ferrari's Blog posts of 2011

31 results

PASS Summit 2011: good time for a chat on DAX?

This year I and Marco Russo will host a Birds of a Feather lunch about “ DAX, Vertipaq and BISM Tabular ” during PASS Summit in Seattle. If you want to spend some time speaking about DAX, the new Vertipaq engine of just have a good chat in front of some  Read more

Creating a copy of a BISM Tabular project

Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name and then proceed with updates, until I was satisfied with the final result. Then, working with the two projects side-by-side I could  Read more

Deep dive day on #DAX at #SQLBits

September 29th I and Marco Russo will be delivering a full day of deep dive into the DAX programming language, during the training days of SqlBits 9 . Later on, during the conference, I will deliver a session about many to many relationships in DAX, exploiting  Read more

#PowerPivot Webinar, august 17th at 11 AM CET

Tomorrow, at 11 AM CET, I will deliver a webinar on how to produce interesting reports with PowerPivot, a webcast which is a first taste of my incoming session for the European Sharepoint Conference. You can see all the details here:,-an-example-of-a-powerful-user-created-report-in-powerpivot.aspx  Read more

PowerPivot Workshop in Portugal #PowerPivot, #ppws

A new date is available for the PowerPivot workshop I and Marco are delivering all over Europe. On September 19-20 , 2011 we will be in Lisbon (Portugal) to present the workshop to Excel users and BI professionals. Moreover, as Denali CTP3 of PowerPivot  Read more

OT: New transaction in the World Database

Wow! Today I hit F5 on this interesting transaction: BEGIN TRANSACTION     INSERT INTO World.Babies (Name, Surname, DateOfBirth, Gender)     VALUES (‘Arianna’, ‘Ferrari’, ‘20110720’, ‘Female’);     UPDATE World.Parents  Read more

Parent/Child Hierarchies in Tabular with Denali

Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions needed to handle  Read more