Modeling financial scenarios tutorial available from Microsoft


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 must read for those who are trying to understand how to implement budget and prior year variance analysis, last known value aggregation scenarios (used for headcount analysis) and many other extremely useful calculations. The dataset is also included with the typical dimensionality for a finance application – Account, Time and Profit Center.

2 comments on “Modeling financial scenarios tutorial available from Microsoft”

Leave a Reply to Business Intelligist Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s