Tag Archives: Business Intelligence in Excel

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

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