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 » Analysis Servic... » DAX » PowePivot   (RSS)
  • Advanced DAX course in May - unique date in 1H 2013 #dax #tabular #ssas #powerpivot

    One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number of companies, with and without a previous experience on former versions of Analysis ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 22, 2013
  • End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI

    This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its General Availability is expected in early 2013 but many early adopters are already using it daily (myself included) PowerPivot and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 27, 2012
  • Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

    If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows considered in the group that the SUMMARIZE uses ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 4, 2012
  • New videos available #dax #ssas #powerpivot

    The collaboration I and Alberto started with Project Botticelli is starting producing content. At this point we have three videos available: DAX in Action shows the power of DAX in PowerPivot solving common patterns not so easy or fast to solve in other languages DAX: Calculated Columns vs. Measures shows the difference between calculated ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 24, 2012
  • DAX Studio 1.0 beta available #dax #tabular #powerpivot

    Are you waiting for a usable and interactive DAX editor? Are you tired of using the MDX editor provided by SSMS as a temporary solution to write and execute a DAX query? The wait is over! DAX Studio is a free Excel add-in that enables you to write a DAX query in a small dialog box that offer a productive environment, with a tabular object browser ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 30, 2012
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement