Working capital data model
The working capital data model can be constructed in a variety of ways. The most important feature of the data model is its ability to accumulate account balances over time. In Chapter 3, Financial Perspective, we accomplish this by adding an as-of calendar. However, we can also create a model that uses periodic snapshots and avoid accumulating individual transactions after every user selection. A periodic snapshot is a recurring event that saves a copy of the data at the end of every day, week, or month.
Tip
Even though we may end up only using monthly snapshots in a QlikView application, it is wise to take a daily snapshot of the data and save it in QVD files in case business requirements change.
In this chapter, we will use a periodic snapshot to measure following events in the data model:
- Month-end inventory balances by item and warehouse over three years
- Day-end inventory balances by item and warehouse over the last the last three months
- Month-end balances of...
