September 2014 - Posts

• Advanced DAX Workshops in the upcoming months –#dax #tabular #powerpivot

  The adoption of DAX is slowly growing and we can see that from comments to article, blog posts, web site traffic (including DAX Formatter usage). For this reason, the demand for more advanced training about DAX is also increasing. We had great feedback Read More... Posted Tuesday, September 30, 2014 10:48 AM by Marco Russo (SQLBI) | 8 Comments Filed under: DAX, SSAS, Tabular

• Simulate the SQL WHERE condition in DAX–#dax #powerpivot #ssas

  I recently wrote a short article about filtering data in DAX. In the last month I’ve seen a growing number of people with a SQL background going to Tabular, without having a previous experience of MDX. In my opinion, learning DAX is easier if you try Read More... Posted Monday, September 29, 2014 10:34 AM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot, SSAS, Tabular

• MDX Studio refresh

  If you work with MDX, using MDX Studio is a must, but it has not been updated for years. But community is great and Ihor Bobak has been able to apply two fixes: performance counters work with named instance and there is a single version regardless of Read More... Posted Thursday, September 11, 2014 10:38 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, SSAS

• Embed Analysis Services Tabular in your service or application #ssas #tabular

  Since 2012 I have seen many companies adopting SQL Server Analysis Services Tabular as the analytical engine for their product or service. I think that this is still a fraction of the companies that might do the same choice. Why? Because… The features Read More... Posted Tuesday, September 9, 2014 10:35 AM by Marco Russo (SQLBI) | 3 Comments Filed under: SSAS, Tabular