Centralized Business Intelligence

My approach as a BI professional has always been to organize the data into conformed structures, present that to end users for consumption in their ad-hoc analysis, and only build formal reports and dashboards as necessary. I think the conformed structures provide great consistency for BI across the enterprise no matter who is building it…

Continue reading →

SSRS 2008 Add-In for MOSS 2007

Quick one here…I was recently setting up a SSRS 2008 dev environment integrated with a MOSS 2007 dev environment and encountered some strange problems with the SSRS 2008 Add-In for SharePoint. Basically every time it would run and state the installation was “interrupted” and nothing was changed. To my frustration nothing appeared to be wrong…

Continue reading →

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 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…

Continue reading →

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 for porting it around to other office apps (eg. Word, PowerPoint). Let me know if you have questions by posting a comment and enjoy!

Continue reading →

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, 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…

Continue reading →