SSIS Event Log Business Intelligence
Tracking performance of SSIS processes using an ETL data mart
Microsoft Healthcare User Group Presentation
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...
Democratizing Business Intelligence using Gemini
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 ye...
Building a Project Timeline in MS Excel
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 f...
Excel Tip – Defaulting to Non-Compatibility Mode
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 n...
Excelsius and the MS BI Stack
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,...
Key Performance Indicators based on Earned Value Analysis / Management
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 basicall...
Using Excel 2007 files as a Source in SSIS 2005
Thanks to “jaegd” for his post here: forums.microsoft.com/… on how to accomplish this. Below please find some more details along w/ a example ...
SQL Server Analysis Services (SSAS) Connection Properties
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 receivin...
Excel Tip: Identifying the max length of values in a column
Sometimes files are received such as client feeds that contain values in columns that exceed the maximum number of characters allowed in the destination databas...