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 » Tabular » DAX » BISM » PowerPivot   (RSS)
  • 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
  • Fact Tables with Different Granularities in #PowerPivot and #BISM #Tabular

    A few weeks ago I received a question that inspired me in writing this article about how to handle data at different granularities in PowerPivot and BISM Tabular. I think this is a common pattern when you have a budget table that contains data at an aggregated level (like month and product category) and you want to compare it with sales that are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 11, 2012
  • PowerPivot, basket analysis and the hidden many to many

    Surfing on the web, here, I came into this intriguing question: How do we ask something like ''Show me how many customers have an iPad but don't have a book?'' We are speaking about a sales analysis where the canonical entities are Customers, Products and Sales. Moreover, because we have been used to speak about cycles since many years ago, ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on May 19, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement