We presented a few session at SQLBits and the video of these sessions are available. This is the list of sessions available from SQLBits 8 and SQLBits 9 – just click the link on the title and jump to the…  Read more

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

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