THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSAS » Analysis Services   (RSS)
Showing page 1 of 5 (48 total posts)
  • The State of Power BI #powerbi

    The 2015 has been an amazing year for Power BI. One year ago, I was commenting on this blog the public preview of Power BI dashboards. A few days ago, Microsoft released the December update of Power BI Desktop and several updates of the Power BI service. In one year, we moved from a situation where Microsoft seemed (and actually was) too slow in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 21, 2015
  • Large Dimensions in SSAS Tabular #ssas #vertipaq

    After many years of helping several companies around the world creating small and large data models using SQL Server Analysis Services Tabular, I’ve seen a common performance issue that is underestimated at design time. The VertiPaq engine in SSAS Tabular is amazingly fast, you can have billion of rows in a table and query performance are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 20, 2015
  • VertiPaq Analyzer for Analysis Services #ssas #tabular #powerpivot #powerbi

    During the writing of The Definitive Guide to DAX I wanted a simple way to analyze the content and distribution of data compressed in the VertiPaq engine, used by Analysis Services Tabular, Power Pivot and Power BI models. I always relied on BISM Memory Report (thanks Kasper!), but when you focus on a single database there are a number of details ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 28, 2015
  • 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
  • Performance Tuning of #tabular models in Analysis Services 2012 #ssas

    In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about what is really used and required today in the real world. I think it is a good news that ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 5, 2013
  • Common request: export #Tabular model and data to #PowerPivot

    I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature people (including me) would like to see: Create an empty PowerPivot workbook with the same ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 19, 2013
1 2 3 4 5 Next >
Privacy Statement