October 2010 - Posts

• Visio Forward Engineer 1.1

  You know, I love Visio to develop simple databases and I have written a Visio add-in that performs the forward engineer of data models, called Visio Forward Engineer. Now I have found some time to update the project to version 1.1. You can download the Read More... Posted Tuesday, October 19, 2010 1:54 PM by AlbertoFerrari | 14 Comments

• PowerPivot and Many to Many Relationships

  If you have already read this post from Marco Russo and have understood everything, then this new post of mine will be useless. But if you are like me, i.e. you have read it and have broken your head trying to understand the final (really smart!) formula, Read More... Posted Tuesday, October 19, 2010 10:45 AM by AlbertoFerrari | 0 Comments

• Banding with PowerPivot

  Banding is one of the most common requirements when you have the need to analyze continuous values, like the retail price of a product which may change over time, due to discounts and price variations. I have already spoken about banding with regards Read More... Posted Tuesday, October 12, 2010 9:00 AM by AlbertoFerrari | 2 Comments Filed under: PowerPivot DAX Banding Data Model Excel