Browse by Tags

• Analysis Services
• BIDS
• BISM
• Book
• Business Intelligence
• Conference
• Conference Communities
• Denali
• Excel
• Gemini
• MDX
• PASS
• PivotTable
• PowePivot
• Reporting Services
• SSAS
• Tabular
• UDM

• 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 Read More... Posted Wednesday, January 11, 2012 2:35 PM by Marco Russo (SQLBI) | 2 Comments Filed under: BISM, DAX, PowerPivot, Tabular

• 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 Read More... Posted Monday, November 07, 2011 11:40 AM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, DAX, MDX, PowerPivot

• Median, Moving Average, Quartile and Percentile calculations in #PowerPivot

  Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be applied Read More... Posted Tuesday, September 13, 2011 7:18 AM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, MDX, PowerPivot

• #PowerPivot Workshop in Lisbon - Portugal #ppws

  Alberto anticipated me announcing our next edition of the PowerPivot Workshop in Lisbon (Portugal) on September 19-20, 2011. The announcement has been published also on the SQLPort website in Portuguese! But remember, the workshop will be entirely in Read More... Posted Friday, July 29, 2011 11:25 AM by Marco Russo (SQLBI) | 1 Comments Filed under: DAX, PowerPivot

• 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 Read More... Posted Friday, July 22, 2011 10:55 AM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, DAX, Denali, PowerPivot

• 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 Read More... Posted Wednesday, May 18, 2011 5:56 PM by Marco Russo (SQLBI) | 14 Comments Filed under: Analysis Services, BISM, Business Intelligence, DAX, MDX, PowePivot, PowerPivot, UDM

• Thinking in DAX (#powerpivot and #bism)

  Last week Alberto published an interesting post about Counting Products in the Current Status with PowerPivot . Starting from a question raised from a reader, Alberto described how to solve a common issue (let me know the “current status” of each item Read More... Posted Thursday, March 17, 2011 6:46 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot

• Last day of early bird for PowerPivot Workshop in Dublin #ppws

  The early bird discount for the PowerPivot Workshop in Dublin will expire today, Friday 11 March. There is also an upcoming workshop in Copenhagen (March 21-22, 2011) and a PowerPivot workshop in Zurich on April 4-5, 2011. I and Alberto are preparing Read More... Posted Friday, March 11, 2011 1:14 AM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot

• Difference between DISTINCT and VALUES in DAX

  I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name Read More... Posted Tuesday, March 08, 2011 2:39 AM by Marco Russo (SQLBI) | 9 Comments Filed under: DAX, PivotTable, PowerPivot

• Parent-child hierarchies and unary operators in PowerPivot

  Alberto wrote an excellent post describing how to implement the Unary Operator feature (which is present in Analysis Services) in PowerPivot (there was a previous post about parent-child hierarchies, too). I have to say that the solution is not so easy Read More... Posted Friday, March 04, 2011 11:24 AM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot

• Slowly Changing Dimensions handling in PowerPivot (and BISM?)

  During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes Read More... Posted Thursday, February 10, 2011 4:06 PM by Marco Russo (SQLBI) | 3 Comments Filed under: DAX, PowerPivot

• PowerPivot FILTER condition optimizations

  In the comments of a recent post from Alberto Ferrari there was an interesting note about different performance related to the order of conditions in a FILTER call. I investigated about that and Jeffrey Wang has been so nice to give me some info about Read More... Posted Monday, February 07, 2011 4:10 PM by Marco Russo (SQLBI) | 1 Comments Filed under: DAX, PowerPivot

• Stock Analysis and Moving Average with PowerPivot

  One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot . You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement Read More... Posted Thursday, January 27, 2011 7:09 PM by Marco Russo (SQLBI) | 3 Comments Filed under: DAX, Excel, PowerPivot

• Working days calculation with PowerPivot

  Whenever you have to calculate the distance between two dates, you can simply subtract two dates and DAX in PowerPivot will give you the answer. However, in case you want to calculate the difference in terms of working days you have to instruct your data Read More... Posted Thursday, January 20, 2011 7:58 PM by Marco Russo (SQLBI) | 2 Comments Filed under: DAX, PowerPivot

• Inside DAX Time Intelligence functions

  Jeffrey Wang wrote a new post about DAX Time Intelligence functions. This is an “under the cover” description that explains the rationale behind these functions, which need to be used following particular guidelines (described at the beginning of the Read More... Posted Tuesday, January 18, 2011 11:03 AM by Marco Russo (SQLBI) | 1 Comments Filed under: DAX, PowerPivot