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 » BISM » PowerPivot   (RSS)
Showing page 1 of 2 (16 total posts)
  • 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
  • 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
  • Campaign for #PowerPivot and #Tabular textual modeling language #msbi #ssas

    If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models. This is the simplest way to improve the Productivity of PowerPivot and Tabular ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 3, 2013
  • 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
  • Sorting Dates Columns in #PowerPivot and #BISM #Tabular

    I just published an article about Sorting Dates Columns in PowerPivot v2 and BISM Tabular on SQLBI website. In reality, the article is about sorting columns by other columns in a Tabular model, but the common scenario in which you need that is in a Calendar table where you can have columns that have to be sorted by using a combination of other ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 8, 2011
  • 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
  • Many-to-many in #BISM Tabular issue in #crescent and #powerview

    If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you: it appears that, at least in its first release, Power View will not support this scenario, showing a behavior ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 18, 2011
  • Community Event in Lisbon on September 19 #ppws

    As I already announced on this blog some weeks ago, there will be a PowerPivot Workshop in Lisbon (Portugal) on September 19-20, 2011. The evening of September 19 there will be also a free community event in Lisbon where Alberto will speak: you can find all details and registration link here. We know that August is an holiday month for many ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 2, 2011
  • Separate date and time in #powerpivot (and #bism tabular)

    In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time (hour/minute) but to do that it is often useful to have two independent set of attributes: one for the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 1, 2011
  • Parent-child special calculations in #BISM #Tabular #Denali

    Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child hierarchy) and the other is the Sum of Children (computes all the nodes that are descendants ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 22, 2011
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement