Hi Kleegeek Nice to read your review, while I was reading it I noticed some of the points which you might still not be aware of. Let’s analyze those; SSRS: SSRS is a good reporting tool, but mostly it is used for static reporting, detail level reports, it doesn't provide…

Hi Peter Nice article, now we discuss from point 11 to 15 in detail; #11: I do agree with you partially on this, because I don't understand the need for creating a separate surrogate key for SSIS. My point is using the keys from Production tables; personally I use Change…

Hi Peter Let's discuss from point 6 to 10 in here; #6: I totally agree with you, never trust or undermine the fact that data will be coming in the format as suggested by the ETL Team. There is always a possibility of wrong data types, bad data, switched data, all kind of…

Hi Paul It is nice to hear that Microsoft is going to launch yet another BI tool called "Power BI". With soo many tools already available in the market from Microsoft from Performance Point, Power View, Power Pivot, SSRS & Excel sometimes it becomes very difficult as a BI…

Hi Peter Let’s talk about the difficulties you have faced during your BI career; #1: I do agree with you partially, that having a dedicated Share Point resource would be handy because you might be going to run into performance or security issues somewhere along the…

Hi Paul Nice article, and this question has been asked to us by various of our clients and by ourselves as well. Why Microsoft offering so many BI tools, for front end dashboard / reporting. Each of the tool you have mentioned above has their own limitations and…

HI Melissa I am already aware of the Report query timeout setting, but still you might agree with me sometimes due to heavy load on server some Reports that work perfectly fine, took longer time to render. So as a developer you don't want to put very short time out limit…