Alberto Ferrari's Blog

   View full profile
74 blog posts
Blog post –

On comparing Power BI with other tools

In the last few years, the Business Intelligence (BI) world has been moving towards self-service BI. As expected, several vendors created tools empowering regular users to gain insights from their data. Among the many, there is Power BI. Nowadays, users…  Read more

Blog post –

New Whitepaper from SQLBI: Vertipaq vs ColumnStore

At the end of June 2012, I was in Amsterdam to present some sessions at Teched Europe 2012 and, while preparing the material for the demos (yes, the best demos are the ones I prepare at the last minute), I decided to make a comparison between the two  Read more

Blog post –

DAX in Action

I do not normally blog about my activity at conferences, courses and workshop, not because I don’t like these “marketing” topics, but only because I forget to do it. That said, sometimes I do some really exciting activities and, well, I need to share  Read more

Blog post –

DAX in Action

I do not normally blog about my activity at conferences, courses and workshop, not because I don’t like these “marketing” topics, but only because I forget to do it. That said, sometimes I do some really exciting activities and, well, I need to share  Read more

Blog post –

Clever Hierarchy Handling in DAX

Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no DAX functions that let you access,  Read more

Blog post –

Speaking at Lisbon NetPonto UG on 02/13/2012

As you might (or not) know, I travel a lot for work and, when possible, I always try to speak at local user groups. It is fun and I always learn a lot by speaking with other professionals like me. Being in Lisbon next week, I’ll deliver a speech at Microsoft  Read more

Blog post –

OT: A Good Reason to Attend #SQLBits

My 4yo son keeps asking me why I should leave home so often to attend SQL conferences around the world and today, after a couple of days of snow, he discovered a good reason, along with the best place for the SQLBits scarf.  Read more

Blog post –

Circular Dependencies in DAX

What is a circular dependency? If A depends on B and B depends on A, then you have a circular dependency. As programmers, we know that they should be avoided to obtain a working system. All this looks fine but, when authoring a simple DAX formula containing  Read more

Blog post –

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