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. 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.

Note

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 A/R invoices over the last three years...