Marco Russo's blog posts of 2011

Page 3 of 89 blog posts
blog post –

After #SQLBits ready for #SQLPASS

I just returned from my second SQLBits , this time in Liverpool, and I have to say it is a really great conference. Everything can be improved, but I have to say that it’s hard to find a conference where you can have more networking opportunities than  Read more

blog post –

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

blog post –

Automate PowerPivot Data Refresh in Excel

link 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  Read more

blog post –

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

blog post –

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

blog post –

I will speak at #SQLPass #Summit and #SQLRally Nordic!

I already announced a few weeks ago that I and Alberto will speak at SQLBits in Liverpool. We will also speak at SQLPASS Summit in Seattle and at SQLRally Nordic . A few details about my sessions: SQLPASS Summit (Seattle, WA – October 11-14, 2011) : My  Read more

blog post –

#MDX Cookbook : a new must read for #SSAS developers

There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve  Read more

blog post –

Importing tables from #BISM Tabular model in #PowerPivot

A BISM Tabular model can be browsed in Excel by using just the standard PivotTable like it was a regular Analysis Services cube (that now we call a Multidimensional model). If you are used to PowerPivot, this seems a limitation, because you cannot interact  Read more