Alberto Ferrari's blog posts of 2010

6 blog posts
blog post –

PowerPivot: editing measures when you reach 45

I have always been used to small fonts but now, as I am getting older, I’d better admit that a greater font is much more relaxing. Editing PowerPivot measures has always been a pain, since all you have available is a small text box and I hate to admit  Read more

blog post –

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

blog post –

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

blog post –

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

blog post –

Final Update of the Rough Cuts of our PowerPivot book available!

The upcoming book Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I wrote with Marco is its final stage. You can see the final update through the “ Rough Cuts ” initiative by O’Reilly. The book will be available in bookstores in the first  Read more

blog post –

Visio Forward Engineer Addin for Office 2010

Most of my database model are written with Visio. I don’t want to start a digression whether Visio is good or not to build a simple data model: Visio is enogh for my modeling needs and customers love its colours and the ability to open the model with  Read more