Internal Reporting Semantic Models

In this chapter, we will create trial balance internal reporting semantic models and a journal entry internal reporting semantic model. This involves extending the trial balance external reporting semantic models and a journal entry external reporting semantic model from Chapter 11, based on the internal reporting logical models in Chapter 12. We will start with any of the three semantic models from Chapter 11 – either Tyrell Corp, Weyland Industries, or StarSchema.co.uk – then go through each semantic model stage covering Power Query, data modelling, and Data Analysis eXpressions (DAX).