September 2011 - Posts

• Official announcement of #SSASMaestro

  SQLCAT team just announced the first SSAS Maestros and I'm happy to be part of them! I already know many of them and I'm more than happy to see that also Alberto and Chris, who co-authered the Expert Cube Development with Microsoft SQL Server 2008 Analysis Read More... Posted Tuesday, September 20, 2011 3:19 AM by Marco Russo (SQLBI) | 1 Comments Filed under: SSAS

• 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

• Automate PowerPivot Data Refresh in Excel

  In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago . The sad answer is that this feature is not supported in Read More... Posted Thursday, September 08, 2011 2:58 AM by Marco Russo (SQLBI) | 5 Comments Filed under: PowerPivot

• 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 Read More... Posted Friday, September 02, 2011 10:25 AM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, Communities, PowerPivot

• 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) Read More... Posted Thursday, September 01, 2011 12:24 PM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, PowerPivot, SSAS