Monthly Archives: March 2013

Power Pivot in Excel. First look. Part 2

This post is continue of the PowerPivot in Excel. First look Part 1.  Today I will get the currency rate for each transaction that is done not in rubles currency. The rates are entered usually monthly (but there can exceptions), … Continue reading

Posted in Business Intelligence, Database development, SQL Server, Technology | Tagged , , , , | Leave a comment

How to create currency conversion in Microsoft SQL Server Analysis Services (SSAS)

In this post I would like to speak about currency rates calculations in standard dimension model, and in the next post I would return to Tabular model, DAX language and perform the same calculations there. It’s quite a common business … Continue reading

Posted in Business Intelligence, Database development, SQL Server, Technology | Tagged , , , , | Leave a comment

PowerPivot in Excel. First Look. Part 1.

In this post let’s have a look on PowerPivot add-on for Excel 2010-2013. Be aware, PowerPivot is not available for Office 2013 (365) Home Premium, so it was preferable for me to stand on Office 2010 rather than migrate to … Continue reading

Posted in Business Intelligence, Technology | Tagged , | 1 Comment

Date Range in SQL

While creating SQL queries for reports, it’s usually required to get a continuous list of dates for a given period. E.g.: get all dates from 1980 Jan 01 till 2013 Dec 31 (12419 records). In this post I would like … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | 6 Comments