Exploring advanced modeling considerations

Once you have a basic semantic model – one with a simple star schema – there can always be further requirements that would need you to perform more advanced modeling to cater to those requirements. Let’s take a look at what happens when you have multiple business processes to handle.

Catering to multiple business processes

The original requirements of this example consisted of a second business process that we have still not addressed (Table 5.8): Order budgets. The order budgets are stored across multiple annual Excel workbooks in a SharePoint folder. A sample of one of these files is depicted in Figure 5.29:

Figure 5.29: Sample of the Order budgets file for 2012

Using the method that we learned about in Chapter 3, in the Files and spreadsheets section, and lessons from this chapter, we must process these set of files into a fact table (Figure 5.32):

Figure...