The business case and model
In the remainder of this chapter, we look at a portfolio of real estate properties. Different properties may have different life cycle durations. Each property has:
- An investment in year 0, cash flows, and a residual value.
- Cash flows with a recurring pattern during the life span of the property, either positive (income) or negative (expenses).
- Positive or negative cash flows with an irregular pattern, like maintenance.
You can download this model, 2.6 Exploring the future.pbix, from https://github.com/PacktPublishing/Extreme-DAX/tree/main/Chapter2.6.
The model contains three fact tables: fPosCashFlows for positive recurring cash flows, fNegCashFlows for negative recurring cash flows, and fIrregular for irregular cash flows.
There can be many different cash flow drivers; to be able to analyze them separately, there is a filter table with the type of cash flow for each fact table:
Figure 2.6.4...
