Topic: PowePivot

       Page 3 of 37 blog posts
blog post –

Optimize Many-to-Many with SUMMARIZE and Other Techniques

We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships  Read more

blog post –

String Comparison in #DAX

In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about  Read more

blog post –

#PowerPivot Workshop Online for America’s Time Zones #ppws

After so many request we have finally arranged a PowerPivot Workshop online edition dedicated to America’s time zones! It is scheduled for December 19-20, 2012, with this schedule: US Eastern Time (EST): 10:00am-1:00pm / 2:00pm-5:00pm US Central Time  Read more

blog post –

Windows Azure Step-by-Step

My colleague and friend Roberto Brunetti wrote Windows Azure Step by Step Microsoft Press. It is a good introductive book about programming on Windows Azure. He is a well known speaker, author and trainer in Italy and he finally used its great skills  Read more