Kasper de Jonge has recently posted a PowerPivot model, Access database with some financial data and a white paper that provides what I think is the absolutely best way to jump start a BI initiative focused on implementing financial metrics and KPIs. Please find the overview and the download link here. This is an absolute … Continue reading Modeling financial scenarios tutorial available from Microsoft
Month: May 2013
Kerberos Configuration Manager for SQL Server
Anybody who has had to worry about implementing security in a SharePoint environment has at some point run into challenges with impersonating end users and passing their credentials all the way to the analysis services cube for authorization. The dreaded two hop challenges necessitated having to implement Kerberos authentication which has caused a lot of … Continue reading Kerberos Configuration Manager for SQL Server
Unpivot data using Microsoft Data Explorer
I have been really impressed with Microsoft Data Explorer the minute I had a chance to play with it as I was able to turn formatted Excel reports into legitimate data sources available for analysis. Fairly recently, an update to the tool delivered an uber critical feature that makes a huge impact on the world … Continue reading Unpivot data using Microsoft Data Explorer
business intelligist 