THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » PowerPivot » DAX » MDX   (RSS)
  • Converting #MDX to #DAX and PowerPivot Workshop online #ppws

    I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate” your MDX knowledge in DAX. I think that this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 7, 2011
  • Median, Moving Average, Quartile and Percentile calculations in #PowerPivot

    Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be applied in other scenarios. Here is a list of posts and reasons to read:Calculating Moving Averages in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 13, 2011
  • Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

    During TechEd 2011, Microsoft announced an important update to its BI roadmap. The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit 2010 the announcement regarding the next version of SQL Server, codenamed ''Denali'', ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 18, 2011
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    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 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement