SSIS Event Log Business Intelligence
Tracking performance of SSIS processes using an ETL data mart
Tag: Business Intelligence
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...
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 m...
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...