Wow, what a day yesterday. Gave a presentation at the Microsoft Healthcare User Group Conference with Rick Garcia of Methodist hospital to two completely packed rooms. Funny thing, Rick and I had no clue we were supposed to be using the microphones because there was another room full of attendees that obviously couldn’t hear us […]
If you’ve not heard of Gemini yet you’re in for a treat. I found these videos on youtube yesterday of the Gemini demo from the BI conference last year that you can view below. Gemini is a new part of the MS BI stack that is an add-in for Excel that allows power-users the ability […]
Below is a recent screencast I recorded showing how to build a project timeline (gannt chart style) using MS Excel. It’s simple and easy and works great for porting it around to other office apps (eg. Word, PowerPoint). Let me know if you have questions by posting a comment and enjoy!
I was recently fighting with Excel because I was sick of it wanting to run in Compatibility Mode by default. Everything I found out there said that you simply need to change the option for Save-As to be the 2007 format. This only seemed to work on the workbooks I had open. If I closed […]
Recently I was on a call with a client and one of their IT guys asked if the Microsoft Business Intelligence stack can do everything Exclesius can do. In short, the answer is sorta. Through reporting services the MS BI stack can provide similar functionality however, it cannot provide the flash animations you get in […]
Just had some ideas from class tonight regarding Earned Value Analysis (EVA). If you’re unfamiliar with EVA google it and you’ll find it is basically a way to measure a projects performance. Microsoft has a small ‘about’ page found here that might help as well – http://office.microsoft.com/en-us/project/HP010342581033.aspx The three key elements of EVA are: Budgeted […]
Thanks to “jaegd” for his post here: http://forums.microsoft.com/… on how to accomplish this. Below please find some more details along w/ a example which can be downloaded here (ssis-2005-excel-2007-source-example). Steps Create new OLEDB Connection by right clicking on the Connection Manager tray Chose any valid type or value for the connection and click okay Rename the […]
Recently I was having some issues getting a new SQL Server Analysis Services (SSAS) cube to process on a new development (dev) server. The error I kept receiving was…