Introduction

This chapter will focus on how to modify and enhance the model built in the previous chapter. After building a model, we will need to maintain and enhance the model as the business users update or change their requirements. We will begin by adding additional tables to the model that contain the descriptive data columns for several code columns. Then we will create relationships between these new tables and the existing data tables.

Once the new data is loaded into the model, we will modify various pieces of the model, including adding a new key performance indicator.

Next, we will perform calculations to see how to create and modify measures and columns.