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), and rate for the last day of the month determines…
Project schedule – after creation it is used regularly till end of the project. The main schedule I prefer to track in Microsoft Project. In my practice I’m trying to use the following principles while dealing with MS Project: Human resources load can not be more then 80%. On the…
Communication plan is a set of matrixes and procedures to regulate relations inside project team and with outside teams and individuals. Usually I do not publish communication plan as a separate document, it’s the part of Project Management plan. In my post I will go through main section of communication…
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 task when you have to provide business with prices and…
На прошедшей неделе решили вспомнить давно минувшие времена и немного поиграть в MtG. Так как колоды сохранились не у всех, на драфт народу не хватало, а идти в клуб не хотелось, то оставался единственный вариант – взять несколько бустеров и вскрыть их. Именно о том, как можно это сделать с максимальным…
I would like to start detailed description for the Project Planning Phase with Functional and Technical designs. As I’m speaking about software development projects, this post will have some specific, and of course you cannot use the same templates for example building projects ))). Another important thing is that designs…
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 new version of the product. So, what PowerPivot is and…
За прошедшее время сыграли две партии в Dixit и одну дуэльную в Агриколу.Dixit оба раза раскладывали на четверых. В Dixit играли с новым сверх творческим человеком. Первую партию он разбирался в нюансах игры, а со второй партии начал зажигать. Одна ассоциация про «Грибной приход» на карточку с вороном-священником много стоит. Со свежими людьми, которые могут…
So, we’ve come to the most important phase for Project Manager – Planning Phase. Why is it so important? The main reason is that on this phase we lay the baseline for the whole project. And with poor foundation any “building” would crash. This building – is our project, and…
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 to describe several ways how this can be done and…