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 » DAX » Analysis Servic... » SSAS   (RSS)
Showing page 1 of 2 (13 total posts)
  • DIVIDE vs division operator in #dax

    Alberto Ferrari wrote an interesting article about DIVIDE performance in DAX. This new function has been introduced in SQL Server Analysis Services 2012 SP1, so it is available also in Excel 2013 (which still doesn’t have other features/fixes introduced by following Cumulative Updates…). The idea that instead of writing: IF ( Sales[Quantity] ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2014
  • Basket Analysis with #dax in #powerpivot and #ssas #tabular

    A few days ago I published a new article on DAX Patterns web site describing how to implement Basket Analysis in DAX. This topic is a very classical one and is also covered in the many-to-many revolution white paper. It has been also discussed in several blog posts, listed here in historical order: Simple Basket Analysis in DAX by Chris Webb ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 12, 2014
  • LASTDATE vs. MAX? CALCULATETABLE vs. FILTER? It depends! #dax #powerpivot #tabular

    A few days ago I published the article FILTER vs CALCULATETABLE: optimization using cardinality estimation, where I try to explain why the sentence “CALCULATETABLE is better than FILTER” is not always true. In reality, CALCULATETABLE internally might use FILTER for every logical expression you use as a filter argument. What really matters is the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 6, 2014
  • Using USERELATIONSHIP function in Measures and Calculated Columns #dax #powerpivot #ssas

    You can use the USERELATIONSHIP function in DAX to apply a non-active relationship in a particular DAX calculation. This approach is usually simple in a measure (just use USERELATIOSHIP in one of the filter arguments of CALCULATE) but as soon as you try using it in a calculated column, you can find several issues. In the article USERELATIONSHIP ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 1, 2013
  • Time Intelligence Video Tutorial on Project Botticelli #dax #powerpivot #ssas

    Alberto Ferrari recently recorded a free short video introduction about what is time intelligence. When you have to perform time-related calculations in Power Pivot or in Analysis Services Tabular, you have to rely on some DAX expressions. There are specific functions grouped in a “Time Intelligence” section in the on-line documentation, but it’s ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 5, 2013
  • 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
  • First DAX Advanced Workshop in London, May 2013 #dax #tabular #ssas

    Are you working with SSAS Tabular? Are you an experienced PowerPivot user? In both cases, you should be aware that there is only one skill that is important for PowerPivot and SSAS Tabular, and it is the DAX language. I and Alberto have been using DAX since 2010, wrote several books containing several chapters about DAX and we know that there is ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 7, 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
  • Meet SQLBI at PASS Summit 2012 #sqlpass

    Next week I and Alberto Ferrari will be in Seattle at PASS Summit 2012. You can meet us at our sessions, at a book signing and hopefully watching some other session during the conference. Here are our appointments: Thursday, November 08, 2012, 10:15 AM - 11:45 AM – Alberto Ferrari – Room 606-607 Querying and Optimizing DAX (BIA-321-S) ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 2, 2012
  • The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

    In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services 2005. The paper contains many generic patterns that can be applied in many common data ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 9, 2011
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement