1. Preparing Data for a Report

Workflow: Preparing Data for a Report

In this workflow we prepare data to be displayed in a report.

Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year.

We then report the money allocated, the money spent and the money remaining for each project each year.

Calculating money spent for each project each year

Calculating money in budget for each project each year

Reading data

Money by project & year

Unpivot

Calculating remaining money for each year