December 2011 - Posts

• 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... Posted Friday, December 30, 2011 11:57 AM by Marco Russo (SQLBI) | 23 Comments Filed under: DAX, PowePivot, Tabular

• Query Projection in #DAX

  I wrote a short article about query projection in DAX. To make the story short, you should always use SUMMARIZE in order to remove columns from a table in a query. Thus, if you just want three columns from a table, instead of writing this in SQL: SELECT Read More... Posted Thursday, December 29, 2011 2:50 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, BISM, Tabular

• Ratio Calculation Differences between #MDX and #DAX in #BISM #Tabular

  You should have already read that DAX is simpler than MDX. It’s true, and sometime you have to pay a price for simplicity. I am used to say that DAX is somewhere between SQL and MDX. In fact, SQL requires you to put any relationship in the query (using Read More... Posted Tuesday, December 27, 2011 3:38 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, BISM

• Best session in BI Platform Track at PASS Summit 2011 #sqlpass

  Last week the final session evaluations from PASS Summit 2011 have been communicated to speakers and best scores have been made public. My session was not particularly good: it had very good feedback (overall average 4.32) and some average one, mostly Read More... Posted Monday, December 19, 2011 4:13 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, PASS, BISM

• Vote desired sessions at #SQLBits 10

  Just a breaking news: you can vote the sessions you'd like to attend at the next SQLbits in London! I already did my job and I have to say that it's very hard to use your 10 sesssions - there are too many sessions that I'd like to watch! Read More... Posted Monday, December 12, 2011 10:53 PM by Marco Russo (SQLBI) | 0 Comments

• Sorting Dates Columns in #PowerPivot and #BISM #Tabular

  I just published an article about Sorting Dates Columns in PowerPivot v2 and BISM Tabular on SQLBI website. In reality, the article is about sorting columns by other columns in a Tabular model, but the common scenario in which you need that is in a Calendar Read More... Posted Thursday, December 8, 2011 1:15 PM by Marco Russo (SQLBI) | 2 Comments Filed under: PowerPivot, BISM, Tabular

• Publish Your Data on Windows Azure MarketPlace

  If you missed this, it is finally possible to publish your data on Windows Azure Marketplace . The name DataMarket is no longer present here also because the marketplace also include applications and not only data, but the news introduced by the last Read More... Posted Wednesday, December 7, 2011 9:28 AM by Marco Russo (SQLBI) | 0 Comments

• #SQLBits video (of my session) finally available

  The video of the session Vertipaq vs OLAP: Change Your Data Modeling Approach that I delivered at SQLBits 9 is finally available! You can find here the video of sessions I and Alberto Ferrari delivered at the last two SQLBits. Last week we also submitted Read More... Posted Monday, December 5, 2011 11:25 AM by Marco Russo (SQLBI) | 2 Comments Filed under: DAX, BISM