Microsoft Healthcare User Group Presentation

Me and Rick trying to decide who is going to try the mic first

Me and Rick trying to decide who is going to try the mic first

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 without them.

In the presentation Rick talked about how they, with the help of Courtyard Group, have reformed their Business Intelligence (BI) organization to be driven by the end-user versus by the IT team. This is key in all BI organizations as, it is not something that IT (in most cases) will truly understand usually.

When IT is the driver behind BI initiatives what I’ve found is that users will simply take the data that IT is providing them, import it into Excel or Access, and then build their own BI from it. This is bad. From an organizational standpiont you have a valuable resource spending time collecting, formatting, and organizing data (something much better handeled by IT when given proper requirements) rather than doing the true analysis. From an Business Continuity (BCP) standpoint you are also now subject to a single point of failure since the analyst will most likely save the reports to their desktop

My portion of the presentation covered the Microsoft Business Intelligence stack and how we are using that to help Methodists IT group focus more on delivering the analysis tools to the users rather than doing the reports themselves. This falls into that category of “BI for the masses” and helping create that reality where IT’s main focus is to integrate the systems and present the analytical tools to the business users to do the analysis. This is how I believe BI works best and provides the most value to an organization. Of course, all of this is delivered in SharePoint as this is where all end-users are being driven to store, manage, and find any and all information.

I am really excited about where Methodist is going with their Business Intelligence initiative and hope to follow up with some more great details at the next Microsoft Healthcare User Group Conference.

Cheers!
Ben

References:

MS HUG Breakout Sessions: http://www.mshug.org/events/exchange_Sept2009.aspx

Presentation Slides: http://www.mshug.org/docs/exhange2009/Garcia_LeveragingSharePointBI.pdf
Methodist Hospital System: http://www.methodisthealth.com
Courtyard Group: http://www.courtyard-group.com/
SharePoint360: http://sharepoint360.com

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

  1. Budgeted Cost of Work Scheduled
  2. Actual Cost of Work Performed
  3. Budgeted Cost of Work Performed

These are the ‘Measures’ of the project. The Key Performance Indicators you can derive based on these measures are:

  1. Cost Variance
  2. Schedule Variance

Sounds just like a dashboard right? Anyone interested in coming up with a PerformancePoint dashboard with these metrics based on Visual Studio Team Foundation Server? I know I am…

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 receiving was:

[Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001; SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001.

After much toying around I was able to determine what was causing this. In my case I had my shared data source connection for my data warehouse using Windows Authentication and the Impersonation Info set to Default. The problem appears to stem from the translation from Windows Authentication to the Impersonation Info option.

To fix this I changed my shared data source connection to use a SQL Server account and left the Impersonation Info option as default. This then must have allowed SSAS to translate the username and password info when doing the impersonation. I could be wrong but it is now working.

If you have any comments on this or a deeper explination please share? If you too are experiencing this issue o I hope this helps!