One month ago I wrote about my sessions at PASS Business Analytics Conference 2013, in Chicago, IL on April 10-12, 2013. If you still have not registered, you can save $200 by using the code BAC228BL and you should hurry up, because there is another discount if you register within March 15, 2013. If you are too lazy to click on the previous post, ...

Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in this article on SQLBI, which can be applied to any Time Intelligence function with a <dates> argument. The key ...

These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up!Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and Alberto Ferrari will present the session we already delivered in Copenhagen two weeks ago. This is the ...

It’s Day 1 of #24HOP and it’s been great to participate in this event with so many women from all over the world in one long training-fest. The SQL community has been abuzz on Twitter with running commentary which is fun to watch while listening to the current speaker. If you missed the fun today because you’re busy with all that work you’ve got ...

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...

PASS Summit 2010 is approaching and I'm facing the dilemma of choosing concurrent sessions in certain timeslots. I'm not alone in this situation and discussing it with other people only enhance my doubts because I see only more reasons to look also other sessions, instead of finding clues to exclude something. However, it seems that there ...

Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting also for another reason: it can open up your mind about why Vertipaq (the engine of ...

My Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning book has been printed and is now in stock on many bookstores! This is another good news of the past week, who have been dense of good news. I and Alberto have been interviewed by Vidas Matelis about the book and we’ve received several subscriptions for our first PowerPivot Workshop ...

Yesterday I had a nice time delivering the SQLBI Methodology session at 24 Hours of PASS. A few hours later, I had the news about the official RTM of the PowerPivot book I wrote with Alberto. The complete title is Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning and we hope it will be a good book for both advanced Excel users (who are ...